B'),'J','->J'),'C','->C'),'R','->R'),'L','->L') INSTR_TREAT_RT ,b.STL_GRD ,b.CAST_EDT_CHARGE_CNT ||'-'||b.CAST_CHARGE_SEQ CAST_SEQ ,PROC_CD ,TREAT_CD ,(select SM_CFNM from TBZ00_COMMCD where LG_CD = 'G02001' and SM_CD = TREAT_CD ) CD_DESC ,TREAT_DTIME ,TREAT_TEMP ,TREAT_WGT ,A.REG_DTIME from TBG03_STLMAKE_PROG a, TBG02_CHARGE_COMM b where a.CHARGE_NO = b.CHARGE_NO AND a.CHARGE_NO = ? ORDER BY TREAT_DTIME ) ]]> TO_CHAR(SYSDATE - 10,'YYYYMMDDHH24MMSS') and SUBSTR(t1.CHARGE_MANA_NO,2,9) = SUBSTR(T3.CHARGE_NO,2,9) AND L2_SEND = 'Y' AND ROWNUM <= 10 ORDER BY CHG_SEQ ]]>