| 1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH020035_01.select" desc=" datagrid1 " fetchSize="10">
- <![CDATA[
- SELECT COIL_NO
- ,SLAB_NO
- ,COIL_THK
- ,COIL_WTH
- ,COIL_LEN
- ,ACT_WGT
- ,ORD_NO
- ,ORD_SEQ
- ,DEVLMT_DTIME
- ,old_sampl_no
- FROM tbh02_coil_comm WHERE coil_no = ?
- ]]>
- </query>
- <query id="UIH020035_02.select" desc=" datagrid2 " fetchSize="10">
- <![CDATA[
- SELECT a.DEVNO
- ,a.CHARING_DTIME
- ,DECODE(a.ROW_NUM,1,'西',2,'东') ROW_NUM
- ,a.CHRGING_BEF_WGT
- ,a.CHRGING_BEF_TEMP
- ,a.CHRGING_WKSHIFT
- ,a.CHRGING_WKGROUP
- ,a.INFUR_HOUR
- ,a.EXTRACT_AVG_TEMP
- ,a.EQ_HT_INFUR_HOUR
- ,a.EQ_HT_TEMP
- ,a.EXTRACT_DTIME
- ,b.CHG_TMP_TGT
- ,b.CHG_TMP_MAX
- ,b.CHG_TMP_MIN
- ,b.CRACK_TGT
- ,b.CRACK_MAX
- ,a.EXTRACT_WKSHIFT
- ,a.EXTRACT_WKGROUP
- FROM TBH02_REHEATFUR a,TBF02_SPEC_MILL b
- WHERE a.coil_no = b.coil_no(+)
- AND a.coil_no = ?
- ]]>
- </query>
- </queryMap>
|
