= to_date(?,'YYYY-MM-DD HH24:MI:SS') and TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') < to_date(?,'YYYY-MM-DD HH24:MI:SS')+1 order by CR_PLANT_TRS_DTIME,CR_PLANT_TRS_SEQ ) QQ full join (select A.OLD_SAMPL_NO, max(DECODE(WI.CHEM_CD, 'C', WI.CHEM_VAL)) VALUE_C, max(DECODE(WI.CHEM_CD, 'Mn', WI.CHEM_VAL)) VALUE_Mn, max(DECODE(WI.CHEM_CD, 'S', WI.CHEM_VAL)) VALUE_S, max(DECODE(WI.CHEM_CD, 'P', WI.CHEM_VAL)) VALUE_P, max(DECODE(WI.CHEM_CD, 'Si', WI.CHEM_VAL)) VALUE_Si, max(DECODE(WI.CHEM_CD, 'Ti', WI.CHEM_VAL)) VALUE_Ti, max(DECODE(WI.CHEM_CD, 'N', WI.CHEM_VAL)) VALUE_N from c_tbk02_coil_comm A,TBE02_ORD_PRC B,TBB02_WORK_INGR WI,TBG02_CHARGE_COMM_D D where A.OLD_ORD_NO = B.ORD_NO AND A.OLD_ORD_SEQ = B.ORD_SEQ and A.COIL_STAT = '1' and A.CUR_PROG_CD = 'PAB' AND TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') >= to_date(?,'YYYY-MM-DD HH24:MI:SS') and TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') < to_date(?,'YYYY-MM-DD HH24:MI:SS')+1 AND WI.CHARGE_NO = D.CHARGE_NO AND WI.PROC_CD || WI.CHEM_SEQ = D.LST_INGR_CD AND SUBSTR(A.SLAB_NO, 1, 10) = WI.CHARGE_NO AND WI.CHEM_CD IN ('C','Mn','S','P','Si','Ti','N') GROUP BY A.OLD_SAMPL_NO) CC on QQ.OLD_SAMPL_NO = CC.OLD_SAMPL_NO ]]> = to_date(?,'YYYY-MM-DD HH24:MI:SS') and TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') < to_date(?,'YYYY-MM-DD HH24:MI:SS')+1 order by CR_PLANT_TRS_DTIME,CR_PLANT_TRS_SEQ ) QQ full join (select A.OLD_SAMPL_NO, max(DECODE(WI.CHEM_CD, 'C', WI.CHEM_VAL)) VALUE_C, max(DECODE(WI.CHEM_CD, 'Mn', WI.CHEM_VAL)) VALUE_Mn, max(DECODE(WI.CHEM_CD, 'S', WI.CHEM_VAL)) VALUE_S, max(DECODE(WI.CHEM_CD, 'P', WI.CHEM_VAL)) VALUE_P, max(DECODE(WI.CHEM_CD, 'Si', WI.CHEM_VAL)) VALUE_Si, max(DECODE(WI.CHEM_CD, 'Ti', WI.CHEM_VAL)) VALUE_Ti, max(DECODE(WI.CHEM_CD, 'N', WI.CHEM_VAL)) VALUE_N from c_tbk02_coil_comm A,TBE02_ORD_PRC B,TBB02_WORK_INGR WI,TBG02_CHARGE_COMM_D D where A.OLD_ORD_NO = B.ORD_NO AND A.OLD_ORD_SEQ = B.ORD_SEQ and A.COIL_STAT = '1' and A.CUR_PROG_CD = 'PAB' AND TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') >= to_date(?,'YYYY-MM-DD HH24:MI:SS') and TO_DATE(A.CUR_PROG_CD_DTIME,'YYYY-MM-DD HH24:MI:SS') < to_date(?,'YYYY-MM-DD HH24:MI:SS')+1 AND WI.CHARGE_NO = D.CHARGE_NO AND WI.PROC_CD || WI.CHEM_SEQ = D.LST_INGR_CD AND SUBSTR(A.SLAB_NO, 1, 10) = WI.CHARGE_NO AND WI.CHEM_CD IN ('C','Mn','S','P','Si','Ti','N') GROUP BY A.OLD_SAMPL_NO) CC on QQ.OLD_SAMPL_NO = CC.OLD_SAMPL_NO ]]>