| 12345678910111213141516171819202122232425262728293031323334353637383940 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING PROGRESS MONITORING ">
- <query id="UIG040301_01.select" desc=" 取板坯运送前的信息，此时板坯在我方数据库。 ">
- <![CDATA[
- SELECT '' SEQ
- ,B.SLAB_NO
- ,B.STL_GRD
- ,B.SLAB_THK
- ,B.SLAB_WTH
- ,B.SLAB_LEN
- ,B.SLAB_WGT
- ,B.WEIGHT_WGT
- ,B.CUR_LOAD_LOC
- ,NVL(B.SMS_YARD_EXT_DTIME,B.SLAB_STOCK_ENT_DTIME) YARD_EXT_DTIME
- ,B.SMS_YARD_EXT_DTIME
- ,'' REMARKS
- ,C.ORD_NO
- ,A.BOF_STA_DTIME
- FROM TBG02_SLAB_COMM B
- ,TBG04_SLAB_TRANSF C
- ,TBG02_CHARGE_COMM A
- WHERE '1' = '1'
- AND B.SLAB_NO = C.SLAB_NO(+)
- --AND B.CHARGE_NO = A.CHARGE_NO
- AND SUBSTR(B.CHARGE_NO,1,9) = SUBSTR(A.CHARGE_NO,1,9)
- AND B.SLAB_NO LIKE ?||'%'
- ---将出库时间为空，而板坯状态slab_stat为3，热轧入库时间SLAB_STOCK_ENT_DTIME不为空的数据也查出来
- AND ((SUBSTR(B.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN ? AND ?)
- OR (B.SMS_YARD_EXT_DTIME IS NULL AND B.SLAB_STAT = '3' AND
- SUBSTR(B.SLAB_STOCK_ENT_DTIME, 1, 8) BETWEEN ? AND ?))
- --AND SUBSTR(B.SMS_YARD_EXT_DTIME,1,8) >= ?
- --AND SUBSTR(B.SMS_YARD_EXT_DTIME,1,8) <= ?
- AND B.STL_GRD LIKE ?||'%'
- AND B.SLAB_RT LIKE ?||'%'
- AND C.ORD_NO||'&' LIKE ?||'%'
- AND B.SLAB_WTH BETWEEN NVL(?,0) AND NVL(?,10000)
- ORDER BY B.STL_GRD,B.SLAB_STOCK_ENT_DTIME,B.SLAB_NO
- ]]>
- </query>
- </queryMap>
|
