= ? 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 AND nvl(A.YARD_LOCK_YN,'N') LIKE ?||'%' --40 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 AND nvl(A.YARD_LOCK_YN,'N') LIKE ?||'%' --40 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 ]]> '4' then '2' when NVL(L.CC_DEVNO,E.CC_DEVNO)='J2' and substr(A.SLAB_NO,11,1)<'5' then '3' when NVL(L.CC_DEVNO,E.CC_DEVNO)='J2' and substr(A.SLAB_NO,11,1)>'4' then '4' else '5' end STREAM_NO ,F.STL_GRD PLAN_STL_GRD ,A.STL_GRD ,A.SLAB_THK ,A.SLAB_WTH ,A.SLAB_LEN ,B.AVG_WIDTH ,A.SLAB_WGT ,A.WEIGHT_WGT*1000 WEIGHT_WGT ,ROUND(A.SLAB_THK/1000 * A.SLAB_WTH/1000 * A.SLAB_LEN/1000 * 7.85 * 1000) SLAB_WGT85 ,DECODE(PLT_PLANT_ARRV_LOC,null,'热轧','zb','中板','hb','厚板','lg','外销') GOWHERE ,CASE WHEN A.WEIGHT_WGT IS NOT NULL THEN to_char(ROUND(A.WEIGHT_WGT*1000-ROUND(A.SLAB_THK/1000 * A.SLAB_WTH/1000 * A.SLAB_LEN/1000 * 7.85 * 1000))) ELSE '' END SLAB_WGT_DIFF ,CASE WHEN A.WEIGHT_WGT IS NOT NULL AND ROUND(A.WEIGHT_WGT*1000-ROUND(A.SLAB_THK/1000 * A.SLAB_WTH/1000 * A.SLAB_LEN/1000 * 7.85 * 1000))>=-50 AND ROUND(A.WEIGHT_WGT*1000-ROUND(A.SLAB_THK/1000 * A.SLAB_WTH/1000 * A.SLAB_LEN/1000 * 7.85 * 1000))<=150 THEN '合格' END SLAB_WGT_OK ,CUR_LOAD_LOC ,decode(a.SLAB_OUT_TP, 'Y', '允许出库', '不允许出库') SLAB_OUT_TP ,E.BOF_STA_DTIME ,E.CASTING_STA_DTIME ,E.CASTING_END_DTIME ,A.SLAB_STOCK_ENT_DTIME ,A.SLAB_STOCK_EXT_DTIME ,A.SMS_YARD_ENT_DTIME ,A.SMS_YARD_EXT_DTIME --,decode(A.SLAB_RT,'H','热轧厂','Z','中板厂','P','厚板厂') SLAB_RT ,CASE WHEN PLT_PLANT_ARRV_LOC IS NULL THEN CASE WHEN BPLOADSTAT(CUR_LOAD_LOC,SLAB_STAT,MATRL_END_CAUSE_CD) = '废钢库' THEN '废钢库' ELSE '热轧' END WHEN PLT_PLANT_ARRV_LOC = 'zb' THEN '中板' WHEN PLT_PLANT_ARRV_LOC = 'hb' THEN '厚板' WHEN PLT_PLANT_ARRV_LOC = 'lg' THEN '外销' END SLAB_RT ,decode(A.ORD_FL,'1','订单材','2','余材') ORD_FL ,(select sm_cfnm from tbz00_commcd where lg_cd like 'E01010%' and sm_cd = A.NONORD_CAUSE_CD)NONORD_CAUSE_CD ,(SELECT SM_CFNM FROM TBZ00_COMMCD WHERE SM_CD = A.SLAB_INGR_DEC_KIND AND LG_CD = 'B01133') SLAB_INGR_DEC_KIND --成分判定依据 ,A.SLAB_INGR_DEC_GRD ,(SELECT SM_CFNM FROM TBZ00_COMMCD WHERE SM_CD = SUBSTR(A.SLAB_NO,3,1) AND LG_CD = 'B01132') CHANDI ,A.ORD_NO ,A.ORD_SEQ ,H.L2_SCH_NO ,decode(C.KEEPWARM_YN,'Y','有','N','无','','无')KEEPWARM_YN --是否需要坑冷 ,(SELECT T.SM_CFNM FROM TBZ00_COMMCD T WHERE T.LG_CD = 'A01001' AND T.SM_CD = D.RCVORD_TP)RCVORD_TP --是否出口 ,DECODE(C.DLIV_TP,'T','火运','C','汽运') DLIV_TP -- 运输方式 ,C.SPEC_STL_GRD --订单钢号 ,C.CMT_DLIV_DEVLMT_DATE --交货期 ,C.ORD_THK --订单厚度 ,C.ORD_WTH --订单宽度 ,ROUND(C.PROD_WGT_MIN/1000,2)||'~'||ROUND(C.PROD_WGT_MAX/1000,2)||'T' ORD_WGT --订单单重范围 ,decode(A.SLAB_INGR_DEC_GRD,'1','合格','2','不合格','','待判') SLAB_INGR_DEC_GRD1 ,A.INGR_EXT_DTIME INGR_DEC_DTIME ,A.SLAB_CUT_DTIME --切割时间 ,decode(A.CUT_WKSHIFT,'1','早班','2','中班','3','晚班') CUT_WKSHIFT ,decode(A.CUT_WKGROUP,'A','甲班','B','乙班','C','丙班','D','丁班') CUT_WKGROUP ,A.CUT_EMP_ID ,DECODE(K.DSN_KIND, '1', 'Y', 'N') INGR_YN ,'' REMARKS ,A.REMARKS REMARKS2 ,A.NONORD_OCR_DTIME --,A.SLAB_INGR_DEC_DTIME ,NVL(A.SLAB_DCS_DETAIL,E.CHARGE_DCS_DETAIL) REMARKS ,'' SEQ FROM TBG02_SLAB_COMM A ,TBA01_ORD_LINE C ,TBA01_ORD_COMM D ,TBG02_CHARGE_COMM E ,TBF01_SPEC_SLAB F ,TBD01_SLABDN_OBJ2 H ,TBG02_CC_RESULT L ,(SELECT T.ORD_NO ,T.ORD_SEQ ,'1' DSN_KIND FROM TBB01_ORD_HEAD T WHERE T.CUST_SPEC_NO_INGR IS NOT NULL) K ,(SELECT * FROM STL_CCM_WIDTHGAUGE@Xgejgzxt_Wgt UNION SELECT * FROM J#STL_CCM_WIDTHGAUGE@Xgejgzxt_Wgt) B WHERE A.PLAN_SLAB_NO = F.SLAB_MANA_NO(+) AND A.ORD_NO = C.ORD_NO(+) AND A.ORD_SEQ = C.ORD_SEQ(+) AND A.ORD_NO = D.ORD_NO(+) AND A.ORD_NO = K.ORD_NO(+) AND A.ORD_SEQ = K.ORD_SEQ(+) AND A.DSN_SLAB_NO = H.DSN_SLAB_NO(+) AND SUBSTR(A.SLAB_NO,1,9) = SUBSTR(E.CHARGE_NO,1,9) AND A.CHARGE_NO = L.CHARGE_NO(+) AND A.SLAB_NO = B.BILLETNO(+) AND A.SLAB_NO LIKE ?||'%' AND A.STL_GRD = NVL(?,A.STL_GRD) AND A.CUR_LOAD_LOC||'&' LIKE DECODE(?,'J','L','R','Z')||'%' 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(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 ]]>