XinYu_RZMES/.svn/pristine/4d/4deaf3b6d339cb62a80e6ee81a337b4053f568f3.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="炼钢品质速报">
	
			
	<query  id="UIB020270_01.SELECT" desc="日生产炉次数">
		WITH TGDAY
		AS (SELECT ? AS TG FROM DUAL)
		SELECT X.PRODNM_CD PRODNM_CD
			 , to_char(COUNT(*)) AS CNT
			 , to_char(COUNT(DECODE(X.INGR_DEC_GRD,'1',1))) AS CNT_1
			 , to_char(COUNT(DECODE(X.INGR_DEC_GRD,'2',1))) AS CNT_2
			 , to_char((COUNT(DECODE(X.INGR_DEC_GRD,'1',1))/COUNT(*))*100,'990.99')||'%' AS CNT_3
		FROM TBG02_CHARGE_COMM X,TGDAY Z
		WHERE LST_INGR_REG_DTIME LIKE SUBSTR(Z.TG,1,8)||DECODE(Z.TG,'','','%')
		AND   INGR_DEC_GRD IS NOT   NULL
		GROUP BY X.PRODNM_CD
		ORDER BY 1 ASC
	</query>

	<query  id="UIB020270_02.SELECT" desc="月生产炉次数">
	   WITH TGDAY
       AS (SELECT ? AS TG FROM DUAL)
       SELECT X.PRODNM_CD
       , to_char(COUNT(*)) AS CNT
       , to_char(COUNT(DECODE(X.INGR_DEC_GRD,'1',1))) AS CNT_1
       , to_char(COUNT(DECODE(X.INGR_DEC_GRD,'2',1))) AS CNT_2
       , to_char((COUNT(DECODE(X.INGR_DEC_GRD,'1',1))/COUNT(*))*100,'990.99')||'%' AS CNT_3
       FROM TBG02_CHARGE_COMM X,TGDAY Z
       WHERE LST_INGR_REG_DTIME LIKE SUBSTR(Z.TG,1,6)||DECODE(Z.TG,'','','%')
       AND   INGR_DEC_GRD IS NOT   NULL
       GROUP BY X.PRODNM_CD
       ORDER BY 1 ASC  
	</query>
	
	<query  id="UIB020270_03.SELECT" desc="热轧日生产板坯数">
		WITH TGDAY
        AS (SELECT ? AS TG FROM DUAL)
		SELECT T1.PRODNM_CD,
        to_char(COUNT(DECODE(t2.SLAB_INGR_DEC_GRD,'','',1))) AS CNT,
        to_char(COUNT(DECODE(t2.SLAB_INGR_DEC_GRD,'1',1))) AS CNT_1,
        to_char(COUNT(DECODE(t2.SLAB_INGR_DEC_GRD,'2',1))) AS CNT_2
        FROM TBG02_CHARGE_COMM t1,TBG02_SLAB_COMM t2,TGDAY t3
    	where t1.charge_no = substr(t2.slab_no,1,10) 
		and t1.INGR_DEC_GRD = '2'                    
		and t2.PRODNM_CD = 'AR'
		and LST_INGR_REG_DTIME LIKE SUBSTR(T3.TG,1,8)||DECODE(T3.TG,'','','%')  
		GROUP BY  T1.PRODNM_CD  
	</query>
	
	<query  id="UIB020270_04.SELECT" desc="热轧月生产板坯数">
		WITH TGDAY
        AS (SELECT ? AS TG FROM DUAL)
		SELECT T1.PRODNM_CD,
        to_char(COUNT(DECODE(t2.SLAB_INGR_DEC_GRD,'','',1))) AS CNT,
        to_char(COUNT(DECODE(t2.SLAB_INGR_DEC_GRD,'1',1))) AS CNT_1,
        to_char(COUNT(DECODE(t2.SLAB_INGR_DEC_GRD,'2',1))) AS CNT_2
        FROM TBG02_CHARGE_COMM t1,TBG02_SLAB_COMM t2,TGDAY t3
    	where t1.charge_no = substr(t2.slab_no,1,10) 
		and t1.INGR_DEC_GRD = '2'                    
		and t2.PRODNM_CD = 'AR'
		and LST_INGR_REG_DTIME LIKE SUBSTR(t3.TG,1,6)||DECODE(t3.TG,'','','%')  
		GROUP BY  T1.PRODNM_CD
	</query>

	<query  id="UIB020270_05.SELECT" desc="外观检验实际（日）(废)">
		WITH TGDAY
		AS (SELECT ? AS TG FROM DUAL)
		SELECT T1.PRODNM_CD,
		TO_CHAR(COUNT(*)) CNT,
        TO_CHAR(COUNT(DECODE(T1.EXTSHAPE_DEC_GRD,'1',1))) CNT_1, 
        TO_CHAR(COUNT(CASE WHEN T1.EXTSHAPE_DEC_GRD != '1' THEN CRK_CD1 END)) CRK_CD1,
        TO_CHAR(COUNT(CASE WHEN T1.EXTSHAPE_DEC_GRD != '1' THEN CRK_CD2 END)) CRK_CD2,
        TO_CHAR(COUNT(CASE WHEN T1.EXTSHAPE_DEC_GRD != '1' THEN CRK_CD3 END)) CRK_CD3,
        TO_CHAR(COUNT(CASE WHEN T1.EXTSHAPE_DEC_GRD != '1' THEN CRK_CD4 END)) CRK_CD4,
        TO_CHAR(COUNT(CASE WHEN T1.EXTSHAPE_DEC_GRD != '1' THEN CRK_CD5 END)) CRK_CD5
        FROM TBH02_COIL_COMM T1,TGDAY T2
        WHERE
        T1.EXTSHAPE_DEC_GRD is not null
		and T1.extshape_dec_dtime LIKE SUBSTR(T2.TG,1,8)||DECODE(T2.TG,'','','%')
        GROUP BY T1.PRODNM_CD      
	</query>	
	
	<query  id="UIB020270_06.SELECT" desc="外观检验实际（月）(废)">
		WITH TGDAY
		AS (SELECT ? AS TG FROM DUAL)
		SELECT T1.PRODNM_CD,
		TO_CHAR(COUNT(*)) CNT,
        TO_CHAR(COUNT(DECODE(T1.EXTSHAPE_DEC_GRD,'1',1))) CNT_1, 
        TO_CHAR(COUNT(CASE WHEN T1.EXTSHAPE_DEC_GRD != '1' THEN CRK_CD1 END)) CRK_CD1,
        TO_CHAR(COUNT(CASE WHEN T1.EXTSHAPE_DEC_GRD != '1' THEN CRK_CD2 END)) CRK_CD2,
        TO_CHAR(COUNT(CASE WHEN T1.EXTSHAPE_DEC_GRD != '1' THEN CRK_CD3 END)) CRK_CD3,
        TO_CHAR(COUNT(CASE WHEN T1.EXTSHAPE_DEC_GRD != '1' THEN CRK_CD4 END)) CRK_CD4,
        TO_CHAR(COUNT(CASE WHEN T1.EXTSHAPE_DEC_GRD != '1' THEN CRK_CD5 END)) CRK_CD5
        FROM TBH02_COIL_COMM T1,TGDAY T2
        WHERE
        T1.EXTSHAPE_DEC_GRD is not null
		and T1.extshape_dec_dtime LIKE SUBSTR(T2.TG,1,6)||DECODE(T2.TG,'','','%')
        GROUP BY T1.PRODNM_CD
	</query>		
	
    <query  id="UIB020270_07.SELECT" desc="产品检验实绩（日）(废)">
		WITH TGDAY
        AS (SELECT ? AS TG FROM DUAL)
        SELECT T1.PRODNM_CD,
        TO_CHAR(COUNT(*)) CNT,
        TO_CHAR(COUNT(DECODE(T1.TOT_DEC_GRD,'1',1))) CNT_1, 
        TO_CHAR(COUNT(DECODE(T1.MATLQLTY_DEC_GRD,'2',1))) CNT_2, 
        TO_CHAR(COUNT(DECODE(T1.WGT_DEC_RST,'2',1))) CNT_3, 
        TO_CHAR(COUNT(DECODE(T1.SIZE_DEC_RST,'2',1))) CNT_4, 
        TO_CHAR(COUNT(DECODE(T1.EXTSHAPE_DEC_GRD,'2',1))) CNT_5,
        TO_CHAR((COUNT(DECODE(T1.TOT_DEC_GRD,'1',1))/COUNT(*))*100,'990.99')||'%' CNT_6
        FROM TBH02_COIL_COMM T1,TGDAY T2
        WHERE
        T1.YARD_ENTRY_DTIME LIKE SUBSTR(T2.TG,1,8)||DECODE(T2.TG,'','','%') and
        T1.TOT_DEC_DTIME LIKE SUBSTR(T2.TG,1,8)||DECODE(T2.TG,'','','%') 
        GROUP BY T1.PRODNM_CD
	</query>
	
	<query  id="UIB020270_08.SELECT" desc="产品检验实绩（月）(废)">
		WITH TGDAY
        AS (SELECT ? AS TG FROM DUAL)
        SELECT T1.PRODNM_CD,
        TO_CHAR(COUNT(*)) CNT,
        TO_CHAR(COUNT(DECODE(T1.TOT_DEC_GRD,'1',1))) CNT_1, 
        TO_CHAR(COUNT(DECODE(T1.MATLQLTY_DEC_GRD,'2',1))) CNT_2, 
        TO_CHAR(COUNT(DECODE(T1.WGT_DEC_RST,'2',1))) CNT_3, 
        TO_CHAR(COUNT(DECODE(T1.SIZE_DEC_RST,'2',1))) CNT_4, 
        TO_CHAR(COUNT(DECODE(T1.EXTSHAPE_DEC_GRD,'2',1))) CNT_5,
        TO_CHAR((COUNT(DECODE(T1.TOT_DEC_GRD,'1',1))/COUNT(*))*100,'990.99')||'%' CNT_6
        FROM TBH02_COIL_COMM T1,TGDAY T2
        WHERE
        T1.YARD_ENTRY_DTIME LIKE SUBSTR(T2.TG,1,6)||DECODE(T2.TG,'','','%') and
        T1.TOT_DEC_DTIME LIKE SUBSTR(T2.TG,1,6)||DECODE(T2.TG,'','','%') 
        GROUP BY T1.PRODNM_CD
	</query>
	
	<query  id="UIB020270.CHARGE" desc="炉次成分判定实绩">
		<![CDATA[
SELECT T.*
,DECODE(H_DAY_CNT,0,'',TO_CHAR((H_DAY_CNT_2/H_DAY_CNT)*100,'990.99')||'%') H_DAY_CNT_6
,DECODE(H_MON_CNT,0,'',TO_CHAR((H_MON_CNT_2/H_MON_CNT)*100,'990.99')||'%') H_MON_CNT_6
,DECODE(P_DAY_CNT,0,'',TO_CHAR((P_DAY_CNT_2/P_DAY_CNT)*100,'990.99')||'%') P_DAY_CNT_6
,DECODE(P_MON_CNT,0,'',TO_CHAR((P_MON_CNT_2/P_MON_CNT)*100,'990.99')||'%') P_MON_CNT_6
,DECODE(Z_DAY_CNT,0,'',TO_CHAR((Z_DAY_CNT_2/Z_DAY_CNT)*100,'990.99')||'%') Z_DAY_CNT_6
,DECODE(Z_MON_CNT,0,'',TO_CHAR((Z_MON_CNT_2/Z_MON_CNT)*100,'990.99')||'%') Z_MON_CNT_6
,DECODE(A_DAY_CNT,0,'',TO_CHAR((A_DAY_CNT_2/A_DAY_CNT)*100,'990.99')||'%') A_DAY_CNT_6
,DECODE(A_MON_CNT,0,'',TO_CHAR((A_MON_CNT_2/A_MON_CNT)*100,'990.99')||'%') A_MON_CNT_6
,'-' NL
FROM 
(WITH TGDAY
    AS (SELECT :1  AS TG FROM DUAL)
SELECT 
    (SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   SLAB_RT = 'H'  
    ) H_DAY_CNT                                          --生产炉次数(热轧_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   SLAB_RT = 'H'  
    ) H_MON_CNT                                          --生产炉次数(热轧_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   SLAB_RT = 'P'    
    ) P_DAY_CNT                                          --生产炉次数(厚板_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   SLAB_RT = 'P'   
    ) P_MON_CNT                                          --生产炉次数(厚板_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   SLAB_RT = 'Z'    
    ) Z_DAY_CNT                                          --生产炉次数(中板_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   SLAB_RT = 'Z'   
    ) Z_MON_CNT                                          --生产炉次数(中板_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   SLAB_RT IN ('Z','H','P')     
    ) A_DAY_CNT                                          --生产炉次数(合计_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   SLAB_RT IN ('Z','H','P')   
    ) A_MON_CNT                                          --生产炉次数(合计_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD IS NULL
    AND   SLAB_RT = 'H'    
    ) H_DAY_CNT_1                                          --无判定炉次数(热轧_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD IS NULL
    AND   SLAB_RT = 'H'   
    ) H_MON_CNT_1                                          --无判定炉次数(热轧_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD IS NULL
    AND   SLAB_RT = 'P'    
    ) P_DAY_CNT_1                                          --无判定炉次数(厚板_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD IS NULL
    AND   SLAB_RT = 'P'   
    ) P_MON_CNT_1                                          --无判定炉次数(厚板_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD IS NULL
    AND   SLAB_RT = 'Z'    
    ) Z_DAY_CNT_1                                          --无判定炉次数(中板_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD IS NULL
    AND   SLAB_RT = 'Z'   
    ) Z_MON_CNT_1                                          --无判定炉次数(中板_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD IS NULL
    AND   SLAB_RT IN ('Z','H','P')    
    ) A_DAY_CNT_1                                          --无判定炉次数(合计_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD IS NULL
    AND   SLAB_RT IN ('Z','H','P')   
    ) A_MON_CNT_1                                          --无判定炉次数(合计_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '1'
    AND   SLAB_RT = 'H'  
    ) H_DAY_CNT_2                                          --合格炉次数(热轧_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '1'
    AND   SLAB_RT = 'H'  
    ) H_MON_CNT_2                                          --合格炉次数(热轧_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '1'
    AND   SLAB_RT = 'P'  
    ) P_DAY_CNT_2                                          --合格炉次数(厚板_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '1'
    AND   SLAB_RT = 'P'  
    ) P_MON_CNT_2                                          --合格炉次数(厚板_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '1'
    AND   SLAB_RT = 'Z'  
    ) Z_DAY_CNT_2                                          --合格炉次数(中板_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '1'
    AND   SLAB_RT = 'Z'  
    ) Z_MON_CNT_2                                          --合格炉次数(中板_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '1'
    AND   SLAB_RT IN ('Z','H','P')  
    ) A_DAY_CNT_2                                          --合格炉次数(合计_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '1'
    AND   SLAB_RT IN ('Z','H','P')  
    ) A_MON_CNT_2                                          --合格炉次数(合计_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'H'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    )H_DAY_CNT_3                                           --生产板坯数(热轧_日) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'H'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    )H_MON_CNT_3                                           --生产板坯数(热轧_月) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'P'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    )P_DAY_CNT_3                                           --生产板坯数(厚板_日) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'P'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    )P_MON_CNT_3                                           --生产板坯数(厚板_月) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'Z'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    )Z_DAY_CNT_3                                           --生产板坯数(中板_日) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'Z'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    )Z_MON_CNT_3                                           --生产板坯数(中板_月)
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'H'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   G02SC.SLAB_INGR_DEC_GRD = '1' 
    )H_DAY_CNT_4                                           --订单合格板坯数(热轧_日) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'H'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   G02SC.SLAB_INGR_DEC_GRD = '1'
    )H_MON_CNT_4                                           --订单合格板坯数(热轧_月) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'P'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   G02SC.SLAB_INGR_DEC_GRD = '1' 
    )P_DAY_CNT_4                                           --订单合格板坯数(厚板_日) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'P'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   G02SC.SLAB_INGR_DEC_GRD = '1'
    )P_MON_CNT_4                                           --订单合格板坯数(厚板_月) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'Z'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   G02SC.SLAB_INGR_DEC_GRD = '1' 
    )Z_DAY_CNT_4                                           --订单合格板坯数(中板_日) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'Z'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   G02SC.SLAB_INGR_DEC_GRD = '1'
    )Z_MON_CNT_4                                           --订单合格板坯数(中板_月) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'H'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   (G02SC.SLAB_INGR_DEC_GRD = '2' OR G02SC.SLAB_INGR_DEC_GRD IS NULL) 
    )H_DAY_CNT_5                                           --订单不合格板坯数(热轧_日) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'H'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   (G02SC.SLAB_INGR_DEC_GRD = '2' OR G02SC.SLAB_INGR_DEC_GRD IS NULL)
    )H_MON_CNT_5                                           --订单不合格板坯数(热轧_月) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'P'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   (G02SC.SLAB_INGR_DEC_GRD = '2' OR G02SC.SLAB_INGR_DEC_GRD IS NULL) 
    )P_DAY_CNT_5                                           --订单不合格板坯数(厚板_日) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'P'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   (G02SC.SLAB_INGR_DEC_GRD = '2' OR G02SC.SLAB_INGR_DEC_GRD IS NULL)
    )P_MON_CNT_5                                           --订单不合格板坯数(厚板_月)
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'Z'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   (G02SC.SLAB_INGR_DEC_GRD = '2' OR G02SC.SLAB_INGR_DEC_GRD IS NULL)
    )Z_DAY_CNT_5                                           --订单不合格板坯数(中板_日) 
    
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D G02CC,TBG02_SLAB_COMM G02SC,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   G02CC.INGR_DEC_GRD =  '2' 
    AND   G02SC.SLAB_RT = 'Z'  
    AND   SUBSTR(G02SC.SLAB_NO,1,10) = G02CC.CHARGE_NO
    AND   (G02SC.SLAB_INGR_DEC_GRD = '2' OR G02SC.SLAB_INGR_DEC_GRD IS NULL)
    )Z_MON_CNT_5                                           --订单不合格板坯数(中板_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '2'
    AND   SLAB_RT = 'H'  
    ) H_DAY_CNT_7                                          --不合格炉次数(热轧_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '2'
    AND   SLAB_RT = 'H'  
    ) H_MON_CNT_7                                          --不合格炉次数(热轧_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '2'
    AND   SLAB_RT = 'P'  
    ) P_DAY_CNT_7                                          --不合格炉次数(厚板_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '2'
    AND   SLAB_RT = 'P'  
    ) P_MON_CNT_7                                          --不合格炉次数(厚板_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '2'
    AND   SLAB_RT = 'Z'  
    ) Z_DAY_CNT_7                                          --不合格炉次数(中板_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '2'
    AND   SLAB_RT = 'Z'  
    ) Z_MON_CNT_7                                          --不合格炉次数(中板_月)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= TGDAY.TG||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '2'
    AND   SLAB_RT IN ('Z','H','P')  
    ) A_DAY_CNT_7                                          --不合格炉次数(合计_日)
    ,(SELECT COUNT(*) FROM TBG02_CHARGE_COMM_D,TGDAY
    WHERE LST_INGR_REG_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
    AND   LST_INGR_REG_DTIME <= TGDAY.TG||'235959'
    AND   INGR_DEC_GRD = '2'
    AND   SLAB_RT IN ('Z','H','P')  
    ) A_MON_CNT_7                                          --不合格炉次数(合计_月)
