XinYu_RZMES/.svn/pristine/59/59f35c32cbdfdadb9d176e2f0402164abbabb3ba.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING QUERY ">
	<query id="UIH051900_01.select" desc=" 规格查询 ">
        <![CDATA[
			  SELECT    Y.EXTSHAPE_DEC_GRD,
           Y.INSTR_COIL_THK||'*'||Y.INSTR_COIL_WTH T_W,
           Y.SPEC_STL_GRD,
            TO_CHAR(nvl(COIL_IN_DAY_NUM,0)) COIL_IN_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_IN_DAY_WGT,0)/1000,2)) COIL_IN_DAY_WGT,TO_CHAR(nvl(COIL_IN_MON_NUM,0)) COIL_IN_MON_NUM,TO_CHAR(ROUND(NVL(COIL_IN_MON_WGT,0)/1000,2)) COIL_IN_MON_WGT,
            TO_CHAR(nvl(COIL_OUT_T_DAY_NUM,0)) COIL_OUT_T_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_T_DAY_WGT,0)/1000,2)) COIL_OUT_T_DAY_WGT,TO_CHAR(nvl(COIL_OUT_T_MON_NUM,0)) COIL_OUT_T_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_T_MON_WGT,0)/1000,2)) COIL_OUT_T_MON_WGT,
            TO_CHAR(nvl(COIL_OUT_C_DAY_NUM,0)) COIL_OUT_C_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_C_DAY_WGT,0)/1000,2)) COIL_OUT_C_DAY_WGT,TO_CHAR(nvl(COIL_OUT_C_MON_NUM,0)) COIL_OUT_C_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_C_MON_WGT,0)/1000,2)) COIL_OUT_C_MON_WGT, 
            TO_CHAR(nvl(COIL_YARD_DAY_NUM,0)) COIL_YARD_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_YARD_DAY_WGT,0)/1000,2)) COIL_YARD_DAY_WGT,TO_CHAR(nvl(COIL_YARD_MON_NUM,0)) COIL_YARD_MON_NUM,TO_CHAR(ROUND(NVL(COIL_YARD_MON_WGT,0)/1000,2)) COIL_YARD_MON_WGT,
            TO_CHAR(nvl(COIL_OUT_DAY_NUM,0)) COIL_OUT_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_DAY_WGT,0)/1000,2)) COIL_OUT_DAY_WGT,TO_CHAR(nvl(COIL_OUT_MON_NUM,0)) COIL_OUT_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_MON_WGT,0)/1000,2)) COIL_OUT_MON_WGT  

FROM 
(
 SELECT DISTINCT A.INSTR_COIL_THK,A.INSTR_COIL_WTH,A.SPEC_STL_GRD,DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','','待判定') EXTSHAPE_DEC_GRD
         FROM TBH02_COIL_COMM A 
        WHERE (A.YARD_ENTRY_DTIME >= 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
		]]>
    </query>
	<query id="UIH051900_02.select" desc=" 牌号查询 ">
        <![CDATA[
			   SELECT    Y.EXTSHAPE_DEC_GRD,
            Y.SPEC_STL_GRD,
            TO_CHAR(nvl(COIL_IN_DAY_NUM,0)) COIL_IN_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_IN_DAY_WGT,0)/1000,2)) COIL_IN_DAY_WGT,TO_CHAR(nvl(COIL_IN_MON_NUM,0)) COIL_IN_MON_NUM,TO_CHAR(ROUND(NVL(COIL_IN_MON_WGT,0)/1000,2)) COIL_IN_MON_WGT,
            TO_CHAR(nvl(COIL_OUT_T_DAY_NUM,0)) COIL_OUT_T_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_T_DAY_WGT,0)/1000,2)) COIL_OUT_T_DAY_WGT,TO_CHAR(nvl(COIL_OUT_T_MON_NUM,0)) COIL_OUT_T_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_T_MON_WGT,0)/1000,2)) COIL_OUT_T_MON_WGT,
            TO_CHAR(nvl(COIL_OUT_C_DAY_NUM,0)) COIL_OUT_C_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_C_DAY_WGT,0)/1000,2)) COIL_OUT_C_DAY_WGT,TO_CHAR(nvl(COIL_OUT_C_MON_NUM,0)) COIL_OUT_C_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_C_MON_WGT,0)/1000,2)) COIL_OUT_C_MON_WGT, 
            TO_CHAR(nvl(COIL_YARD_DAY_NUM,0)) COIL_YARD_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_YARD_DAY_WGT,0)/1000,2)) COIL_YARD_DAY_WGT,TO_CHAR(nvl(COIL_YARD_MON_NUM,0)) COIL_YARD_MON_NUM,TO_CHAR(ROUND(NVL(COIL_YARD_MON_WGT,0)/1000,2)) COIL_YARD_MON_WGT,
            TO_CHAR(nvl(COIL_OUT_DAY_NUM,0)) COIL_OUT_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_DAY_WGT,0)/1000,2)) COIL_OUT_DAY_WGT,TO_CHAR(nvl(COIL_OUT_MON_NUM,0)) COIL_OUT_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_MON_WGT,0)/1000,2)) COIL_OUT_MON_WGT  

