| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIH020033_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="UIH020033_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="UIH020033_03.select" desc=" datagrid3 " fetchSize="10">
- <![CDATA[
- SELECT F1_ENT_PASS_DTIME
- ,F7_ENT_PASS_DTIME
- ,b.F1_ENT_TEMP_AVG --F1入口?度平均
- ,b.F1_ENT_TEMP_MAX --F1入口?度最大
- ,b.F1_ENT_TEMP_MIN --F1入口?度最小
- ,b.FM_EXT_STRIP_THK --FM出口厚度?定
- ,b.FM_EXT_STRIP_THK_AVG --FM出口厚度平均
- ,b.FM_EXT_STRIP_THK_MIN --FM出口厚度最小
- ,b.FM_EXT_STRIP_THK_MAX --FM出口厚度最大
- ,DECODE(NVL(B.COIL_LEN,'0'),'0','0',ROUND((b.FM_EXT_STRIP_THK_OUT_OF_LEN/COIL_LEN)*100,2)) FM_EXT_STRIP_THK_OUT_OF_LEN --FM出口厚度不在范?
- ,b.FM_EXT_STRIP_WTH --FM出口?度?定
- ,b.FM_EXT_STRIP_WTH_AVG --FM出口?度平均
- ,b.FM_EXT_STRIP_WTH_MIN --FM出口?度最小
- ,b.FM_EXT_STRIP_WTH_MAX --FM出口?度最大
- ,DECODE(NVL(B.COIL_LEN,'0'),'0','0',ROUND((FM_EXT_STRIP_WTH_OUT_OF_LEN/COIL_LEN)*100,2)) FM_EXT_STRIP_WTH_OUT_OF_LEN
-
- FROM tbh02_mill_result b WHERE b.coil_no = ?
- ]]>
- </query>
- <query id="UIH020033_04.select" desc=" datagrid4 " fetchSize="10">
- <![CDATA[
- SELECT b.FM_EXT_STRIP_CROWN --FM出口凸度?定
- ,b.FM_EXT_STRIP_CROWN_AVG --FM出口凸度平均
- ,b.FM_EXT_STRIP_CROWN_MIN --FM出口凸度最小
- ,b.FM_EXT_STRIP_CROWN_MAX --FM出口凸度最大
- ,DECODE(NVL(B.COIL_LEN,0),'0','0',ROUND((b.FM_EXT_STRIP_CROWN_OUT_OF_LEN/COIL_LEN)*100,2)) FM_EXT_STRIP_CROWN_OUT_OF_LEN --FM出口凸度不在范?
- ,b.FM_SYM_STRIP_FLATNESS_AVG --??平直度平均?
- ,b.FM_SYM_STRIP_FLATNESS_MAX --??平直度最大
- ,b.FM_SYM_STRIP_FLATNESS_MIN --??平直度最小
- ,DECODE(NVL(B.COIL_LEN,0),'0','0',ROUND((b.FM_SYM_STRIP_OUT_OF_RANGE/COIL_LEN)*100,2)) FM_SYM_STRIP_OUT_OF_RANGE --??平直度不在范?
- ,b.FM_ASY_STRIP_FLATNESS_AVG --非??平直度平均?
- ,b.FM_ASY_STRIP_FLATNESS_MAX --非??平直度最大
- ,b.FM_ASY_STRIP_FLATNESS_MIN --非??平直度最小
- ,DECODE(NVL(B.COIL_LEN,0),'0','0',ROUND((b.FM_ASY_STRIP_OUT_OF_RANGE/COIL_LEN)*100,2)) FM_ASY_STRIP_OUT_OF_RANGE --非??平直度不在范?
- ,b.FM_STRIP_WDG_AVG --?型 出口平均?
- ,b.FM_STRIP_WDG_MAX --?型 出口最大
- ,b.FM_STRIP_WDG_MIN --?型 出口最小
- ,DECODE(NVL(B.COIL_LEN,0),'0','0',ROUND((b.FM_STRIP_WDG_OUT_OF_RANGE/COIL_LEN)*100,2)) FM_STRIP_WDG_OUT_OF_RANGE --?型 出口 不在范?
-
- FROM tbh02_mill_result b WHERE b.coil_no = ?
- ]]>
- </query>
- <query id="UIH020033_05.select" desc=" datagrid5 " fetchSize="10">
- <![CDATA[
- SELECT b.FM_EXT_STRIP_TEMP --FM出口?度?定
- ,b.FM_EXT_STRIP_TEMP_AVG --FM出口?度平均
- ,b.FM_EXT_STRIP_TEMP_MIN --FM出口?度最小
- ,b.FM_EXT_STRIP_TEMP_MAX --FM出口?度最大
- ,DECODE(NVL(B.COIL_LEN,'0'),'0','0',ROUND((b.STRIP_OUT_OF_RANGE/COIL_LEN)*100,2)) STRIP_OUT_OF_RANGE --FM出口?度不在范?
- ,b.F7_MILL_SPEED_HEAD --穿?速度
- ,b.F7_MILL_SPEED_ACC1 --?制速度ACC1
- ,b.F7_MILL_SPEED_ACC2 --?制速度ACC2
- ,b.F7_MILL_SPEED_VMAX --?制速度VMAX
- ,b.F7_MILL_SPEED_VT --?制速度VT
- FROM tbh02_mill_result b WHERE b.coil_no = ?
- ]]>
- </query>
- </queryMap>
|
