XinYu_RZMES/.svn/pristine/c5/c574f7947dfe8477c8d1f72d9e64cea048bfe6a7.svn-base

<?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>