| 1234567891011121314151617181920212223242526272829303132333435363738 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="">
-
- <query id="UIB030070.SELECT" desc="" fetchSize="10">
- <![CDATA[
- SELECT SC.STL_GRD ,
- SUM(SC.SLAB_WGT) JYL
- ,SUM(SC.SLAB_WGT) - NVL(SUM(SC.SCRAP_WGT) , 0) HGL
- ,ROUND(SUM(DECODE(CM.INGR_FAC_DEC_GRD , '2' , 0 , 1))/COUNT(*)*100 , 2 ) HGL_NK --内控合格
- ,ROUND(( 1- (SUM(DECODE(SC.SCRAP_WGT , NULL , 0 , SC.SCRAP_WGT))+SUM(DECODE(CC.MISSNO_CLF_CD , NULL , 0 , CC.ACT_WGT)) )/SUM(SC.SLAB_WGT)) *100 ,2) HGL_ZH --综合合格
- ,SUM(DECODE(SC.SCRAP_WGT , NULL , 0 , SC.SCRAP_WGT))+SUM(DECODE(CC.MISSNO_CLF_CD , NULL , 0 , CC.ACT_WGT)) FP
- ,SUM(DECODE(CC.MISSNO_CLF_CD , NULL , 0 , CC.ACT_WGT)) ZHFP
- ,SUM(DECODE(SC.SLAB_INGR_DEC_GRD , '2' , SC.SLAB_WGT , 0)) HXCF
- ,SUM(DECODE(SC.CRK_CD1 , '07' , SC.SLAB_WGT , 0)) LIEWEN --裂纹
- ,SUM(DECODE(SC.CRK_CD1 , '14' , SC.SLAB_WGT , 0)) QIKONG --气孔
- ,SUM(DECODE(SC.CRK_CD1 , '?' , SC.SLAB_WGT , 0)) SUOKONG --缩孔
- ,SUM(DECODE(SC.CRK_CD1 , '?' , SC.SLAB_WGT , 0)) DUANCHI --短尺
- ,SUM(DECODE(SC.CRK_CD1 , '18' , SC.SLAB_WGT , 0)) AOKENG --凹坑
- ,SUM(DECODE(SC.CRK_CD1 , '30' , SC.SLAB_WGT , 0)) SHUANGJIAO --双浇
- ,SUM(DECODE(SC.CRK_CD1 , '31' , SC.SLAB_WGT , 0)) FENCENG --分层
- ,SUM(DECODE(SC.CRK_CD1 , '04' , SC.SLAB_WGT , 0)) GUDU --鼓肚
- ,SUM(DECODE(SC.CRK_CD1 , '?' , SC.SLAB_WGT , 0)) WANQI --弯曲
- ,SUM(DECODE(SC.CRK_CD1 , '?' , SC.SLAB_WGT , 0)) QIPAO --气泡
- ,SUM(DECODE(SC.CRK_CD1 , '?' , SC.SLAB_WGT , 0)) CHONGJIE --重接
- ,SUM(DECODE(SC.CRK_CD1 , '?' , SC.SLAB_WGT , 0)) CHAOCHANG --超长
- ,SUM(DECODE(SC.CRK_CD1 , '?' , SC.SLAB_WGT , 0)) GESHANG --割伤
-
- FROM TBG02_SLAB_COMM SC , TBH02_COIL_COMM CC , TBG02_CHARGE_COMM CM
- WHERE SUBSTR(SC.CUR_LOAD_LOC ,0 ,1 ) != 'L'
- AND SC.SLAB_STAT != '1'
- AND SC.SLAB_NO = CC.SLAB_NO(+)
- AND SUBSTR(SC.SLAB_NO ,1,10 ) = CM.CHARGE_NO
- AND SUBSTR(SC.SLAB_CUT_DTIME ,1,8 ) BETWEEN ? AND ?
- GROUP BY SC.STL_GRD
- ORDER BY SC.STL_GRD
- ]]>
- </query>
- </queryMap>
|
