| 1234567891011121314151617181920212223242526272829303132 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIG040030_01.select" desc="板坯库详细信息查询 数据来源:TBG04_SLAB_YARD tbg02_slab_comm">
- <![CDATA[
- select a.storelay
- ,a.slab_no
- ,b.slab_thk
- ,b.slab_len
- ,b.slab_wth
- ,b.slab_wgt
- ,b.stl_grd
- ,b.ord_no
- ,b.ord_seq
- ,b.PRODNM_CD
- ,b.ord_fl
- ,b.CORRECT_YN
- ,c.L2_SEND RHF_SCH_YN
- from tbg04_slab_yard a
- ,tbg02_slab_comm b
- ,(SELECT SLAB_NO,L2_SEND FROM TBF02_MILL_IDX WHERE STATUS_CD = 'A') c
- where a.slab_no = b.slab_no
- and a.slab_no = c.slab_no(+)
- and a.YARD_ADDR = ?
- ORDER BY a.storelay desc
- ]]>
- </query>
- <query id="UIG040030_01.CALL_SLAB_MOVE" desc=" UIG040030 INTI_PARAM ">
- <![CDATA[
- {call PKG_UIG.PROD_YARD_SLAB_MOVE(?,?,?,?)}
- ]]>
- </query>
- </queryMap>
|
