| 12345678910111213141516171819202122232425262728293031 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="">
-
- <query id="UIB030060.SELECT" desc="" fetchSize="10">
- <![CDATA[
- SELECT
- H02CC.SPEC_STL_GRD --计划钢号
- ,SUM(G02SC.SLAB_WGT) YUANLIAO --原料
- ,SUM(H02CC.ACT_WGT) CHANLIANG --产量
- ,SUM(CASE WHEN H02CC.TOT_DEC_GRD = '1' THEN H02CC.ACT_WGT ELSE 0 END) HGL --合格量
- ,SUM(CASE WHEN H02CC.ORD_FL = '2' THEN H02CC.ACT_WGT ELSE 0 END) FJH --非计划
- ,SUM(CASE WHEN H02RM.MISSNO_CLF = '2' THEN H02CC.ACT_WGT ELSE 0 END) JH --加回
- ,SUM(CASE WHEN H02RM.MISSNO_CLF = '3' THEN H02CC.ACT_WGT ELSE 0 END) ZH --轧回
- ,SUM(CASE WHEN H02CC.TOT_DEC_GRD = '1' THEN H02CC.ACT_WGT ELSE 0 END)/SUM(H02CC.ACT_WGT) HGLV --合格率
- ,SUM(H02CC.ACT_WGT)/SUM(G02SC.SLAB_WGT) CCLV --成材率
- ,SUM((CASE WHEN ( H02CC.EXTSHAPE_DEC_GRD = '3' OR H02CC.EXTSHAPE_DEC_GRD = '4') OR H02CC.SIZE_DEC_RST = '2' THEN 1 ELSE 0 END))/COUNT(*) FJLV-- 非计划率
- ,SUM((CASE WHEN MRT.MISSNO_BAR_THK||MRT.MISSNO_BAR_WTH||MRT.MISSNO_BAR_WGT IS NOT NULL AND MRT.MISSNO_CLF_CD = 'C' THEN H02CC.ACT_WGT ELSE 0 END ) ) ZHONGBAN --中板
- ,SUM(CASE WHEN H02CC.TOT_DEC_GRD IS NULL AND H02CC.MISSNO_CLF_CD IS NULL THEN H02CC.ACT_WGT ELSE 0 END) DAIPAN --待判
- ,SUM(CASE WHEN H02CC.MISSNO_CLF_CD IS NOT NULL THEN H02CC.ACT_WGT ELSE 0 END ) FGL --废钢量
- FROM TBH02_COIL_COMM H02CC ,TBG02_SLAB_COMM G02SC ,TBH02_RHF_MISSNO H02RM ,TBH02_MILL_RESULT MRT
- WHERE H02CC.SLAB_NO = G02SC.SLAB_NO(+)
- AND H02CC.COIL_NO = H02RM.COIL_NO(+)
- AND H02CC.SLAB_NO = H02RM.SLAB_NO(+)
- AND H02CC.COIL_NO = MRT.COIL_NO(+)
- AND H02CC.SPEC_STL_GRD IS NOT NULL
- AND H02CC.MILL_DTIME BETWEEN ? AND ?
- GROUP BY H02CC.SPEC_STL_GRD
- ORDER BY H02CC.SPEC_STL_GRD
- ]]>
- </query>
- </queryMap>
|
