| 12345678910111213141516171819202122 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH090070_01.select" desc=" 中板、废卷入库报表 " fetchSize="10">
- <![CDATA[
- select substr(a.coil_no,1,10) SAMPL_NO,
- b.slab_no,
- b.spec_stl_grd,
- c.missno_bar_thk||'*'||c.missno_bar_wth T_W,
- c.missno_bar_wgt,
- a.yard_clf||a.step_clf||a.storelay||a.store_seq COIL_YARD,
- c.missno_bar_wgt missno_bar_wgt1,
- a.yard_clf||a.step_clf||a.storelay||a.store_seq COIL_YARD1,
- a.reg_dtime,
- a.reg_id
- from tbh05_coil_yard a,tbh02_coil_comm b,tbh02_mill_result c
- where a.coil_no = b.old_sampl_no
- and b.slab_no = c.slab_no
- and a.yard_clf like 'R%'
- and a.reg_dtime like ?||'%'
- ]]>
- </query>
- </queryMap>
|
