| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="待判定板坯信息">
-
- <query id="UIB030205_01.INITSELECT" desc="物料进程">
- SELECT T.SM_CD VALUE , T.SM_CFNM LABEL FROM TBZ00_COMMCD T WHERE T.LG_CD = 'E01002'
- </query>
-
- <query id="UIB030205_01.SELECT" desc="未判定板坯" fetchSize="10">
- <![CDATA[
- SELECT SCM.SLAB_NO
- ,SCM.STL_GRD
- ,DECODE(SCM.BEF_STL_GRD , NULL , SCM.STL_GRD , SCM.BEF_STL_GRD) BEF_STL_GRD
- ,SCM.ORD_FL
- ,SCM.SLAB_INGR_DEC_KIND
- ,SCM.SLAB_INGR_DEC_EMP_ID
- ,SCM.SLAB_INGR_DEC_DTIME
- ,SCM.CUR_PROG_CD
- ,SCM.CUR_PROG_CD_PGM
- ,SCM.SLAB_INGR_DEC_GRD
- ,SCM.EXTSHAPE_GRD
- ,DECODE(SUBSTR(SCM.CUR_LOAD_LOC , 0 , 1) , 'L' , 'Y' , 'N') SLAB_YN --是否在炼钢板坯库
- FROM TBG02_SLAB_COMM SCM
- WHERE SCM.SLAB_STAT = '2'
- AND SCM.SLAB_INGR_DEC_GRD IS NULL
- ORDER BY SCM.SLAB_NO
- ]]>
- </query>
- <query id="UIB030205_02.SELECT" desc="不合格板坯">
- SELECT SCM.SLAB_NO
- ,SCM.STL_GRD
- ,DECODE(SCM.BEF_STL_GRD , NULL , SCM.STL_GRD , SCM.BEF_STL_GRD) BEF_STL_GRD
- ,SCM.ORD_FL
- ,SCM.SLAB_INGR_DEC_KIND
- ,SCM.SLAB_INGR_DEC_EMP_ID
- ,SCM.SLAB_INGR_DEC_DTIME
- ,SCM.CUR_PROG_CD
- ,SCM.CUR_PROG_CD_PGM
- ,SCM.SLAB_INGR_DEC_GRD
- ,SCM.EXTSHAPE_GRD
- ,DECODE(SUBSTR(SCM.CUR_LOAD_LOC , 0 , 1) , 'L' , 'Y' , 'N') SLAB_YN --是否在炼钢板坯库
- FROM TBG02_SLAB_COMM SCM
- WHERE SCM.SLAB_STAT = '2'
- AND SCM.SLAB_INGR_DEC_GRD = '2'
- ORDER BY SCM.SLAB_NO
- </query>
- </queryMap>
|
