| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH020031_01.select" desc=" " fetchSize="10">
- <![CDATA[
- select D.ROLL_SLAB_SEQ SEQ,
- b.mill_dtime MILL_DTIME,
- a.COIL_NO,
- a.SLAB_NO,
- d.SPEC_STL_GRD STL_GRD,
- d.ORD_NO ORD_NO,
- d.ORD_SEQ ORD_SEQ,
- (select CUST_NM FROM TBZ00_CUSTOMER WHERE CUST_CD = d.CUST_CD and REC_TP='01') CUST_NM,
- (select CUST_NM ORD_NM FROM TBZ00_CUSTOMER WHERE CUST_CD = d.ORD_CUST_CD and REC_TP='02') ORD_NM,
- b.SPEC_ABBSYM,
- b.PRODNM_CD,
- a.RM_EXT_AVG_THK,
- a.RM_EXT_AVG_WTH,
- a.RM_EXT_AVG_LEN,
- a.R2_EXT_TEMP,
- a.R1_EXT_TEMP,
- a.F1_ENT_TEMP_AVG,
- A.F1_ENT_TEMP_MAX,
- A.F1_ENT_TEMP_MIN,
- A.F1_ENT_TEMP,
- a.FM_EXT_STRIP_TEMP,
- a.FM_EXT_STRIP_TEMP_AVG,
- a.FM_EXT_STRIP_TEMP_MAX,
- a.FM_EXT_STRIP_TEMP_MIN,
- a.FM_EXT_STRIP_WTH,
- a.FM_EXT_STRIP_WTH_AVG,
- a.FM_EXT_STRIP_WTH_MAX,
- a.FM_EXT_STRIP_WTH_MIN,
- a.FM_EXT_STRIP_THK,
- a.FM_EXT_STRIP_THK_AVG,
- a.FM_EXT_STRIP_THK_MAX,
- a.FM_EXT_STRIP_THK_MIN,
- a.DC_TEMP_AVG,
- a.COIL_OUTDIA,
- c.EQ_HT_TEMP,
- c.EQ_HT_INFUR_HOUR,
- c.INFUR_HOUR,
- c.EXTRACT_AVG_TEMP,
- b.old_sampl_no,
- DECODE(b.EXTSHAPE_DEC_GRD,'1','合格','2','订单外合格','3','次品','4','废品','','待判定') EXTSHAPE_DEC_GRD,
- DECODE(b.TOT_DEC_GRD,'1','合格','2','不合格','3','次品','4','废品','','待判定') TOT_DEC_GRD
- from tbh02_mill_result a,tbh02_coil_comm b,TBH02_REHEATFUR c,tbf02_spec_mill d
- where b.coil_no = a.COIL_NO(+)
- AND b.COIL_NO = c.coil_no(+)
- and b.COIL_NO = d.COIL_NO(+)
- and d.ROLL_MANA_NO like :1||'%'
- and NVL(B.MILL_DTIME,'20090515000000') between NVL(:2,'20090515000000') and NVL(:3,'20220515000000')
- AND B.OLD_SAMPL_NO LIKE :4||'%'
- AND ROWNUM < 5001
- order by d.ROLL_SLAB_SEQ
-
- ]]>
- </query>
- </queryMap>
|
