XinYu_RZMES/.svn/pristine/19/19a5e476eb56963d1b8e8a1804dcfb4cadcfd5dc.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="出钢参数接收现况分析(中厚板)">
	<query id="UIF022010.countMaterielCoilThkSlabWthByK" desc="根据块数求各钢卷厚度板坯宽度物料分析现况" fetchSize="10">
        <![CDATA[
			
/*******************************根据块数求各钢卷厚度板坯宽度物料分析现况***********************************/
			
SELECT  CASE WHEN INSTR_COIL_THK IS NULL AND GROUPING (ORD_FL) = '1' AND GROUPING (INSTR_COIL_THK) = '1'  THEN '合计' 
             WHEN INSTR_COIL_THK IS NULL AND GROUPING (ORD_FL) = '0' AND GROUPING (INSTR_COIL_THK) = '1'  THEN '小计'
             WHEN INSTR_COIL_THK IS NOT NULL THEN decode(INSTR_COIL_THK,'1.2','0 ~ 1.2','1.8','1.2 ~ 1.8',
        '2.5','1.8 ~ 2.5','3.5','2.5 ~ 3.5',
        '4.5','3.5 ~ 4.5','5.0','4.5 ~ 5.0',
        '7.0','5.0 ~ 7.0','9.0','7.0 ~ 9.0',
        '16.0','9.0 ~ 16.0',
        '99','余材')                              END   INSTR_COIL_THK
        ,SUM(NVL(SLAB_CNT750,''))                        SLAB_CNT750
        ,SUM(NVL(SLAB_CNT800,''))                        SLAB_CNT800
        ,SUM(NVL(SLAB_CNT850,''))                        SLAB_CNT850
        ,SUM(NVL(SLAB_CNT900,''))                        SLAB_CNT900
        ,SUM(NVL(SLAB_CNT950,''))                        SLAB_CNT950
        ,SUM(NVL(SLAB_CNT1000,''))                       SLAB_CNT1000
        ,SUM(NVL(SLAB_CNT1050,''))                       SLAB_CNT1050
        ,SUM(NVL(SLAB_CNT1100,''))                       SLAB_CNT1100
        ,SUM(NVL(SLAB_CNT1150,''))                       SLAB_CNT1150
        ,SUM(NVL(SLAB_CNT1200,''))                       SLAB_CNT1200
        ,SUM(NVL(SLAB_CNT1250,''))                       SLAB_CNT1250
        ,SUM(NVL(SLAB_CNT1300,''))                       SLAB_CNT1300
        ,SUM(NVL(SLAB_CNT1350,''))                       SLAB_CNT1350
        ,SUM(NVL(SLAB_CNT1400,''))                       SLAB_CNT1400
        ,SUM(NVL(SLAB_CNT1450,''))                       SLAB_CNT1450
        ,SUM(NVL(SLAB_CNT_BIG1450,''))                   SLAB_CNT_BIG1450
        ,(SUM(NVL(SLAB_CNT750,0))  + 
        SUM(NVL(SLAB_CNT800,0))  + 
        SUM(NVL(SLAB_CNT850,0))  + 
        SUM(NVL(SLAB_CNT900,0))  + 
        SUM(NVL(SLAB_CNT950,0))  + 
        SUM(NVL(SLAB_CNT1000,0)) + 
        SUM(NVL(SLAB_CNT1050,0)) + 
        SUM(NVL(SLAB_CNT1100,0)) + 
        SUM(NVL(SLAB_CNT1150,0)) + 
        SUM(NVL(SLAB_CNT1200,0)) + 
        SUM(NVL(SLAB_CNT1250,0)) + 
        SUM(NVL(SLAB_CNT1300,0)) + 
        SUM(NVL(SLAB_CNT1350,0)) + 
        SUM(NVL(SLAB_CNT1400,0)) + 
        SUM(NVL(SLAB_CNT1450,0)) +
        SUM(NVL(SLAB_CNT_BIG1450,0)))                   SUM_CNT
         
   FROM (SELECT  CASE WHEN 0    <= T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 1.2  THEN '1.2'
                      WHEN 1.2  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 1.8  THEN '1.8'
                      WHEN 1.8  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 2.5  THEN '2.5'
                      WHEN 2.5  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 3.5  THEN '3.5'
                      WHEN 3.5  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 4.5  THEN '4.5'
                      WHEN 4.5  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 5.0  THEN '5.0'
                      WHEN 5.0  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 7.0  THEN '7.0'
                      WHEN 7.0  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 9.0  THEN '9.0'
                      WHEN 9.0  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 16   THEN '16.0'         END   INSTR_COIL_THK
                ,CASE WHEN 0    <= T1.SLAB_WTH AND T1.SLAB_WTH <= 750  THEN '1'            END   SLAB_CNT750
                ,CASE WHEN 750  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 800  THEN '1'            END   SLAB_CNT800
                ,CASE WHEN 800  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 850  THEN '1'            END   SLAB_CNT850
                ,CASE WHEN 850  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 900  THEN '1'            END   SLAB_CNT900
                ,CASE WHEN 900  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 950  THEN '1'            END   SLAB_CNT950
                ,CASE WHEN 950  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1000 THEN '1'            END   SLAB_CNT1000
                ,CASE WHEN 1000 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1050 THEN '1'            END   SLAB_CNT1050
                ,CASE WHEN 1050 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1100 THEN '1'            END   SLAB_CNT1100
                ,CASE WHEN 1100 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1150 THEN '1'            END   SLAB_CNT1150
                ,CASE WHEN 1150 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1200 THEN '1'            END   SLAB_CNT1200
                ,CASE WHEN 1200 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1250 THEN '1'            END   SLAB_CNT1250
                ,CASE WHEN 1250 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1300 THEN '1'            END   SLAB_CNT1300
                ,CASE WHEN 1300 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1350 THEN '1'            END   SLAB_CNT1350
                ,CASE WHEN 1350 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1400 THEN '1'            END   SLAB_CNT1400
                ,CASE WHEN 1400 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1450 THEN '1'            END   SLAB_CNT1450
                ,CASE WHEN T1.SLAB_WTH > 1450                          THEN '1'            END   SLAB_CNT_BIG1450
                ,T1.ORD_FL               
		--------------------------------------------------------------------------------------------------------------
		--MODIFY BY SJW 090829
		--DESC      :防止订单材 TBG02_SLAB_COMM_D 中没有板坯记录的情况
		--VERSION:1.12-->1.13	
		   FROM  TBG02_SLAB_COMM           T1 
				 ,TBG02_SLAB_COMM_D        T2
		  WHERE  T1.SLAB_NO                =   T2.SLAB_NO
			AND  T1.ORD_FL                 =   T2.ORD_FL
			AND  T1.ORD_NO                 =   T2.ORD_NO
			AND  T1.ORD_SEQ                =   T2.ORD_SEQ
			AND  T1.ORD_FL = '1'
		---------------------------------------------------------------------------------------------------------------
            AND  T1.SLAB_RT            IN    ('H','C')
            AND  T1.SLAB_STAT          =      '2'
            AND  T1.CUR_LOAD_LOC       LIKE  'Z%'
            AND (T1.SLAB_LEN         BETWEEN  0  AND  11000)
            AND  T1.SLAB_RT            LIKE   ? || '%' 
            AND  T1.STL_GRD            LIKE   ? || '%' 
            AND  T1.CUR_PROG_CD        IN     ('RBA','RBB','RAB')
			AND  T1.CUR_PROG_CD        LIKE   ? || '%' 
            AND T1.INSTR_COIL_THK > 0
                       
          UNION ALL
          
         SELECT  '99'                                                                              INSTR_COIL_THK
                ,CASE WHEN 0    <= T1.SLAB_WTH AND T1.SLAB_WTH <= 750  THEN '1'            END   SLAB_CNT750
                ,CASE WHEN 750  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 800  THEN '1'            END   SLAB_CNT800
                ,CASE WHEN 800  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 850  THEN '1'            END   SLAB_CNT850
                ,CASE WHEN 850  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 900  THEN '1'            END   SLAB_CNT900
                ,CASE WHEN 900  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 950  THEN '1'            END   SLAB_CNT950
                ,CASE WHEN 950  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1000 THEN '1'            END   SLAB_CNT1000
                ,CASE WHEN 1000 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1050 THEN '1'            END   SLAB_CNT1050
                ,CASE WHEN 1050 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1100 THEN '1'            END   SLAB_CNT1100
                ,CASE WHEN 1100 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1150 THEN '1'            END   SLAB_CNT1150
                ,CASE WHEN 1150 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1200 THEN '1'            END   SLAB_CNT1200
                ,CASE WHEN 1200 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1250 THEN '1'            END   SLAB_CNT1250
                ,CASE WHEN 1250 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1300 THEN '1'            END   SLAB_CNT1300
                ,CASE WHEN 1300 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1350 THEN '1'            END   SLAB_CNT1350
                ,CASE WHEN 1350 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1400 THEN '1'            END   SLAB_CNT1400
                ,CASE WHEN 1400 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1450 THEN '1'            END   SLAB_CNT1450
                ,CASE WHEN T1.SLAB_WTH > 1450                          THEN '1'            END   SLAB_CNT_BIG1450
                ,'2' ORD_FL
           FROM  TBG02_SLAB_COMM T1
          WHERE  T1.ORD_FL           =      '2'
            AND  T1.SLAB_RT            IN    ('H','C')
            AND  T1.SLAB_STAT          =      '2'
            AND  T1.CUR_LOAD_LOC       LIKE  'Z%'
            AND (T1.SLAB_LEN         BETWEEN  0  AND  11000)
            AND  T1.SLAB_RT            LIKE   ? || '%' 
            AND  T1.STL_GRD            LIKE   ? || '%' 			
            AND  T1.CUR_PROG_CD        IN('RRC','RAB')
			AND  T1.CUR_PROG_CD        LIKE   ? || '%'
         
              
         UNION ALL 

        SELECT '1.2'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

              UNION ALL 

        SELECT '1.8'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '2.5'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'       ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '3.5'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '4.5'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '5.0'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '7.0'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '9.0'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '16.0'    INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '99'      INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '2'        ORD_FL
        FROM  DUAL
  )          
  GROUP  BY  ROLLUP(ORD_FL,INSTR_COIL_THK) 
   HAVING   ORD_FL ||GROUPING(INSTR_COIL_THK) <> '21'

/*******************************根据块数求各钢卷厚度板坯宽度物料分析现况***********************************/

        ]]>
    </query>  
	
