| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING QUERY ">
- <query id="UIG020800_TRACKING.select" desc=" " fetchSize="10">
- <![CDATA[
- /* Formatted on 2010-5-29 下午 02:47:37 (QP5 v5.114.809.3010) */
- SELECT TBG_STL.L1_CHARGE_NO,
- TBG_STL.L1_STATION_NO,
- TBG_STL.L1_LD_NO,
- TBG_STL.L1_STL_GRD,
- TBG_STL.L1_IRON_WGT,
- TBG_STL.L1_IRON_TEMP,
- SUBSTR(TBG_STL.L1_LF_START_DTIME,9,6)L1_LF_START_DTIME,
- TBG_STL.L1_TREAT_HOUR,
- TBG_STL.ID,
- TBG_STL.L1_PROC_CD,
- TBG_STL.R1_PROC_CD,
- TBG_STL.R1_CHARGE_NO,
- TBG_STL.R1_STATION_NO,
- TBG_STL.R1_LD_NO,
- TBG_STL.R1_STL_GRD,
- TBG_STL.R1_STEEL_WEIGHT,
- SUBSTR(TBG_STL.R1_WEIGHT_TIME,9,6)R1_WEIGHT_TIME,
- SUBSTR(TBG_STL.R1_STEEL_TEMP,9,6)R1_STEEL_TEMP,
- SUBSTR(TBG_STL.R1_TEMP_TIME,9,6)R1_TEMP_TIME,
- SUBSTR(TBG_STL.R1_RH_START_DTIME,9,6)R1_RH_START_DTIME,
- TBG_STL.R1_TREAT_HOUR,
- TBG_STL.K1_KR_NO,
- TBG_STL.K1_LD_NO,
- TBG_STL.K1_IRON_WEIGT,
- SUBSTR(TBG_STL.K1_WEIGHT_TIME,9,6)K1_WEIGHT_TIME,
- TBG_STL.K1_IRON_TEMP,
- SUBSTR(TBG_STL.K1_TEMP_TIME,9,6)K1_TEMP_TIME,
- TBG_STL.K2_KR_NO,
- TBG_STL.K2_LD_NO,
- TBG_STL.K2_IRON_WEIGT,
- SUBSTR(TBG_STL.K2_WEIGHT_TIME,9,6)K2_WEIGHT_TIME,
- TBG_STL.K2_IRON_TEMP,
- SUBSTR(TBG_STL.K2_TEMP_TIME,9,6)K2_TEMP_TIME,
- TBG_STL.K1_PROC_CD,
- TBG_STL.K2_PROC_CD,
- TBG_STL.J1_PROC_CD,
- TBG_STL.J1_CHARGE_NO,
- TBG_STL.J1_LD_NO,
- TBG_STL.J1_STL_GRD,
- TBG_STL.J1_STLMELT_WGT,
- TBG_STL.J1_LD_WGT,
- TBG_STL.J1_LD_TEMP,
- TBG_STL.J1_TD_WGT,
- TBG_STL.J1_TD_TEMP,
- SUBSTR(TBG_STL.J1_CC_START_DTIME,9,6)J1_CC_START_DTIME,
- TBG_STL.J1_CC_HOUR,
- TBG_STL.J1_CC_SPEED1,
- TBG_STL.J1_CC_SIZE1,
- TBG_STL.J1_CC_STATE1,
- TBG_STL.J1_CC_SPEED2,
- TBG_STL.J1_CC_SIZE2,
- TBG_STL.J1_CC_STATE2,
- TBG_STL.J2_PROC_CD,
- TBG_STL.J2_CHARGE_NO,
- TBG_STL.J2_LD_NO,
- TBG_STL.J2_STL_GRD,
- TBG_STL.J2_STLMELT_WGT,
- TBG_STL.J2_LD_WGT,
- TBG_STL.J2_LD_TEMP,
- TBG_STL.J2_TD_WGT,
- TBG_STL.J2_TD_TEMP,
- SUBSTR(TBG_STL.J2_CC_START_DTIME,9,6)J2_CC_START_DTIME,
- TBG_STL.J2_CC_HOUR,
- TBG_STL.J2_CC_SPEED1,
- TBG_STL.J2_CC_SIZE1,
- TBG_STL.J2_CC_STATE1,
- TBG_STL.J2_CC_SPEED2,
- TBG_STL.J2_CC_SIZE2,
- TBG_STL.J2_CC_STATE2,
- TBG_STL.J3_PROC_CD,
- TBG_STL.J3_CHARGE_NO,
- TBG_STL.J3_LD_NO,
- TBG_STL.J3_STL_GRD,
- TBG_STL.J3_STLMELT_WGT,
- TBG_STL.J3_LD_WGT,
- TBG_STL.J3_LD_TEMP,
- TBG_STL.J3_TD_WGT,
- TBG_STL.J3_TD_TEMP,
- SUBSTR(TBG_STL.J3_CC_START_DTIME,9,6)J3_CC_START_DTIME,
- TBG_STL.J3_CC_HOUR,
- TBG_STL.J3_CC_SPEED1,
- TBG_STL.J3_CC_SIZE1,
- TBG_STL.J3_CC_STATE1,
- TBG_STL.J3_CC_SPEED2,
- TBG_STL.J3_CC_SIZE2,
- TBG_STL.J3_CC_STATE2
- FROM TBG02_STLMAKE_TRACKING TBG_STL
- WHERE (ROWNUM = 1)
- ]]>
- </query>
- </queryMap>
|