FROM dual) T
		]]> 
	</query>

	<query  id="UIB020270.SLAB" desc="炉次成分判定实绩">
		<![CDATA[
SELECT T.* 
,DECODE(CNT1_3,0,'',TO_CHAR((CNT1_3/CNT1_1)*100,'990.99')||'%') CNT1_5
,DECODE(CNT2_3,0,'',TO_CHAR((CNT2_3/CNT2_1)*100,'990.99')||'%') CNT2_5
FROM
(WITH TGDAY
    AS (SELECT :1 AS TG FROM DUAL)
SELECT 
       (SELECT COUNT(*) FROM TBG02_SLAB_COMM,TGDAY 
       WHERE SLAB_INGR_DEC_DTIME >= TGDAY.TG||'000000'
       AND   SLAB_INGR_DEC_DTIME <= TGDAY.TG||'235959'
       ) CNT1_1                                              --成分录入板坯数(日计)
       ,(SELECT COUNT(*) FROM TBG02_SLAB_COMM,TGDAY  
       WHERE SLAB_INGR_DEC_DTIME >= TGDAY.TG||'000000'
       AND   SLAB_INGR_DEC_DTIME <= TGDAY.TG||'235959'
       AND   SLAB_INGR_DEC_GRD IS NULL 
       ) CNT1_2                                              --无判定板坯数(日计)
       ,(SELECT COUNT(*) FROM TBG02_SLAB_COMM,TGDAY  
       WHERE SLAB_INGR_DEC_DTIME >= TGDAY.TG||'000000'
       AND   SLAB_INGR_DEC_DTIME <= TGDAY.TG||'235959'
       AND   SLAB_INGR_DEC_GRD = '1' 
       ) CNT1_3                                               --合格板坯数(日计)
       ,(SELECT COUNT(*) FROM TBG02_SLAB_COMM,TGDAY  
       WHERE SLAB_INGR_DEC_DTIME >= TGDAY.TG||'000000'
       AND   SLAB_INGR_DEC_DTIME <= TGDAY.TG||'235959'
       AND   SLAB_INGR_DEC_GRD = '2'                         --不合格板坯数(日计) 
       ) CNT1_4
       ,(SELECT COUNT(*) FROM TBG02_SLAB_COMM,TGDAY 
       WHERE SLAB_INGR_DEC_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
       AND   SLAB_INGR_DEC_DTIME <= TGDAY.TG||'235959'
       ) CNT2_1                                              --成分录入板坯数(月计)
       ,(SELECT COUNT(*) FROM TBG02_SLAB_COMM,TGDAY  
       WHERE SLAB_INGR_DEC_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
       AND   SLAB_INGR_DEC_DTIME <= TGDAY.TG||'235959'
       AND   SLAB_INGR_DEC_GRD IS NULL 
       ) CNT2_2                                              --无判定板坯数(月计)
       ,(SELECT COUNT(*) FROM TBG02_SLAB_COMM,TGDAY  
       WHERE SLAB_INGR_DEC_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
       AND   SLAB_INGR_DEC_DTIME <= TGDAY.TG||'235959'
       AND   SLAB_INGR_DEC_GRD = '1' 
       ) CNT2_3                                               --合格板坯数(月计)
       ,(SELECT COUNT(*) FROM TBG02_SLAB_COMM,TGDAY  
       WHERE SLAB_INGR_DEC_DTIME >= SUBSTR(TGDAY.TG,1,6)||'01'||'000000'
       AND   SLAB_INGR_DEC_DTIME <= TGDAY.TG||'235959'
       AND   SLAB_INGR_DEC_GRD = '2'                         --不合格板坯数(月计)
       ) CNT2_4       
FROM DUAL) T 			
		]]> 
	</query>
	<query  id="UIB020270.DATE" desc="查询系统日期">
		<![CDATA[	
		SELECT TO_CHAR(SYSDATE,'YYYYMMDD') dt FROM dual
		]]> 
	</query>
</queryMap>