= ? 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(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(nvl(E.CASTING_STA_DTIME,'23331111111111'),'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 ]]>