XinYu_RZMES/.svn/pristine/90/90fc3f390d7f4f2a415123c1f743bc0d82d88c25.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">
	<query id="UIG040400_01.select" desc=" 取板坯运送前的信息，此时板坯在我方数据库。 ">
	   <![CDATA[
		SELECT  '' SEQ
	  ,A.ROLL_MANA_NO
      ,A.ROLL_SLAB_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.SLAB_CUT_DTIME
      ,B.SLAB_STOCK_EXT_DTIME
      ,ROUND((((SYSDATE - TO_DATE(B.SLAB_CUT_DTIME,'YYYY-MM-DD HH24:MI:SS')) - (SYSDATE - TO_DATE(B.SLAB_STOCK_EXT_DTIME,'YYYY-MM-DD HH24:MI:SS')) )*24),2) TIMES
      ,C.CHRGING_BEF_TEMP
      ,(SELECT T.SM_EFNM FROM TBZ00_COMMCD T WHERE T.LG_CD LIKE 'G04002' AND SM_CD =  B.SLAB_EXIT_TYPE) SLAB_STOCK_EXT_TYPE
      ,'' ORD_NO
      ,DECODE(NVL(B.SLAB_STOCK_TYPE,''),'3','加回','4','轧回') REMARKS
      
    FROM    TBG02_SLAB_COMM B
            ,TBF02_SPEC_MILL A
            ,tbh02_reheatfur C
    WHERE   '1' = '1'
    AND     B.SLAB_NO = A.SLAB_NO
    AND     B.SLAB_NO = C.SLAB_NO(+)
    AND     A.STATUS_CD <> 'D'
    AND     B.SLAB_NO LIKE ?||'%'
    AND     B.SLAB_STOCK_EXT_DTIME >= ?
    AND     B.SLAB_STOCK_EXT_DTIME <= ?
    AND     B.STL_GRD LIKE ?||'%'
    AND     A.ROLL_MANA_NO LIKE ?||'%'
    AND     (SELECT T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD = 'B01132' AND T.SM_CD = SUBSTR(A.SLAB_NO,3,1))LIKE ?||'%'
    AND   	B.SLAB_LEN >= ? AND B.SLAB_LEN <= ?
    AND   	B.SLAB_WTH >= ? AND B.SLAB_WTH <= ?
    AND   	B.SLAB_STOCK_TYPE||'&' like  ?||'%'  --热轧入库类型(1:热送入库 2 冷送入库 3 加回入库 4 轧回入库）
    AND     B.SLAB_EXIT_TYPE||'&' LIKE ?||'%'
    AND     ROUND((((SYSDATE - TO_DATE(B.SLAB_CUT_DTIME,'YYYY-MM-DD HH24:MI:SS')) - (SYSDATE - TO_DATE(B.SLAB_STOCK_EXT_DTIME,'YYYY-MM-DD HH24:MI:SS')) )*24),2) > ?
    AND     ROUND((((SYSDATE - TO_DATE(B.SLAB_CUT_DTIME,'YYYY-MM-DD HH24:MI:SS')) - (SYSDATE - TO_DATE(B.SLAB_STOCK_EXT_DTIME,'YYYY-MM-DD HH24:MI:SS')) )*24),2) < ?
    AND		NVL(C.CHRGING_BEF_TEMP,0)>=?
    ORDER BY B.STL_GRD,B.SLAB_STOCK_ENT_DTIME,B.SLAB_NO 
        ]]> 
  </query>
  <query id="UIG040400_02.select" desc=" 取板坯运送前的信息，此时板坯在我方数据库。 ">
	   <![CDATA[
		SELECT  '' SEQ
      ,B.SLAB_NO
      ,B.STL_GRD
      ,B.SLAB_THK
      ,B.SLAB_WTH
      ,B.SLAB_LEN
      ,B.SLAB_WGT
      ,B.CUR_LOAD_LOC
      ,B.SLAB_STOCK_EXT_DTIME
      ,A.ROLL_MANA_NO
      ,A.ROLL_SLAB_SEQ
      ,DECODE(NVL(B.SLAB_STOCK_TYPE,''),'3','加回','4','轧回') REMARKS
    FROM    TBG02_SLAB_COMM B
            ,TBF02_SPEC_MILL A
    WHERE   '1' = '1'
    AND     B.SLAB_NO = A.SLAB_NO
    AND     A.STATUS_CD <> 'D'
    AND     B.SLAB_NO = ?
  	ORDER BY B.STL_GRD,B.SLAB_STOCK_ENT_DTIME,B.SLAB_NO 
        ]]> 
  </query>
</queryMap>