'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) < ? ORDER BY B.STL_GRD,B.SLAB_STOCK_ENT_DTIME,B.SLAB_NO ]]> 'D' AND B.SLAB_NO = ? ORDER BY B.STL_GRD,B.SLAB_STOCK_ENT_DTIME,B.SLAB_NO ]]>