XinYu_RZMES/.svn/pristine/c9/c97e4e0ed91c0d8cb885089d0dea09f9830b80c7.svn-base

<?xml version="1.0" encoding='UTF-8'?>
<queryMap desc="STEEL MAKING PROGRESS MONITORING  ">
	<query id="UIG040800_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.CUR_LOAD_LOC
			,B.SLAB_STOCK_ENT_DTIME
			,E.CASTING_STA_DTIME
       ,E.CASTING_END_DTIME
       ,B.SLAB_CUT_DTIME                --切割时间
       ,DECODE(B.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,B.SLAB_INGR_DEC_DTIME) INGR_DEC_DTIME
       ,ROUND((((SYSDATE-TO_DATE(TO_CHAR(TO_DATE(E.CASTING_STA_DTIME,'YYYYMMDDHH24MISS'),'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS')) - (SYSDATE-TO_DATE(DECODE(B.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,B.SLAB_INGR_DEC_DTIME),'YYYY-MM-DD HH24:MI:SS')))*24 - 0.75),2) IGR_LAG_DTIME
       ,ROUND((((SYSDATE-TO_DATE(TO_CHAR(TO_DATE(E.CASTING_END_DTIME,'YYYYMMDDHH24MISS'),'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS')) - (SYSDATE-TO_DATE(B.SLAB_CUT_DTIME,'YYYY-MM-DD HH24:MI:SS')))*24 - 1),2) CUT_LAG_DTIME
			,DECODE(NVL(B.SLAB_STOCK_TYPE,''),'3','加回','4','轧回') REMARKS
			,B.ORD_NO
			,B.ORD_SEQ
    FROM    TBG02_SLAB_COMM B
    		,TBG02_CHARGE_COMM E
    		,TBG02_CHARGE_COMM_D A
    WHERE   '1' = '1'
    AND     SUBSTR(B.SLAB_NO,1,10) = A.CHARGE_NO 
    AND     E.CHARGE_NO = A.SUB_CHARGE_NO      
    AND 	B.SLAB_NO LIKE ?||'%'
    AND     B.SLAB_STOCK_ENT_DTIME >= ?
    AND     B.SLAB_STOCK_ENT_DTIME <= ?
    AND     B.STL_GRD LIKE ?||'%'
    AND     (SELECT T.SM_CFNM FROM TBZ00_COMMCD T  WHERE T.LG_CD = 'B01132' AND T.SM_CD = SUBSTR(B.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   	ROUND((((SYSDATE-to_date(to_char(TO_date(nvl(E.CASTING_END_DTIME,'23331111111111'),'YYYYMMDDHH24MISS'),'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS')) - (SYSDATE-to_date(nvl(B.SLAB_CUT_DTIME,'10000101010101'),'YYYY-MM-DD HH24:MI:SS')))*24 - 1),2) >= ?
    AND   	ROUND((((SYSDATE-to_date(to_char(TO_date(nvl(E.CASTING_END_DTIME,'23331111111111'),'YYYYMMDDHH24MISS'),'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS')) - (SYSDATE-to_date(nvl(B.SLAB_CUT_DTIME,'10000101010101'),'YYYY-MM-DD HH24:MI:SS')))*24 - 1),2) <= ?
    AND   	ROUND((((SYSDATE-to_date(to_char(TO_date(nvl(E.CASTING_STA_DTIME,'23331111111111'),'YYYYMMDDHH24MISS'),'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS')) - (SYSDATE-to_date(nvl(decode(B.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,B.SLAB_INGR_DEC_DTIME),'10000101010101'),'YYYY-MM-DD HH24:MI:SS')))*24 - 0.75),2) >= ?
    AND   	ROUND((((SYSDATE-to_date(to_char(TO_date(nvl(E.CASTING_STA_DTIME,'23331111111111'),'YYYYMMDDHH24MISS'),'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS')) - (SYSDATE-to_date(nvl(decode(B.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,B.SLAB_INGR_DEC_DTIME),'10000101010101'),'YYYY-MM-DD HH24:MI:SS')))*24 - 0.75),2) <= ?
    AND     B.ORD_NO||'&' LIKE ?||'%'
    AND     B.ORD_SEQ||'&' LIKE ?||'%'
    ORDER BY B.STL_GRD,B.SLAB_STOCK_ENT_DTIME,B.SLAB_NO
        ]]> 
  </query>
  <query id="UIG040800_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_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
      ,(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
      ,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 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 ?||'%'
    ORDER BY B.STL_GRD,B.SLAB_STOCK_ENT_DTIME,B.SLAB_NO 
        ]]> 
  </query>
</queryMap>