XinYu_RZMES/.svn/pristine/c1/c1810786ff0a8d4855be5d9e5085f1f27fc25311.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="炼钢工序类别作业所需时间标准">
	<query id="UIF012030_BOF1.find" desc="查询1号转炉信息" fetchSize="10">
		
        <![CDATA[
			
			/*查查询1号转炉信息*/

	 SELECT   B.CAST_MANA_NO,/*   浇次管理号*/
            B.CAST_CHARGE_SEQ,/*  浇次内顺序*/
            A.PRC_LINE  ,/*转炉号*/
            B.CHARGE_MANA_NO ,/* 炉次管理号*/
            B.STL_GRD,/*钢号*/
            B.PREV_CHARGE_WGT ,/* 预定出钢量*/
            B.LINE_PROC_CD ,/* 处理路径代码*/
            B.CCM_THK,/*  浇铸厚度*/
            B.CCM_WTH ,/* 浇铸宽度*/
            B.ORD_SLAB_CNT,/*  订单板坯块数*/
            B.NONORD_SLAB_CNT,/*  余材板坯块数*/
            B.PRE_BOF_STR_DTIME,/*  计划出钢开始*/
            T1.SM_CFNM PROG_CD,/*   进程代码*/
            A.STATUS_CD ,
            T3.SM_CFNM  STATUS_CFNM,/*   状态区分*/
            T2.SM_CFNM  HCR_CLF,/*   热送代*/
            A.L2_SEND,/*   L2传送*/
            B.MILL_FL,/*   轧制编制区分*/
            B.CHARGE_EDT_SEQ,/*   炉次编制号*/
            C.RTN_CHARGE_CLF,/* 回送代码*/
            DECODE(D.DSN_KIND,'1','Y','') DSN_KIND
            --,DECODE(TO_CHAR(E.L2DEMO),'','','Y') L2DEMO  --中厚板特殊要求
            ,(CASE WHEN NVL(LENGTH(E.L2DEMO),0)>0 THEN 'Y' ELSE '' END)  L2DEMO   --中厚板特殊要求
            ,B.INS_CHARGE_STR_DTIME        --计划炼钢起始时间
            ,B.INS_CHARGE_END_DTIME        --计划炼钢截止时间
            ,C.DIVIDE_CHARGE_YN
            ,B.CHARGE_RT
      FROM      TBF01_CHARGE_IDX   A, 
                TBF01_SPEC_CHARGE  B,
                TBG02_CHARGE_COMM  C,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01002') T1,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01012') T2,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'Z01001') T3,
          ----------------------------------------------------------------------------
          --MODIFY: BY SJW 090828
        --DESC  : 王艳辉要求增加显示客服特殊要求
        --VERSION:1.8-->1.9
        (SELECT  DISTINCT B.CHARGE_MANA_NO,'1' DSN_KIND
          FROM  TBF01_SPEC_CHARGE  A
            ,TBF01_SPEC_SLAB   B
            ,TBB01_ORD_HEAD    C
        WHERE   A.CHARGE_EDT_SEQ   =    B.CHARGE_EDT_SEQ
          AND   B.ORD_NO           =    C.ORD_NO
          AND   B.ORD_SEQ          =    C.ORD_SEQ
          AND   A.STATUS_CD        IN   ('A','B')
          AND   C.CUST_SPEC_NO_INGR IS NOT NULL)                                      D 
          -------------------------------------------------------------------------------         
          --MODIFY: BY WXY 100526
         --DESC  : 王艳辉要求增加显示中厚板客户特殊要求
          ,(   SELECT WMSYS.WM_CONCAT(DISTINCT C.SPEC_REQ_DESC) L2DEMO
                     ,SUBSTR(C.SLAB_MANA_NO,1,10) CHARGE_MANA_NO
              FROM TBF01_SPEC_SLAB C
              WHERE SPEC_REQ_DESC IS NOT NULL 
              GROUP BY SUBSTR(C.SLAB_MANA_NO,1,10))      E 
          -------------------------------------------------------------------------------                           
      WHERE     'B' = ?
         AND  A.STATUS_CD                IN    ('A','B')
         AND  A.PRC_LINE                 =    '1' /*(转炉标准)*/
         AND  A.CHARGE_EDT_SEQ           =     B.CHARGE_EDT_SEQ
         AND  B.CHARGE_MANA_NO           =     C.NEW_PLAN_CHARGE_NO(+)
         AND  B.PROG_CD                  =         T1.SM_CD(+)
         AND  B.HCR_CLF                  =         T2.SM_CD
         AND  B.STATUS_CD                =         T3.SM_CD
       AND  B.CHARGE_RT                LIKE     ?
     ----------------------------------------------------------  
     --MODIFY: BY SJW 090828
     --DESC  : 王艳辉要求增加显示客户特殊要求
     --VERSION:1.8-->1.9
         AND B.CHARGE_MANA_NO            =      D.CHARGE_MANA_NO(+)
     ----------------------------------------------------------  
    
     --MODIFY: BY WXY 100526
     --DESC  : 王艳辉要求增加显示中厚板客户特殊要求
         AND B.CHARGE_MANA_NO = E.CHARGE_MANA_NO(+)
          ----------------------------------------------------------  
      ORDER   BY A.CHG_SEQ  ASC
		
        ]]>
    </query> 
   <query id="UIF012030_BOF2.find" desc="查询2号转炉信息" fetchSize="10">
		
        <![CDATA[
			
			/*查询2号转炉信息*/

	 SELECT B.CAST_MANA_NO,/*   浇次管理号*/
            B.CAST_CHARGE_SEQ,/*  浇次内顺序*/
            A.PRC_LINE  ,/*转炉号*/
            B.CHARGE_MANA_NO ,/* 炉次管理号*/
            B.STL_GRD,/*钢号*/
            B.PREV_CHARGE_WGT ,/* 预定出钢量*/
            B.LINE_PROC_CD ,/* 处理路径代码*/
            B.CCM_THK,/*  浇铸厚度*/
            B.CCM_WTH ,/* 浇铸宽度*/
            B.ORD_SLAB_CNT,/*  订单板坯块数*/
            B.NONORD_SLAB_CNT,/*  余材板坯块数*/
            B.PRE_BOF_STR_DTIME,/*  计划出钢开始*/
            T1.SM_CFNM PROG_CD,/*   进程代码*/
            A.STATUS_CD ,
            T3.SM_CFNM  STATUS_CFNM,/*   状态区分*/
            T2.SM_CFNM  HCR_CLF,/*   热送代*/
            A.L2_SEND,/*   L2传送*/
            B.MILL_FL,/*   轧制编制区分*/
            B.CHARGE_EDT_SEQ,/*   炉次编制号*/
            C.RTN_CHARGE_CLF,/* 回送代码*/
            DECODE(D.DSN_KIND,'1','Y','') DSN_KIND
            --,DECODE(to_char(E.L2DEMO),'','','Y') L2DEMO  --中厚板特殊要求
            ,(case when nvl(length(E.L2DEMO),0)>0 then 'Y' else '' end)  L2DEMO
            ,B.INS_CHARGE_STR_DTIME				--计划炼钢起始时间
            ,B.INS_CHARGE_END_DTIME				--计划炼钢截止时间
            ,C.DIVIDE_CHARGE_YN
            ,B.CHARGE_RT
      FROM      TBF01_CHARGE_IDX   A, 
                TBF01_SPEC_CHARGE  B,
                TBG02_CHARGE_COMM  C,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01002') T1,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01012') T2,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'Z01001') T3,
			    ----------------------------------------------------------------------------
			    --MODIFY: BY SJW 090828
				--DESC  : 王艳辉要求增加显示客服特殊要求
				--VERSION:1.8-->1.9
				(SELECT  DISTINCT B.CHARGE_MANA_NO,'1' DSN_KIND
				  FROM  TBF01_SPEC_CHARGE  A
						,TBF01_SPEC_SLAB   B
						,TBB01_ORD_HEAD    C
				WHERE   A.CHARGE_EDT_SEQ   =    B.CHARGE_EDT_SEQ
				  AND   B.ORD_NO           =    C.ORD_NO
				  AND   B.ORD_SEQ          =    C.ORD_SEQ
				  AND   A.STATUS_CD        IN   ('A','B')
				  AND   C.CUST_SPEC_NO_INGR IS NOT NULL)                                      D 
			    -------------------------------------------------------------------------------   
			    --MODIFY: BY WXY 100526
		 		--DESC  : 王艳辉要求增加显示中厚板客户特殊要求
          ,(   SELECT wmsys.wm_concat(DISTINCT c.SPEC_REQ_DESC) L2DEMO
                     ,substr(c.SLAB_MANA_NO,1,10) CHARGE_MANA_NO
              FROM TBF01_SPEC_SLAB C
              WHERE SPEC_REQ_DESC IS NOT NULL 
              GROUP BY substr(c.SLAB_MANA_NO,1,10))      E 
          -------------------------------------------------------------------------------                               
      WHERE     'B' = ?
         AND  A.STATUS_CD                IN    ('A','B')
         AND  A.PRC_LINE                 =    '2' /*(转炉标准)*/
         AND  A.CHARGE_EDT_SEQ           =     B.CHARGE_EDT_SEQ
         AND  B.CHARGE_MANA_NO           =     C.NEW_PLAN_CHARGE_NO(+)
         AND  B.PROG_CD                   =         T1.SM_CD(+)
         AND  B.HCR_CLF                   =         T2.SM_CD
         AND  B.STATUS_CD                 =         T3.SM_CD
	     AND  B.CHARGE_RT                like     ?
		 ----------------------------------------------------------	
		 --MODIFY: BY SJW 090828
		 --DESC  : 王艳辉要求增加显示客服特殊要求
		 --VERSION:1.8-->1.9
         AND B.CHARGE_MANA_NO            =      D.CHARGE_MANA_NO(+)
		 ----------------------------------------------------------	
		 --MODIFY: BY WXY 100526
		 --DESC  : 王艳辉要求增加显示中厚板客户特殊要求
         AND B.CHARGE_MANA_NO = E.CHARGE_MANA_NO(+)
          ----------------------------------------------------------	
      ORDER   BY A.CHG_SEQ  ASC
			                        
    ]]>
    </query> 
		<query id="UIF012030_CCM1.find" desc="查询1号CCM信息" fetchSize="10">
		
        <![CDATA[
			
			/*查询1号CCM信息*/
				
	 SELECT B.CAST_MANA_NO,/*   浇次管理号*/
            B.CAST_CHARGE_SEQ,/*  浇次内顺序*/
            A.PRC_LINE  ,/*转炉号*/
            B.CHARGE_MANA_NO ,/* 炉次管理号*/
            B.STL_GRD,/*钢号*/
            B.PREV_CHARGE_WGT ,/* 预定出钢量*/
            B.LINE_PROC_CD ,/* 处理路径代码*/
            B.CCM_THK,/*  浇铸厚度*/
            B.CCM_WTH ,/* 浇铸宽度*/
            B.ORD_SLAB_CNT,/*  订单板坯块数*/
            B.NONORD_SLAB_CNT,/*  余材板坯块数*/
            B.PRE_BOF_STR_DTIME,/*  计划出钢开始*/
            T1.SM_CFNM PROG_CD,/*   进程代码*/
            A.STATUS_CD ,
            T3.SM_CFNM  STATUS_CFNM,/*   状态区分*/
            T2.SM_CFNM  HCR_CLF,/*   热送代*/
            A.L2_SEND,/*   L2传送*/
            B.MILL_FL,/*   轧制编制区分*/
            B.CHARGE_EDT_SEQ,/*   炉次编制号*/
            C.RTN_CHARGE_CLF,/* 回送代码*/
            DECODE(D.DSN_KIND,'1','Y','') DSN_KIND
            ,B.INS_CHARGE_STR_DTIME				--计划炼钢起始时间
            ,B.INS_CHARGE_END_DTIME				--计划炼钢截止时间
            ,C.DIVIDE_CHARGE_YN
            ,B.CHARGE_RT
      FROM      TBF01_CHARGE_IDX   A, 
                TBF01_SPEC_CHARGE  B,
                TBG02_CHARGE_COMM  C,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01002') T1,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01012') T2,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'Z01001') T3,
			    ----------------------------------------------------------------------------
			    --MODIFY: BY SJW 090828
				--DESC  : 王艳辉要求增加显示客服特殊要求
				--VERSION:1.8-->1.9
				(SELECT  DISTINCT B.CHARGE_MANA_NO,C.DSN_KIND
				  FROM  TBF01_SPEC_CHARGE  A
						,TBF01_SPEC_SLAB   B
						,TBB01_ORD_INGR    C
				WHERE   A.CHARGE_EDT_SEQ   =    B.CHARGE_EDT_SEQ
				  AND   B.ORD_NO           =    C.ORD_NO
				  AND   B.ORD_SEQ          =    C.ORD_SEQ
				  AND   A.STATUS_CD        IN   ('A','B')
				  AND   C.DSN_KIND         =    '1')                                      D 
			    -------------------------------------------------------------------------------                               
      WHERE     'C' = ?
         AND  A.STATUS_CD                IN    ('A','B')
         AND  A.CCM_PRC_LINE            =    '1'/*(连铸标准)*/
         AND  A.CHARGE_EDT_SEQ           =     B.CHARGE_EDT_SEQ
         AND  B.CHARGE_MANA_NO           =     C.NEW_PLAN_CHARGE_NO(+)
         AND  B.PROG_CD                   =         T1.SM_CD
         AND  B.HCR_CLF                   =         T2.SM_CD
         AND  B.STATUS_CD                 =         T3.SM_CD
	     AND  B.CHARGE_RT                like     ?
		 ----------------------------------------------------------	
		 --MODIFY: BY SJW 090828
		 --DESC  : 王艳辉要求增加显示客服特殊要求
		 --VERSION:1.8-->1.9
         AND B.CHARGE_MANA_NO            =      D.CHARGE_MANA_NO(+)
		 ----------------------------------------------------------	
      ORDER   BY A.CHG_SEQ  ASC
			
        ]]>
    </query> 
   <query id="UIF012030_CCM2.find" desc="查询2号CCM信息" fetchSize="10">
		
        <![CDATA[
		
	/*查询2号CCM信息*/	
	 SELECT B.CAST_MANA_NO,/*   浇次管理号*/
            B.CAST_CHARGE_SEQ,/*  浇次内顺序*/
            A.PRC_LINE  ,/*转炉号*/
            B.CHARGE_MANA_NO ,/* 炉次管理号*/
            B.STL_GRD,/*钢号*/
            B.PREV_CHARGE_WGT ,/* 预定出钢量*/
            B.LINE_PROC_CD ,/* 处理路径代码*/
            B.CCM_THK,/*  浇铸厚度*/
            B.CCM_WTH ,/* 浇铸宽度*/
            B.ORD_SLAB_CNT,/*  订单板坯块数*/
            B.NONORD_SLAB_CNT,/*  余材板坯块数*/
            B.PRE_BOF_STR_DTIME,/*  计划出钢开始*/
            T1.SM_CFNM PROG_CD,/*   进程代码*/
            A.STATUS_CD ,
            T3.SM_CFNM  STATUS_CFNM,/*   状态区分*/
            T2.SM_CFNM  HCR_CLF,/*   热送代*/
            A.L2_SEND,/*   L2传送*/
            B.MILL_FL,/*   轧制编制区分*/
            B.CHARGE_EDT_SEQ,/*   炉次编制号*/
            C.RTN_CHARGE_CLF,/* 回送代码*/
            DECODE(D.DSN_KIND,'1','Y','') DSN_KIND
            ,B.INS_CHARGE_STR_DTIME				--计划炼钢起始时间
            ,B.INS_CHARGE_END_DTIME				--计划炼钢截止时间
            ,C.DIVIDE_CHARGE_YN
            ,B.CHARGE_RT
      FROM      TBF01_CHARGE_IDX   A, 
                TBF01_SPEC_CHARGE  B,
                TBG02_CHARGE_COMM  C,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01002') T1,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01012') T2,
                (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'Z01001') T3,
			    ----------------------------------------------------------------------------
			    --MODIFY: BY SJW 090828
				--DESC  : 王艳辉要求增加显示客服特殊要求
				--VERSION:1.8-->1.9
				(SELECT  DISTINCT B.CHARGE_MANA_NO,C.DSN_KIND
				  FROM  TBF01_SPEC_CHARGE  A
						,TBF01_SPEC_SLAB   B
						,TBB01_ORD_INGR    C
				WHERE   A.CHARGE_EDT_SEQ   =    B.CHARGE_EDT_SEQ
				  AND   B.ORD_NO           =    C.ORD_NO
				  AND   B.ORD_SEQ          =    C.ORD_SEQ
				  AND   A.STATUS_CD        IN   ('A','B')
				  AND   C.DSN_KIND         =    '1')                                      D 
			    -------------------------------------------------------------------------------                               
      WHERE     'C' = ?
         AND  A.STATUS_CD                IN    ('A','B')
         AND  A.CCM_PRC_LINE            =    '2'/*(连铸标准)*/
         AND  A.CHARGE_EDT_SEQ           =     B.CHARGE_EDT_SEQ
         AND  B.CHARGE_MANA_NO           =     C.NEW_PLAN_CHARGE_NO(+)
         AND B.PROG_CD                   =         T1.SM_CD
         AND B.HCR_CLF                   =         T2.SM_CD
         AND B.STATUS_CD                 =         T3.SM_CD
	     AND  B.CHARGE_RT                like     ?
		 ----------------------------------------------------------	
		 --MODIFY: BY SJW 090828
		 --DESC  : 王艳辉要求增加显示客服特殊要求
		 --VERSION:1.8-->1.9
         AND B.CHARGE_MANA_NO            =      D.CHARGE_MANA_NO(+)
		 ----------------------------------------------------------	
      ORDER   BY A.CHG_SEQ  ASC
			
        ]]>
    </query> 
	
    <query id="UIF012030_slabInfo.find" desc=" " fetchSize="10">
    <![CDATA[		
	SELECT    A.CHARGE_SLAB_SEQ,/*    炉次内顺序*/
                      A.SLAB_EDT_SEQ,/*    板坯编制号*/
                      A.SLAB_MANA_NO,/*    板坯管理号*/
                      A.STL_GRD,/*     钢号*/
                      A.SLAB_THK,/*    板坯厚度*/
                      A.SLAB_WTH,/*    板坯宽度*/
                      A.SLAB_LEN,/*    板坯长度*/
                      A.SLAB_WGT,/*    板坯重量*/
                      T4.SM_CFNM  HCR_CLF,/*    热送代码*/
                      A.EMGMTR_NMG_CLF,/*    紧急材代码*/
                      A.OVER_ROLL_YN,/*    过量生产判断*/
                      T3.SM_CFNM  ORD_FL,/*    订单材余材区分*/
                      A.ORD_THK,/*    订单厚度*/
                      A.ORD_WTH,/*    订单宽度*/
                      T2.SM_CFNM ORD_USEAGE_CD,/*    订单用途代码*/
                      A.DELV_REQ_DATE,/*    交货期*/
                      T1.SM_CFNM SLAB_RT /*    板坯去向*/  
                      ,A.ORD_NO
                      ,A.ORD_SEQ    
                ,A.KEEPWARM_YN    
                ,SPEC_REQ_DESC         /*中厚板特殊要求备注*/  
                ,DECODE(B.DLIV_TP,'T','火运','C','汽运') DLIV_TP  /*运输方式 TL 091207*/    
            FROM TBF01_SPEC_SLAB  A,
                 (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01004') T1,
                 (SELECT T.SM_CD ,T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01007') T2,
                 (SELECT T.SM_CD ,T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01007') T3,
                 (SELECT T.SM_CD ,T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01012') T4,
                 TBA01_ORD_LINE B
            WHERE A.SLAB_RT          =         T1.SM_CD
              AND A.ORD_USEAGE_CD    =         T2.SM_CD(+)
              AND A.ORD_FL           =         T3.SM_CD
              AND A.ORD_NO           =         B.ORD_NO(+)
              AND A.ORD_SEQ          =         B.ORD_SEQ(+)
              AND A.HCR_CLF          =         T4.SM_CD
              AND A.CHARGE_EDT_SEQ   =         ?    /*  所选炉次CHARGE 号*/
      ORDER   BY A.CHARGE_SLAB_SEQ  ASC
		 ]]>
    </query> 
	
	<query id="UIF012030_STL_STANDARD.find" desc=" 查询炼钢操作标准  " fetchSize="10">
		
        <![CDATA[
		
	/*查询炼钢操作标准*/	
		SELECT  A.CHARGE_EDT_SEQ             
        		,A.CHARGE_MANA_NO
				,to_char(B.BOF_TEMP_TGT) BOF_TEMP_TGT
		        ,to_char(B.CAS_TEMP_TGT) CAS_TEMP_TGT
		        ,to_char(B.RH_TEMP_TGT) RH_TEMP_TGT
		        ,to_char(B.LF_TEMP_TGT) LF_TEMP_TGT
		        ,to_char(B.PREV_CHARGE_WGT) PREV_CHARGE_WGT
		FROM    TBF01_SPEC_CHARGE  B
		        ,TBF01_CHARGE_IDX  A 
		WHERE  B.CHARGE_EDT_SEQ  =  A.CHARGE_EDT_SEQ
		 AND  A.L2_SEND         =     'N'
		 AND  A.STATUS_CD       =     'A'
		 AND  A.PRC_LINE        =     ?
		 AND  A.CHG_SEQ         <=    (SELECT  CHG_SEQ
		                                 FROM  TBF01_CHARGE_IDX
		                                WHERE  CHARGE_MANA_NO   =   ?
		                                  AND  L2_SEND          =   'N'
		                                  AND  STATUS_CD        =   'A')
		ORDER  BY  A.CHG_SEQ
			
        ]]>
    </query> 
</queryMap>