XinYu_RZMES/.svn/pristine/2d/2dcc3de92d29378267c9b4635719069dacd37954.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">
	<query id="UIG040300_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
      ,B.Sms_Yard_Ent_Dtime
      ,'' REMARKS
      ,A.ORD_NO
      ,B.SLAB_RT
      ,C.BOF_STA_DTIME
    FROM    TBG02_SLAB_COMM B
            ,TBG04_SLAB_TRANSF A
            ,TBG02_CHARGE_COMM C
    WHERE   '1' = '1'
    AND     B.SLAB_NO = A.SLAB_NO(+)
    --AND     B.CHARGE_NO = C.CHARGE_NO
    AND     SUBSTR(B.CHARGE_NO,1,9) = SUBSTR(C.CHARGE_NO,1,9)
    AND     B.SLAB_NO LIKE ?||'%'
    AND     SUBSTR(B.SLAB_CUT_DTIME,1,8) >= ?
    AND     SUBSTR(B.SLAB_CUT_DTIME,1,8) <= ?
    AND     B.STL_GRD LIKE ?||'%'
    AND     B.SLAB_RT||'&' LIKE ?||'%'
    ORDER BY B.STL_GRD,B.SLAB_STOCK_ENT_DTIME,B.SLAB_NO
        ]]> 
  </query>
</queryMap>