FROM 
(
 SELECT DISTINCT A.SPEC_STL_GRD,DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','','待判定') EXTSHAPE_DEC_GRD
         FROM TBH02_COIL_COMM A 
        WHERE (A.YARD_ENTRY_DTIME >= 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

		]]>
    </query>
	<query id="UIH051900_03.select" desc=" 不带牌号和规格的查询 ">
        <![CDATA[
         SELECT    Y.EXTSHAPE_DEC_GRD,
            TO_CHAR(nvl(COIL_IN_DAY_NUM,0)) COIL_IN_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_IN_DAY_WGT,0)/1000,2)) COIL_IN_DAY_WGT,TO_CHAR(nvl(COIL_IN_MON_NUM,0)) COIL_IN_MON_NUM,TO_CHAR(ROUND(NVL(COIL_IN_MON_WGT,0)/1000,2)) COIL_IN_MON_WGT,
            TO_CHAR(nvl(COIL_OUT_T_DAY_NUM,0)) COIL_OUT_T_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_T_DAY_WGT,0)/1000,2)) COIL_OUT_T_DAY_WGT,TO_CHAR(nvl(COIL_OUT_T_MON_NUM,0)) COIL_OUT_T_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_T_MON_WGT,0)/1000,2)) COIL_OUT_T_MON_WGT,
            TO_CHAR(nvl(COIL_OUT_C_DAY_NUM,0)) COIL_OUT_C_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_C_DAY_WGT,0)/1000,2)) COIL_OUT_C_DAY_WGT,TO_CHAR(nvl(COIL_OUT_C_MON_NUM,0)) COIL_OUT_C_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_C_MON_WGT,0)/1000,2)) COIL_OUT_C_MON_WGT, 
            TO_CHAR(nvl(COIL_YARD_DAY_NUM,0)) COIL_YARD_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_YARD_DAY_WGT,0)/1000,2)) COIL_YARD_DAY_WGT,TO_CHAR(nvl(COIL_YARD_MON_NUM,0)) COIL_YARD_MON_NUM,TO_CHAR(ROUND(NVL(COIL_YARD_MON_WGT,0)/1000,2)) COIL_YARD_MON_WGT,
            TO_CHAR(nvl(COIL_OUT_DAY_NUM,0)) COIL_OUT_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_DAY_WGT,0)/1000,2)) COIL_OUT_DAY_WGT,TO_CHAR(nvl(COIL_OUT_MON_NUM,0)) COIL_OUT_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_MON_WGT,0)/1000,2)) COIL_OUT_MON_WGT  

FROM 
(
 SELECT DISTINCT DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','','待判定') EXTSHAPE_DEC_GRD
         FROM TBH02_COIL_COMM A 
        WHERE (A.YARD_ENTRY_DTIME >= 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(+)

		]]>
    </query>
	<query id="UIH051900_04.select" desc=" 不带牌号和规格并且入库改为轧制量的查询 ">
        <![CDATA[
			          SELECT    Y.EXTSHAPE_DEC_GRD,
            TO_CHAR(nvl(COIL_IN_DAY_NUM,0)) COIL_IN_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_IN_DAY_WGT,0)/1000,2)) COIL_IN_DAY_WGT,
            TO_CHAR(nvl(COIL_OUT_T_DAY_NUM,0)) COIL_OUT_T_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_T_DAY_WGT,0)/1000,2)) COIL_OUT_T_DAY_WGT,TO_CHAR(nvl(COIL_OUT_T_MON_NUM,0)) COIL_OUT_T_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_T_MON_WGT,0)/1000,2)) COIL_OUT_T_MON_WGT,
            TO_CHAR(nvl(COIL_OUT_C_DAY_NUM,0)) COIL_OUT_C_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_C_DAY_WGT,0)/1000,2)) COIL_OUT_C_DAY_WGT,TO_CHAR(nvl(COIL_OUT_C_MON_NUM,0)) COIL_OUT_C_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_C_MON_WGT,0)/1000,2)) COIL_OUT_C_MON_WGT, 
            TO_CHAR(nvl(COIL_YARD_DAY_NUM,0)) COIL_YARD_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_YARD_DAY_WGT,0)/1000,2)) COIL_YARD_DAY_WGT,
            TO_CHAR(nvl(COIL_OUT_DAY_NUM,0)) COIL_OUT_DAY_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_DAY_WGT,0)/1000,2)) COIL_OUT_DAY_WGT,TO_CHAR(nvl(COIL_OUT_MON_NUM,0)) COIL_OUT_MON_NUM,TO_CHAR(ROUND(NVL(COIL_OUT_MON_WGT,0)/1000,2)) COIL_OUT_MON_WGT  

FROM 
(
 SELECT DISTINCT DECODE(A.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','','待判定') EXTSHAPE_DEC_GRD
         FROM TBH02_COIL_COMM A 
        WHERE (A.MILL_DTIME >= :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(+)
		]]>
    </query>

</queryMap>