SELECT A.REG_DTIME,A.ROLL_EDT_SEQ,A.ROLL_MANA_NO,SUM(1) ROLL_COIL_CNT, SUM(B.COIL_WGT) ROLL_COIL_WGT, SUM(CASE WHEN B.STATUS_CD IN('A','B','C') THEN 1 ELSE 0 END) RES_ROLL_COIL_CNT, SUM(CASE WHEN B.STATUS_CD IN('A','B','C') THEN B.COIL_WGT ELSE 0 END) RES_ROLL_COIL_WGT, SUM(CASE WHEN B.STATUS_CD ='D' THEN 1 ELSE 0 END) END_COIL_CNT, SUM(CASE WHEN B.STATUS_CD ='D' THEN B.COIL_WGT ELSE 0 END) END_COIL_WGT, 'FALSE' CHK,DECODE(A.L2_SEND,'N','未下发','已下发') L2_SEND FROM C_TBF03_SPEC_ROLL A,C_TBF03_SPEC_MILL B WHERE A.ROLL_MANA_NO=B.ROLL_MANA_NO AND A.STATUS_CD IN('A','B') GROUP BY A.REG_DTIME,A.ROLL_EDT_SEQ,A.ROLL_MANA_NO,A.L2_SEND ORDER BY LPAD(TO_CHAR(A.ROLL_EDT_SEQ),5,'0') SELECT ROLL_MANA_NO NAME_,ROLL_MANA_NO ID_ FROM C_TBF03_SPEC_ROLL WHERE T.STATUS_CD IN ('A','B') ORDER BY LPAD(TO_CHAR(ROLL_EDT_SEQ),3,'0')