XinYu_RZMES/.svn/pristine/0a/0afe830c8c26cb00cd6f6b218472d1734e1e7a19.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="炼钢工序类别作业所需时间标准">
	<query id="UIF012040.find" desc="查询需要调整的转炉信息" fetchSize="10">
		
        <![CDATA[
			
			/*查询从工序调整的炉次信息*/
SELECT      'false' CHK,
			B.CAST_MANA_NO  ,/*浇次管理号*/
            B.CAST_CHARGE_SEQ  ,/*浇次内顺序*/
            B.PRC_LINE  ,/*转炉号*/
            B.CHARGE_MANA_NO  ,/*炉次管理号*/
            B.STL_GRD  ,/*钢号*/
            B.PREV_CHARGE_WGT  ,/*预定出钢量*/
            regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(B.LINE_PROC_CD,'B','>>BOF'),'C','>>CAS'),'L','>>LF'),'R','>>RH'),'V','>>VD'),'J','>>CCM') 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  ,/*进程代码*/
            T3.SM_CFNM  STATUS_CD  ,/*状态区分*/
            T2.SM_CFNM  HCR_CLF  ,/*热送代*/
            A.L2_SEND  ,/*L2传送*/
            B.MILL_FL,  /*轧制编制区分*/
            B.CHARGE_EDT_SEQ/*   炉次编制号*/           
FROM        TBF01_CHARGE_IDX     A, 
            TBF01_SPEC_CHARGE    B,
			(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
WHERE  A.STATUS_CD                 =     'A'
	 AND  A.L2_SEND = 'N'
     AND  B.HCR_CLF                = T2.SM_CD
     AND  B.PROG_CD                = T1.SM_CD 
     AND  B.STATUS_CD              = T3.SM_CD
     AND  A.CHARGE_EDT_SEQ         =     B.CHARGE_EDT_SEQ
     AND  B.STL_GRD                LIKE      ?||'%'
     AND  A.PRC_LINE               LIKE      ?||'%'
	 AND  A.CCM_PRC_LINE           LIKE    ?||'%'
     AND  A.CHARGE_EDT_SEQ          =     B.CHARGE_EDT_SEQ
ORDER   BY A.CHG_SEQ  ASC
		
        ]]>
    </query> 
   <query id="UIF012040_1.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    ,/*板坯重量*/
          T1.SM_CFNM  HCR_CLF    ,/*热送代码*/
          A.EMGMTR_NMG_CLF    ,/*紧急材代码*/
          A.OVER_ROLL_YN    ,/*过量生产判断*/
          T2.SM_CFNM   ORD_FL    ,/*订单材余材区分*/
          A.ORD_THK    ,/*订单厚度*/
          A.ORD_WTH    ,/*订单宽度*/
          T3.SM_CFNM  ORD_USEAGE_CD    ,/*订单用途代码*/
          A.DELV_REQ_DATE,/*交货期*/
          T4.SM_CFNM  SLAB_RT    /*板坯去向*/
FROM      TBF01_SPEC_SLAB  A,
        (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01012') T1,
		(SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01007') T2,
		(SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01007') T3,
        (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01004') T4
WHERE     A.CHARGE_EDT_SEQ      =     ?
  AND     A.HCR_CLF             =     T1.SM_CD
  AND     A.ORD_FL              =     T2.SM_CD
  AND     A.ORD_USEAGE_CD       =     T3.SM_CD
  AND     A.SLAB_RT             =     T4.SM_CD  
ORDER   BY A.CHARGE_SLAB_SEQ  ASC
			                        
    ]]>
    </query>  
    <query id="UIF012040_COMM_PATH_CD.find" desc="查询工序路径的信息" fetchSize="10">
		
        <![CDATA[
			SELECT A.LG_CD
				   ,A.SM_CFNM SM_CD
				   ,regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(regexp_replace(A.SM_CFNM,'B','>>BOF'),'C','>>CAS'),'L','>>LF'),'R','>>RH'),'V','>>VD'),'J','>>CCM') SM_CFNM
				   ,A.SM_EFNM 
				   FROM (
				SELECT INSTR(T1.SM_CFNM,NVL(:1,T1.SM_CFNM),1) BOF
				       ,INSTR(T1.SM_CFNM,NVL(:2,T1.SM_CFNM),1) CAS
				       ,INSTR(T1.SM_CFNM,NVL(:3,T1.SM_CFNM),1) LF
				       ,INSTR(T1.SM_CFNM,NVL(:4,T1.SM_CFNM),1) RH
				       ,INSTR(T1.SM_CFNM,NVL(:5,T1.SM_CFNM),1) VD
				       ,INSTR(T1.SM_CFNM,NVL(:6,T1.SM_CFNM),1) CCM
				       ,T1.* FROM  TBZ00_COMMCD T1 
				WHERE T1.LG_CD = 'F01004'
				AND  LENGTHB(T1.SM_CFNM) = :7
				) A
				WHERE BOF > 0
				AND CAS > 0
				AND LF > 0
				AND RH > 0
				AND VD > 0
				AND CCM > 0           
    ]]>
    </query> 
</queryMap>