= T.MINI AND DECODE(ORD_FL,'1',C.INSTR_COIL_WTH,'2',C.SLAB_WTH - 50) < T.MAXI ) WTH_GRP_CD FROM TBG02_SLAB_COMM C WHERE C.SLAB_STAT = '2' AND C.SLAB_RT = 'H' AND C.CUR_PROG_CD IN ('RRC','RBA'))Z GROUP BY ROLLUP (Z.WTH_GRP_CD) ORDER BY Z.WTH_GRP_CD ) T2 ,( SELECT DECODE(C.WTH_GRP_CD,NULL,'小计',C.WTH_GRP_CD) WTH_GRP_CD, COUNT(B.SLAB_EDT_SEQ) cnt_cut --切割待机量 FROM TBF01_SPEC_CHARGE A ,TBF01_SPEC_SLAB B ,TBF02_ROLL_WTH_GRP C WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND A.PROG_CD IN ('JBB','JBF','JCR','JRF','JJB') AND A.STATUS_CD IN ('A','B') AND C.PLT = 'H' AND B.SLAB_RT = 'H' AND DECODE(B.ORD_FL,'1',B.ORD_WTH,B.SLAB_WTH - 50) >= C.MINI AND DECODE(B.ORD_FL,'1',B.ORD_WTH,B.SLAB_WTH - 50) <= C.MAXI GROUP BY ROLLUP (WTH_GRP_CD) ) T3 ,( SELECT DECODE(C.WTH_GRP_CD,NULL,'小计',C.WTH_GRP_CD) WTH_GRP_CD, NVL(COUNT(B.SLAB_EDT_SEQ),0) CNT_ZSDJ --出钢指示待机量 FROM TBF01_SPEC_CHARGE A ,TBF01_SPEC_SLAB B ,TBF02_ROLL_WTH_GRP C WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND A.PROG_CD = 'JBA' AND A.STATUS_CD = 'A' AND C.PLT = 'H' AND B.SLAB_RT = 'H' AND DECODE(B.ORD_FL,'1',B.ORD_WTH,B.SLAB_WTH - 50) >= C.MINI AND DECODE(B.ORD_FL,'1',B.ORD_WTH,B.SLAB_WTH - 50) <= C.MAXI GROUP BY ROLLUP (WTH_GRP_CD) ) T4 ,( SELECT DECODE(Z.WTH_GRP_CD,NULL,'小计',Z.WTH_GRP_CD) WTH_GRP_CD ,NVL(SUM(Z.DXL),0) DXL --对象量 FROM( WITH BB_DXL AS ( SELECT WTH_GRP_CD ,SUM(A.ORD_REM_WGT) ORD_REM_WGT_TOT FROM TBE02_ORD_PRC A ,TBF02_ROLL_WTH_GRP B WHERE A.ORD_PROG_CD IN ('D','E') --D 投入确定 --E生产进行 AND B.PLT = 'H' AND A.ORD_WTH >= B.MINI AND A.ORD_WTH = T.MINI AND DECODE(ORD_FL,'1',C.INSTR_COIL_WTH,'2',C.SLAB_WTH - 50) < T.MAXI ) WTH_GRP_CD FROM TBG02_SLAB_COMM C WHERE C.SLAB_STAT = '2' AND C.SLAB_RT = 'H' AND C.CUR_PROG_CD IN ('RRC','RBA'))Z GROUP BY ROLLUP (Z.WTH_GRP_CD) ORDER BY Z.WTH_GRP_CD ) T2 ,( SELECT DECODE(C.WTH_GRP_CD,NULL,'小计',C.WTH_GRP_CD) WTH_GRP_CD, SUM(B.SLAB_WGT) cnt_cut --切割待机量 FROM TBF01_SPEC_CHARGE A ,TBF01_SPEC_SLAB B ,TBF02_ROLL_WTH_GRP C WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND A.PROG_CD IN ('JBB','JBF','JCR','JRF','JJB') AND A.STATUS_CD IN ('A','B') AND C.PLT = 'H' AND B.SLAB_RT = 'H' AND DECODE(B.ORD_FL,'1',B.ORD_WTH,B.SLAB_WTH - 50) >= C.MINI AND DECODE(B.ORD_FL,'1',B.ORD_WTH,B.SLAB_WTH - 50) <= C.MAXI GROUP BY ROLLUP (WTH_GRP_CD) ) T3 ,( SELECT DECODE(C.WTH_GRP_CD,NULL,'小计',C.WTH_GRP_CD) WTH_GRP_CD, NVL( SUM(B.SLAB_WGT),0) CNT_ZSDJ --出钢指示待机量 FROM TBF01_SPEC_CHARGE A ,TBF01_SPEC_SLAB B ,TBF02_ROLL_WTH_GRP C WHERE A.CHARGE_EDT_SEQ = B.CHARGE_EDT_SEQ AND A.PROG_CD = 'JBA' AND A.STATUS_CD = 'A' AND C.PLT = 'H' AND B.SLAB_RT = 'H' AND DECODE(B.ORD_FL,'1',B.ORD_WTH,B.SLAB_WTH - 50) >= C.MINI AND DECODE(B.ORD_FL,'1',B.ORD_WTH,B.SLAB_WTH - 50) <= C.MAXI GROUP BY ROLLUP (WTH_GRP_CD) ) T4 ,( SELECT DECODE(Z.WTH_GRP_CD,NULL,'小计',Z.WTH_GRP_CD) WTH_GRP_CD ,NVL(SUM(Z.DXL),0) DXL --对象量 FROM( WITH BB_DXL AS ( SELECT WTH_GRP_CD ,SUM(A.ORD_REM_WGT) ORD_REM_WGT_TOT FROM TBE02_ORD_PRC A ,TBF02_ROLL_WTH_GRP B WHERE A.ORD_PROG_CD IN ('D','E') --D 投入确定 --E生产进行 AND B.PLT = 'H' AND A.ORD_WTH >= B.MINI AND A.ORD_WTH