| 1234567891011 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH090080_01.select" desc=" 成品库入库明细查询 " fetchSize="10">
- <![CDATA[
- select c.YARD_CLF||c.STEP_CLF||c.STORELAY||c.STORE_SEQ COIL_YARD,c.COIL_NO,c.REG_ID,c.REG_DTIME,a.ROLL_MANA_NO,a.ROLL_SLAB_SEQ,
- b.ACT_WGT,B.INSTR_COIL_THK||'*'||B.INSTR_COIL_WTH T_W,decode(B.TOT_DEC_GRD,'1','合格','2','次品','3','余材','4','废品','待判定') TOT_DEC_GRD
- from tbf02_spec_mill a,tbh02_coil_comm b ,tbh05_coil_yard c
- where a.SLAB_NO = b.SLAB_NO and b.OLD_SAMPL_NO = c.COIL_NO and a.ROLL_MANA_NO = ? order by a.ROLL_SLAB_SEQ
- ]]>
- </query>
- </queryMap>
|
