XinYu_RZMES/.svn/pristine/61/614ebef6b5fb826e19306eac381cf473c33096eb.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
<query id="UIG010030_01" desc="  " fetchSize="10">
		<![CDATA[
			  
 SELECT '' NUM  
       ,CHARGE_NO CHARGE_NO
       ,CHG_CHARGE_MANA_NO CHG_CHARGE_MANA_NO
       ,SUBSTR(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LINE_PROC_CD,'B','BOF'),'C','CAS'),'R','RH'),'J','CCM'),'L','LF'),3) INSTR_TREAT_RT 
       ,ACT_RT ACT_RT
       ,PROC_CD PROC_CD
       ,STL_GRD STL_GRD
       ,ORD_FL ORD_FL
       ,HCR_CLF HCR_CLF
       ,PRODNM_CD PRODNM_CD
       ,SPEC_ABBSYM SPEC_ABBSYM
       ,CAST_NO CAST_NO
       ,BOF_TAPPING_WGT BOF_TAPPING_WGT
       ,CCM_ARRV_WGT CCM_ARRV_WGT
 FROM 
 (
  SELECT  a.CHARGE_NO
       ,CHG_CHARGE_MANA_NO 
       ,REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LINE_PROC_CD,'J','->J'),'L','->L'),'R','->R'),'C','->C'),'B','->B') LINE_PROC_CD   
       ,REPLACE(ACT_BOF_RT,'B','BOF')||
        DECODE(ACT_CAS_RT,NULL,NULL,'->')||
        REPLACE(ACT_CAS_RT,'C','CAS')||
        DECODE(ACT_RH_RT,NULL,NULL,'',NULL,'->')|| 
        REPLACE(ACT_RH_RT,'R','RH' )||
        DECODE(ACT_LF_RT,NULL,NULL,'',NULL,'->')|| 
        REPLACE(ACT_LF_RT,'L','LF')|| 
        DECODE(ACT_CCM_RT,NULL,NULL,'',NULL,'->')||
        REPLACE(ACT_CCM_RT,'J','CCM') ||
        DECODE(ACT_CCM_RT,NULL,NULL,NULL) ACT_RT
       ,SM_CFNM PROC_CD
       ,c.STL_GRD
       ,a.ORD_FL
       ,c.HCR_CLF
       ,c.PRODNM_CD
       ,c.SPEC_ABBSYM
       ,CAST_NO
       ,BOF_TAPPING_WGT
       ,CCM_ARRV_WGT
      FROM TBG02_CHARGE_COMM a , 
        TBF01_SPEC_CHARGE c  ,
       (SELECT CHARGE_EDT_SEQ,CHG_CHARGE_MANA_NO FROM TBF01_CHARGE_IDX 
          WHERE STATUS_CD IN('A','B')
           AND  L2_SEND = 'Y' 
           ORDER BY CHG_SEQ 
        ) b , 
        (  SELECT   a.CHARGE_NO ,a.TREAT_CD PROC_CD,SM_CFNM,MAX_DTIME
             FROM TBG03_STLMAKE_PROG a,
                  (
                    SELECT CHARGE_NO,MAX(TREAT_DTIME) MAX_DTIME  
                      FROM  TBG03_STLMAKE_PROG
                     WHERE  CHARGE_STAT != '3'
                      GROUP BY CHARGE_NO  
                  ) b,
                  (
                    SELECT  SM_CD,SM_CFNM FROM  TBZ00_COMMCD
                    WHERE  LG_CD = 'G02001'
                  ) c
            WHERE  a.TREAT_CD = c.SM_CD
             and  a.CHARGE_NO  = b.CHARGE_NO
             AND    a.TREAT_DTIME = b.MAX_DTIME
              
        ) d  
       
        WHERE   a.CHARGE_NO = d.CHARGE_NO(+)   
          AND b.CHG_CHARGE_MANA_NO =  PLAN_CHARGE_NO(+)
          AND b.CHARGE_EDT_SEQ = c.CHARGE_EDT_SEQ
      )      
        ]]>
	</query> 
</queryMap>