| 12345678910111213141516171819202122232425262728293031323334353637383940414243 |
- <?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 ?||'%'
- --中厚板出库时间
- AND ((SUBSTR(B.SMS_YARD_EXT_DTIME, 1, 8) BETWEEN ? AND ?)
- --热轧出库时间
- OR (SUBSTR(B.SLAB_EXT_RZ_TIME, 1, 8) BETWEEN ? AND ?)
- --外销坯可能没有出库时间，也没有热轧入库时间，以SLAB_STOCK_EXT_DTIME时间为准
- OR (B.SMS_YARD_EXT_DTIME IS NULL AND B.SLAB_STAT = '3' AND B.SLAB_STOCK_EXT_DTIME IS NOT NULL AND B.ORD_NO LIKE '7%' AND
- SUBSTR(B.SLAB_STOCK_EXT_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>
|
