| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH020034_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="UIH020034_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="UIH020034_03.select" desc=" datagrid3 " fetchSize="10">
- <![CDATA[
- SELECT
- b.MILL_DTIME
- ,b.WKSHIFT
- ,b.WKGROUP
- ,b.DC_TEMP --?定卷取?度
- ,b.DC_TEMP_AVG --卷取?度平均?
- ,b.DC_TEMP_MIN --卷取?度最小?
- ,b.DC_TEMP_MAX --卷取?度最大?
- ,DECODE(NVL(B.COIL_LEN,0),'0','0',ROUND((b.DC_TEMP_OUT_OF_RANGE/COIL_LEN)*100,2)) DC_TEMP_OUT_OF_RANGE --卷取?度不在范?
- ,b.DC_NO --卷取机?
- ,b.DC_ON_DTIME --?始卷取?刻
- ,b.DC_OFF_DTIME --?束卷取?刻
- ,b.MISSNO_CLF_CD --REJECT?分代?
- ,(select SM_CFNM MISSNO_CAUSE_CD from TBZ00_COMMCD where lg_cd = B.MISSNO_CAUSE_QY AND SM_CD = b.MISSNO_CAUSE_CD) MISSNO_CAUSE_CD --REJECT理由代?
- ,b.MISSNO_DTIME --REJECT?生??
- ,B.MISSNO_CAUSE_QY
-
- FROM TBH02_MILL_RESULT B WHERE b.coil_no = ?
- ]]>
- </query>
- </queryMap>
|
