| 12345678910111213141516171819202122232425 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="板坯详细查询">
-
- <query id="UIB030201.SELECT" desc="" fetchSize="10">
- <![CDATA[
- SELECT
- CCM.SLAB_NO
- ,CCM.ORD_NO
- ,CCM.ORD_SEQ
- ,CCM.STL_GRD
- ,CCM.SLAB_WGT
- ,CCM.BEF_STL_GRD
- ,CCM.EXTSHAPE_GRD
- ,CCM.SF_METHOD
- ,CCM.ORD_FL
- ,DECODE(CCM.INSTR_SLAB_THK||'*'||CCM.INSTR_SLAB_WTH||'*'||CCM.INSTR_SLAB_LEN ,'**'
- , NULL , CCM.INSTR_SLAB_THK||'*'||CCM.INSTR_SLAB_WTH||'*'||CCM.INSTR_SLAB_LEN ) INSTR_TWL
- , DECODE(CCM.SLAB_THK||'*'||CCM.SLAB_WTH||'*'||CCM.SLAB_LEN , '**'
- , NULL , CCM.SLAB_THK||'*'||CCM.SLAB_WTH||'*'||CCM.SLAB_LEN
- ) TWL
- FROM TBG02_SLAB_COMM CCM
- WHERE CCM.SLAB_STAT != '1'
- ]]>
- </query>
- </queryMap>
|
