= ? AND A.SLAB_LEN <= ? --6 AND A.ORD_NO||'&' LIKE ?||'%' --7 AND A.ORD_FL||'&' LIKE ?||'%' --8 AND A.SLAB_STOCK_TYPE||'&' like ?||'%' --9热轧入库类型(1:热送入库 2 冷送入库 3 加回入库 4 轧回入库） AND A.SLAB_RT||'&' LIKE ?||'%' --10 AND A.NONORD_CAUSE_CD||'&' LIKE ?||'%' --11 AND A.SLAB_INGR_DEC_GRD||'&' LIKE ?||'%' --12 AND A.SLAB_WTH >= ? AND A.SLAB_WTH <= ? --14 AND SUBSTR(nvl(C.CMT_DLIV_DEVLMT_DATE,10000000), 1, 8) <= nvl(?,'50000000') --15交货期 ------------------------------------------- AND C.DLIV_TP||'&' LIKE ?||'%' --16运输方式 AND C.KEEPWARM_YN||'&' LIKE ?||'%' --17 AND (A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ?) --23 --------------------ADD BY WXY 091130 生产处要求 AND substr(A.SLAB_CUT_DTIME,1,8) >= ? --24 AND substr(A.SLAB_CUT_DTIME,1,8) <= ? --25 AND SUBSTR(A.SLAB_NO,3,1) LIKE ? --26 AND SUBSTR(E.CC_DEVNO,2,1)||'&' LIKE ?||'%' --27 AND C.XSQY||'&' LIKE ?||'%' --28 AND A.SLAB_TOT_DEC_GRD||'&' LIKE ?||'%' --29 ------------------------------------------------- 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(A.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(A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.SLAB_INGR_DEC_DTIME),'10000101010101'),'YYYY-MM-DD HH24:MI:SS')))*24 - 0.75),2) <= ? AND A.CUR_PROG_CD LIKE ?||'%' --34 -- AND G.PRD_TY||'&' LIKE ?||'%' AND INSTR(NVL(? , NVL(G.PRD_TY,'AR')) , NVL(G.PRD_TY,'AR')) > 0 --为空的作为AR，简单处理 --35 AND A.SLAB_THK >= ? AND A.SLAB_THK <= ? --37 AND H.L2_SCH_NO||'&' LIKE ?||'%' --38 AND INSTR(NVL(? , NVL(A.CRK_CD1,'ALL')) , NVL(A.CRK_CD1,'ALL')) > 0 --为空的作为ALL，简单处理 --39 ORDER BY STL_GRD,SLAB_NO,SLAB_WTH ]]> = ? AND A.SLAB_LEN <= ? AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_FL||'&' LIKE ?||'%' AND A.SLAB_STOCK_TYPE||'&' like ?||'%' --热轧入库类型(1:热送入库 2 冷送入库 3 加回入库 4 轧回入库） AND A.SLAB_RT||'&' LIKE ?||'%' AND A.NONORD_CAUSE_CD||'&' LIKE ?||'%' AND A.SLAB_INGR_DEC_GRD||'&' LIKE ?||'%' AND A.SLAB_WTH >= ? AND A.SLAB_WTH <= ? AND SUBSTR(nvl(C.CMT_DLIV_DEVLMT_DATE,10000000), 1, 8) <= nvl(?,'50000000') --交货期 ------------------------------------------- AND C.DLIV_TP||'&' LIKE ?||'%' --运输方式 AND C.KEEPWARM_YN||'&' LIKE ?||'%' AND (A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ?) --------------------ADD BY WXY 091130 生产处要求 AND substr(A.SLAB_CUT_DTIME,1,8) >= ? AND substr(A.SLAB_CUT_DTIME,1,8) <= ? AND SUBSTR(A.SLAB_NO,3,1) LIKE ? AND SUBSTR(E.CC_DEVNO,2,1)||'&' LIKE ?||'%' AND C.XSQY||'&' LIKE ?||'%' AND A.SLAB_TOT_DEC_GRD||'&' LIKE ?||'%' ------------------------------------------------- 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(A.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(A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.SLAB_INGR_DEC_DTIME),'10000101010101'),'YYYY-MM-DD HH24:MI:SS')))*24 - 0.75),2) <= ? AND A.CUR_PROG_CD LIKE ?||'%' -- AND G.PRD_TY||'&' LIKE ?||'%' AND INSTR(NVL(? , NVL(G.PRD_TY,'AR')) , NVL(G.PRD_TY,'AR')) > 0 --为空的作为AR，简单处理 AND A.SLAB_THK >= ? AND A.SLAB_THK <= ? AND H.L2_SCH_NO||'&' LIKE ?||'%' AND INSTR(NVL(? , NVL(A.CRK_CD1,'ALL')) , NVL(A.CRK_CD1,'ALL')) > 0 --为空的作为ALL，简单处理 --39 ORDER BY STL_GRD,SLAB_NO,SLAB_WTH ]]> = ? AND A.SLAB_LEN <= ? --6 AND A.ORD_NO||'&' LIKE ?||'%' --7 AND A.ORD_FL||'&' LIKE ?||'%' --8 AND A.SLAB_STOCK_TYPE||'&' like ?||'%' --9热轧入库类型(1:热送入库 2 冷送入库 3 加回入库 4 轧回入库） AND A.SLAB_RT||'&' LIKE ?||'%' --10 AND A.NONORD_CAUSE_CD||'&' LIKE ?||'%' --11 AND A.SLAB_INGR_DEC_GRD||'&' LIKE ?||'%' --12 AND A.SLAB_WTH >= ? AND A.SLAB_WTH <= ? --14 AND SUBSTR(nvl(C.CMT_DLIV_DEVLMT_DATE,10000000), 1, 8) <= nvl(?,'50000000') --15交货期 ------------------------------------------- AND C.DLIV_TP||'&' LIKE ?||'%' --16运输方式 AND C.KEEPWARM_YN||'&' LIKE ?||'%' --17 AND (A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ?) --23 --------------------ADD BY WXY 091130 生产处要求 AND substr(A.SLAB_CUT_DTIME,1,8) >= ? --24 AND substr(A.SLAB_CUT_DTIME,1,8) <= ? --25 AND SUBSTR(A.SLAB_NO,3,1) LIKE ? --26 AND SUBSTR(E.CC_DEVNO,2,1)||'&' LIKE ?||'%' --27 AND C.XSQY||'&' LIKE ?||'%' --28 AND A.SLAB_TOT_DEC_GRD||'&' LIKE ?||'%' --29 ------------------------------------------------- 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(A.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(A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.SLAB_INGR_DEC_DTIME),'10000101010101'),'YYYY-MM-DD HH24:MI:SS')))*24 - 0.75),2) <= ? AND A.CUR_PROG_CD LIKE ?||'%' --34 -- AND G.PRD_TY||'&' LIKE ?||'%' AND INSTR(NVL(? , NVL(G.PRD_TY,'AR')) , NVL(G.PRD_TY,'AR')) > 0 --为空的作为AR，简单处理 --35 AND A.SLAB_THK >= ? AND A.SLAB_THK <= ? --37 AND H.L2_SCH_NO||'&' LIKE ?||'%' --38 AND INSTR(NVL(? , NVL(A.CRK_CD1,'ALL')) , NVL(A.CRK_CD1,'ALL')) > 0 --为空的作为ALL，简单处理 --39 ORDER BY STL_GRD,SLAB_NO,SLAB_WTH) QQS full join (SELECT A.SLAB_NO, max(decode(WI.CHEM_CD, 'C', WI.CHEM_VAL)) VALUE_C, max(decode(WI.CHEM_CD, 'Mn', WI.CHEM_VAL)) VALUE_Mn, max(decode(WI.CHEM_CD, 'P', WI.CHEM_VAL)) VALUE_P, max(decode(WI.CHEM_CD, 'S', WI.CHEM_VAL)) VALUE_S, max(decode(WI.CHEM_CD, 'Si',WI.CHEM_VAL)) VALUE_Si, max(decode(WI.CHEM_CD, 'Cr', WI.CHEM_VAL)) VALUE_Cr, max(decode(WI.CHEM_CD, 'Mo', WI.CHEM_VAL)) VALUE_Mo, max(decode(WI.CHEM_CD, 'Ni', WI.CHEM_VAL)) VALUE_Ni, max(decode(WI.CHEM_CD, 'Cu', WI.CHEM_VAL)) VALUE_Cu, max(decode(WI.CHEM_CD, 'Nb', WI.CHEM_VAL)) VALUE_Nb, max(decode(WI.CHEM_CD, 'V', WI.CHEM_VAL)) VALUE_V, max(decode(WI.CHEM_CD, 'Ti', WI.CHEM_VAL)) VALUE_Ti, max(decode(WI.CHEM_CD, 'Als', WI.CHEM_VAL)) VALUE_Als, max(decode(WI.CHEM_CD, 'B', WI.CHEM_VAL)) VALUE_B, max(decode(WI.CHEM_CD, 'N', WI.CHEM_VAL)) VALUE_N, max(decode(WI.CHEM_CD, 'CEV', WI.CHEM_VAL)) VALUE_CEV FROM TBG02_SLAB_COMM A, TBB02_WORK_INGR WI, TBG02_CHARGE_COMM_D CHD, TBA01_ORD_LINE C, TBG02_CHARGE_COMM E, TBE02_ORD_PRC G, TBD01_SLABDN_OBJ2 H WHERE SUBSTR(A.SLAB_NO, 1, 10) = CHD.CHARGE_NO AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) and a.ORD_NO = g.ORD_NO(+) and a.ORD_SEQ = g.ORD_SEQ(+) AND A.DSN_SLAB_NO = H.DSN_SLAB_NO(+) ----MOD BY WXY 炉次变更----100302--------- AND SUBSTR(A.SUB_SLAB_NO, 1, 10) = E.CHARGE_NO AND WI.CHARGE_NO = CHD.CHARGE_NO AND WI.PROC_CD || WI.CHEM_SEQ = CHD.LST_INGR_CD AND A.SLAB_STAT = '2' AND A.SLAB_NO LIKE ?||'%' --1 AND A.STL_GRD LIKE '%'||NVL(?,A.STL_GRD)||'%' --2 AND A.CUR_LOAD_LOC||'&' LIKE DECODE(?,'J','L','R','Z')||'%' --3 AND SUBSTR(A.SLAB_NO,3,1) IN (SELECT SM_CD FROM TBZ00_COMMCD WHERE SM_CFNM||'&' LIKE ?||'%' AND LG_CD = 'B01132') --4 AND A.SLAB_LEN >= ? AND A.SLAB_LEN <= ? --6 AND A.ORD_NO||'&' LIKE ? ||'%' --7 AND A.ORD_FL||'&' LIKE ? ||'%' --8 AND A.SLAB_STOCK_TYPE||'&' like ? ||'%' --9热轧入库类型(1:热送入库 2 冷送入库 3 加回入库 4 轧回入库） AND A.SLAB_RT||'&' LIKE ? ||'%' --10 AND A.NONORD_CAUSE_CD||'&' LIKE ? ||'%' --11 AND A.SLAB_INGR_DEC_GRD||'&' LIKE ? ||'%' --12 AND A.SLAB_WTH >= ? AND A.SLAB_WTH <= ? --14 AND SUBSTR(nvl(C.CMT_DLIV_DEVLMT_DATE,10000000), 1, 8) <= nvl(?,'50000000') --15交货期 ------------------------------------------- AND C.DLIV_TP||'&' LIKE ?||'%' --16运输方式 AND C.KEEPWARM_YN||'&' LIKE ?||'%' --17 AND (A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ?) --23 --------------------ADD BY WXY 091130 生产处要求 AND substr(A.SLAB_CUT_DTIME,1,8) >= ? --24 AND substr(A.SLAB_CUT_DTIME,1,8) <= ? --25 AND SUBSTR(A.SLAB_NO,3,1) LIKE ? --26 AND SUBSTR(E.CC_DEVNO,2,1)||'&' LIKE ?||'%' --27 AND C.XSQY||'&' LIKE ?||'%' --28 AND A.SLAB_TOT_DEC_GRD||'&' LIKE ?||'%' --29 ------------------------------------------------- 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(A.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(A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.SLAB_INGR_DEC_DTIME),'10000101010101'),'YYYY-MM-DD HH24:MI:SS')))*24 - 0.75),2) <= ? AND A.CUR_PROG_CD LIKE ?||'%' --34 -- AND G.PRD_TY||'&' LIKE ?||'%' AND INSTR(NVL(? , NVL(G.PRD_TY,'AR')) , NVL(G.PRD_TY,'AR')) > 0 --为空的作为AR，简单处理 --35 AND A.SLAB_THK >= ? AND A.SLAB_THK <= ? --37 AND H.L2_SCH_NO||'&' LIKE ?||'%' --38 AND INSTR(NVL(?, NVL(A.CRK_CD1,'ALL')) , NVL(A.CRK_CD1,'ALL')) > 0 --为空的作为ALL，简单处理 --39 GROUP BY A.SLAB_NO ORDER BY A.SLAB_NO) WINGR on QQS.SLAB_NO = WINGR.SLAB_NO ]]> = ? AND A.SLAB_LEN <= ? AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_FL||'&' LIKE ?||'%' AND A.SLAB_STOCK_TYPE||'&' like ?||'%' --热轧入库类型(1:热送入库 2 冷送入库 3 加回入库 4 轧回入库） AND A.SLAB_RT||'&' LIKE ?||'%' AND A.NONORD_CAUSE_CD||'&' LIKE ?||'%' AND A.SLAB_INGR_DEC_GRD||'&' LIKE ?||'%' AND A.SLAB_WTH >= ? AND A.SLAB_WTH <= ? AND SUBSTR(nvl(C.CMT_DLIV_DEVLMT_DATE,10000000), 1, 8) <= nvl(?,'50000000') --交货期 ------------------------------------------- AND C.DLIV_TP||'&' LIKE ?||'%' --运输方式 AND C.KEEPWARM_YN||'&' LIKE ?||'%' AND (A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ?) --------------------ADD BY WXY 091130 生产处要求 AND substr(A.SLAB_CUT_DTIME,1,8) >= ? AND substr(A.SLAB_CUT_DTIME,1,8) <= ? AND SUBSTR(A.SLAB_NO,3,1) LIKE ? AND SUBSTR(E.CC_DEVNO,2,1)||'&' LIKE ?||'%' AND C.XSQY||'&' LIKE ?||'%' AND A.SLAB_TOT_DEC_GRD||'&' LIKE ?||'%' ------------------------------------------------- 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(A.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(A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.SLAB_INGR_DEC_DTIME),'10000101010101'),'YYYY-MM-DD HH24:MI:SS')))*24 - 0.75),2) <= ? AND A.CUR_PROG_CD LIKE ?||'%' -- AND G.PRD_TY||'&' LIKE ?||'%' AND INSTR(NVL(? , NVL(G.PRD_TY,'AR')) , NVL(G.PRD_TY,'AR')) > 0 --为空的作为AR，简单处理 AND A.SLAB_THK >= ? AND A.SLAB_THK <= ? AND H.L2_SCH_NO||'&' LIKE ?||'%' AND INSTR(NVL(? , NVL(A.CRK_CD1,'ALL')) , NVL(A.CRK_CD1,'ALL')) > 0 --为空的作为ALL，简单处理 --39 ORDER BY STL_GRD,SLAB_NO,SLAB_WTH) QQS full join (SELECT A.SLAB_NO, max(decode(WI.CHEM_CD, 'C', WI.CHEM_VAL)) VALUE_C, max(decode(WI.CHEM_CD, 'Mn', WI.CHEM_VAL)) VALUE_Mn, max(decode(WI.CHEM_CD, 'P', WI.CHEM_VAL)) VALUE_P, max(decode(WI.CHEM_CD, 'S', WI.CHEM_VAL)) VALUE_S, max(decode(WI.CHEM_CD, 'Si',WI.CHEM_VAL)) VALUE_Si, max(decode(WI.CHEM_CD, 'Cr', WI.CHEM_VAL)) VALUE_Cr, max(decode(WI.CHEM_CD, 'Mo', WI.CHEM_VAL)) VALUE_Mo, max(decode(WI.CHEM_CD, 'Ni', WI.CHEM_VAL)) VALUE_Ni, max(decode(WI.CHEM_CD, 'Cu', WI.CHEM_VAL)) VALUE_Cu, max(decode(WI.CHEM_CD, 'Nb', WI.CHEM_VAL)) VALUE_Nb, max(decode(WI.CHEM_CD, 'V', WI.CHEM_VAL)) VALUE_V, max(decode(WI.CHEM_CD, 'Ti', WI.CHEM_VAL)) VALUE_Ti, max(decode(WI.CHEM_CD, 'Als', WI.CHEM_VAL)) VALUE_Als, max(decode(WI.CHEM_CD, 'B', WI.CHEM_VAL)) VALUE_B, max(decode(WI.CHEM_CD, 'N', WI.CHEM_VAL)) VALUE_N, max(decode(WI.CHEM_CD, 'CEV', WI.CHEM_VAL)) VALUE_CEV FROM TBG02_SLAB_COMM A, TBB02_WORK_INGR WI, TBG02_CHARGE_COMM_D CHD, TBA01_ORD_LINE C, TBG02_CHARGE_COMM E, TBE02_ORD_PRC G, TBD01_SLABDN_OBJ2 H WHERE SUBSTR(A.SLAB_NO, 1, 10) = CHD.CHARGE_NO AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) and a.ORD_NO = g.ORD_NO(+) and a.ORD_SEQ = g.ORD_SEQ(+) AND A.DSN_SLAB_NO = H.DSN_SLAB_NO(+) ----MOD BY WXY 炉次变更----100302--------- AND SUBSTR(A.SUB_SLAB_NO, 1, 10) = E.CHARGE_NO AND WI.CHARGE_NO = CHD.CHARGE_NO AND WI.PROC_CD || WI.CHEM_SEQ = CHD.LST_INGR_CD AND A.SLAB_STAT = '2' and A.SLAB_RTURN = 'Y' AND A.SLAB_NO LIKE ?||'%' AND A.STL_GRD LIKE '%'||NVL(?,A.STL_GRD)||'%' AND A.CUR_LOAD_LOC||'&' LIKE DECODE(?,'G','')||'%' AND SUBSTR(A.SLAB_NO,3,1) IN (SELECT SM_CD FROM TBZ00_COMMCD WHERE SM_CFNM||'&' LIKE ?||'%' AND LG_CD = 'B01132') AND A.SLAB_LEN >= ? AND A.SLAB_LEN <= ? AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_FL||'&' LIKE ?||'%' AND A.SLAB_STOCK_TYPE||'&' like ?||'%' --热轧入库类型(1:热送入库 2 冷送入库 3 加回入库 4 轧回入库） AND A.SLAB_RT||'&' LIKE ?||'%' AND A.NONORD_CAUSE_CD||'&' LIKE ?||'%' AND A.SLAB_INGR_DEC_GRD||'&' LIKE ?||'%' AND A.SLAB_WTH >= ? AND A.SLAB_WTH <= ? AND SUBSTR(nvl(C.CMT_DLIV_DEVLMT_DATE,10000000), 1, 8) <= nvl(?,'50000000') --交货期 ------------------------------------------- AND C.DLIV_TP||'&' LIKE ?||'%' --运输方式 AND C.KEEPWARM_YN||'&' LIKE ?||'%' AND (A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ? OR A.STL_GRD LIKE ?) --------------------ADD BY WXY 091130 生产处要求 AND substr(A.SLAB_CUT_DTIME,1,8) >= ? AND substr(A.SLAB_CUT_DTIME,1,8) <= ? AND SUBSTR(A.SLAB_NO,3,1) LIKE ? AND SUBSTR(E.CC_DEVNO,2,1)||'&' LIKE ?||'%' AND C.XSQY||'&' LIKE ?||'%' AND A.SLAB_TOT_DEC_GRD||'&' LIKE ?||'%' ------------------------------------------------- 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(A.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(A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.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(A.SLAB_INGR_DEC_DTIME,'',E.INGR_DEC_DTIME,A.SLAB_INGR_DEC_DTIME),'10000101010101'),'YYYY-MM-DD HH24:MI:SS')))*24 - 0.75),2) <= ? AND A.CUR_PROG_CD LIKE ?||'%' -- AND G.PRD_TY||'&' LIKE ?||'%' AND INSTR(NVL(? , NVL(G.PRD_TY,'AR')) , NVL(G.PRD_TY,'AR')) > 0 --为空的作为AR，简单处理 AND A.SLAB_THK >= ? AND A.SLAB_THK <= ? AND H.L2_SCH_NO||'&' LIKE ?||'%' AND INSTR(NVL(? , NVL(A.CRK_CD1,'ALL')) , NVL(A.CRK_CD1,'ALL')) > 0 --为空的作为ALL，简单处理 --39 GROUP BY A.SLAB_NO ORDER BY A.SLAB_NO) WINGR on QQS.SLAB_NO = WINGR.SLAB_NO ]]> = ? AND A.SLAB_LEN <= ? AND A.ORD_NO||'&' LIKE ?||'%' AND A.ORD_FL||'&' LIKE ?||'%' AND A.SLAB_STOCK_TYPE||'&' like ?||'%' --热轧入库类型(1:热送入库 2 冷送入库 3 加回入库 4 轧回入库） AND A.SLAB_RT||'&' LIKE ?||'%' AND A.NONORD_CAUSE_CD||'&' LIKE ?||'%' AND A.SLAB_INGR_DEC_GRD||'&' LIKE ?||'%' AND A.SLAB_WTH >= ? AND A.SLAB_WTH <= ? AND SUBSTR(nvl(A.SLAB_STOCK_ENT_DTIME,50000000), 1, 8) >= NVL(?, '10000000') AND SUBSTR(nvl(A.SLAB_STOCK_ENT_DTIME,10000000), 1, 8) <= NVL(?, '50000000') AND SUBSTR(nvl(A.SLAB_STOCK_EXT_DTIME,50000000), 1, 8) >= NVL(?, '10000000') AND SUBSTR(nvl(A.SLAB_STOCK_EXT_DTIME,10000000), 1, 8) <= NVL(?, '50000000') AND SUBSTR(nvl(E.BOF_STA_DTIME,50000000), 1, 8) >= NVL(?, '10000000') AND SUBSTR(nvl(E.BOF_STA_DTIME,00000000), 1, 8) <= NVL(?, '50000000') AND E.CC_DEVNO = NVL(? , E.CC_DEVNO) AND SUBSTR(nvl(A.SMS_YARD_ENT_DTIME,50000000), 1, 8) >= NVL(?, '10000000') AND SUBSTR(nvl(A.SMS_YARD_ENT_DTIME,10000000), 1, 8) <= NVL(?, '50000000') AND SUBSTR(nvl(A.SMS_YARD_EXT_DTIME,50000000), 1, 8) >= NVL(?, '10000000') AND SUBSTR(nvl(A.SMS_YARD_EXT_DTIME,10000000), 1, 8) <= NVL(?, '50000000') AND E.BOF_STA_DTIME IS NOT NULL ORDER BY STL_GRD,SLAB_NO,SLAB_WTH ]]>