<query id="UIF022010.countMaterielCoilThkSlabWthByW" desc="根据重量求各钢卷厚度板坯宽度物料分析现况" fetchSize="10">
        <![CDATA[
			
/*******************************根据重量求各钢卷厚度板坯宽度物料分析现况***********************************/

SELECT  CASE WHEN INSTR_COIL_THK IS NULL AND GROUPING (ORD_FL) = '1' AND GROUPING (INSTR_COIL_THK) = '1'  THEN '合计' 
             WHEN INSTR_COIL_THK IS NULL AND GROUPING (ORD_FL) = '0' AND GROUPING (INSTR_COIL_THK) = '1'  THEN '小计'
             WHEN INSTR_COIL_THK IS NOT NULL THEN decode(INSTR_COIL_THK,'1.2','0 ~ 1.2','1.8','1.2 ~ 1.8',
        '2.5','1.8 ~ 2.5','3.5','2.5 ~ 3.5',
        '4.5','3.5 ~ 4.5','5.0','4.5 ~ 5.0',
        '7.0','5.0 ~ 7.0','9.0','7.0 ~ 9.0',
        '16.0','9.0 ~ 16.0',
        '99','余材')                              END   INSTR_COIL_THK
        ,SUM(NVL(SLAB_CNT750,''))                        SLAB_CNT750
        ,SUM(NVL(SLAB_CNT800,''))                        SLAB_CNT800
        ,SUM(NVL(SLAB_CNT850,''))                        SLAB_CNT850
        ,SUM(NVL(SLAB_CNT900,''))                        SLAB_CNT900
        ,SUM(NVL(SLAB_CNT950,''))                        SLAB_CNT950
        ,SUM(NVL(SLAB_CNT1000,''))                       SLAB_CNT1000
        ,SUM(NVL(SLAB_CNT1050,''))                       SLAB_CNT1050
        ,SUM(NVL(SLAB_CNT1100,''))                       SLAB_CNT1100
        ,SUM(NVL(SLAB_CNT1150,''))                       SLAB_CNT1150
        ,SUM(NVL(SLAB_CNT1200,''))                       SLAB_CNT1200
        ,SUM(NVL(SLAB_CNT1250,''))                       SLAB_CNT1250
        ,SUM(NVL(SLAB_CNT1300,''))                       SLAB_CNT1300
        ,SUM(NVL(SLAB_CNT1350,''))                       SLAB_CNT1350
        ,SUM(NVL(SLAB_CNT1400,''))                       SLAB_CNT1400
        ,SUM(NVL(SLAB_CNT1450,''))                       SLAB_CNT1450
        ,SUM(NVL(SLAB_CNT_BIG1450,''))                   SLAB_CNT_BIG1450
        ,(SUM(NVL(SLAB_CNT750,0))  + 
        SUM(NVL(SLAB_CNT800,0))  + 
        SUM(NVL(SLAB_CNT850,0))  + 
        SUM(NVL(SLAB_CNT900,0))  + 
        SUM(NVL(SLAB_CNT950,0))  + 
        SUM(NVL(SLAB_CNT1000,0)) + 
        SUM(NVL(SLAB_CNT1050,0)) + 
        SUM(NVL(SLAB_CNT1100,0)) + 
        SUM(NVL(SLAB_CNT1150,0)) + 
        SUM(NVL(SLAB_CNT1200,0)) + 
        SUM(NVL(SLAB_CNT1250,0)) + 
        SUM(NVL(SLAB_CNT1300,0)) + 
        SUM(NVL(SLAB_CNT1350,0)) + 
        SUM(NVL(SLAB_CNT1400,0)) + 
        SUM(NVL(SLAB_CNT1450,0)) +
        SUM(NVL(SLAB_CNT_BIG1450,0)))                   SUM_CNT
         
   FROM (SELECT  CASE WHEN 0    <= T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 1.2  THEN '1.2'
                      WHEN 1.2  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 1.8  THEN '1.8'
                      WHEN 1.8  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 2.5  THEN '2.5'
                      WHEN 2.5  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 3.5  THEN '3.5'
                      WHEN 3.5  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 4.5  THEN '4.5'
                      WHEN 4.5  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 5.0  THEN '5.0'
                      WHEN 5.0  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 7.0  THEN '7.0'
                      WHEN 7.0  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 9.0  THEN '9.0'
                      WHEN 9.0  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 16   THEN '16.0'             END   INSTR_COIL_THK
                ,CASE WHEN 0    <= T1.SLAB_WTH AND T1.SLAB_WTH <= 750  THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT750
                ,CASE WHEN 750  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 800  THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT800
                ,CASE WHEN 800  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 850  THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT850
                ,CASE WHEN 850  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 900  THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT900
                ,CASE WHEN 900  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 950  THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT950
                ,CASE WHEN 950  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1000 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1000
                ,CASE WHEN 1000 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1050 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1050
                ,CASE WHEN 1050 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1100 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1100
                ,CASE WHEN 1100 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1150 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1150
                ,CASE WHEN 1150 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1200 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1200
                ,CASE WHEN 1200 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1250 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1250
                ,CASE WHEN 1250 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1300 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1300
                ,CASE WHEN 1300 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1350 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1350
                ,CASE WHEN 1350 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1400 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1400
                ,CASE WHEN 1400 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1450 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1450
                ,CASE WHEN T1.SLAB_WTH > 1450                          THEN TO_CHAR(T1.SLAB_WGT)             END   SLAB_CNT_BIG1450
                ,T1.ORD_FL                
		--------------------------------------------------------------------------------------------------------------
		--MODIFY BY SJW 090829
		--DESC      :防止订单材 TBG02_SLAB_COMM_D 中没有板坯记录的情况
		--VERSION:1.12-->1.13	
		   FROM  TBG02_SLAB_COMM           T1 
				 ,TBG02_SLAB_COMM_D        T2
		  WHERE  T1.SLAB_NO                =   T2.SLAB_NO
			AND  T1.ORD_FL                 =   T2.ORD_FL
			AND  T1.ORD_NO                 =   T2.ORD_NO
			AND  T1.ORD_SEQ                =   T2.ORD_SEQ
			AND  T1.ORD_FL = '1'
			---------------------------------------------------------------------------------------------------------------
            AND  T1.SLAB_RT            IN    ('H','C')
            AND  T1.SLAB_STAT          =      '2'
			AND (T1.SLAB_LEN         BETWEEN  0  AND  11000)
			AND  T1.CUR_LOAD_LOC       LIKE  'Z%'
            AND  T1.SLAB_RT            LIKE   ? || '%' 
            AND  T1.STL_GRD            LIKE   ? || '%' 
            AND  T1.CUR_PROG_CD        IN     ('RBA','RBB','RAB')
			AND  T1.CUR_PROG_CD        LIKE   ? || '%' 
            AND T1.INSTR_COIL_THK > 0
                       
          UNION ALL
          
         SELECT  '99'                                                                                              INSTR_COIL_THK
                ,CASE WHEN 0    <= T1.SLAB_WTH AND T1.SLAB_WTH <= 750  THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT750
                ,CASE WHEN 750  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 800  THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT800
                ,CASE WHEN 800  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 850  THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT850
                ,CASE WHEN 850  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 900  THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT900
                ,CASE WHEN 900  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 950  THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT950
                ,CASE WHEN 950  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1000 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1000
                ,CASE WHEN 1000 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1050 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1050
                ,CASE WHEN 1050 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1100 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1100
                ,CASE WHEN 1100 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1150 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1150
                ,CASE WHEN 1150 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1200 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1200
                ,CASE WHEN 1200 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1250 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1250
                ,CASE WHEN 1250 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1300 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1300
                ,CASE WHEN 1300 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1350 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1350
                ,CASE WHEN 1350 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1400 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1400
                ,CASE WHEN 1400 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1450 THEN  TO_CHAR(T1.SLAB_WGT)            END   SLAB_CNT1450
                ,CASE WHEN T1.SLAB_WTH > 1450                          THEN TO_CHAR(T1.SLAB_WGT)             END   SLAB_CNT_BIG1450
                ,'2' ORD_FL
           FROM  TBG02_SLAB_COMM T1
          WHERE  T1.ORD_FL           =      '2'
            AND  T1.SLAB_RT            IN    ('H','C')
            AND  T1.SLAB_STAT          =      '2'
			AND  T1.CUR_LOAD_LOC       LIKE  'Z%'
			AND (T1.SLAB_LEN           BETWEEN  0  AND  11000)
            AND  T1.SLAB_RT            LIKE   ? || '%' 
            AND  T1.STL_GRD            LIKE   ? || '%' 
            AND  T1.CUR_PROG_CD        IN('RRC','RAB')
			AND  T1.CUR_PROG_CD        LIKE   ? || '%'
         
              
         UNION ALL 

        SELECT '1.2'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

              UNION ALL 

        SELECT '1.8'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '2.5'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'       ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '3.5'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '4.5'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '5.0'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '7.0'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '9.0'     INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '16.0'    INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '1'        ORD_FL
        FROM  DUAL

        UNION ALL

        SELECT '99'      INSTR_COIL_THK ,
               ''         SLAB_CNT750,
               ''         SLAB_CNT800,
               ''         SLAB_CNT850,
               ''         SLAB_CNT900,
               ''         SLAB_CNT950,
               ''         SLAB_CNT1000,
               ''         SLAB_CNT1050,
               ''         SLAB_CNT1100,
               ''         SLAB_CNT1150,
               ''         SLAB_CNT1200,
               ''         SLAB_CNT1250,
               ''         SLAB_CNT1300,
               ''         SLAB_CNT1350,
               ''         SLAB_CNT1400,
               ''         SLAB_CNT1450,
               ''         SLAB_CNT_BIG1450,
               '2'        ORD_FL
        FROM  DUAL
  )          
  GROUP  BY  ROLLUP(ORD_FL,INSTR_COIL_THK) 
   HAVING   ORD_FL ||GROUPING(INSTR_COIL_THK) <> '21'

/*******************************根据重量求各钢卷厚度板坯宽度物料分析现况***********************************/

        ]]>
    </query> 
	<query id="UIF022010.findSlabinfo" desc="求各炉次所接受的中厚板板坯参数" fetchSize="10">
        <![CDATA[
/**************************************UIF022010.findSlabinfo****************************/

SELECT   A.SLAB_NO             -- 板坯号            
        ,A.SLAB_THK            --板坯厚度
        ,A.SLAB_WTH            --板坯宽度
        ,A.SLAB_LEN            --板坯长度
        ,A.SLAB_WGT            --板坯重量   
	    ---------------------------------------------------------------------
        --modify by sjw 090829
        --desc:  根据吴宏部长要求而加 
	    --VERSION:1.12-->1.13		 
        ,E.ORD_WTH             --订单宽度
        ,E.ORD_THK             --订单厚度
        ---------------------------------------------------------------------   
        ,DECODE(A.ORD_FL,'1',C.HOT_THK_AIM,'') HOT_THK_AIM        --热厚度AIM
        ,DECODE(A.ORD_FL,'1',C.HOT_THK_MIN,'') HOT_THK_MIN        --热厚度MIN
        ,DECODE(A.ORD_FL,'1',C.HOT_THK_MAX,'') HOT_THK_MAX        --热厚度MAX
        ,DECODE(A.ORD_FL,'1',C.WTH_AIM,'')     WTH_AIM            --宽度AlM
        ,DECODE(A.ORD_FL,'1',C.WTH_MIN,'')     WTH_MIN            --宽度MIN
        ,DECODE(A.ORD_FL,'1',C.WTH_MAX,'')     WTH_MAX            --宽度MAX  
        ,DECODE(ORD_FL,'2','','1',B.ORD_LEN) MILL_LEN    --轧制长度
        ,DECODE(ORD_FL,'2','','1',B.ORD_WGT) MILL_WGT    --轧制重量
        ,T1.SM_CFNM  CUR_PROG_CD                         -- 当前进程    
		,A.STL_GRD             -- 钢码                    
        ,A.CUR_LOAD_LOC        -- 堆置位置          
        ,T3.SM_CFNM  HCR_CLF   -- 热送代号          
        ,DECODE(ORD_FL,'2','','1',A.ORD_NO)   ORD_NO              -- 合同号            
        ,DECODE(ORD_FL,'2','','1',A.ORD_SEQ)  ORD_SEQ             -- 订单号            
        ,A.SPEC_ABBSYM         -- 标准号            
        ,T4.SM_CFNM  ORD_USEAGE_CD       -- 订单用途代码      
        ,E.DEL_TO_DATE       -- 交货期            
        ,T5.SM_CFNM  SLAB_RT               -- 去向              
        ,NVL(E.EMGMTR_NMG_CLF,'N') EMGMTR_NMG_CLF
FROM        TBG02_SLAB_COMM                                                     A,
            (SELECT SLAB_NO, 
                    COUNT(SLAB_CUT_SEQ) COIL_CUT_CNT, 
                    SUM(ORD_LEN) ORD_LEN, SUM(ORD_WGT) ORD_WGT 
                    FROM TBG02_SLAB_COMM_D GROUP BY SLAB_NO)                     B,
            TBB01_ORD_PROD                                                       C,
        (SELECT           SLAB_NO,
                 CASE     WHEN 0    <= T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 1.2  THEN '0 ~ 1.2'
                          WHEN 1.2  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 1.8  THEN '1.2 ~ 1.8'
                          WHEN 1.8  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 2.5  THEN '1.8 ~ 2.5'
                          WHEN 2.5  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 3.5  THEN '2.5 ~ 3.5'
                          WHEN 3.5  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 4.5  THEN '3.5 ~ 4.5'
                          WHEN 4.5  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 5.0  THEN '4.5 ~ 5.0'
                          WHEN 5.0  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 7.0  THEN '5.0 ~ 7.0'
                          WHEN 7.0  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 9.0  THEN '7.0 ~ 9.0'
                          WHEN 9.0  <  T1.INSTR_COIL_THK  AND T1.INSTR_COIL_THK  <= 16   THEN '9.0 ~ 16.0' 
					      WHEN T1.INSTR_COIL_THK          IS NULL                        THEN '0' END   INSTR_COIL_THK,
                 CASE     WHEN 0    <= T1.SLAB_WTH AND T1.SLAB_WTH <= 750  THEN '≤750'
                          WHEN 750  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 800  THEN '≤800'
                          WHEN 800  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 850  THEN '≤850'
                          WHEN 850  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 900  THEN '≤900'
                          WHEN 900  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 950  THEN '≤950'
                          WHEN 950  <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1000 THEN '≤1000'
                          WHEN 1000 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1050 THEN '≤1050'
                          WHEN 1050 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1100 THEN '≤1100'
                          WHEN 1100 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1150 THEN '≤1150'
                          WHEN 1150 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1200 THEN '≤1200'
                          WHEN 1200 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1250 THEN '≤1250'
                          WHEN 1250 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1300 THEN '≤1300'
                          WHEN 1300 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1350 THEN '≤1350'
                          WHEN 1350 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1400 THEN '≤1400'
                          WHEN 1400 <  T1.SLAB_WTH AND T1.SLAB_WTH <= 1450 THEN '≤1450'
                          WHEN T1.SLAB_WTH > 1450                          THEN '>1450'       END  SLAB_WTH
            FROM  TBG02_SLAB_COMM T1 )                                                D,
            TBE02_ORD_PRC                                                             E
      ,(SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD =  'E01002') T1
      ,(SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD =  'E01012') T3
      ,(SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD =  'A01007') T4
      ,(SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD =  'B01004') T5
     WHERE  A.ORD_NO           = E.ORD_NO(+)
        AND A.ORD_SEQ          = E.ORD_SEQ (+)
        AND A.ORD_NO           = C.ORD_NO(+)
        AND A.ORD_SEQ          = C.ORD_SEQ (+)
        AND A.CUR_PROG_CD      = T1.SM_CD (+)
        AND A.HCR_CLF          = T3.SM_CD (+) 
        AND E.ORD_USEAGE_CD    = T4.SM_CD (+) 
        AND A.SLAB_RT          = T5.SM_CD (+)
        AND A.SLAB_NO          = B.SLAB_NO(+)
        AND A.SLAB_NO          = D.SLAB_NO           
        AND  A.SLAB_RT         IN     ('H','C')
        AND  A.CUR_PROG_CD     IN     ('RRC','RBA','RBB','RAB')
        AND  A.SLAB_STAT       =      '2'
	    AND  A.CUR_LOAD_LOC       LIKE  'Z%'	
		AND (A.SLAB_LEN         BETWEEN  0   AND  11000)
	    AND  A.STL_GRD         LIKE   ? || '%' 
	    AND  A.SLAB_RT         LIKE   ? || '%'
	    AND  D.SLAB_WTH        LIKE   DECODE(?,'合计','',?) || '%' 
	    AND  D.INSTR_COIL_THK  LIKE   DECODE(?,'合计','','小计','','余材','',?) || '%'
	    AND  A.ORD_FL          LIKE   DECODE(?,'余材','2','合计','','1')|| '%'
	    AND  A.CUR_PROG_CD        LIKE   ? || '%' 
	--    AND  A.CUR_PROG_CD     LIKE   DECODE(?,'余材','RRC','合计','','RBA')|| '%'
			
/*******************************UIF022010.findSlabinfo***********************************/
        ]]>
    </query> 
</queryMap>