XinYu_RZMES/.svn/pristine/54/54149b873722a580d53e2bd127479a19713072fd.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="">
  
     <query id="UIB030040.SELECT" desc="" fetchSize="10">  
        <![CDATA[
      SELECT 
      CDDM.SM_CFNM CD                                                                   --产地                                                                        --产地
      ,(CASE WHEN H02CC.COIL_THK >1 AND H02CC.COIL_THK <= 2 THEN 1
      WHEN H02CC.COIL_THK >2 AND H02CC.COIL_THK <= 3 THEN 2                                                                                                   
      WHEN H02CC.COIL_THK >3 AND H02CC.COIL_THK <= 4 THEN 3                                             
      WHEN H02CC.COIL_THK >4 AND H02CC.COIL_THK <= 5 THEN 4                                             
      WHEN H02CC.COIL_THK >5 AND H02CC.COIL_THK <= 6 THEN 5
      WHEN H02CC.COIL_THK >6 AND H02CC.COIL_THK <= 7 THEN 6
      WHEN H02CC.COIL_THK >7 AND H02CC.COIL_THK <= 8 THEN 7
      WHEN H02CC.COIL_THK >8 AND H02CC.COIL_THK <= 9 THEN 8
      WHEN H02CC.COIL_THK >9 AND H02CC.COIL_THK <= 10 THEN 9
      WHEN H02CC.COIL_THK >10 AND H02CC.COIL_THK <= 11 THEN 10
      WHEN H02CC.COIL_THK >11 AND H02CC.COIL_THK <= 12 THEN 11
      WHEN H02CC.COIL_THK >12 AND H02CC.COIL_THK <= 13 THEN 12
      WHEN H02CC.COIL_THK >13 AND H02CC.COIL_THK <= 14 THEN 13
      WHEN H02CC.COIL_THK >14 AND H02CC.COIL_THK <= 15 THEN 14
      WHEN H02CC.COIL_THK >15 AND H02CC.COIL_THK <= 16 THEN 15
      ELSE H02CC.COIL_THK
      END) COIL_THK
      ,F02SM.SPEC_STL_GRD 
      ,H02CC.SPEC_STL_GRD SPEC_STL_GRD1                                                                                           --计划钢号
      ,to_char(SUM(G02SC.SLAB_WGT)/1000,'FM999990.000') SLAB_WGT                                                                          --原料
      ,to_char(SUM((CASE WHEN H02CC.TOT_DEC_GRD = '1' THEN H02CC.ACT_WGT/1000 END)),'FM999990.000') JYL    --检验量
      --,TO_CHAR(SUM((CASE WHEN SUBSTR(H02CC.SAMPL_NO,14) <> 'XX' AND H02CC.MATLQLTY_DEC_GRD = '1' THEN H02CC.ACT_WGT END))/1000,'FM999990.000') FYL                                         --复样量
      ,TO_CHAR(SUM((CASE WHEN CHECK_RESMP(H02CC.SAMPL_NO)>0 AND H02CC.MATLQLTY_DEC_GRD = '1' THEN H02CC.ACT_WGT END))/1000,'FM999990.000') FYL                                         --复样量
      ,(CASE WHEN SUM(G02SC.SLAB_WGT) != 0 AND to_char(SUM((CASE WHEN H02CC.TOT_DEC_GRD = '1' OR H02CC.TOT_DEC_GRD IS NULL THEN H02CC.ACT_WGT/1000 END)),'FM999990.000') != 0
      THEN TO_CHAR((SUM(H02CC.ACT_WGT)/SUM(G02SC.SLAB_WGT))*100,'FM990.00') 
      ELSE ' ' END)CCL                                                            --成材率
      ,TO_CHAR(SUM((CASE WHEN H02CC.TOT_DEC_GRD = '1' OR H02CC.TOT_DEC_GRD IS NULL THEN H02CC.ACT_WGT END))/1000,'FM999990.000') HGL                                                  --合格量
      ,TO_CHAR(SUM((CASE WHEN H02CC.TOT_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD = H02CC.SPEC_STL_GRD THEN H02CC.ACT_WGT END))/1000,'FM999990.000') PZL 
      ,TO_CHAR(SUM((CASE WHEN H02CC.ORD_FL      = '2' THEN H02CC.ACT_WGT END))/1000,'FM999990.000') FJH
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '10' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_TUDU                                                --工艺次,凸度 
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '09' THEN
      H02CC.ACT_WGT END ))/1000,'FM999990.000') GYC_LANGXING       --工艺次,浪形 
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '08' THEN
      H02CC.ACT_WGT END ))/1000,'FM999990.000') GYC_GUNYIN         --工艺次,辊印
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '24' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_YAHENG         --工艺次,压痕
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '03' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_HUASHANG       --工艺次,划伤
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '01' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_TUKUAI         --工艺次,凸块
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '02' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_YIWU           --工艺次,异物压入
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '56' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_QITA           --工艺次,其他
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '53' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_GUANGLIANG     --工艺次,光亮带
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '55' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_ZHONGLIANG     --工艺次,重量不良
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '52' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_BIANSUN        --工艺次,边损
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '54' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_HOUDU          --工艺次,厚度不良 
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '43' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_XIEXING        --工艺次,楔形
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '39' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_MADIAN         --工艺次,麻点
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '29' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_KUANDU         --工艺次,宽度不良
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '26' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_JUANXING       --工艺次,卷形不良
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '24' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_ZHEDIE         --工艺次,折叠
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '22' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_TAXING         --工艺次,塔形
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '20' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYC_BUPING         --工艺次,不平度
      ,TO_CHAR(SUM(CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 IS NULL AND H02CC.MATLQLTY_DEC_GRD != '1' 
      THEN H02CC.ACT_WGT END)/1000,'FM999990.000')                               GYC_XINGNENG      --工艺次,性能次   
      ,TO_CHAR(SUM(CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '4' THEN
      H02CC.ACT_WGT END)/1000,'FM999990.000')                                    GYC_FEIPIN        --工艺次，废品
      --,TO_CHAR(SUM(SQ_QD_COMMON.FIND_COIL_GYC(H02CC.COIL_NO))/1000,'FM999990.000')           GYC_LEIJI 
      ,TO_CHAR(SUM(CASE WHEN (H02CC.EXTSHAPE_DEC_GRD = '3' AND Z00C.CD_SEQ = '2') 
      OR (H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 IS NULL AND H02CC.MATLQLTY_DEC_GRD != '1' )
      OR H02CC.EXTSHAPE_DEC_GRD = '4' THEN H02CC.ACT_WGT END)/1000,'FM999990.000') GYC_LEIJI        --工艺次，累计
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '37' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZC_QIPAO         --钢质次,气泡
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '38' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZC_FENCENG       --钢质次,分层
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '42' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZC_JIAZA         --钢质次,夹杂
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '11' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZC_BIANLIE       --钢质次,边裂
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '06' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZC_AOKENG        --钢质次,凹坑
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '57' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZC_HENGLIE       --钢质次,横裂
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '59' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZC_QITA          --钢质次,其它(钢质)
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '3' AND H02CC.CRK_CD1 = '58' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZC_ZONGLIE       --钢质次,纵裂
      --,TO_CHAR(SUM(SQ_QD_COMMON.FIND_COIL_GZC(H02CC.COIL_NO))/1000,'FM999990.000')           GZC_LEIJI
               --钢质次，累计 
      ,TO_CHAR(SUM(CASE WHEN  H02CC.EXTSHAPE_DEC_GRD = '3' AND Z00C.CD_SEQ = '1'
      THEN H02CC.ACT_WGT END)/1000,'FM999990.000') GZC_LEIJI          
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '10' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_TUDU           --工艺改判,凸度 
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '09' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_LANGXING       --工艺改判,浪形 
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '08' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_GUNYIN         --工艺改判,辊印
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '24' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_YAHENG         --工艺改判,压痕
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '03' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_HUASHANG       --工艺改判,划伤
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '01' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_TUKUAI         --工艺改判,凸块
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '02' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_YIWU           --工艺改判,异物压入
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '56' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_QITA           --工艺改判,其他
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '53' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_GUANGLIANG     --工艺改判,光亮带
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '55' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_ZHONGLIANG     --工艺改判,重量不良
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '52' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_BIANSUN        --工艺改判,边损
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '54' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_HOUDU          --工艺改判,厚度不良 
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '43' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_XIEXING        --工艺改判,楔形
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '39' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_MADIAN         --工艺改判,麻点
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '29' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_KUANDU         --工艺改判,宽度不良
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '26' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_JUANXING       --工艺改判,卷形不良
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '24' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_ZHEDIE         --工艺改判,折叠
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '22' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_TAXING         --工艺改判,塔形
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '20' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000') GYGP_BUPING         --工艺改判,不平度
      ,TO_CHAR(SUM(CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND H02CC.CRK_CD1 IS NULL 
      AND H02CC.TOT_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      THEN H02CC.ACT_WGT END)/1000,'FM999990.000')                               GYGP_XINGNENG      --工艺改判,性能次
      --,TO_CHAR(SUM(SQ_QD_COMMON.FIND_COIL_GYGP(H02CC.COIL_NO))/1000,'FM999990.000')           GYGP_LEIJI        --工艺改判，累计
      ,to_char(SUM(CASE WHEN (H02CC.CRK_CD1 IS NULL OR Z00C.CD_SEQ = '2') 
      AND H02CC.EXTSHAPE_DEC_GRD = '1'
      AND H02CC.TOT_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD
      THEN H02CC.ACT_WGT END)/1000,'FM999990.000') GYGP_LEIJI
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '37' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZGP_QIPAO         --钢质改判,气泡
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '38' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZGP_FENCENG       --钢质改判,分层
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '42' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZGP_JIAZA         --钢质改判,夹杂
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '11' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZGP_BIANLIE       --钢质改判,边裂
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '06' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZGP_AOKENG        --钢质改判,凹坑
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '57' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZGP_HENGLIE       --钢质改判,横裂
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '59' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZGP_QITA          --钢质改判,其它(钢质)
      ,TO_CHAR(SUM((CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND H02CC.CRK_CD1 = '58' THEN
      H02CC.ACT_WGT END))/1000,'FM999990.000')  GZGP_ZONGLIE       --钢质改判,纵裂
      --,TO_CHAR(SUM(SQ_QD_COMMON.FIND_COIL_GZGP(H02CC.COIL_NO))/1000,'FM999990.000')           GZGP_LEIJI         --钢质改判，累计                       
      ,to_char(SUM(CASE WHEN H02CC.EXTSHAPE_DEC_GRD = '1' AND F02SM.SPEC_STL_GRD != H02CC.SPEC_STL_GRD 
      AND Z00C.CD_SEQ = '1' THEN
      H02CC.ACT_WGT END)/1000,'FM999990.000')  GZGP_LEIJI   
      FROM TBH02_COIL_COMM H02CC
      ,TBG02_SLAB_COMM G02SC
      ,TBF02_SPEC_MILL F02SM
      ,(SELECT T.SM_CD,T.SM_CFNM,T.CD_SEQ 
      FROM TBZ00_COMMCD T WHERE T.LG_CD = 'H02001' AND T.CD_SEQ IS NOT NULL) Z00C
    ,(SELECT T.SM_CD,T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'B01132') CDDM    
      WHERE H02CC.SLAB_NO = G02SC.SLAB_NO(+)
      AND   H02CC.COIL_NO = F02SM.COIL_NO(+)
      AND   H02CC.CRK_CD1 = Z00C.SM_CD(+)
    AND   SUBSTR(G02SC.SLAB_NO,3,1) = CDDM.SM_CD      
    AND  H02CC.MISSNO_CLF_CD IS NULL  
      AND   H02CC.MILL_DTIME >= :1||'000000'
      AND   H02CC.MILL_DTIME <= :2||'235959'
      GROUP BY 
      CDDM.SM_CFNM                                                                    --产地                                                                        --产地
      ,(CASE WHEN H02CC.COIL_THK >1 AND H02CC.COIL_THK <= 2 THEN 1
      WHEN H02CC.COIL_THK >2 AND H02CC.COIL_THK <= 3 THEN 2                                                                                                   
      WHEN H02CC.COIL_THK >3 AND H02CC.COIL_THK <= 4 THEN 3                                             
      WHEN H02CC.COIL_THK >4 AND H02CC.COIL_THK <= 5 THEN 4                                             
      WHEN H02CC.COIL_THK >5 AND H02CC.COIL_THK <= 6 THEN 5
      WHEN H02CC.COIL_THK >6 AND H02CC.COIL_THK <= 7 THEN 6
      WHEN H02CC.COIL_THK >7 AND H02CC.COIL_THK <= 8 THEN 7
      WHEN H02CC.COIL_THK >8 AND H02CC.COIL_THK <= 9 THEN 8
      WHEN H02CC.COIL_THK >9 AND H02CC.COIL_THK <= 10 THEN 9
      WHEN H02CC.COIL_THK >10 AND H02CC.COIL_THK <= 11 THEN 10
      WHEN H02CC.COIL_THK >11 AND H02CC.COIL_THK <= 12 THEN 11
      WHEN H02CC.COIL_THK >12 AND H02CC.COIL_THK <= 13 THEN 12
      WHEN H02CC.COIL_THK >13 AND H02CC.COIL_THK <= 14 THEN 13
      WHEN H02CC.COIL_THK >14 AND H02CC.COIL_THK <= 15 THEN 14
      WHEN H02CC.COIL_THK >15 AND H02CC.COIL_THK <= 16 THEN 15
      ELSE H02CC.COIL_THK
      END)                                                                                                          
      ,F02SM.SPEC_STL_GRD 
      ,H02CC.SPEC_STL_GRD
      ORDER BY F02SM.SPEC_STL_GRD
        ]]>   
    </query> 
</queryMap>