= substr(:1,1,6)||'01' AND A.YARD_ENTRY_DTIME <= :2) OR (A.TRNF_DTIME >= substr(:3,1,6)||'01' AND A.TRNF_DTIME <= :4) )Y, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, B.INSTR_COIL_THK INSTR_COIL_THK, B.INSTR_COIL_WTH INSTR_COIL_WTH, B.SPEC_STL_GRD SPEC_STL_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_IN_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_IN_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_IN_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_IN_MON_WGT FROM (SELECT min(INSTR_COIL_THK) INSTR_COIL_THK, min(INSTR_COIL_WTH) INSTR_COIL_WTH, min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME = :5 GROUP BY EXTSHAPE_DEC_GRD,INSTR_COIL_THK,INSTR_COIL_WTH,SPEC_STL_GRD ) a, ( SELECT min(INSTR_COIL_THK) INSTR_COIL_THK, min(INSTR_COIL_WTH) INSTR_COIL_WTH, min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME >= substr(:6,1,6)||'01' AND a.YARD_ENTRY_DTIME <= :7 GROUP BY EXTSHAPE_DEC_GRD,INSTR_COIL_THK,INSTR_COIL_WTH,SPEC_STL_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD AND A.INSTR_COIL_THK(+) = B.INSTR_COIL_THK AND A.INSTR_COIL_WTH(+) = B.INSTR_COIL_WTH AND A.SPEC_STL_GRD(+) = B.SPEC_STL_GRD ORDER BY A.EXTSHAPE_DEC_GRD,A.INSTR_COIL_THK,A.INSTR_COIL_WTH,A.SPEC_STL_GRD ) A, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, B.INSTR_COIL_THK INSTR_COIL_THK, B.INSTR_COIL_WTH INSTR_COIL_WTH, B.SPEC_STL_GRD SPEC_STL_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_T_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_T_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_T_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_T_MON_WGT FROM (SELECT min(INSTR_COIL_THK) INSTR_COIL_THK, min(INSTR_COIL_WTH) INSTR_COIL_WTH, min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :8 AND A.DLIV_TP = 'T' GROUP BY EXTSHAPE_DEC_GRD,INSTR_COIL_THK,INSTR_COIL_WTH,SPEC_STL_GRD ) a, ( SELECT min(INSTR_COIL_THK) INSTR_COIL_THK, min(INSTR_COIL_WTH) INSTR_COIL_WTH, min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:9,1,6)||'01' AND a.TRNF_DTIME <= :10 AND A.DLIV_TP = 'T' GROUP BY EXTSHAPE_DEC_GRD,INSTR_COIL_THK,INSTR_COIL_WTH,SPEC_STL_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD AND A.INSTR_COIL_THK(+) = B.INSTR_COIL_THK AND A.INSTR_COIL_WTH(+) = B.INSTR_COIL_WTH AND A.SPEC_STL_GRD(+) = B.SPEC_STL_GRD ORDER BY A.EXTSHAPE_DEC_GRD,A.INSTR_COIL_THK,A.INSTR_COIL_WTH,A.SPEC_STL_GRD ) B, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, B.INSTR_COIL_THK INSTR_COIL_THK, B.INSTR_COIL_WTH INSTR_COIL_WTH, B.SPEC_STL_GRD SPEC_STL_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_C_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_C_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_C_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_C_MON_WGT FROM (SELECT min(INSTR_COIL_THK) INSTR_COIL_THK, min(INSTR_COIL_WTH) INSTR_COIL_WTH, min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :11 AND A.DLIV_TP = 'C' GROUP BY EXTSHAPE_DEC_GRD,INSTR_COIL_THK,INSTR_COIL_WTH,SPEC_STL_GRD ) a, ( SELECT min(INSTR_COIL_THK) INSTR_COIL_THK, min(INSTR_COIL_WTH) INSTR_COIL_WTH, min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:12,1,6)||'01' AND a.TRNF_DTIME <= :13 AND A.DLIV_TP = 'C' GROUP BY EXTSHAPE_DEC_GRD,INSTR_COIL_THK,INSTR_COIL_WTH,SPEC_STL_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD AND A.INSTR_COIL_THK(+) = B.INSTR_COIL_THK AND A.INSTR_COIL_WTH(+) = B.INSTR_COIL_WTH AND A.SPEC_STL_GRD(+) = B.SPEC_STL_GRD ORDER BY A.EXTSHAPE_DEC_GRD,A.INSTR_COIL_THK,A.INSTR_COIL_WTH,A.SPEC_STL_GRD ) C, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, B.INSTR_COIL_THK INSTR_COIL_THK, B.INSTR_COIL_WTH INSTR_COIL_WTH, B.SPEC_STL_GRD SPEC_STL_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_YARD_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_YARD_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_YARD_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_YARD_MON_WGT FROM (SELECT min(INSTR_COIL_THK) INSTR_COIL_THK, min(INSTR_COIL_WTH) INSTR_COIL_WTH, min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME = :14 AND A.CUR_LOAD_LOC IS NOT NULL GROUP BY EXTSHAPE_DEC_GRD,INSTR_COIL_THK,INSTR_COIL_WTH,SPEC_STL_GRD ) a, ( SELECT min(INSTR_COIL_THK) INSTR_COIL_THK, min(INSTR_COIL_WTH) INSTR_COIL_WTH, min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME >= substr(:15,1,6)||'01' AND a.YARD_ENTRY_DTIME <= :16 AND A.CUR_LOAD_LOC IS NOT NULL GROUP BY EXTSHAPE_DEC_GRD,INSTR_COIL_THK,INSTR_COIL_WTH,SPEC_STL_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD AND A.INSTR_COIL_THK(+) = B.INSTR_COIL_THK AND A.INSTR_COIL_WTH(+) = B.INSTR_COIL_WTH AND A.SPEC_STL_GRD(+) = B.SPEC_STL_GRD ORDER BY A.EXTSHAPE_DEC_GRD,A.INSTR_COIL_THK,A.INSTR_COIL_WTH,A.SPEC_STL_GRD ) D, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, B.INSTR_COIL_THK INSTR_COIL_THK, B.INSTR_COIL_WTH INSTR_COIL_WTH, B.SPEC_STL_GRD SPEC_STL_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_MON_WGT FROM (SELECT min(INSTR_COIL_THK) INSTR_COIL_THK, min(INSTR_COIL_WTH) INSTR_COIL_WTH, min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :17 GROUP BY EXTSHAPE_DEC_GRD,INSTR_COIL_THK,INSTR_COIL_WTH,SPEC_STL_GRD ) a, ( SELECT min(INSTR_COIL_THK) INSTR_COIL_THK, min(INSTR_COIL_WTH) INSTR_COIL_WTH, min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:18,1,6)||'01' AND a.TRNF_DTIME <= :19 GROUP BY EXTSHAPE_DEC_GRD,INSTR_COIL_THK,INSTR_COIL_WTH,SPEC_STL_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD AND A.INSTR_COIL_THK(+) = B.INSTR_COIL_THK AND A.INSTR_COIL_WTH(+) = B.INSTR_COIL_WTH AND A.SPEC_STL_GRD(+) = B.SPEC_STL_GRD ORDER BY A.EXTSHAPE_DEC_GRD,A.INSTR_COIL_THK,A.INSTR_COIL_WTH,A.SPEC_STL_GRD ) E WHERE Y.INSTR_COIL_THK = B.INSTR_COIL_THK(+) AND Y.INSTR_COIL_WTH = B.INSTR_COIL_WTH(+) AND Y.SPEC_STL_GRD = B.SPEC_STL_GRD(+) AND Y.EXTSHAPE_DEC_GRD = B.EXTSHAPE_DEC_GRD(+) AND Y.INSTR_COIL_THK = A.INSTR_COIL_THK(+) AND Y.INSTR_COIL_WTH = A.INSTR_COIL_WTH(+) AND Y.SPEC_STL_GRD = A.SPEC_STL_GRD(+) AND Y.EXTSHAPE_DEC_GRD = A.EXTSHAPE_DEC_GRD(+) AND Y.INSTR_COIL_THK = C.INSTR_COIL_THK(+) AND Y.INSTR_COIL_WTH = C.INSTR_COIL_WTH(+) AND Y.SPEC_STL_GRD = C.SPEC_STL_GRD(+) AND Y.EXTSHAPE_DEC_GRD = C.EXTSHAPE_DEC_GRD(+) AND Y.INSTR_COIL_THK = D.INSTR_COIL_THK(+) AND Y.INSTR_COIL_WTH = D.INSTR_COIL_WTH(+) AND Y.SPEC_STL_GRD = D.SPEC_STL_GRD(+) AND Y.EXTSHAPE_DEC_GRD = D.EXTSHAPE_DEC_GRD(+) AND Y.INSTR_COIL_THK = E.INSTR_COIL_THK(+) AND Y.INSTR_COIL_WTH = E.INSTR_COIL_WTH(+) AND Y.SPEC_STL_GRD = E.SPEC_STL_GRD(+) AND Y.EXTSHAPE_DEC_GRD = E.EXTSHAPE_DEC_GRD(+) order by Y.SPEC_STL_GRD,Y.INSTR_COIL_THK,Y.INSTR_COIL_WTH ]]> = substr(:1,1,6)||'01' AND A.YARD_ENTRY_DTIME <= :2) OR (A.TRNF_DTIME >= substr(:3,1,6)||'01' AND A.TRNF_DTIME <= :4) )Y, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, B.SPEC_STL_GRD SPEC_STL_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_IN_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_IN_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_IN_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_IN_MON_WGT FROM (SELECT min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME = :5 GROUP BY EXTSHAPE_DEC_GRD,SPEC_STL_GRD ) a, ( SELECT min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME >= substr(:6,1,6)||'01' AND a.YARD_ENTRY_DTIME <= :7 GROUP BY EXTSHAPE_DEC_GRD,SPEC_STL_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD AND A.SPEC_STL_GRD(+) = B.SPEC_STL_GRD ORDER BY A.EXTSHAPE_DEC_GRD,A.SPEC_STL_GRD ) A, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, B.SPEC_STL_GRD SPEC_STL_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_T_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_T_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_T_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_T_MON_WGT FROM (SELECT min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :8 AND A.DLIV_TP = 'T' GROUP BY EXTSHAPE_DEC_GRD,SPEC_STL_GRD ) a, ( SELECT min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:9,1,6)||'01' AND a.TRNF_DTIME <= :10 AND A.DLIV_TP = 'T' GROUP BY EXTSHAPE_DEC_GRD,SPEC_STL_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD AND A.SPEC_STL_GRD(+) = B.SPEC_STL_GRD ORDER BY A.EXTSHAPE_DEC_GRD,A.SPEC_STL_GRD ) B, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, B.SPEC_STL_GRD SPEC_STL_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_C_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_C_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_C_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_C_MON_WGT FROM (SELECT min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :11 AND A.DLIV_TP = 'C' GROUP BY EXTSHAPE_DEC_GRD,SPEC_STL_GRD ) a, ( SELECT min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:12,1,6)||'01' AND a.TRNF_DTIME <= :13 AND A.DLIV_TP = 'C' GROUP BY EXTSHAPE_DEC_GRD,SPEC_STL_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD AND A.SPEC_STL_GRD(+) = B.SPEC_STL_GRD ORDER BY A.EXTSHAPE_DEC_GRD,A.SPEC_STL_GRD ) C, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, B.SPEC_STL_GRD SPEC_STL_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_YARD_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_YARD_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_YARD_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_YARD_MON_WGT FROM (SELECT min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME = :14 AND A.CUR_LOAD_LOC IS NOT NULL GROUP BY EXTSHAPE_DEC_GRD,SPEC_STL_GRD ) a, ( SELECT min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME >= substr(:15,1,6)||'01' AND a.YARD_ENTRY_DTIME <= :16 AND A.CUR_LOAD_LOC IS NOT NULL GROUP BY EXTSHAPE_DEC_GRD,SPEC_STL_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD AND A.SPEC_STL_GRD(+) = B.SPEC_STL_GRD ORDER BY A.EXTSHAPE_DEC_GRD,A.SPEC_STL_GRD ) D, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, B.SPEC_STL_GRD SPEC_STL_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_MON_WGT FROM (SELECT min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :17 GROUP BY EXTSHAPE_DEC_GRD,SPEC_STL_GRD ) a, ( SELECT min(SPEC_STL_GRD) SPEC_STL_GRD, count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:18,1,6)||'01' AND a.TRNF_DTIME <= :19 GROUP BY EXTSHAPE_DEC_GRD,SPEC_STL_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD AND A.SPEC_STL_GRD(+) = B.SPEC_STL_GRD ORDER BY A.EXTSHAPE_DEC_GRD,A.SPEC_STL_GRD ) E WHERE Y.SPEC_STL_GRD = B.SPEC_STL_GRD(+) AND Y.EXTSHAPE_DEC_GRD = B.EXTSHAPE_DEC_GRD(+) AND Y.SPEC_STL_GRD = A.SPEC_STL_GRD(+) AND Y.EXTSHAPE_DEC_GRD = A.EXTSHAPE_DEC_GRD(+) AND Y.SPEC_STL_GRD = C.SPEC_STL_GRD(+) AND Y.EXTSHAPE_DEC_GRD = C.EXTSHAPE_DEC_GRD(+) AND Y.SPEC_STL_GRD = D.SPEC_STL_GRD(+) AND Y.EXTSHAPE_DEC_GRD = D.EXTSHAPE_DEC_GRD(+) AND Y.SPEC_STL_GRD = E.SPEC_STL_GRD(+) AND Y.EXTSHAPE_DEC_GRD = E.EXTSHAPE_DEC_GRD(+) order by Y.SPEC_STL_GRD ]]> = substr(:1,1,6)||'01' AND A.YARD_ENTRY_DTIME <= :2) OR (A.TRNF_DTIME >= substr(:3,1,6)||'01' AND A.TRNF_DTIME <= :4) )Y, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_IN_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_IN_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_IN_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_IN_MON_WGT FROM (SELECT count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME = :5 GROUP BY EXTSHAPE_DEC_GRD ) a, ( SELECT count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME >= substr(:6,1,6)||'01' AND a.YARD_ENTRY_DTIME <= :7 GROUP BY EXTSHAPE_DEC_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD ORDER BY A.EXTSHAPE_DEC_GRD ) A, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_T_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_T_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_T_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_T_MON_WGT FROM (SELECT count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :8 AND A.DLIV_TP = 'T' GROUP BY EXTSHAPE_DEC_GRD ) a, ( SELECT count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:9,1,6)||'01' AND a.TRNF_DTIME <= :10 AND A.DLIV_TP = 'T' GROUP BY EXTSHAPE_DEC_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD ORDER BY A.EXTSHAPE_DEC_GRD ) B, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_C_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_C_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_C_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_C_MON_WGT FROM (SELECT count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :11 AND A.DLIV_TP = 'C' GROUP BY EXTSHAPE_DEC_GRD ) a, ( SELECT count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:12,1,6)||'01' AND a.TRNF_DTIME <= :13 AND A.DLIV_TP = 'C' GROUP BY EXTSHAPE_DEC_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD ORDER BY A.EXTSHAPE_DEC_GRD ) C, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_YARD_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_YARD_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_YARD_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_YARD_MON_WGT FROM (SELECT count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME = :14 AND A.CUR_LOAD_LOC IS NOT NULL GROUP BY EXTSHAPE_DEC_GRD ) a, ( SELECT count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.YARD_ENTRY_DTIME >= substr(:15,1,6)||'01' AND a.YARD_ENTRY_DTIME <= :16 AND A.CUR_LOAD_LOC IS NOT NULL GROUP BY EXTSHAPE_DEC_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD ORDER BY A.EXTSHAPE_DEC_GRD ) D, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_MON_WGT FROM (SELECT count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :17 GROUP BY EXTSHAPE_DEC_GRD ) a, ( SELECT count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:18,1,6)||'01' AND a.TRNF_DTIME <= :19 GROUP BY EXTSHAPE_DEC_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD ORDER BY A.EXTSHAPE_DEC_GRD ) E WHERE Y.EXTSHAPE_DEC_GRD = B.EXTSHAPE_DEC_GRD(+) AND Y.EXTSHAPE_DEC_GRD = A.EXTSHAPE_DEC_GRD(+) AND Y.EXTSHAPE_DEC_GRD = C.EXTSHAPE_DEC_GRD(+) AND Y.EXTSHAPE_DEC_GRD = D.EXTSHAPE_DEC_GRD(+) AND Y.EXTSHAPE_DEC_GRD = E.EXTSHAPE_DEC_GRD(+) ]]> = :1 AND A.MILL_DTIME <= :2) OR (A.TRNF_DTIME >= substr(:3,1,6)||'01' AND A.TRNF_DTIME <= :4) )Y, ( SELECT TO_CHAR(nvl(count(OLD_SAMPL_NO),0)) COIL_IN_DAY_NUM, TO_CHAR(nvl(SUM(ACT_WGT),0)) COIL_IN_DAY_WGT, DECODE(MIN(EXTSHAPE_DEC_GRD),'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.MILL_DTIME >= :5 and a.MILL_DTIME <= :6 GROUP BY EXTSHAPE_DEC_GRD ) A, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_T_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_T_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_T_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_T_MON_WGT FROM (SELECT count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :7 AND A.DLIV_TP = 'T' GROUP BY EXTSHAPE_DEC_GRD ) a, ( SELECT count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:8,1,6)||'01' AND a.TRNF_DTIME <= :9 AND A.DLIV_TP = 'T' GROUP BY EXTSHAPE_DEC_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD ORDER BY A.EXTSHAPE_DEC_GRD ) B, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_C_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_C_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_C_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_C_MON_WGT FROM (SELECT count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :10 AND A.DLIV_TP = 'C' GROUP BY EXTSHAPE_DEC_GRD ) a, ( SELECT count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:11,1,6)||'01' AND a.TRNF_DTIME <= :12 AND A.DLIV_TP = 'C' GROUP BY EXTSHAPE_DEC_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD ORDER BY A.EXTSHAPE_DEC_GRD ) C, (SELECT TO_CHAR(nvl(count(OLD_SAMPL_NO),0)) COIL_YARD_DAY_NUM, TO_CHAR(nvl(SUM(ACT_WGT),0)) COIL_YARD_DAY_WGT, DECODE(MIN(EXTSHAPE_DEC_GRD),'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.COIL_STAT = '2' GROUP BY EXTSHAPE_DEC_GRD ) D, ( SELECT DECODE(B.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品') EXTSHAPE_DEC_GRD, TO_CHAR(nvl(DAY_NUM,0)) COIL_OUT_DAY_NUM, TO_CHAR(nvl(DAY_WGT,0)) COIL_OUT_DAY_WGT, TO_CHAR(nvl(MON_NUM,0)) COIL_OUT_MON_NUM, TO_CHAR(nvl(MON_WGT,0)) COIL_OUT_MON_WGT FROM (SELECT count(OLD_SAMPL_NO) DAY_NUM, SUM(ACT_WGT) DAY_WGT, MIN(EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME = :13 GROUP BY EXTSHAPE_DEC_GRD ) a, ( SELECT count(OLD_SAMPL_NO) MON_NUM, SUM(ACT_WGT) MON_WGT, MIN(A.EXTSHAPE_DEC_GRD) EXTSHAPE_DEC_GRD FROM TBH02_COIL_COMM A WHERE a.TRNF_DTIME >= substr(:14,1,6)||'01' AND a.TRNF_DTIME <= :15 GROUP BY EXTSHAPE_DEC_GRD )b WHERE A.EXTSHAPE_DEC_GRD(+) = B.EXTSHAPE_DEC_GRD ORDER BY A.EXTSHAPE_DEC_GRD ) E WHERE Y.EXTSHAPE_DEC_GRD = B.EXTSHAPE_DEC_GRD(+) AND Y.EXTSHAPE_DEC_GRD = A.EXTSHAPE_DEC_GRD(+) AND Y.EXTSHAPE_DEC_GRD = C.EXTSHAPE_DEC_GRD(+) AND Y.EXTSHAPE_DEC_GRD = D.EXTSHAPE_DEC_GRD(+) AND Y.EXTSHAPE_DEC_GRD = E.EXTSHAPE_DEC_GRD(+) ]]>