| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH020032_01.select" desc=" datagrid1 " fetchSize="10">
- <![CDATA[
- select
- a.COIL_NO
- ,a.SLAB_NO
- ,a.STL_GRD
- ,a.ORD_NO
- ,a.PRODNM_CD
- ,a.ORD_USE_CD
- ,a.SPEC_ABBSYM
- ,a.DEVLMT_DTIME
- ,a.INSTR_ROUTE
- ,a.ROUTE
- ,a.SAMPL_PICK_YN
- ,a.EXTSHAPE_INSPECT_YN
- ,a.old_sampl_no
- FROM tbh02_coil_comm a WHERE coil_no = ?
- ]]>
- </query>
- <query id="UIH020032_02.select" desc=" datagrid2 " fetchSize="10">
- <![CDATA[
- SELECT a.INSTR_COIL_THK
- ,a.INSTR_COIL_WTH
- ,a.INSTR_COIL_LEN
- ,a.INSTR_COIL_WGT
-
- ,a.INSTR_COIL_INDIA
- ,a.INSTR_COIL_OUTDIA
- ,a.COIL_THK
- ,a.COIL_WTH
- ,a.COIL_LEN
- ,a.ACT_WGT
- ,a.COIL_OUTDIA
- ,a.COIL_INDIA
- FROM TBH02_COIL_COMM A WHERE COIL_NO = ?
- ]]>
- </query>
- <query id="UIH020032_03.select" desc=" datagrid3 " fetchSize="10">
- <![CDATA[
- SELECT B.MILL_DTIME
- , b.WKSHIFT
- ,b.WKGROUP
- ,b.RHF_DESCAL_YN
- ,b.RM_ENT_DESCAL_YN
- ,b.RM_EXT_DESCAL_YN
- ,b.RM1_PASS_CNT
- ,b.RM2_PASS_CNT
- ,b.R1_EXT_TEMP
- ,b.R2_EXT_TEMP
- ,b.RM_EXT_AVG_THK
- ,b.RM_EXT_AVG_WTH
- ,b.RM_EXT_AVG_LEN
-
- FROM TBH02_MILL_RESULT B WHERE COIL_NO = ?
- ]]>
- </query>
- </queryMap>
|
