| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748 |
- <?xml version="1.0" encoding='UTF-8'?>
- <queryMap desc="STEEL MAKING PROGRESS MONITORING ">
- <query id="UIG040200_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.STL_GRD STL
- ,E.CASTING_STA_DTIME
- ,E.CASTING_END_DTIME
- ,B.SLAB_CUT_DTIME --切割时间
- ,DECODE(B.SLAB_INGR_DEC_DTIME,'',A.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
- ,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_STOCK_ENT_DTIME,'YYYY-MM-DD HH24:MI:SS')))*24 - 1),2) STOCK_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(E.CASTING_STA_DTIME,'YYYYMMDDHH24MISS'),'YYYYMMDDHH24MISS'),'YYYY-MM-DD HH24:MI:SS')) - (SYSDATE-TO_DATE(DECODE(B.SLAB_INGR_DEC_DTIME,'',a.INGR_DEC_DTIME,B.SLAB_INGR_DEC_DTIME),'YYYY-MM-DD HH24:MI:SS')))*24 - 0.75),2) >= ?
- AND 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,'',a.INGR_DEC_DTIME,B.SLAB_INGR_DEC_DTIME),'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>
- </queryMap>
|
