XinYu_RZMES/.svn/pristine/42/4287e5a268b8ed6bbb2eefc7cebbe6004cae2094.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="出钢参数接收现况分析(中厚板)">
	<query id="UIF012020.findByK" desc="求各炉次所接受的热轧板坯参数" fetchSize="10">
        <![CDATA[
			
/*******************************求各炉次所接受的热轧板坯参数***********************************/


SELECT  CASE WHEN ORD_THK IS NULL AND GROUPING (ORD_FL) = '1' AND GROUPING (ORD_THK) = '1'  THEN '合计' 
             WHEN ORD_THK IS NULL AND GROUPING (ORD_FL) = '0' AND GROUPING (ORD_THK) = '1'  THEN '小计'
             WHEN ORD_THK IS NOT NULL THEN decode(ORD_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   ORD_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.ORD_THK  AND T1.ORD_THK  <= 1.2  THEN '1.2'
                      WHEN 1.2  <  T1.ORD_THK  AND T1.ORD_THK  <= 1.8  THEN '1.8'
                      WHEN 1.8  <  T1.ORD_THK  AND T1.ORD_THK  <= 2.5  THEN '2.5'
                      WHEN 2.5  <  T1.ORD_THK  AND T1.ORD_THK  <= 3.5  THEN '3.5'
                      WHEN 3.5  <  T1.ORD_THK  AND T1.ORD_THK  <= 4.5  THEN '4.5'
                      WHEN 4.5  <  T1.ORD_THK  AND T1.ORD_THK  <= 5.0  THEN '5.0'
                      WHEN 5.0  <  T1.ORD_THK  AND T1.ORD_THK  <= 7.0  THEN '7.0'
                      WHEN 7.0  <  T1.ORD_THK  AND T1.ORD_THK  <= 9.0  THEN '9.0'
                      WHEN 9.0  <  T1.ORD_THK  AND T1.ORD_THK  <= 16   THEN '16.0'       END   ORD_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
                ,ORD_FL
                 
           FROM  TBF01_SPEC_SLAB T1, TBF01_SPEC_CHARGE T2 
          WHERE  T1.CHARGE_EDT_SEQ   =      T2.CHARGE_EDT_SEQ    
            AND  T1.ORD_FL           =      '1'
            AND  T2.STATUS_CD        =      'A' 
            AND  T2.CHARGE_RT        IN     ('H','C')
            AND  T2.PROG_CD          IN     ('JBA','JBB')
            AND  T2.CHARGE_RT        LIKE   ? || '%'
            AND  T2.STL_GRD          LIKE   ? || '%' 
            AND  T2.PROG_CD          LIKE   ? || '%'
  
          UNION ALL
          
         SELECT  '99'                                                                            ORD_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  TBF01_SPEC_SLAB T1, TBF01_SPEC_CHARGE T2 
          WHERE  T1.CHARGE_EDT_SEQ   =      T2.CHARGE_EDT_SEQ    
            AND  T1.ORD_FL           =      '2'
            AND  T2.STATUS_CD        =      'A' 
            AND  T2.CHARGE_RT        IN     ('H','C')
            AND  T2.PROG_CD          IN     ('JBA','JBB')
            AND  T2.CHARGE_RT        LIKE   ? || '%'
            AND  T2.STL_GRD          LIKE   ? || '%' 
            AND  T2.PROG_CD          LIKE   ? || '%' 
         UNION ALL 

        SELECT '1.2'       ORD_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'       ORD_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'       ORD_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'       ORD_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'     ORD_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'     ORD_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'     ORD_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'     ORD_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'    ORD_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'      ORD_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,ORD_THK) 
   HAVING   ORD_FL ||GROUPING(ORD_THK) <> '21'

/*******************************求各炉次所接受的热轧板坯参数***********************************/

        ]]>
    </query>  
	
<query id="UIF012020.findByW" desc="求各炉次所接受的热轧板坯参数" fetchSize="10">
        <![CDATA[
			
/*******************************求各炉次所接受的热轧板坯参数***********************************/


SELECT  CASE WHEN ORD_THK IS NULL AND GROUPING (ORD_FL) = '1' AND GROUPING (ORD_THK) = '1'  THEN '合计' 
             WHEN ORD_THK IS NULL AND GROUPING (ORD_FL) = '0' AND GROUPING (ORD_THK) = '1'  THEN '小计'
             WHEN ORD_THK IS NOT NULL THEN decode(ORD_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   ORD_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.ORD_THK  AND T1.ORD_THK  <= 1.2  THEN '1.2'
                      WHEN 1.2  <  T1.ORD_THK  AND T1.ORD_THK  <= 1.8  THEN '1.8'
                      WHEN 1.8  <  T1.ORD_THK  AND T1.ORD_THK  <= 2.5  THEN '2.5'
                      WHEN 2.5  <  T1.ORD_THK  AND T1.ORD_THK  <= 3.5  THEN '3.5'
                      WHEN 3.5  <  T1.ORD_THK  AND T1.ORD_THK  <= 4.5  THEN '4.5'
                      WHEN 4.5  <  T1.ORD_THK  AND T1.ORD_THK  <= 5.0  THEN '5.0'
                      WHEN 5.0  <  T1.ORD_THK  AND T1.ORD_THK  <= 7.0  THEN '7.0'
                      WHEN 7.0  <  T1.ORD_THK  AND T1.ORD_THK  <= 9.0  THEN '9.0'
                      WHEN 9.0  <  T1.ORD_THK  AND T1.ORD_THK  <= 16   THEN '16.0'                          END   ORD_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
                ,ORD_FL
                 
           FROM  TBF01_SPEC_SLAB T1, TBF01_SPEC_CHARGE T2 
          WHERE  T1.CHARGE_EDT_SEQ   =      T2.CHARGE_EDT_SEQ    
            AND  T1.ORD_FL           =      '1'
            AND  T2.STATUS_CD        =      'A' 
            AND  T2.CHARGE_RT        IN     ('H','C')
            AND  T2.PROG_CD          IN     ('JBA','JBB')
            AND  T2.CHARGE_RT        LIKE   ? || '%'
            AND  T2.STL_GRD          LIKE   ? || '%' 
            AND  T2.PROG_CD          LIKE   ? || '%'

  
          UNION ALL
          
         SELECT  '99'                                                                            ORD_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  TBF01_SPEC_SLAB T1, TBF01_SPEC_CHARGE T2 
          WHERE  T1.CHARGE_EDT_SEQ   =      T2.CHARGE_EDT_SEQ    
            AND  T1.ORD_FL           =      '2'
            AND  T2.STATUS_CD        =      'A' 
            AND  T2.CHARGE_RT        IN     ('H','C')
            AND  T2.PROG_CD          IN     ('JBA','JBB')
            AND  T2.CHARGE_RT        LIKE   ? || '%'
            AND  T2.STL_GRD          LIKE   ? || '%' 
            AND  T2.PROG_CD          LIKE   ? || '%'
         UNION ALL 
     
        SELECT '1.2'       ORD_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'       ORD_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'       ORD_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'       ORD_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'     ORD_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'     ORD_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'     ORD_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'     ORD_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'    ORD_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'      ORD_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,ORD_THK) 
   HAVING   ORD_FL ||GROUPING(ORD_THK) <> '21'
      
/*******************************求各炉次所接受的热轧板坯参数***********************************/

        ]]>
    </query>  
		
	<query id="UIF012020.findSlabinfo" desc="求各炉次所接受的中厚板板坯参数" fetchSize="10">
        <![CDATA[
/*******************************根据块数求各炉次所接受的热轧板坯参数***********************************/
SELECT  C.SLAB_MANA_NO,
        C.STL_GRD,
        C.SLAB_THK,
        C.SLAB_WTH,
        C.SLAB_LEN,
        C.SLAB_WGT,
        T1.SM_CFNM HCR_CLF,
        T2.SM_CFNM ORD_FL,
        T3.SM_CFNM ORD_USEAGE_CD,
        C.ORD_THK,
        C.ORD_WTH,
        C.DELV_REQ_DATE,
        T4.SM_CFNM PROG_CD,
        T5.SM_CFNM SLAB_RT,
        C.DSN_SLAB_NO,
        B.L2_SEND
  FROM  TBF01_SPEC_CHARGE A,
        TBF01_CHARGE_IDX  B,
        TBF01_SPEC_SLAB   C,
        (SELECT  SLAB_EDT_SEQ,
                 CASE     WHEN 0    <= T1.ORD_THK  AND T1.ORD_THK  <= 1.2  THEN '0 ~ 1.2'
                          WHEN 1.2  <  T1.ORD_THK  AND T1.ORD_THK  <= 1.8  THEN '1.2 ~ 1.8'
                          WHEN 1.8  <  T1.ORD_THK  AND T1.ORD_THK  <= 2.5  THEN '1.8 ~ 2.5'
                          WHEN 2.5  <  T1.ORD_THK  AND T1.ORD_THK  <= 3.5  THEN '2.5 ~ 3.5'
                          WHEN 3.5  <  T1.ORD_THK  AND T1.ORD_THK  <= 4.5  THEN '3.5 ~ 4.5'
                          WHEN 4.5  <  T1.ORD_THK  AND T1.ORD_THK  <= 5.0  THEN '4.5 ~ 5.0'
                          WHEN 5.0  <  T1.ORD_THK  AND T1.ORD_THK  <= 7.0  THEN '5.0 ~ 7.0'
                          WHEN 7.0  <  T1.ORD_THK  AND T1.ORD_THK  <= 9.0  THEN '7.0 ~ 9.0'
                          WHEN 9.0  <  T1.ORD_THK  AND T1.ORD_THK  <= 16   THEN '9.0 ~ 16.0'       END   ORD_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  TBF01_SPEC_SLAB T1 ) D,
				(SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD =  'E01012') T1,
			    (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD =  'E01007') T2,
			    (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD =  'A01007') T3,
				(SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD =  'E01002') T4,
		        (SELECT T.SM_CD, T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD =  'B01004') T5
 WHERE  A.CHARGE_EDT_SEQ  =     B.CHARGE_EDT_SEQ
   AND  A.CHARGE_EDT_SEQ  =     C.CHARGE_EDT_SEQ
   AND  C.SLAB_EDT_SEQ    =     D.SLAB_EDT_SEQ
   AND  T1.SM_CD          =     C.HCR_CLF
   AND  T2.SM_CD          =     C.ORD_FL
   AND  T3.SM_CD(+)       =     C.ORD_USEAGE_CD
   AND  T4.SM_CD          =     A.PROG_CD
   AND  T5.SM_CD          =     C.SLAB_RT
   AND  C.SLAB_RT      IN    ('H','C')
   AND  A.STATUS_CD       =     'A'
   AND  A.PROG_CD          IN     ('JBA','JBB')
   AND  A.STL_GRD          LIKE   ? || '%' 
   AND  A.PROG_CD          LIKE   ? || '%'
   AND  C.SLAB_RT          LIKE   ? || '%'
   AND  D.SLAB_WTH       LIKE     DECODE(?,'合计','',?) || '%' 
   AND  D.ORD_THK        LIKE     DECODE(?,'合计','','小计','','余材','',?) || '%'
   AND  ORD_FL           LIKE     DECODE(?,'余材','2','合计','','1')|| '%'
ORDER BY C.SLAB_MANA_NO
			
/*******************************根据块数求各炉次所接受的热轧板坯参数***********************************/
        ]]>
    </query>
</queryMap>