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 ) ]]>