| 12345678910111213141516171819 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="TRANSFER RECORDS QUERY ">
- <query id="UIH052500_01.select" desc="移送记录查询">
- <![CDATA[
- select t.coil_no,h.spec_stl_grd,h.ord_no,h.ord_seq,h.coil_thk
- ,h.coil_wth,h.coil_len,h.act_wgt,t.cr_plant_trs_clf,t.cr_plant_trs_no
- ,t.cr_plant_trs_seq
- ,decode(t.reg_order,'1','早班','2','中班','3','晚班') reg_order
- ,decode(t.reg_group,'A','甲班','B','乙班','C','丙班','D','丁班') reg_group
- ,t.reg_id,t.reg_dtime,t.yard_addr
- from tbh02_coil_trans t,tbh02_coil_comm h where t.coil_no = h.old_sampl_no
- and t.REG_DTIME >= :1 and t.REG_DTIME <= :2 and t.TRANS_FLAG = :3
- and h.ORD_NO like :4||'%' and h.ORD_SEQ||'&' like :5||'%' and t.COIL_NO||'&' like :6||'%'
- and t.REG_ORDER||'&' like :7||'%' and t.REG_GROUP||'&' like :8||'%' and t.REG_ID||'&' like :9||'%'
- and t.CR_PLANT_TRS_CLF||'&' like :10||'%' and t.CR_PLANT_TRS_NO||'&' like :11||'%'
- order by t.reg_dtime,t.cr_plant_trs_seq
- ]]>
- </query>
- </queryMap>
|
