XinYu_RZMES/.svn/pristine/ed/edd0ecf71581e0f62269a4ef511093054d5c71de.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="质量月报表">
  
  
  
  <query id="UIB030290_01.SELECT">
  <![CDATA[
   WITH SHIJIAN AS (SELECT :1 AS STIME, :2 AS ETIME FROM DUAL),
     TEMP1  
     AS (SELECT T1.SLAB_WGT,
                T1.SLAB_TOT_DEC_GRD,
                T1.SMS_YARD_EXT_DTIME,
                T1.SLAB_STOCK_ENT_DTIME,
                T1.SLAB_TOT_DEC_GRD_DTIME,
                T1.CHARGE_NO,
                T1.SLAB_NO,
               T1.SLAB_CUT_DTIME,
               T1.SLAB_STAT,
               T1.ORD_NO,
               T1.BEF_STL_GRD,
               T1.STL_GRD,
               T1.ORD_FL,
               T1.CRK_CD1,
               T1.SLAB_INGR_DEC_GRD_EXT,
            
             
                T2.CC_DEVNO
           FROM  tbg02_slab_comm T1,tbg02_charge_comm t2
          WHERE SUBSTR (T1.SLAB_NO, 1, 9) = SUBSTR (T2.CHARGE_NO(+), 1, 9))
        (

           SELECT '01' XH
        ,'一次性合格率' ZB
        ,0 DQ_1
        ,0 YL_1
        ,0 DQ_2
        ,0 YL_2
        ,0 DQ_3
        ,0 YL_3
        ,0 DQ_QC
        ,0 YL_QC
        FROM DUAL
       
        UNION
        
        SELECT '02' XH
        ,'检验量(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE T1.CC_DEVNO='J1'
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))))
        ) DQ_1                    -- 1#当期检验量 
        ,(SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE T1.CC_DEVNO='J1' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))   
        ) YL_1          --1#月累检验量
        ,(SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE T1.CC_DEVNO='J2'
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))))
        ) DQ_2                        --2#当期检验量
        ,(SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME))))) 
        ) YL_2          --2#月累检验量
        ,(SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE T1.CC_DEVNO='J3'
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME)))) 
        ) DQ_3                  --3#当期检验量
        ,(SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J3' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME))))) 
        ) YL_3    --3#月累检验量
        ,(SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME)))) 
        ) DQ_QC                  --全厂当期检验量
        ,(SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME))))) 
        ) YL_QC      --全厂月累检验量
        FROM SHIJIAN
      
        UNION
      
        SELECT '03' XH
        ,'合格量(t)' ZB
        ,(SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8'))/*T1.SLAB_INGR_DEC_GRD = '1'*/ THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE T1.CC_DEVNO='J1'
        AND ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))) 
        )     DQ_1                    -- 1#当期合格量
        ,(SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))) 
        ) YL_1          --1#月累合格量
        ,(SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))) 
        AND T1.CC_DEVNO='J2'
        ) DQ_2                        --2#当期合格量
        ,(SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME))))
        ) YL_2          --2#月累合格量
        ,(SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))) 
        AND T1.CC_DEVNO='J3'
        ) DQ_3                  --3#当期合格量
        ,(SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME))))
        ) YL_3      --3#月累合格量
        ,(SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))) 
        ) DQ_QC                  --全厂当期合格量
        ,(SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME))))
        ) YL_QC      --全厂月累合格量
        FROM SHIJIAN
        
        UNION
        
        SELECT '04'  XH
        ,'合格率(%)' ZB
        ,TO_CHAR((SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))) 
        AND T1.CC_DEVNO='J1')
        /((SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE T1.CC_DEVNO='J1'
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME)))))),'0.9999')*100  
        DQ_1                    -- 1#当期合格率
        ,TO_CHAR((SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        /((SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME))))))),'0.9999')*100   
        YL_1          --1#月累合格率
        ,TO_CHAR((SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME)))
        AND T1.CC_DEVNO='J2')
        /((SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE T1.CC_DEVNO='J2'
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME)))))),'0.9999')*100  
        DQ_2                    -- 2#当期合格率
        ,TO_CHAR((SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        /((SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME))))))),'0.9999')*100   
        YL_2          --2#月累合格率
        ,TO_CHAR((SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))) 
        AND T1.CC_DEVNO='J3')
        /((SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE T1.CC_DEVNO='J3'
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME)))))),'0.9999')*100  
        DQ_3                   -- 3#当期合格率
        ,TO_CHAR((SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J3' 
        AND ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        /((SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J3' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME))))))),'0.9999')*100   
        YL_3          --3#月累合格率
        ,TO_CHAR((SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))))
        /((SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME)))))),'0.9999')*100  
        DQ_QC                     -- 全厂当期合格率
        ,TO_CHAR((SELECT SUM(CASE WHEN (NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        /((SELECT SUM(CASE WHEN T1.SLAB_WGT / 1000 <> 0 THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME))))))),'0.9999')*100   
        YL_QC          --全厂月累合格率
        FROM SHIJIAN
        
        UNION
        
        SELECT '05' XH
        ,'废品量(t)' ZB
        ,(SELECT SUM(CASE WHEN (T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1')     DQ_1                    -- 1#当期牌废品量
        ,(SELECT SUM(CASE WHEN (T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_1          --1#月累废品量
        ,(SELECT SUM(CASE WHEN (T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') THEN T1.SLAB_WGT / 1000 ELSE 0 END)
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2') DQ_2                        --2#当期废品量
        ,(SELECT SUM(CASE WHEN (T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') THEN T1.SLAB_WGT / 1000 ELSE 0 END)
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_2          --2#月累废品量
        ,(SELECT SUM(CASE WHEN (T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3') DQ_3                  --3#当期废品量
        ,(SELECT SUM(CASE WHEN (T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_3    --3#月累废品量
        ,(SELECT SUM(CASE WHEN (T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        ) DQ_QC                  --全厂当期废品量
        ,(SELECT SUM(CASE WHEN (T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') THEN T1.SLAB_WGT / 1000 ELSE 0 END)
        FROM TEMP1 T1
        WHERE   SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_QC      --全厂月累废品量
        FROM SHIJIAN
        
        UNION
      
        SELECT '06' XH
        ,'无合同未出库量(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.ORD_NO IS NULL AND T1.SLAB_STAT = '2' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  >= STIME
        AND SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1')     DQ_1                    -- 1#当期无合同未出库量
        ,(SELECT SUM(CASE WHEN T1.ORD_NO IS NULL AND T1.SLAB_STAT = '2' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  <= ETIME) YL_1          --1#月累无合同未出库量
        ,(SELECT SUM(CASE WHEN T1.ORD_NO IS NULL AND T1.SLAB_STAT = '2' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  >= STIME
        AND SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2') DQ_2                        --2#当期无合同未出库量
        ,(SELECT SUM(CASE WHEN T1.ORD_NO IS NULL AND T1.SLAB_STAT = '2' THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  <= ETIME) YL_2          --2#月累无合同未出库量
        ,(SELECT SUM(CASE WHEN T1.ORD_NO IS NULL AND T1.SLAB_STAT = '2' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  >= STIME
        AND SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3') DQ_3                  --3#当期无合同未出库量
        ,(SELECT SUM(CASE WHEN T1.ORD_NO IS NULL AND T1.SLAB_STAT = '2' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  <= ETIME) YL_3    --3#月累无合同未出库量
        ,(SELECT SUM(CASE WHEN T1.ORD_NO IS NULL AND T1.SLAB_STAT = '2' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  >= STIME
        AND SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  <= ETIME 
        ) DQ_QC                  --全厂当期无合同未出库量
        ,(SELECT SUM(CASE WHEN T1.ORD_NO IS NULL AND T1.SLAB_STAT = '2' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE   SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(DECODE(T1.SLAB_TOT_DEC_GRD, '8', T1.SLAB_TOT_DEC_GRD_DTIME,'7',T1.SLAB_TOT_DEC_GRD_DTIME, T1.SLAB_CUT_DTIME) ,1,8 )  <= ETIME) YL_QC      --全厂月累无合同未出库量
        FROM SHIJIAN
      
        UNION
      
        SELECT '07' XH
        ,'牌号改判量(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.BEF_STL_GRD != T1.STL_GRD AND T1.BEF_STL_GRD IS NOT NULL  THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME)))) 
        AND T1.CC_DEVNO='J1')     DQ_1                    -- 1#当期牌号改判量
        ,(SELECT SUM(CASE WHEN T1.BEF_STL_GRD != T1.STL_GRD AND T1.BEF_STL_GRD IS NOT NULL  THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        ) YL_1          --1#月累牌号改判量
        ,(SELECT SUM(CASE WHEN T1.BEF_STL_GRD != T1.STL_GRD AND T1.BEF_STL_GRD IS NOT NULL  THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))))
        AND t1.CC_DEVNO='J2') DQ_2                        --2#当期牌号改判量
        ,(SELECT SUM(CASE WHEN T1.BEF_STL_GRD != T1.STL_GRD AND T1.BEF_STL_GRD IS NOT NULL  THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        ) YL_2          --2#月累牌号改判量
        ,(SELECT SUM(CASE WHEN T1.BEF_STL_GRD != T1.STL_GRD AND T1.BEF_STL_GRD IS NOT NULL  THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))))
        AND T1.CC_DEVNO='J3') DQ_3                  --3#当期牌号改判量
        ,(SELECT SUM(CASE WHEN T1.BEF_STL_GRD != T1.STL_GRD AND T1.BEF_STL_GRD IS NOT NULL  THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        ) YL_3    --3#月累牌号改判量
        ,(SELECT SUM(CASE WHEN T1.BEF_STL_GRD != T1.STL_GRD AND T1.BEF_STL_GRD IS NOT NULL  THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))))
        ) DQ_QC                  --全厂当期牌号改判量
        ,(SELECT SUM(CASE WHEN T1.BEF_STL_GRD != T1.STL_GRD AND T1.BEF_STL_GRD IS NOT NULL  THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        ) YL_QC      --全厂月累牌号改判量
        FROM SHIJIAN
        
        UNION
        
        SELECT '08' XH
        ,'非计划量(t)' ZB
        ,(SELECT SUM(CASE WHEN (T1.ORD_FL = '2' ) OR
                  (T1.ORD_FL = '1' AND
                  (T1.SLAB_TOT_DEC_GRD IS NULL OR
                  SUBSTR(T1.ORD_NO,2,1) IN ('6','7'))) THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))))
        AND T1.CC_DEVNO='J1')     DQ_1                    -- 1#当期非计划量
        ,(SELECT SUM(CASE WHEN (T1.ORD_FL = '2' ) OR
                  (T1.ORD_FL = '1' AND
                  (T1.SLAB_TOT_DEC_GRD IS NULL OR
                  SUBSTR(T1.ORD_NO,2,1) IN ('6','7'))) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        ) YL_1          --1#月累非计划量
        ,(SELECT SUM(CASE WHEN (T1.ORD_FL = '2' ) OR
                  (T1.ORD_FL = '1' AND
                  (T1.SLAB_TOT_DEC_GRD IS NULL OR
                  SUBSTR(T1.ORD_NO,2,1) IN ('6','7'))) THEN T1.SLAB_WGT / 1000 ELSE 0 END)
        FROM TEMP1 T1
        WHERE (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))))
        AND T1.CC_DEVNO='J2') DQ_2                        --2#当期非计划量
        ,(SELECT SUM(CASE WHEN (T1.ORD_FL = '2' ) OR
                  (T1.ORD_FL = '1' AND
                  (T1.SLAB_TOT_DEC_GRD IS NULL OR
                  SUBSTR(T1.ORD_NO,2,1) IN ('6','7'))) THEN T1.SLAB_WGT / 1000 ELSE 0 END)
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        ) YL_2          --2#月累非计划量
        ,(SELECT SUM(CASE WHEN (T1.ORD_FL = '2' ) OR
                  (T1.ORD_FL = '1' AND
                  (T1.SLAB_TOT_DEC_GRD IS NULL OR
                  SUBSTR(T1.ORD_NO,2,1) IN ('6','7'))) THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))))
        AND T1.CC_DEVNO='J3') DQ_3                  --3#当期非计划量
        ,(SELECT SUM(CASE WHEN (T1.ORD_FL = '2' ) OR
                  (T1.ORD_FL = '1' AND
                  (T1.SLAB_TOT_DEC_GRD IS NULL OR
                  SUBSTR(T1.ORD_NO,2,1) IN ('6','7'))) THEN T1.SLAB_WGT / 1000 ELSE 0 END)
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        ) YL_3    --3#月累非计划量
        ,(SELECT SUM(CASE WHEN (T1.ORD_FL = '2' ) OR
                  (T1.ORD_FL = '1' AND
                  (T1.SLAB_TOT_DEC_GRD IS NULL OR
                  SUBSTR(T1.ORD_NO,2,1) IN ('6','7'))) THEN T1.SLAB_WGT / 1000 ELSE 0 END)
        FROM TEMP1 T1
        WHERE (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) BETWEEN STIME AND ETIME) 
        OR ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        (SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN STIME AND ETIME 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN STIME AND ETIME))))
        ) DQ_QC                  --全厂当期非计划量
        ,(SELECT SUM(CASE WHEN (T1.ORD_FL = '2' ) OR
                  (T1.ORD_FL = '1' AND
                  (T1.SLAB_TOT_DEC_GRD IS NULL OR
                  SUBSTR(T1.ORD_NO,2,1) IN ('6','7'))) THEN T1.SLAB_WGT / 1000 ELSE 0 END)
        FROM TEMP1 T1
        WHERE  (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME, 1, 8) <= ETIME) OR 
        ((NVL(T1.SLAB_TOT_DEC_GRD, 'K') NOT IN ('7','8')) AND
        ((SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) AND SUBSTR(T1.SMS_YARD_EXT_DTIME, 1, 8) <= ETIME) 
        OR (T1.SMS_YARD_EXT_DTIME IS NULL AND (SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 6) >= SUBSTR(ETIME,1,6) 
        AND SUBSTR(T1.SLAB_STOCK_ENT_DTIME, 1, 8) <= ETIME)))))
        ) YL_QC      --全厂月累非计划量
        FROM SHIJIAN
        
        UNION
        
        SELECT '09' XH
        ,'化废(t)' ZB
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND (T1.SLAB_INGR_DEC_GRD_EXT = '8' OR T1.SLAB_INGR_DEC_GRD_EXT = '7') AND T1.CRK_CD1 IS NULL) THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1')     DQ_1                    -- 1#当期牌化废
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND (T1.SLAB_INGR_DEC_GRD_EXT = '8' OR T1.SLAB_INGR_DEC_GRD_EXT = '7') AND T1.CRK_CD1 IS NULL) THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_1          --1#月累化废
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND (T1.SLAB_INGR_DEC_GRD_EXT = '8' OR T1.SLAB_INGR_DEC_GRD_EXT = '7') AND T1.CRK_CD1 IS NULL) THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2') DQ_2                        --2#当期化废
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND (T1.SLAB_INGR_DEC_GRD_EXT = '8' OR T1.SLAB_INGR_DEC_GRD_EXT = '7') AND T1.CRK_CD1 IS NULL) THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_2          --2#月累化废
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND (T1.SLAB_INGR_DEC_GRD_EXT = '8' OR T1.SLAB_INGR_DEC_GRD_EXT = '7') AND T1.CRK_CD1 IS NULL) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3') DQ_3                  --3#当期化废
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND (T1.SLAB_INGR_DEC_GRD_EXT = '8' OR T1.SLAB_INGR_DEC_GRD_EXT = '7') AND T1.CRK_CD1 IS NULL) THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_3    --3#月累化废
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND (T1.SLAB_INGR_DEC_GRD_EXT = '8' OR T1.SLAB_INGR_DEC_GRD_EXT = '7') AND T1.CRK_CD1 IS NULL) THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) DQ_QC                  --全厂当期化废
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') AND (T1.SLAB_INGR_DEC_GRD_EXT = '8' OR T1.SLAB_INGR_DEC_GRD_EXT = '7') AND T1.CRK_CD1 IS NULL) THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_QC      --全厂月累化废
        FROM SHIJIAN
        
        UNION
        
        SELECT '10' XH
        ,'鼓肚(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('04','33','34') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1                    -- 1#当期牌鼓肚
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('04','33','34') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累鼓肚
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('04','33','34') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2                        --2#当期鼓肚
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('04','33','34') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累鼓肚
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('04','33','34') THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3                  --3#当期鼓肚
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('04','33','34') THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累鼓肚
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('04','33','34') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC                  --全厂当期鼓肚
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('04','33','34') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累鼓肚
        FROM SHIJIAN
         
        UNION
        
        SELECT '11' XH
        ,'割伤(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('48') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1                    -- 1#当期牌割伤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('48') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累割伤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('48') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2                        --2#当期割伤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('48') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累割伤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('48') THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3                  --3#当期割伤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('48') THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累割伤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('48') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC                  --全厂当期割伤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('48') THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE   SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累割伤
        FROM SHIJIAN
        
        UNION
        
        SELECT '12' XH
        ,'气孔(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '14' THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1                    -- 1#当期牌气孔
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '14' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累气孔
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '14' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2          --2#当期气孔
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '14' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累气孔
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '14' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3                  --3#当期气孔
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '14' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累气孔
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '14' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC                  --全厂当期气孔
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '14' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累气孔
        FROM SHIJIAN
        
        UNION
        
        SELECT '13' XH
        ,'裂纹(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('07','32','44','47','49') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1                    -- 1#当期牌裂纹
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('07','32','44','47','49') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累裂纹
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('07','32','44','47','49') THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2          --2#当期裂纹
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('07','32','44','47','49') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累裂纹
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('07','32','44','47','49') THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3         --3#当期裂纹
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('07','32','44','47','49') THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累裂纹
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('07','32','44','47','49') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC                  --全厂当期裂纹
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('07','32','44','47','49') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累裂纹
        FROM SHIJIAN
        
        UNION
        
        SELECT '14' XH
        ,'短尺(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '50' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1     -- 1#当期牌短尺
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '50' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累短尺
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '50' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2         --2#当期短尺
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '50' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累短尺
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '50' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3          --3#当期短尺
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '50' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累短尺
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '50' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC    --全厂当期短尺
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '50' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累短尺
        FROM SHIJIAN
        
        
        UNION
        
        SELECT '15' XH
        ,'凹坑(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('18','35','36') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1     -- 1#当期牌凹坑
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('18','35','36') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累凹坑
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('18','35','36') THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2        --2#当期凹坑
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('18','35','36') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累凹坑
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('18','35','36') THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3          --3#当期凹坑
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('18','35','36') THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累凹坑
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('18','35','36') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC    --全厂当期凹坑
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('18','35','36') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE   SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累凹坑
        FROM SHIJIAN
        
        
        UNION
        
        SELECT '16' XH
        ,'夹杂(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '10' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1       -- 1#当期牌夹杂
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '10' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累夹杂
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '10' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2     --2#当期夹杂
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '10' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累夹杂
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '10' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3       --3#当期夹杂
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '10' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累夹杂
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '10' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC    --全厂当期夹杂
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '10' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累夹杂
        FROM SHIJIAN
        
        UNION
        
        SELECT '17' XH
        ,'分层(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '31' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1   -- 1#当期牌分层
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '31' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累分层
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '31' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2    --2#当期分层
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '31' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累分层
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '31' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3    --3#当期分层
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '31' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累分层
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '31' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC     --全厂当期分层
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '31' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  
       SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累分层
        FROM SHIJIAN
        
        UNION
        
        SELECT '18' XH
        ,'结疤(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '09' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1    -- 1#当期牌结疤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '09' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累结疤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '09' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2      --2#当期结疤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '09' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累结疤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '09' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3         --3#当期结疤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '09' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累结疤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '09' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC     --全厂当期结疤
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '09' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  
       SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累结疤
        FROM SHIJIAN
        
        UNION
        
        SELECT '19' XH
        ,'双浇(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '30' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1    -- 1#当期牌双浇
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '30' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累双浇
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '30' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2      --2#当期双浇
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '30' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累双浇
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '30' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3    --3#当期双浇
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '30' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
       T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累双浇
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '30' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC     --全厂当期双浇
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = '30' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  
       SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累双浇
        FROM SHIJIAN
        
        UNION
        
        SELECT '20' XH
        ,'弯曲(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('02','03') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1    -- 1#当期牌弯曲
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('02','03') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累弯曲
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('02','03') THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2    --2#当期弯曲
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('02','03') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2       --2#月累弯曲
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('02','03') THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3       --3#当期弯曲
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('02','03') THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累弯曲
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('02','03') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC     --全厂当期弯曲
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 IN ('02','03') THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累弯曲
        FROM SHIJIAN
        
        UNION
        
        SELECT '21' XH
        ,'超长(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'CC' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1   -- 1#当期牌超长
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'CC' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1        --1#月累超长
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'CC' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2     --2#当期超长
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'CC' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累超长
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'CC' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3    --3#当期超长
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'CC' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
       T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累超长
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'CC' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC                  --全厂当期超长
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'CC' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  
        SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累超长
        FROM SHIJIAN
        
        UNION
        
        SELECT '22' XH
        ,'退废(t)' ZB
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'TF' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/))     DQ_1    -- 1#当期牌退废
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'TF' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_1          --1#月累退废
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'TF' THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_2    --2#当期退废
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'TF' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_2          --2#月累退废
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'TF' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3'
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_3   --3#当期退废
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'TF' THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE  
        T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_3    --3#月累退废
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'TF' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) DQ_QC   --全厂当期退废
        ,(SELECT SUM(CASE WHEN T1.CRK_CD1 = 'TF' THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE   SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME
        AND ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/)) YL_QC      --全厂月累退废
        FROM SHIJIAN
        
        UNION
        
        SELECT '23' XH
        ,'其它(t)' ZB
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') 
        AND (NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '8' AND NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '7' 
        AND T1.CRK_CD1 IS NULL)) OR
        (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/) 
        AND ((T1.CRK_CD1 <> '02' AND T1.CRK_CD1 <> '03' AND T1.CRK_CD1 <> '04' AND 
           T1.CRK_CD1 <> '07' AND T1.CRK_CD1 <> '09' AND T1.CRK_CD1 <> '10' AND
             T1.CRK_CD1 <> '14' AND T1.CRK_CD1 <> '18' AND T1.CRK_CD1 <> '30' AND
             T1.CRK_CD1 <> '31' AND T1.CRK_CD1 <> '32' AND T1.CRK_CD1 <> '33' AND
             T1.CRK_CD1 <> '34' AND T1.CRK_CD1 <> '35' AND T1.CRK_CD1 <> '36' AND 
             T1.CRK_CD1 <> '44' AND T1.CRK_CD1 <> '47' AND T1.CRK_CD1 <> '48' AND 
             T1.CRK_CD1 <> '49' AND T1.CRK_CD1 <> '50'))) 
             THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J1')     DQ_1    -- 1#当期牌其它
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') 
        AND (NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '8' AND NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '7' 
        AND T1.CRK_CD1 IS NULL)) OR
        (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/) 
        AND ((T1.CRK_CD1 <> '02' AND T1.CRK_CD1 <> '03' AND T1.CRK_CD1 <> '04' AND 
           T1.CRK_CD1 <> '07' AND T1.CRK_CD1 <> '09' AND T1.CRK_CD1 <> '10' AND
             T1.CRK_CD1 <> '14' AND T1.CRK_CD1 <> '18' AND T1.CRK_CD1 <> '30' AND
             T1.CRK_CD1 <> '31' AND T1.CRK_CD1 <> '32' AND T1.CRK_CD1 <> '33' AND
             T1.CRK_CD1 <> '34' AND T1.CRK_CD1 <> '35' AND T1.CRK_CD1 <> '36' AND 
             T1.CRK_CD1 <> '44' AND T1.CRK_CD1 <> '47' AND T1.CRK_CD1 <> '48' AND 
             T1.CRK_CD1 <> '49' AND T1.CRK_CD1 <> '50'))) 
             THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J1' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_1          --1#月累其它
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') 
        AND (NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '8' AND NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '7' 
        AND T1.CRK_CD1 IS NULL)) OR
        (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/) 
        AND ((T1.CRK_CD1 <> '02' AND T1.CRK_CD1 <> '03' AND T1.CRK_CD1 <> '04' AND 
           T1.CRK_CD1 <> '07' AND T1.CRK_CD1 <> '09' AND T1.CRK_CD1 <> '10' AND
             T1.CRK_CD1 <> '14' AND T1.CRK_CD1 <> '18' AND T1.CRK_CD1 <> '30' AND
             T1.CRK_CD1 <> '31' AND T1.CRK_CD1 <> '32' AND T1.CRK_CD1 <> '33' AND
             T1.CRK_CD1 <> '34' AND T1.CRK_CD1 <> '35' AND T1.CRK_CD1 <> '36' AND 
             T1.CRK_CD1 <> '44' AND T1.CRK_CD1 <> '47' AND T1.CRK_CD1 <> '48' AND 
             T1.CRK_CD1 <> '49' AND T1.CRK_CD1 <> '50'))) 
             THEN T1.SLAB_WGT / 1000 ELSE 0 END)   
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J2') DQ_2    --2#当期其它
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') 
        AND (NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '8' AND NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '7' 
        AND T1.CRK_CD1 IS NULL)) OR
        (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/) 
        AND ((T1.CRK_CD1 <> '02' AND T1.CRK_CD1 <> '03' AND T1.CRK_CD1 <> '04' AND 
           T1.CRK_CD1 <> '07' AND T1.CRK_CD1 <> '09' AND T1.CRK_CD1 <> '10' AND
             T1.CRK_CD1 <> '14' AND T1.CRK_CD1 <> '18' AND T1.CRK_CD1 <> '30' AND
             T1.CRK_CD1 <> '31' AND T1.CRK_CD1 <> '32' AND T1.CRK_CD1 <> '33' AND
             T1.CRK_CD1 <> '34' AND T1.CRK_CD1 <> '35' AND T1.CRK_CD1 <> '36' AND 
             T1.CRK_CD1 <> '44' AND T1.CRK_CD1 <> '47' AND T1.CRK_CD1 <> '48' AND 
             T1.CRK_CD1 <> '49' AND T1.CRK_CD1 <> '50'))) 
             THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  T1.CC_DEVNO='J2' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_2          --2#月累其它
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') 
        AND (NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '8' AND NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '7' 
        AND T1.CRK_CD1 IS NULL)) OR
        (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/) 
        AND ((T1.CRK_CD1 <> '02' AND T1.CRK_CD1 <> '03' AND T1.CRK_CD1 <> '04' AND 
           T1.CRK_CD1 <> '07' AND T1.CRK_CD1 <> '09' AND T1.CRK_CD1 <> '10' AND
             T1.CRK_CD1 <> '14' AND T1.CRK_CD1 <> '18' AND T1.CRK_CD1 <> '30' AND
             T1.CRK_CD1 <> '31' AND T1.CRK_CD1 <> '32' AND T1.CRK_CD1 <> '33' AND
             T1.CRK_CD1 <> '34' AND T1.CRK_CD1 <> '35' AND T1.CRK_CD1 <> '36' AND 
             T1.CRK_CD1 <> '44' AND T1.CRK_CD1 <> '47' AND T1.CRK_CD1 <> '48' AND 
             T1.CRK_CD1 <> '49' AND T1.CRK_CD1 <> '50'))) 
             THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME 
        AND T1.CC_DEVNO='J3') DQ_3   --3#当期其它
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') 
        AND (NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '8' AND NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '7' 
        AND T1.CRK_CD1 IS NULL)) OR
        (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/) 
        AND ((T1.CRK_CD1 <> '02' AND T1.CRK_CD1 <> '03' AND T1.CRK_CD1 <> '04' AND 
           T1.CRK_CD1 <> '07' AND T1.CRK_CD1 <> '09' AND T1.CRK_CD1 <> '10' AND
             T1.CRK_CD1 <> '14' AND T1.CRK_CD1 <> '18' AND T1.CRK_CD1 <> '30' AND
             T1.CRK_CD1 <> '31' AND T1.CRK_CD1 <> '32' AND T1.CRK_CD1 <> '33' AND
             T1.CRK_CD1 <> '34' AND T1.CRK_CD1 <> '35' AND T1.CRK_CD1 <> '36' AND 
             T1.CRK_CD1 <> '44' AND T1.CRK_CD1 <> '47' AND T1.CRK_CD1 <> '48' AND 
             T1.CRK_CD1 <> '49' AND T1.CRK_CD1 <> '50'))) 
             THEN T1.SLAB_WGT / 1000 ELSE 0 END)    
        FROM TEMP1 T1
        WHERE T1.CC_DEVNO='J3' 
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_3    --3#月累其它
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') 
        AND (NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '8' AND NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '7' 
        AND T1.CRK_CD1 IS NULL)) OR
        (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/) 
        AND ((T1.CRK_CD1 <> '02' AND T1.CRK_CD1 <> '03' AND T1.CRK_CD1 <> '04' AND 
           T1.CRK_CD1 <> '07' AND T1.CRK_CD1 <> '09' AND T1.CRK_CD1 <> '10' AND
             T1.CRK_CD1 <> '14' AND T1.CRK_CD1 <> '18' AND T1.CRK_CD1 <> '30' AND
             T1.CRK_CD1 <> '31' AND T1.CRK_CD1 <> '32' AND T1.CRK_CD1 <> '33' AND
             T1.CRK_CD1 <> '34' AND T1.CRK_CD1 <> '35' AND T1.CRK_CD1 <> '36' AND 
             T1.CRK_CD1 <> '44' AND T1.CRK_CD1 <> '47' AND T1.CRK_CD1 <> '48' AND 
             T1.CRK_CD1 <> '49' AND T1.CRK_CD1 <> '50'))) 
             THEN T1.SLAB_WGT / 1000 ELSE 0 END)  
        FROM TEMP1 T1
        WHERE SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  >= STIME
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) DQ_QC    --全厂当期其它
        ,(SELECT SUM(CASE WHEN ((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') 
        AND (NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '8' AND NVL(T1.SLAB_INGR_DEC_GRD_EXT,'K') <> '7' 
        AND T1.CRK_CD1 IS NULL)) OR
        (((T1.SLAB_TOT_DEC_GRD = '7' OR T1.SLAB_TOT_DEC_GRD = '8') /*AND T1.EXTSHAPE_GRD_EXT = '8'*/) 
        AND ((T1.CRK_CD1 <> '02' AND T1.CRK_CD1 <> '03' AND T1.CRK_CD1 <> '04' AND 
           T1.CRK_CD1 <> '07' AND T1.CRK_CD1 <> '09' AND T1.CRK_CD1 <> '10' AND
             T1.CRK_CD1 <> '14' AND T1.CRK_CD1 <> '18' AND T1.CRK_CD1 <> '30' AND
             T1.CRK_CD1 <> '31' AND T1.CRK_CD1 <> '32' AND T1.CRK_CD1 <> '33' AND
             T1.CRK_CD1 <> '34' AND T1.CRK_CD1 <> '35' AND T1.CRK_CD1 <> '36' AND 
             T1.CRK_CD1 <> '44' AND T1.CRK_CD1 <> '47' AND T1.CRK_CD1 <> '48' AND 
             T1.CRK_CD1 <> '49' AND T1.CRK_CD1 <> '50'))) 
             THEN T1.SLAB_WGT / 1000 ELSE 0 END) 
        FROM TEMP1 T1
        WHERE  SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,6 )  >= SUBSTR(ETIME,1,6)
        AND SUBSTR(T1.SLAB_TOT_DEC_GRD_DTIME ,1,8 )  <= ETIME) YL_QC      --全厂月累其它
        FROM SHIJIAN
       
      )  
      
       
		 ]]>   
	</query>
</queryMap>