SELECT MAT_TP,PROG_CD,MAT_NO,MAT_THK,MAT_WTH,MAT_LEN,MAT_WGT,WGT,CUR_LOAD_LOC,REG_DTIME,CD_SEQ FROM( SELECT '酸轧基料卷' MAT_TP ,A.CUR_PROG_CD PROG_CD ,A.COIL_NO MAT_NO ,A.COIL_THK MAT_THK ,A.COIL_WTH MAT_WTH ,A.COIL_LEN MAT_LEN ,A.ACT_WGT MAT_WGT ,B.WGT ,A.CUR_LOAD_LOC ,A.YARD_ENTRY_DTIME REG_DTIME ,C.CD_SEQ FROM C_TBK02_COIL_COMM A ,TBZ00_COMMCD C ,(SELECT COIL_NO,SUM(ORD_WGT) WGT FROM C_TBK02_COIL_COMM_D WHERE ORD_NO = :1 AND ORD_SEQ = :2 AND ORD_FL = '1' GROUP BY COIL_NO)B WHERE A.COIL_NO = B.COIL_NO AND A.ORD_FL = '1' AND A.COIL_STAT = '2' AND NVL(:3,A.CUR_PROG_CD) = A.CUR_PROG_CD AND C.LG_CD = 'E01002' AND A.CUR_PROG_CD = C.SM_CD UNION ALL SELECT '酸轧成品卷' MAT_TP ,A.CUR_PROG_CD PROG_CD ,A.COIL_NO MAT_NO ,A.COIL_THK MAT_THK ,A.COIL_WTH MAT_WTH ,A.COIL_LEN MAT_LEN ,A.ACT_WGT MAT_WGT ,B.WGT ,A.CUR_LOAD_LOC ,A.YARD_ENTRY_DTIME REG_DTIME ,C.CD_SEQ FROM C_TBL02_COIL_COMM A ,TBZ00_COMMCD C ,(SELECT L_COIL_NO,SUM(ORD_WGT) WGT FROM C_TBL02_COIL_COMM_D WHERE ORD_NO = ::4 AND ORD_SEQ = :5 AND ORD_FL = '1' GROUP BY L_COIL_NO)B WHERE A.COIL_NO = B.L_COIL_NO AND A.ORD_FL = '1' AND A.COIL_STAT = '2' AND NVL(:6,A.CUR_PROG_CD) = A.CUR_PROG_CD AND C.LG_CD = 'E01002' AND A.CUR_PROG_CD = C.SM_CD ) ORDER BY CD_SEQ,MAT_NO