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 --复样量 ,(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 ]]>