XinYu_RZMES/.svn/pristine/82/8286453f70ce527877aa4c4c0e1aec7d8c724da9.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="轧辊编制">
	<query id="UIF023010.FindSchRollEditedInfo" desc="查询轧辊已编制信息" fetchSize="10">
        <![CDATA[
/***********************查询轧辊已编制信息**************************************************************/
			
SELECT  REPLACE(C.WTH_GRP_CD,'WZZ','烫辊材') WTH_GRP_CD,    --宽度组
        C.MINI WTH_MINI,                                   --宽度组下限
        C.MAXI WTH_MAXI,                                   --宽度组上限
        A.ROLL_SLAB_CNT,                                   --已编制板坯数量
        A.ROLL_SLAB_WGT,                                   --已编制板坯质量
        A.MILL_LEN,                                        --轧制长度
        D.MINI,                                            --编制量下限
        D.MAXI,                                            --编制量上限
        A.ROLL_DTIME,                                       --注册时间
        C.WTH_GRP_CD  CD_SEQ                               --宽度组排序序号
FROM    TBF02_SCH_ROLL                       A ,
        TBF02_ROLL_WTH                       B ,
        TBF02_ROLL_WTH_GRP                   C ,
        TBF02_ROLL_WTH                       D                
WHERE A.WTH_GRP_CD = B.WTH_GRP_CD(+)
  AND C.PLT = 'H'
  AND C.WTH_GRP_CD = A.WTH_GRP_CD(+)
  AND C.WTH_GRP_CD = D.WTH_GRP_CD(+)

UNION ALL 
 SELECT '合计'                WTH_GRP_CD ,                   --宽度组
         0                    WTH_MINI,                     --宽度组下限
         0                    WTH_MAXI,                     --宽度组上限
         SUM(A.ROLL_SLAB_CNT) ROLL_SLAB_CNT,                --已编制板坯总数量
         SUM(A.ROLL_SLAB_WGT) ROLL_SLAB_WGT,                --已编制板坯总重量
         SUM(A.MILL_LEN )    MILL_LEN,                      --轧制总长度
         D.MINI                   MINI,                     --编制量下限
         D.MAXI                   MAXI,                     --编制量上限
         ''                   ROLL_DTIME,                   --注册时间
         'W00'               CD_SEQ                         --宽度组排序序号
FROM    TBF02_SCH_ROLL           A,                         --CCR轧辊编制参数      TB
        TBF02_ROLL_WTH           B,                         --轧辊各宽度编制量标准 TB
        TBF02_ROLL_WTH_GRP       C,                         --轧辊各宽度组编制标准 TB
        TBF02_ROLL_STD           D                          --轧辊编制量标准       TB
WHERE A.WTH_GRP_CD = B.WTH_GRP_CD(+)
  AND C.PLT = 'H'
  AND C.WTH_GRP_CD = A.WTH_GRP_CD(+)
  AND D.PLT = 'H'
 GROUP BY (D.MINI,D.MAXI)
ORDER BY CD_SEQ DESC
			
			
/******************查询轧辊已编制信息*******************************************************************/
        ]]>
    </query>  
	<query id="UIF023010.findSlabComm" desc="选择编制的板坯" fetchSize="10">
        <![CDATA[
/***************************选择编制的板坯**********************************************************/
			
            
SELECT      A.CUR_LOAD_LOC  ,                /*现在堆置位置*/
            A.SLAB_NO  ,                     /*板坯号*/
            A.SLAB_THK,                      /*板坯厚度*/
            A.SLAB_WTH  ,                    /*板坯宽度*/
            A.SLAB_LEN  ,                    /*板坯长度*/
            A.SLAB_WGT  ,                    /*板坯重量*/
            A.INSTR_COIL_THK  ,              /*订单钢卷厚度*/
            A.INSTR_COIL_WTH  ,              /*订单钢卷宽*/
            '' ORD_LEN        ,               /* B.ORD_LEN 订单钢卷长度*/
            '' ORD_WGT        ,                /* B.ORD_WGT 订单钢卷重量*/
            C.HOT_THK_AIM    ,                --热厚度AIM
            C.HOT_THK_MIN    ,                --热厚度MIN
            C.HOT_THK_MAX    ,                --热厚度MAX
            C.WTH_AIM    ,                    --宽度AlM
            C.WTH_MIN    ,                    --宽度MIN
            C.WTH_MAX    ,                    --宽度MAX      
            A.SPEC_ABBSYM  ,                 /*规格略号*/
            A.ORD_NO  ,                      /*合同号*/
            A.ORD_SEQ  ,                     /*订单号*/
            Z.CUST_NM  ,                     /*客户公司代码*/
            A.STL_GRD  ,                     /*钢码*/
            E.DEL_TO_DATE,                     --交货期
            NVL(E.EMGMTR_NMG_CLF,'N') EMGMTR_NMG_CLF,         --紧急材代码
            T.SM_CFNM SLAB_RT                       /*板坯去向*/
			,T2.SM_CFNM DLIV_TP
		    ,A01.MK_CONTENT                   --订单备注
			,XB_PACKAGE.GF_COMNNAME_FIND('A01004' , E.PRODNM_CD )   PRODNM_CD
	    	,DECODE(SLAB_STOCK_TYPE,'3','加回入库','4','轧回入库','正常入库')  SLAB_STOCK_TYPE                 --入库类型
			,DECODE(K.DSN_KIND, '1', 'Y', 'N') AS INGR_YN
			,DECODE(QL.DSN_KIND, '1', 'Y', 'N') AS QLTY_YN  --材质特殊要求
     	    ,DECODE(DE.DSN_KIND, '1', 'Y', 'N') AS DEL_YN  --交付条件特殊要求
  FROM      TBG02_SLAB_COMM                                                                                      A, 
            --(SELECT SLAB_NO, SUM(ORD_LEN) ORD_LEN ,SUM(ORD_WGT) ORD_WGT FROM TBG02_SLAB_COMM_D GROUP BY SLAB_NO) B,
			---------------------------------------------------------------------------------------------------------
			--MODIFY BY SJW 091024
			--DESC: 解决SLAB_COMM AND SLAB_COMM_D中订单不一致的情况
			--TBG02_SLAB_COMM_D                                                                                    B,
			---------------------------------------------------------------------------------------------------------
            TBB01_ORD_PROD                                                                                       C,
            TBD00_STLGRD                                                                                         D,
            TBE02_ORD_PRC                                                                                        E,
            TBZ00_CUSTOMER                                                                                       Z,
            (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01004')                             T,
            TBF02_FUR_SIZE_STD                                                                                   F
            ,(SELECT   SM_CD, SM_CFNM FROM TBZ00_COMMCD  WHERE LG_CD = 'A01012')                                 T2
            ,TBA01_ORD_LINE                                                                                      A01
			,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
			    FROM TBB01_ORD_INGR
			   WHERE DSN_KIND = '1') K 
			,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
		      FROM TBB01_ORD_QLTY
		     WHERE DSN_KIND = '1') QL   --材质特殊要求
	        ,(SELECT DISTINCT ORD_NO, ORD_SEQ, DSN_KIND
		      FROM TBB01_ORD_DEL
		     WHERE DSN_KIND = '1') DE    --交付条件特殊要求
WHERE A.ORD_NO        = A01.ORD_NO(+)
  AND A.ORD_SEQ       = A01.ORD_SEQ(+)  
  AND A01.DLIV_TP       =  T2.SM_CD(+) 
  		----------------------------------------------
			--MOD BY WXY 100302
			--DESC: 板坯号变更修改        
        --AND  A.SUB_SLAB_NO = B.SLAB_NO
		---------------------------------------------------------------------------------------------------------
			--MODIFY BY SJW 091024
			--DESC: 解决SLAB_COMM AND SLAB_COMM_D中订单不一致的情况
		--AND  A.ORD_NO  = B.ORD_NO
	    --AND  A.ORD_SEQ = B.ORD_SEQ  
	    --AND  A.ORD_FL  = B.ORD_FL	                                                                     
		---------------------------------------------------------------------------------------------------------
        AND A.SLAB_NO NOT IN (SELECT SLAB_NO FROM  tbf02_sch_mill)
		--------------------------------------------------------------------------------------------
		--MODIFY BY SJW 090902 VERSION 1.31-->1.32
		--DESC:  出现轧制计划重复做多次的情况，不确定是人工修改了状态还是某个程序改变了轧制计划的状态，故在此控制	
					
		AND A.SLAB_NO NOT IN (SELECT SLAB_NO FROM TBF02_SPEC_MILL WHERE STATUS_CD  IN ('A','B'))	
		--------------------------------------------------------------------------------------------	
        AND A.ORD_NO = C.ORD_NO(+)
        AND A.ORD_SEQ = C.ORD_SEQ(+)
		AND A.ORD_NO = K.ORD_NO(+)
	    AND A.ORD_SEQ = K.ORD_SEQ(+)
	    AND A.ORD_NO  = QL.ORD_NO(+)
	    AND A.ORD_SEQ = QL.ORD_SEQ(+)
	    AND A.ORD_NO  = DE.ORD_NO(+)
	    AND A.ORD_SEQ = DE.ORD_SEQ(+)
        AND A.STL_GRD = D.FAC_STL_GRD(+)
        AND E.ORD_NO = A.ORD_NO
        AND E.ORD_SEQ = A.ORD_SEQ 
        AND Z.CUST_CD        =         A.CUST_CD   
        AND T.SM_CD          =         A.SLAB_RT
	    AND A.SLAB_THK            BETWEEN  F.SLAB_THK_MIN AND F.SLAB_THK_MAX
        AND A.SLAB_WTH            BETWEEN  F.SLAB_WID_MIN AND F.SLAB_WID_MAX
        AND A.SLAB_LEN            BETWEEN  F.SLAB_LEN_MIN AND F.SLAB_LEN_MAX
        AND F.PLT                 = 'H'
        AND F.FUR_LINE            = '1'
		AND A.SLAB_LEN BETWEEN    4500    AND  11000
	--	AND E.RCVORD_CLF    <>         'M'	
		--跺位锁定的不要显示  MODIFY BY SJW 090807	
	    AND NVL(A.YARD_LOCK_YN,'N') <> 'Y' 
		------------------------------------------------------------------------------------------------
	    --MODIFY BY SJW 091024
		--DESC:  排除找不到宽度组的错误数据		
		AND A.INSTR_COIL_WTH  > 0	
		------------------------------------------------------------------------------------------------			
        AND   A.INSTR_COIL_WTH      >=     ?  
        AND   A.INSTR_COIL_WTH      <      ?  
        AND   A.STL_GRD             LIKE   ?  ||'%'
     --   AND   D.FAC_STL_GRP         LIKE   ?  ||'%'
	    AND  nvl( D.FAC_STL_GRP,' ')         LIKE   ?  ||'%'
        AND   A.ORD_NO || A.ORD_SEQ LIKE   ?  ||'%' || ? ||'%'
        AND   E.ORD_USEAGE_CD       LIKE   ?  ||'%' 
	    AND   A.CUR_LOAD_LOC        LIKE   ?  ||'%'
        AND   A.INSTR_COIL_THK      >=     ?
        AND   A.INSTR_COIL_THK      <      ?
        AND A.CUR_PROG_CD           =     'RBA'
        AND   A.SLAB_STAT           =     '2'
        AND   A.ORD_FL              =     '1'
        AND   A.CUR_LOAD_LOC        LIKE  'Z%'
	    AND   E.ORD_PROG_CD        IN ('D','E')
			
    ORDER   BY  C.WTH_AIM           DESC,
                C.HOT_THK_AIM       DESC,
				E.DEL_TO_DATE        ASC,
			    NVL(E.EMGMTR_NMG_CLF,'N')   DESC, 
                A.CUR_LOAD_LOC       DESC
/*****************************选择编制的板坯********************************************************/
        ]]>
    </query> 
	<query id="UIF023010.insertSCH_MILL" desc="查询配置的宽度组" fetchSize="10">
        <![CDATA[
/*************************************************************************************/
	
INSERT INTO TBF02_SCH_MILL M
SELECT      (SELECT NVL(MAX(SLAB_EDT_SEQ ),0) + 1 FROM TBF02_SCH_MILL ) SLAB_EDT_SEQ   --  板坯编制号
            ,A.SLAB_NO                                                                 --  板坯号
            ,''                                                                        --  钢卷号
            ,'A0001'                                                                   --  轧辊号
            ,(SELECT NVL(MAX(ROLL_SLAB_SEQ),0) + 1 FROM TBF02_SCH_MILL ) ROLL_SLAB_SEQ --  轧辊内顺序
            ,''                                                                        --  LOT号
            ,0                                                                         --  LOT内钢卷个数
            ,0                                                                         --  LOT内钢卷编号
            --,H.PRDNM_CD PRODNM_CD                                                     --  产品代码
            ,E.PRODNM_CD
            ,A.STL_GRD                                                                 --  钢号
            ,D.FAC_STL_GRP                                                             --  钢号组
            ,A.SLAB_THK                                                                --  板坯厚度
            ,A.SLAB_WTH                                                                --  板坯宽度
            ,A.SLAB_LEN                                                                --  板坯长度
            ,A.SLAB_WGT                                                                --  板坯重量
			,'0' SLAB_TAPER                                                            --    调宽有无代码
			, A.SLAB_WTH SLAB_WTH_HEAD                                               --    板坯HEAD 宽度
			, A.SLAB_WTH SLAB_WTH_TAIL                                               --    板坯TAIL 宽度
            ,0                                                                         --  宽度变更开始位置
            ,0                                                                         --  宽度变更部分长度
            ,C.THK_AIM                                                                 --  厚度目标
           ,(SELECT T.THK_GRP_CD FROM TBF02_ROLL_THK_GRP T                             --  厚度组代码
                WHERE T.PLT = 'H'
                  AND A.INSTR_COIL_THK >= T.MINI 
                  AND A.INSTR_COIL_THK  < T.MAXI )THK_GRP_CD
            ,C.HOT_THK_AIM                                                             --  热厚度AIM
            ,C.HOT_THK_MIN                                                             --  热厚度MIN
            ,C.HOT_THK_MAX                                                             --  热厚度MAX
            ,C.WTH_AIM                                                                 --  宽度AlM
            ,C.WTH_MIN                                                                 --  宽度MIN
            ,C.WTH_MAX                                                                 --  宽度MAX                                                
           ,(SELECT T.WTH_GRP_CD FROM TBF02_ROLL_WTH_GRP T                             --  宽度组代码
                WHERE T.PLT = 'H'
                  AND A.INSTR_COIL_WTH >= T.MINI 
                  AND A.INSTR_COIL_WTH  < T.MAXI )WTH_GRP_CD
			,B.ORD_LEN
			,B.ORD_WGT
            ,'C'                                                                       --  热送代号
            ,A.ORD_NO                                                                  --  合同号
            ,A.ORD_SEQ                                                                 --  订单号
            ,E.ORD_USEAGE_CD                                                           --  订单用途代码
            ,A.SPEC_ABBSYM                                                             --  标准号
            ,E.ORDCUST_CD                                                              --  客户代码
            ,E.CUST_CD                                                                 --  客户代码
            ,E.DEST_CD                                                                 --  目的地代码
            ,E.del_to_date                                                             --  交货期
            ,E.UST_CD                                                                  --  UST区分
            ,'H'                                                                       --  去向
            ,A.INSTR_COIL_THK                                                          --  订单厚度
            ,A.INSTR_COIL_WTH                                                          --  订单宽度
            ,A.INSTR_COIL_WGT                                                          --  订单重量
            ,E.ORD_UNIT_WGT_MIN                                                       --  订单单重下限
            ,E.ORD_UNIT_WGT_MAX                                                        --  订单单重上限
            ,A.INSTR_COIL_INDIA                                                        --  订单内径
            ,A.INSTR_COIL_OUTDIA                                                        --  订单外径
            ,E.PACK_METHOD                                                             --  包装方法
            ,''                                                                        --  轧制工艺流程
            ,E.SPM_PROC_YN                                                           --  平整分卷指定判断
            ,B.COIL_CUT_CNT                                                            --  刚卷分割数
            ,''                                                                        --  目标加热温度
            ,''                                                                        --  目标出炉温度
            ,(SELECT  NVL(F.FUR_TME,0)                                     
               FROM  TBF02_FUR_TIME F                                      
              WHERE  F.PLT = 'H'                                           
                AND  F.FUR_LINE = 1                                        
                AND  F.STL_GRD  =  A.STL_GRD                               
                AND  F.SLAB_THK_MIN <= A.SLAB_THK                         
                AND  F.SLAB_THK_MAX >  A.SLAB_THK                          
                AND  F.HCR_CLF      =  'C') FUR_TME           
            ,''                                                            --  轧制时间
            ,A.CUR_LOAD_LOC                                                --  堆置位置
            ,''                                                            --  计划加热炉装炉日期
            ,''                                                            --  计划轧制时间
            ,''                                                            --  错误
            ,'A'                                                           --  状态区分
            ,''                                                            --  标识
            ,''
			,''
			,''
			,A.SLAB_STOCK_TYPE
			,E.ORD_USEAGE_CD
	      ,E.C_SPEC_ABBSYM
	      ,E.C_ORD_THK
	      ,E.C_ORD_WTH
	      ,E.ORD_UNIT_WGT
	      ,E.ORD_UNIT_WGT_MIN
	      ,E.ORD_UNIT_WGT_MAX
	      ,E.C_ORD_INDIA
	      ,E.C_ORD_OUTDIA
	      ,E.C_SPEC_STL_GRD
	      ,E.PROD_LINE
 FROM       TBG02_SLAB_COMM  A,
            TBD00_STLGRD D,
            TBE02_ORD_PRC E,
			TBB01_ORD_HEAD H,
            --(SELECT SLAB_NO, COUNT(SLAB_CUT_SEQ) COIL_CUT_CNT, SUM(ORD_LEN) ORD_LEN, SUM(ORD_WGT) ORD_WGT FROM TBG02_SLAB_COMM_D GROUP BY SLAB_NO) B,
            (SELECT SLAB_NO,
               COUNT(SLAB_CUT_SEQ) COIL_CUT_CNT,
               SUM(ORD_LEN) ORD_LEN,
               SUM(ORD_WGT) ORD_WGT
          FROM TBG02_SLAB_COMM_D COMMD
         WHERE COMMD.SLAB_NO =
               (SELECT SUB_SLAB_NO
                  FROM TBG02_SLAB_COMM
                 WHERE SLAB_NO = ? AND ROWNUM=1)
         GROUP BY SLAB_NO) B,---20160530优化查询，将传入值写在此处
            TBB01_ORD_PROD C
        -----------------------MODIFY BY WXY 100302---------------------------
        -----------------------DESC: 板坯号变更------------------------------
    WHERE   A.SUB_SLAB_NO = B.SLAB_NO
    	-------------------------------------------------------------------
       -- AND A.SLAB_NO = ?
        AND A.SLAB_NO NOT IN (SELECT SLAB_NO FROM  tbf02_sch_mill)
        AND A.STL_GRD = D.FAC_STL_GRD(+)
        AND A.ORD_NO  = C.ORD_NO(+)
        AND A.ORD_SEQ = C.ORD_SEQ(+)
		AND A.ORD_NO  = H.ORD_NO(+)
		AND A.ORD_SEQ = H.ORD_SEQ(+)
        AND E.ORD_NO  = A.ORD_NO
        AND E.ORD_SEQ = A.ORD_SEQ 
        AND A.CUR_PROG_CD           =     'RBA'
        AND   A.SLAB_STAT           =     '2'
        AND   A.ORD_FL              =     '1'
/*         AND   A.CUR_LOAD_LOC        LIKE  'Z%' */
    ORDER   BY  A.SLAB_WTH           DESC,
                A.SLAB_LEN           DESC,              
			    A.CUR_LOAD_LOC       DESC
 
 
			
/*************************************************************************************/
        ]]>
    </query> 
		<query id="UIF023010.findIsCCRFirstEdit" desc="查询是不是已经编制过ccr轧辊" fetchSize="1">
        <![CDATA[
            SELECT T.ROLL_NO
			FROM TBF02_SCH_ROLL T
        ]]>
    </query>
	<query id="UIF023010.insertSCH_ROLL" desc="将最新的CCR编制插入到TBF02_SCH_ROLL" fetchSize="10">
        <![CDATA[
/*****************************将最新的CCR编制插入到TBF02_SCH_ROLL********************************************************/
/*
INSERT INTO TBF02_SCH_ROLL
SELECT  A.ROLL_NO,                                                          --轧辊号
        A.WTH_GRP_CD,                                                       --宽度组代码
        C.MINI,                                                             --宽度组下限
        C.MAXI,                                                             --宽度组上限
        '',                                                                 --钢号组
        COUNT(A.SLAB_EDT_SEQ),                                              --板坯编制数
        SUM(A.SLAB_WGT),                                                    --板坯编制重量
        SUM(B.ORD_LEN),                                                     --轧钢总长度
        '0',                                                                --平整分卷数
        to_char(sysdate,'YYYYMMDDHH24MISS'),                                --CCR轧辊编制时间
        ''
FROM  TBF02_SCH_MILL                                                                  A,
      (SELECT SLAB_NO, SUM(ORD_LEN) ORD_LEN FROM TBG02_SLAB_COMM_D GROUP BY SLAB_NO)  B,
      TBF02_ROLL_WTH_GRP                                                              C                        
WHERE A.SLAB_NO = B.SLAB_NO
  AND A.WTH_GRP_CD = C.WTH_GRP_CD
GROUP BY (A.ROLL_NO,A.WTH_GRP_CD,C.MINI,C.MAXI)
ORDER BY WTH_GRP_CD DESC 
*/				
-----------------------------------------------------------
----------MODIFY BY WXY 100303 ----------------------------
----------DESC: 板坯号变更修改------------------------------
INSERT INTO TBF02_SCH_ROLL
SELECT  A.ROLL_NO,                                                          --轧辊号
        A.WTH_GRP_CD,                                                       --宽度组代码
        C.MINI,                                                             --宽度组下限
        C.MAXI,                                                             --宽度组上限
        '',                                                                 --钢号组
        COUNT(A.SLAB_EDT_SEQ),                                              --板坯编制数
        SUM(A.SLAB_WGT),                                                    --板坯编制重量
        SUM(B.ORD_LEN),                                                     --轧钢总长度
        '0',                                                                --平整分卷数
        to_char(sysdate,'YYYYMMDDHH24MISS'),                                --CCR轧辊编制时间
        ''
FROM  TBF02_SCH_MILL                                                                  A,
      (SELECT SLAB_NO, SUM(ORD_LEN) ORD_LEN FROM TBG02_SLAB_COMM_D GROUP BY SLAB_NO)  B,
      TBG02_SLAB_COMM                                                                 D,
      TBF02_ROLL_WTH_GRP                                                              C                        
WHERE '1' = '1'
  AND A.SLAB_NO = D.SLAB_NO
  AND D.SUB_SLAB_NO = B.SLAB_NO
  AND A.WTH_GRP_CD = C.WTH_GRP_CD
  AND C.PLT = 'H'
GROUP BY (A.ROLL_NO,A.WTH_GRP_CD,C.MINI,C.MAXI)
ORDER BY WTH_GRP_CD DESC
-----------------------------------------------------------
/***********************将最新的CCR编制插入到TBF02_SCH_ROLL**************************************************************/
        ]]>
    </query> 
	
	
	<query id="callCCREdit" desc="사원추가" fetchSize="1">
        <![CDATA[
            {call UIF023010.insSCH_MILL_D}
        ]]>
    </query>
	<query id="callAdjustRollSlabSeqByWthDesc" desc="adjustRollSlabSeqByWthDesc" fetchSize="1">
        <![CDATA[
            {call UIF023010.adjustRollSlabSeqByWthDesc}
        ]]>
    </query>
	<query id="UIF023010.findCCREdited" desc="查询配置的宽度组" fetchSize="10">
        <![CDATA[
/*****************************选择要取消的编制板坯********************************************************/
	
SELECT      A.SLAB_EDT_SEQ,                       /*板坯编制号*/
            A.ROLL_SLAB_SEQ,                      /*轧辊内顺序*/
            A.CUR_LOAD_LOC,                       /*现在堆置位置*/
            A.SLAB_NO  ,                          /*板坯号*/
            A.SLAB_THK,                           /*板坯厚度*/
            A.SLAB_WTH  ,                         /*板坯宽度*/
            A.SLAB_LEN  ,                         /*板坯长度*/
            A.SLAB_WGT  ,                         /*板坯重量*/
            A.ORD_THK  INSTR_COIL_THK ,           /*订单钢卷厚度*/
            A.ORD_WTH  INSTR_COIL_WTH,            /*订单钢卷宽*/
            A.MILL_LEN ORD_LEN   ,                /*订单钢卷长度*/
            A.MILL_LEN ORD_WGT,                   /*订单钢卷重量*/ 
            C.HOT_THK_AIM    ,                     --热厚度AIM
            C.HOT_THK_MIN    ,                     --热厚度MIN
            C.HOT_THK_MAX    ,                     --热厚度MAX
            C.WTH_AIM    ,                         --宽度AlM
            C.WTH_MIN    ,                         --宽度MIN
            C.WTH_MAX    ,                         --宽度MAX
            A.SPEC_ABBSYM ,                       /*规格略号*/
            A.ORD_NO  ,                           /*合同号*/
            A.ORD_SEQ  ,                          /*订单号*/
            Z.CUST_NM,                           /*客户公司代码*/
            A.STL_GRD  ,                          /*钢码*/
            E.DEL_TO_DATE,                        --交货期
            NVL(E.EMGMTR_NMG_CLF,'N') EMGMTR_NMG_CLF,         --紧急材代码
            T.SM_CFNM SLAB_RT                       /*板坯去向*/
		    ,T2.SM_CFNM DLIV_TP
			,B.MK_CONTENT
			,A.SLAB_STOCK_TYPE                          --入库类型
			,E.PRODNM_CD
  FROM      TBF02_SCH_MILL  A, 
            TBB01_ORD_PROD  C,
			TBA01_ORD_LINE  B,
            TBD00_STLGRD    D,
            TBE02_ORD_PRC   E,
            TBZ00_CUSTOMER  Z,
             (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01004') T
		    ,(SELECT   SM_CD, SM_CFNM FROM TBZ00_COMMCD  WHERE LG_CD = 'A01012') T2
            WHERE A.ORD_NO        = B.ORD_NO(+)
              AND A.ORD_SEQ       = B.ORD_SEQ(+)  
              AND B.DLIV_TP       =  T2.SM_CD(+)  
        AND   A.ORD_NO         =       C.ORD_NO(+)
        AND A.ORD_SEQ        =         C.ORD_SEQ(+)
        AND A.STL_GRD        =         D.FAC_STL_GRD(+)
        AND E.ORD_NO         =         A.ORD_NO
        AND E.ORD_SEQ        =         A.ORD_SEQ  
        AND Z.CUST_CD        =         A.CUST_CD   
        AND T.SM_CD          =         A.ROUTE	
        AND   A.ORD_WTH             >=     ?  
        AND   A.ORD_WTH             <      ?  
        AND   A.STL_GRD             LIKE   ?  ||'%'
     --   AND   D.FAC_STL_GRP         LIKE   ?  ||'%'
		AND   NVL(D.FAC_STL_GRP,' ')         LIKE   ?  ||'%'
        AND   A.ORD_NO || A.ORD_SEQ LIKE   ?  ||'%' || ? ||'%'
        AND   E.ORD_USEAGE_CD       LIKE   ?  ||'%' 
	    AND   A.CUR_LOAD_LOC        LIKE   ?  ||'%'
        AND   A.ORD_THK             >=     ?
        AND   A.ORD_THK             <      ?
ORDER BY A.ROLL_SLAB_SEQ
			
/********************************选择要取消的编制板坯*****************************************************/
        ]]>
    </query>
	<query id="UIF023010.deleteSchMill" desc="查询配置的宽度组" fetchSize="10">
        <![CDATA[
/*************************************************************************************/
			
    DELETE FROM TBF02_SCH_MILL T
      WHERE   T.SLAB_NO = ?

/*************************************************************************************/
        ]]>
    </query> 
	<query id="UIF023010.deleteSchMillD" desc="查询配置的宽度组" fetchSize="10">
        <![CDATA[
/*************************************************************************************/
			
    DELETE FROM TBF02_SCH_MILL_D T
      WHERE T.SLAB_EDT_SEQ NOT IN (SELECT SLAB_EDT_SEQ FROM TBF02_SCH_MILL )

/*************************************************************************************/
        ]]>
    </query> 
	<query id="UIF023010.deleteSchRoll" desc="删除CCR轧辊编制信息" fetchSize="10">
        <![CDATA[
/**************删除CCR轧辊编制信息**********************************************************************/
			
    DELETE FROM TBF02_SCH_ROLL
      
/****************删除CCR轧辊编制信息*********************************************************************/
        ]]>
    </query> 
</queryMap>