SQL Id | SQL Text |
00m9b8xca8hvp |
SELECT file_type, ROUND (mb_used, :"SYS_B_00") mb_used,
ROUND (mb_reclaimable, :"SYS_B_01") mb_reclaimable,
DECODE(total_mb, :"SYS_B_02", :"SYS_B_03", ROUND (mb_used * :"SYS_B_04" / total_mb, :"SYS_B_05")) percent_space_used,
DECODE(total_mb, :"SYS_B_06", :"SYS_B_07", ROUND (mb_reclaimable * :"SYS_B_08" / total_mb, :"SYS_B_09")) percent_space_reclaimable,
number_of_files, total_mb db_recovery_file_dest_mb,
flashback_retention_target, oldest_record, ROUND((sysdate-oldest_record)*:"SYS_B_10"*:"SYS_B_11", :"SYS_B_12") oldest_record_age_sec
FROM (SELECT SUM (DECODE (NAME,
:"SYS_B_13", VALUE / :"SYS_B_14",
:"SYS_B_15"
)
) total_mb,
SUM
(DECODE (NAME, :"SYS_B_16", VALUE, :"SYS_B_17")
) flashback_retention_target
FROM v$parameter
WHERE NAME IN
(:"SYS_B_18",
:"SYS_B_19"
)),
(SELECT :"SYS_B_20" file_type, NVL (SUM (BYTES) / :"SYS_B_21",
:"SYS_B_22") mb_used,
sum(CASE WHEN first_time <= (sysdate - (tgt.value
/:"SYS_B_23"))
THEN bytes / :"SYS_B_24"
ELSE :"SYS_B_25"
END
) mb_reclaimable,
COUNT (*) number_of_files, MIN (first_time) oldest_record
FROM v$flashback_database_logfile fla_log,
(SELECT quest_soo_pkg.stringToDigit(value) value FROM v$parameter
WHERE name = :"SYS_B_26") tgt
UNION
SELECT :"SYS_B_27" file_type, NVL (SUM (BYTES / :"SYS_B_28"), :"SYS_B_29") mb,
SUM (CASE
WHEN dl.rectype = :"SYS_B_30"
THEN (BYTES / :"SYS_B_31")
ELSE :"SYS_B_32"
END
) reclaimable_mb, COUNT (*) no_of_files,
MIN (start_time) oldest_record
FROM v$backup_piece bp, x$kccagf dl
WHERE is_recovery_dest_file = :"SYS_B_33" AND deleted = :"SYS_B_34"
AND bp.recid = dl.recid(+)
AND dl.rectype(+) = :"SYS_B_35"
UNION
SELECT :"SYS_B_36" file_type,
NVL (SUM (blocks * block_size) / :"SYS_B_37", :"SYS_B_38") mb,
SUM (CASE
WHEN dl.rectype = :"SYS_B_39"
THEN (LOG.blocks * LOG.block_size / :"SYS_B_40")
ELSE :"SYS_B_41"
END
) reclaimable_mb,
COUNT (*) no_of_files, MIN (first_time) oldest_record
FROM v$archived_log log, x$kccagf dl
WHERE deleted = :"SYS_B_42" AND is_recovery_dest_file = :"SYS_B_43"
AND dl.recid(+) = log.recid
AND dl.rectype(+) = :"SYS_B_44"
UNION
SELECT :"SYS_B_45" file_type, SUM (BYTES / :"SYS_B_46") mb, :"SYS_B_47" reclaimable,
COUNT (*) no_of_files, MIN (first_time) oldest_record
FROM v$logfile lf
JOIN
(SELECT group#, BYTES, first_time
FROM v$standby_log
UNION
SELECT group#, BYTES, first_time
FROM v$log) USING (group#)
WHERE lf.is_recovery_dest_file = :"SYS_B_48"
UNION
SELECT :"SYS_B_49", NVL (SUM (blocks * (block_size /:"SYS_B_50" )), :"SYS_B_51") mb,
:"SYS_B_52" reclaimable_mb, COUNT (*) no_of_files,
MIN (creation_time) oldest_record
FROM v$datafile_copy
WHERE deleted = :"SYS_B_53" AND is_recovery_dest_file = :"SYS_B_54"
UNION
SELECT :"SYS_B_55",
NVL (SUM (block_size * file_size_blks) / :"SYS_B_56", :"SYS_B_57") mb,
:"SYS_B_58" reclaimable, COUNT (*) no_of_files, NULL oldest_record
FROM v$controlfile
WHERE is_recovery_dest_file = :"SYS_B_59")
|
03y9rpv36g51k |
SELECT T1.C_PZH SCFWLYDPZH, T1.C_PZHH SCFWLYDPZHH, T1.C_GYSBM, (SELECT GYS.C_MC FROM SCF2.T_GYSZSJ GYS WHERE GYS.C_GYSBM = T1.C_GYSBM) C_GYSMC, T1.BACKSL, NULL C_CYSL, (SELECT TO_CHAR(PZ.C_JZRQ, 'yyyy-mm-dd hh24:mi:ss') FROM SCF2.TW_WLYDPZ PZ WHERE PZ.C_PZH = T1.C_PZH) C_JZRQ, T1.C_WLBM, (SELECT WL.C_WLMC FROM SCF2.T_WLZSJ WL WHERE WL.C_WLBM = T1.C_WLBM) C_WLMC, T1.C_SL, TO_CHAR(NVL(T1.BACKDATE, SYSDATE), 'yyyy-mm-dd hh24:mi:ss') BACKDATE, T1.SAPWLYDPZH, T1. SJLY, T1.SAPWLYDPZHH, T1.CGWLYDPZH, T1.CGWLYDPZHH, (SELECT PZ.C_WLDWBM FROM SCF2.TW_WLYDPZ PZ WHERE PZ.C_PZH = T1.C_PZH) C_WLDWBM, (SELECT ZZMC FROM SCF2.TPRIZZJG WHERE ZZBM = (SELECT PZ.C_WLDWBM FROM SCF2.TW_WLYDPZ PZ WHERE PZ.C_PZH = T1.C_PZH)) C_WLDWMC, T1.C_WLCKBM, (SELECT CK.C_CKMC FROM SCF2.TW_CKZSJ CK WHERE CK.C_CKBM = T1.C_WLCKBM) C_WLCKMC, (SELECT TO_CHAR(ZS.C_JHSFSJ, 'yyyy-mm-dd hh24:mi:ss') C_JHSFSJ FROM SCF2.TW_WLYDZS ZS WHERE ZS.C_ZSH = T1.C_ZSH AND ROWNUM = 1) C_JHSFSJ FROM (SELECT A.SCFWLYDPZH C_PZH, A.SCFWLYDPZHH C_PZHH, MIN(M.C_CKBM) C_CKBM, MIN(M.C_QWBM) C_QWBM, MIN(M.C_CWBM) C_CWBM, MIN(M.C_WLBM) C_WLBM, MIN(M.C_WLBB) C_WLBB, MIN(M.C_WLTSYT) C_WLTSYT, MIN(M.C_WLYSBM) C_WLYSBM, MIN(M.C_XSQY) C_XSQY, MIN(M.C_KCLX) C_KCLX, MIN(M.C_KCZT) C_KCZT, MIN(M.C_JLDW) C_JLDW, MIN(M.C_WLCKBM) C_WLCKBM, MIN(M.C_WLQWBM) C_WLQWBM, MIN(M.C_WLCWBM) C_WLCWBM, MIN(M.C_SFWLBM) C_SFWLBM, MIN(M.C_ZSH) C_ZSH, MIN(M.C_GYSBM) C_GYSBM, MIN(M.C_DDH) C_DDH, MIN(M.C_DDHH) C_DDHH, SUM(M.C_S
L) C_SL, NVL(MIN(G.BACKSL), SUM(M.C_SL)) BACKSL, MIN(G.SAPWLYDPZH) SAPWLYDPZH, MIN(G.SJLY) SJLY, MIN(G.SAPWLYDPZHH) SAPWLYDPZHH, MIN(G.CGWLYDPZH) CGWLYDPZH, NVL(MIN(G.CGWLYDPZHH), A.SCFWLYDPZHH) CGWLYDPZHH, MIN(G.BACKDATE) BACKDATE FROM TW_PZDYGXHXM A INNER JOIN TW_WLYDPZMX M ON A.SCFWLYDPZH = M.C_PZH AND A.WLYDPZHH = M.C_PZHH AND (M.C_CXBJ IS NULL OR M.C_CXBJ = '0') INNER JOIN TW_PZDYGX G ON G.SCFWLYDPZH = A.SCFWLYDPZH AND G.SCFWLYDPZHH = A.SCFWLYDPZHH AND (:B1 IS NULL OR G.CGWLYDPZH IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B1 )))) WHERE EXISTS (SELECT 1 FROM TW_DYJL DY WHERE DY.C_PZH = A.SCFWLYDPZH AND DY.C_PZLX = '1') AND EXISTS (SELECT 1 FROM TW_WLYDPZ PZ WHERE A.SCFWLYDPZH = PZ.C_PZH AND PZ.C_ZZBM = :B5 AND (PZ.C_YWLBBM = '52T5' OR PZ.C_YWLBBM = '52T7') AND TO_CHAR(PZ.C_JZRQ, 'yyyy-mm-dd') >= :B4 AND TO_CHAR(PZ.C_JZRQ, 'yyyy-mm-dd') <= :B3 AND (:B2 IS NULL OR PZ.C_WLDWBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B2 ))))) AND NOT EXISTS (SELECT 1 FROM TW_PZDYGX GX WHERE (GX.HPZT = '1' AND GX.SCFWLYDPZH = A.SCFWLYDPZH AND GX.SCFWLYDPZHH = A.SCFWLYDPZHH)) GROUP BY A.SCFWLYDPZH, A.SCFWLYDPZHH ) T1 WHERE (:B9 IS NULL OR T1.C_GYSBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B9 )))) AND (:B8 IS NULL OR T1.C_PZH IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B8 )))) AND (:B7 IS NULL OR T1.C_PZHH = :B7 ) AND (:B6 IS NULL OR T1.C_WLCKBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B6 ))))
|
08td029f3abyz | select STATUS, CJR, CJSJ, ORG from sysflowstatus where dbjobbm = :"SYS_B_0" |
0dmptzyb086u6 |
SELECT DISTINCT ZS.C_ZSH, ZS.C_ZSLB, ZS.C_YWLBBM, YWLB.C_YWLBMC, YWLB.C_WLYDLXBM, ZS.C_ZZBM, ZZ.C_MC C_ZZMC, ZS.C_WLDWBM, DECODE(YWLB.C_WLDWLX, '1601', GYS.C_MC, '1602', KH.C_MC, '1603', WLDW.C_MC, '1604', CBZX.C_CBZXMC, '') C_WLDWMC, (SELECT TO_CHAR(MIN(H.C_JHSFSJ), 'YYYY-MM-DD') FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_JHSFSJ, (SELECT DISTINCT CASE WHEN H.C_LLLX = '0' THEN '¿´°å' WHEN H.C_LLLX = '1' THEN 'ÀÁÏ' ELSE '' END FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_LLLX, (SELECT DISTINCT H.C_WLCKBM FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_WLCKBM, (SELECT DISTINCT WLCK.C_CKMC FROM TW_WLYDZSHXM H LEFT JOIN TW_CKZSJ WLCK ON WLCK.C_CKBM=H.C_WLCKBM WHERE H.C_ZSH = ZS.C_ZSH) C_WLCKMC, (SELECT TO_CHAR(MAX(H.C_JHSFSJ), 'YYYY-MM-DD') FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_JHJSSJ, ZS.C_ZSLY, NVL(ZS.C_QXBJ, '0') C_QXBJ, NVL(ZS.C_GBBJ, '0') C_GBBJ, ZS.C_ZXZT, ZS.C_CJR, (SELECT YG.YGMC FROM TPRIYGZSJ YG WHERE YG.YGBM = ZS.C_CJR) C_CJRMC, TO_CHAR(ZS.C_CJSJ, 'yyyy-mm-dd hh24:mi:ss') C_CJSJ, ZS.C_XGR, (SELECT YG.YGMC FROM TPRIYGZSJ YG WHERE YG.YGBM = ZS.C_XGR) C_XGRMC, TO_CHAR(ZS.C_XGSJ, 'yyyy-mm-dd hh24:mi:ss') C_XGSJ, ZS.C_BZ FROM TW_WLYDZS ZS INNER JOIN TW_YWLBZSJ YWLB ON ZS.C_YWLBBM = YWLB.C_YWLBBM INNER JOIN T_ZZZSJ ZZ ON ZS.C_ZZBM = ZZ.C_ZZBM LEFT JOIN T_ZZZSJ WLDW ON ZS.C_WLDWBM = WLDW.C_ZZBM LEFT JOIN T_GYSZSJ GYS ON ZS.C_WLDWBM = GYS.C_GYSBM LEFT JOIN T_KHZSJ KH ON ZS.C_WLDWBM = KH.C_KHBM LEFT JOIN T_CBZXZSJ CBZX ON
ZS.
C_WLDWBM = CBZX.C_CBZXBH WHERE ZS.C_ZZBM = :B6 AND ZS.C_YWLBBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B7 ))) AND (:B2 IS NOT NULL OR :B5 = '1' OR (:B5 = '2' AND (ZS.C_CJSJ BETWEEN TO_DATE(:B4 || ' 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(:B3 || ' 23:59:59', 'yyyy-mm-dd hh24:mi:ss')))) AND (:B2 IS NULL OR INSTR(:B2 , ZS.C_ZSH) > 0) AND (:B1 IS NULL OR ZS.C_WLDWBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B1 )))) AND ZS.C_ZXZT IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B8 ))) AND NVL(ZS.C_QXBJ, '0') IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B9 ))) AND NVL(ZS.C_GBBJ, '0') IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B10 ))) AND EXISTS (SELECT 1 FROM TW_WLYDZSHXM HXM LEFT JOIN TM_ZZWLCS CS ON HXM.C_CKBM = CS.C_DHDBM LEFT JOIN TW_WLYDZSWLMX WLMX ON WLMX.C_ZSH = HXM.C_ZSH AND WLMX.C_ZSXMH = HXM.C_XMH WHERE HXM.C_ZSH = ZS.C_ZSH AND ((:B16 IS NULL) OR (HXM.C_LLLX = :B16 )) AND HXM.C_CKBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B17 ))) AND ((:B15 IS NULL) OR (HXM.C_DDH = :B15 )) AND (CS.C_ZZBM = ZS.C_ZZBM OR CS.C_ZZBM IS NULL) AND ((:B14 IS NULL) OR (FW_GET_BGYBM(ZS.C_ZZBM, HXM.C_CKBM, HXM.C_WLBM, WLMX.C_QWBM, WLMX.C_CWBM, NVL(HXM.C_GYSBM, HXM.C_GYSBM))) IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B14 )))) AND (:B2 IS NOT NULL OR :B5 = '2' OR (:B5 = '1' AND (HXM.C_JHSFSJ BETWEEN TO_DATE(:B4 || ' 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(:B3 || ' 23:59:59', 'yyyy-mm-dd hh24:mi:ss')))) AND (:B13 IS NULL OR (CS.C_ABCDFL IN (SELECT *
FROM TABLE(FW_CONVERT_FLATTOXLH(:B13 ))) OR CS.C_ABCDFL IS NULL)) AND (:B12 IS NULL OR HXM.C_WLCKBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B12 )))) AND (:B11 IS NULL OR HXM.C_WLBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B11 ))))) |
0fx4sd9cd265g | insert into SAP2SCF_SF03_EXPORT_MSEG (id, sessionid, mBLNR, mJAHR, zEILE, bUDAT, bLDAT, cPUDT, cPUTM, uSNAM, xBLNR, xABLN, bKTXT, bWART, mATNR, wERKS, lGORT, cHARG, sOBKZ, sHKZG, mENGE, mEINS, sGTXT, lIFNR, kUNNR, kOSTL, eBELN, eBELP, aUFNR, rSNUM, rSPOS, lFBJA, lFBNR, lFPOS) values (seq_payment.nextval, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", :"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21", :"SYS_B_22", :"SYS_B_23", :"SYS_B_24", :"SYS_B_25", :"SYS_B_26", :"SYS_B_27", :"SYS_B_28", :"SYS_B_29", :"SYS_B_30", :"SYS_B_31", :"SYS_B_32") |
0gshzbuaxq8pz |
SELECT SQ.*, ZZ.C_MC C_SHDW, YS.C_YSMC C_WLYSMC, WL.C_WLMC, DY.CGWLYDPZH C_HPH, DY.BACKSL C_HPSL, (CASE NVL(DY.CXBJ, '0') WHEN '1' THEN 'ÒѳåÏú' WHEN '0' THEN 'δ³åÏú' END) C_CXBJ FROM (SELECT HEAD.C_KJZQ, WHL.C_ZZBM, WHL.C_WLBM, NVL(HEAD.C_QC, 0) + NVL(MIDD.C_BWQ, 0) C_QC, WHL.C_WLYSBM, NVL(HEAD.C_QC, 0) + NVL(BACKWARD.C_BWQ, 0) C_KCJY, BACKWARD.C_BWQ, BWBILL.C_RKPZH, BWBILL.C_RKSL, BWBILL.C_RKLB, BWBILL.C_RKRQ, BWBILL.C_CKPZH, BWBILL.C_CKSL, BWBILL.C_CKLB, BWBILL.C_CKRQ, BWBILL.C_WLDWBM, WHL.C_GYSBM, GYS.C_MC C_GYSMC, BWBILL.C_JZRQ, WHL.C_KCZT, BWBILL.SCFWLYDPZHH, CK.C_CKMC C_WLCKMC FROM (SELECT KCZ.C_KJZQ, KCZ.C_ZZBM, KCZ.C_WLBM, SUM(KCZ.C_QC) C_QC, PCZSJ.C_YSGYSBM C_GYSBM, PCZSJ.C_WLYSBM, ZD.C_QZ C_KCZT FROM TW_XLHZ KCZ LEFT JOIN TW_PCZSJ PCZSJ ON KCZ.C_ZZBM = PCZSJ.C_ZZBM AND KCZ.C_WLBM = PCZSJ.C_WLBM AND KCZ.C_PC = PCZSJ.C_PC LEFT JOIN T_SJZD ZD ON KCZ.C_KCZT = ZD.C_CLBM WHERE KCZ.C_KJZQ = :B14 AND KCZ.C_ZZBM = :B13 AND (:B1 = 0 OR KCZ.C_CKBM IN (SELECT * FROM TABLE(:B6 ))) AND (:B12 = 0 OR KCZ.C_WLBM IN (SELECT * FROM TABLE(:B15 ))) AND (:B11 = 0 OR KCZ.C_KCLX IN (SELECT * FROM TABLE(:B16 ))) AND (:B10 = 0 OR KCZ.C_KCZT IN (SELECT * FROM TABLE(:B17 ))) AND (:B9 = 0 OR PCZSJ.C_YSGYSBM IN (SELECT * FROM TABLE(:B18 ))) GROUP BY KCZ.C_KJZQ, KCZ.C_ZZBM, KCZ.C_WLBM, PCZSJ.C_YSGYSBM, PCZSJ.C_WLYSBM, ZD.C_QZ) WHL LEFT JOIN (SELECT KCZ.C_KJZQ, KCZ.C_ZZBM, KCZ.C_WLBM, SUM(NVL(KCZ.C_QC, 0)) C_QC, PCZSJ.C_YSGYSBM C_GYSBM, PCZSJ.C_WL
YSBM,
ZD.C_QZ C_KCZT FROM TW_XLHZ KCZ LEFT JOIN TW_PCZSJ PCZSJ ON KCZ.C_ZZBM = PCZSJ.C_ZZBM AND KCZ.C_WLBM = PCZSJ.C_WLBM AND KCZ.C_PC = PCZSJ.C_PC LEFT JOIN T_SJZD ZD ON KCZ.C_KCZT = ZD.C_CLBM WHERE KCZ.C_KJZQ = :B8 AND (:B1 = 0 OR KCZ.C_CKBM IN (SELECT * FROM TABLE(:B6 ))) GROUP BY KCZ.C_KJZQ, KCZ.C_ZZBM, KCZ.C_WLBM, PCZSJ.C_YSGYSBM, PCZSJ.C_WLYSBM, ZD.C_QZ) HEAD ON HEAD.C_ZZBM = WHL.C_ZZBM AND HEAD.C_WLBM = WHL.C_WLBM AND HEAD.C_GYSBM = WHL.C_GYSBM AND HEAD.C_KCZT = WHL.C_KCZT LEFT JOIN (SELECT M.C_ZZBM, S.C_WLBM, PCZSJ.C_YSGYSBM C_GYSBM, SUM(CASE B.C_JZFX WHEN '+' THEN S.C_SL ELSE S.C_SL * -1 END) C_BWQ, ZD.C_QZ C_KCZT FROM TW_WLYDPZ M INNER JOIN TW_WLYDPZMX S ON M.C_PZH = S.C_PZH INNER JOIN TW_YWLBZSJ B ON M.C_YWLBBM = B.C_YWLBBM LEFT JOIN T_SJZD ZD ON S.C_KCZT = ZD.C_CLBM LEFT JOIN TW_PCZSJ PCZSJ ON M.C_ZZBM = PCZSJ.C_ZZBM AND S.C_WLBM = PCZSJ.C_WLBM AND S.C_PC = PCZSJ.C_PC WHERE M.C_JZRQ > :B7 AND M.C_JZRQ < :B3 AND (:B1 = 0 OR S.C_CKBM IN (SELECT * FROM TABLE(:B6 ))) GROUP BY M.C_ZZBM, S.C_WLBM, ZD.C_QZ, ZD.C_QZ, PCZSJ.C_YSGYSBM) MIDD ON WHL.C_ZZBM = MIDD.C_ZZBM AND WHL.C_WLBM = MIDD.C_WLBM AND WHL.C_GYSBM = MIDD.C_GYSBM AND WHL.C_KCZT = MIDD.C_KCZT LEFT JOIN (SELECT M.C_ZZBM, S.C_WLBM, PCZSJ.C_YSGYSBM C_GYSBM, SUM(CASE B.C_JZFX WHEN '+' THEN S.C_SL ELSE S.C_SL * -1 END) C_BWQ, ZD.C_QZ C_KCZT FROM TW_WLYDPZ M INNER JOIN TW_WLYDPZMX S ON M.C_PZH = S.C_PZH INNER JOIN TW_YWLBZSJ B ON M.C_YWLBBM = B.C_YWLBBM LEFT JOIN T_SJZD ZD ON S.C_KCZT = ZD.C_CLBM LE
FT JOIN TW_PCZSJ PCZSJ ON M.C_ZZBM = PCZSJ.C_ZZBM AND S.C_WLBM = PCZSJ.C_WLBM AND S.C_PC = PCZSJ.C_PC WHERE M.C_JZRQ > :B7 AND M.C_JZRQ < :B2 AND (:B1 = 0 OR S.C_CKBM IN (SELECT * FROM TABLE(:B6 ))) GROUP BY M.C_ZZBM, S.C_WLBM, ZD.C_QZ, ZD.C_QZ, PCZSJ.C_YSGYSBM) BACKWARD ON WHL.C_ZZBM = BACKWARD.C_ZZBM AND WHL.C_WLBM = BACKWARD.C_WLBM AND WHL.C_GYSBM = BACKWARD.C_GYSBM AND WHL.C_KCZT = BACKWARD.C_KCZT LEFT JOIN (SELECT L.C_ZZBM, L.C_WLBM, L.C_RKPZH, L.C_RKRQ, L.C_RKLB, SUM(L.C_RKSL) C_RKSL, L.C_CKPZH, L.C_CKRQ, L.C_CKLB, L.C_WLDWBM, SUM(L.C_CKSL) C_CKSL, L.C_JZRQ, L.C_KCZT, L.C_GYSBM, MAX(L.SCFWLYDPZHH) SCFWLYDPZHH, MAX(C_WLCKBM) C_WLCKBM FROM (SELECT M.C_ZZBM, S.C_WLBM, S.C_PC, CASE WHEN REGEXP_LIKE(:B5 , B.C_YWLBBM) THEN M.C_PZH ELSE '' END C_RKPZH, CASE WHEN REGEXP_LIKE(:B5 , B.C_YWLBBM) THEN TO_CHAR(M.C_JZRQ, 'yyyy-mm-dd hh24:mi') ELSE NULL END C_RKRQ, CASE WHEN REGEXP_LIKE(:B5 , B.C_YWLBBM) THEN B.C_YWLBMC ELSE NULL END C_RKLB, CASE WHEN REGEXP_LIKE(:B5 , B.C_YWLBBM) THEN CASE B.C_JZFX WHEN '+' THEN C_SL ELSE C_SL * -1 END ELSE 0 END C_RKSL, CASE WHEN REGEXP_LIKE(:B4 , B.C_YWLBBM) THEN M.C_PZH ELSE '' END C_CKPZH, CASE WHEN REGEXP_LIKE(:B4 , B.C_YWLBBM) THEN TO_CHAR(M.C_CJSJ, 'yyyy-mm-dd hh24:mi') ELSE NULL END C_CKRQ, CASE WHEN REGEXP_LIKE(:B4 , B.C_YWLBBM) THEN B.C_YWLBMC ELSE NULL END C_CKLB, M.C_WLDWBM, S.C_WLCKBM, CASE WHEN REGEXP_LIKE(:B4 , B.C_YWLBBM) THEN CASE B.C_JZFX WHEN '-' THEN C_SL ELSE C_SL * -1 END ELSE 0 END
C_CKSL, M.C_JZRQ, ZD.C_QZ C_KCZT, PCZSJ.C_YSGYSBM C_GYSBM, DY.SCFWLYDPZHH FROM TW_WLYDPZ M INNER JOIN TW_WLYDPZMX S ON M.C_PZH = S.C_PZH INNER JOIN TW_YWLBZSJ B ON M.C_YWLBBM = B.C_YWLBBM LEFT JOIN T_SJZD ZD ON S.C_KCZT = ZD.C_CLBM LEFT JOIN TW_PCZSJ PCZSJ ON M.C_ZZBM = PCZSJ.C_ZZBM AND S.C_WLBM = PCZSJ.C_WLBM AND S.C_PC = PCZSJ.C_PC LEFT JOIN TW_PZDYGXHXM DY ON S.C_PZH = DY.SCFWLYDPZH AND S.C_PZHH = DY.WLYDPZHH WHERE M.C_JZRQ >= :B3 AND M.C_JZRQ <= :B2 AND (:B1 = 0 OR S.C_CKBM IN (SELECT * FROM TABLE(:B6 )))) L GROUP BY L.C_ZZBM, L.C_WLBM, L.C_RKPZH, L.C_RKRQ, L.C_RKLB, L.C_CKPZH, L.C_CKRQ, L.C_CKLB, L.C_WLDWBM, L.C_JZRQ, L.C_KCZT, L.C_GYSBM) BWBILL ON BWBILL.C_ZZBM = WHL.C_ZZBM AND BWBILL.C_WLBM = WHL.C_WLBM AND BWBILL.C_GYSBM = WHL.C_GYSBM AND BWBILL.C_KCZT = WHL.C_KCZT LEFT JOIN T_GYSZSJ GYS ON WHL.C_GYSBM = GYS.C_GYSBM LEFT JOIN TW_CKZSJ CK ON BWBILL.C_WLDWBM = CK.C_ZZBM AND BWBILL.C_WLCKBM = CK.C_CKBM) SQ LEFT JOIN T_ZZZSJ ZZ ON SQ.C_WLDWBM = ZZ.C_ZZBM LEFT JOIN T_YSQD YS ON SQ.C_WLYSBM = YS.C_YSBM LEFT JOIN TW_PZDYGX DY ON SQ.C_CKPZH = DY.SCFWLYDPZH AND SQ.SCFWLYDPZHH = DY.SCFWLYDPZHH LEFT JOIN T_WLZSJ WL ON SQ.C_WLBM = WL.C_WLBM ORDER BY SQ.C_ZZBM, SQ.C_GYSBM, SQ.C_WLBM, SQ.C_KCZT, SQ.C_JZRQ |
0km2mucn8vsau |
INSERT INTO TCGBJDWLCBMX (gysbm, DYSDJK , SMBZYSDJK , FMBZYSDJK , DHBZ, BZLX, BJDBH, DL, DW, DH, DYBZTJ, DBZZZL, DYBZMZL, DZCZL, DZCDJ, DYSJL, DYSDJ, DSYSM, DSNP, DYSFY, DBZFY, DFYXJ, CL, CW, CH, CRQDMJ, CKDTCS, CSNP, CZDKCL, CMPFMJG, CKCTS, CLJRXQL, CZBZF, CCKFY, CFYXJ, SL, SW, SH, SYBZTJ, SBZZZL, SYBZMZ, SZCZL, SZCDJ, SJL, SMBZYSDJ, SSYSM, SSCN, SPSF, SBZF, SFYXJ, FL, FW, FH, FKRQTJ, FKRQZL, FZBZZL, FJL, FMBZYSDJ, FYF, FFYXJ, WLZFY, FSNP)VALUES(:"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", :"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21", :"SYS_B_22", :"SYS_B_23", :"SYS_B_24", :"SYS_B_25", :"SYS_B_26", :"SYS_B_27", :"SYS_B_28", :"SYS_B_29", :"SYS_B_30", :"SYS_B_31", :"SYS_B_32", :"SYS_B_33", :"SYS_B_34", :"SYS_B_35", :"SYS_B_36", :"SYS_B_37", :"SYS_B_38", :"SYS_B_39", :"SYS_B_40", :"SYS_B_41", :"SYS_B
_42", :"SYS_B_43", :"SYS_B_44", :"SYS_B_45", :"SYS_B_46", :"SYS_B_47", :"SYS_B_48", :"SYS_B_49", :"SYS_B_50", :"SYS_B_51", :"SYS_B_52", :"SYS_B_53", :"SYS_B_54", :"SYS_B_55", :"SYS_B_56", :"SYS_B_57", :"SYS_B_58", :"SYS_B_59", :"SYS_B_60", :"SYS_B_61") |
0s90x7g3jd9sk |
SELECT INN.*, YG.C_YGMC C_BGYXM, YS.C_YSMC C_WLYSMC, GYS.C_MC C_GYSMC FROM (SELECT T.C_KJZQ, T.C_ZZBM, T.C_CKBM, T.C_QWBM, T.C_CWBM, T.C_WLBM, T.C_PC, FW_CONVERT_XLHTOFLAT(CAST(COLLECT(T.C_XLH) AS TPW_XLH)) C_XLH, T.C_KCLX, T.C_KCZT, T.C_JLDW, NVL(SUM(T.C_ZMSL), 0) C_ZMSL, CASE T.C_PC WHEN '*' THEN DECODE(T.C_KCLX, '1402', '*', T.C_WLDW) ELSE MIN(PCZSJ.C_YSGYSBM) END C_WLDW, PCZSJ.C_YSGYSBM C_GYSBM, FW_GET_BGYBM(:B2 , :B12 , T.C_WLBM, T.C_QWBM, T.C_CWBM, PCZSJ.C_YSGYSBM) C_BGYBM, PCZSJ.C_WLTSYT, :B14 C_WLYSBM FROM TW_XLHZ T LEFT JOIN TW_PCZSJ PCZSJ ON T.C_PC = PCZSJ.C_PC AND PCZSJ.C_ZZBM = :B2 AND PCZSJ.C_WLBM = :B1 WHERE T.C_KJZQ = :B13 AND T.C_ZZBM = :B2 AND T.C_CKBM = :B12 AND T.C_WLBM = :B1 AND (:B11 IS NULL OR T.C_PC IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B11 )))) AND (:B10 IS NULL OR T.C_XLH IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B10 )))) AND (:B9 IS NULL OR T.C_QWBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B9 )))) AND (:B8 IS NULL OR T.C_CWBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B8 )))) AND (:B7 IS NULL OR T.C_KCLX IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B7 )))) AND (:B6 IS NULL OR T.C_KCZT IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B6 )))) AND (:B5 IS NULL OR T.C_WLDW IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B5 )))) AND (:B4 IS NULL OR PCZSJ.C_WLTSYT IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B4 )))) AND T.C_ZMSL >= :B3 GROUP BY T.C_KJZQ, T.C_ZZBM, T.C_CKBM, T.C_QWBM, T.C_CWBM, T.C_WLBM, T.C_PC,
T.C_KCLX, T.C_KCZT, T.C_JLDW, T.C_WLDW, PCZSJ.C_YSGYSBM, PCZSJ.C_WLTSYT, PCZSJ.C_WLYSBM) INN LEFT JOIN T_YGZSJ YG ON INN.C_ZZBM = YG.C_ZZBM AND INN.C_BGYBM = YG.C_YGBM LEFT JOIN T_YSQD YS ON INN.C_WLYSBM = YS.C_YSBM LEFT JOIN T_GYSZSJ GYS ON INN.C_GYSBM = GYS.C_GYSBM |
0vwa9n600yvgm |
SELECT sum(delta_cpu_time) as total_cpu, sum(case when session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' ) then delta_cpu_time else 0 end) as logmr_cpu, sum(case when session_type in ( 'STREAMS Capture' ) then delta_cpu_time else 0 end) as captr_cpu, sum(case when session_type in ( 'Propagation Sender' , 'Propagation Receiver' ) then delta_cpu_time else 0 end) as prpgt_cpu, sum(case when session_type in ( 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' ) then delta_cpu_time else 0 end) as apply_cpu, sum(case when session_type in ( 'QMON Slaves' , 'QMON Coordinator' ) then delta_cpu_time else 0 end) as qmon_cpu FROM ( SELECT b.session_type, (case when b.min_logon_time = e.min_logon_time then e.sum_cpu_time - b.sum_cpu_time else e.sum_cpu_time end) as delta_cpu_time FROM wrh$_sess_time_stats b, wrh$_sess_time_stats e WHERE b.dbid = :dbid AND b.instance_number = :instance_number AND b.snap_id = :startsn AND e.dbid = :dbid AND e.instance_number = :instance_number AND e.snap_id = :endsn AND e.se
ssion_type = b.session_type AND e.session_type in ( 'Logminer Reader' , 'Logminer Preparer' , 'Logminer Builder' , 'STREAMS Capture' , 'Propagation Sender' , 'Propagation Receiver' , 'STREAMS Apply Reader' , 'STREAMS Apply Server' , 'STREAMS Apply Coordinator' , 'QMON Slaves' , 'QMON Coordinator' ) ) all_types |
10xj8nynmpqtq |
SELECT dbin.db_name, dbin.instance_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = :inst_num AND s2.instance_number = :inst_num AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.instance_number = s1.instance_number AND dbin.startup_t
ime = s1.startup_time |
14566d856s6hs | SELECT owner# FROM sys.wri$_adv_tasks WHERE id = :1 |
1bsp1wphh5m3r |
SELECT ZS.C_ZSH, HXM.C_XMH, HXM.C_GYSBM, GYS.C_MC C_GYSMC, HXM.C_WLCKBM, (SELECT C_CKMC FROM TW_CKZSJ WHERE C_CKBM = HXM.C_WLCKBM) C_WLCKMC, ZS.C_WLDWBM, ZZ.C_MC C_WLDWMC, HXM.C_WLBM, WL.C_WLMC, HXM.C_PLX, HXM.C_SL C_JHJHSL, HXM.C_ZXSL C_SJSHSL, HXM.C_JHSFSJ C_JHJHSJ, (SELECT MAX(T2.C_JZRQ) C_JZRQ FROM TW_WLYDPZ T2 WHERE EXISTS (SELECT 1 FROM TW_WLYDPZMX T1 WHERE T1.C_PZH = T2.C_PZH AND T1.C_ZSH = ZS.C_ZSH AND T1.C_ZSXMH = HXM.C_XMH AND T1.C_CXBJ = '0') AND (T2.C_YWLBBM = '52T5' OR T2.C_YWLBBM = '52T7')) C_SJSHSJ, HXM.C_ZXZT, YW.C_YWLBMC, (CASE HXM.C_LLLX WHEN '0' THEN '¿´°å' WHEN '1' THEN 'ÀÁÏ' ELSE '' END) AS C_LLLX, COLOR.YSMC C_WLYSMC, ZS.C_QXBJ, ZS.C_GBBJ, HXM.C_GCBGY, HXM.C_GCBGYMC FROM TW_WLYDZS ZS LEFT JOIN TW_WLYDZSHXM HXM ON HXM.C_ZSH = ZS.C_ZSH LEFT JOIN T_WLZSJ WL ON WL.C_WLBM = HXM.C_WLBM LEFT JOIN T_ZZZSJ ZZ ON ZS.C_WLDWBM = ZZ.C_ZZBM LEFT JOIN T_GYSZSJ GYS ON HXM.C_GYSBM = GYS.C_GYSBM LEFT JOIN TW_YWLBZSJ YW ON ZS.C_YWLBBM = YW.C_YWLBBM LEFT JOIN TBASCOLOR COLOR ON HXM.C_WLYSBM = COLOR.YSBM WHERE (ZS.C_YWLBBM = '52T5' OR ZS.C_YWLBBM = '52T7') AND ZS.C_ZZBM = :B10 AND ((:B9 IS NULL) OR (HXM.C_GYSBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B9 )))))) AND ((:B8 IS NULL) OR (ZS.C_WLDWBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B8 )))))) AND ((:B7 IS NULL) OR (HXM.C_CKBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B7 )))))) AND ((:B6 IS NULL) OR (HXM.C_WLBM IN (SELECT * FROM TABL
E(CO
LLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B6 )))))) AND ((:B5 IS NULL) OR (ZS.C_ZXZT IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B5 )))))) AND NVL(ZS.C_QXBJ, '0') IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B11 )))) AND NVL(ZS.C_GBBJ, '0') IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B12 )))) AND ((:B4 IS NULL) OR ZS.C_YWLBBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B4 ))))) AND ((:B3 IS NULL) OR HXM.C_LLLX IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B3 ))))) AND HXM.C_JHSFSJ >= TO_DATE(:B2 , 'YYYY-MM-DD HH24:MI:SS') AND HXM.C_JHSFSJ <= (TO_DATE(:B1 , 'YYYY-MM-DD HH24:MI:SS') + 1) |
1cjy8v3c0agny | select sys_nc_oid$ from xdb.xdb$resource where rowid = :1 |
1ykxq1vvu3pw5 | BEGIN Prc_Mps_Gyscgbljc(:1, :2, :3, :4, :5); END; |
255j544nntz6k |
SELECT jhd.gysbm zzbm, (SELECT zz.zzmc FROM tprizzjg zz WHERE jhd.gysbm=zz.zzbm) Zzmc, Jhd.Wlgs, Jhd.Jhqdh, To_Char(Jhd.Jhrq, :"SYS_B_00") JHRQ, (SELECT dhd FROM TLOGICJHDMX MX WHERE Mx.Jhqdh = :"SYS_B_01" AND RowNum=:"SYS_B_02") DHD, (select case when lld.xqlx = :"SYS_B_03" then to_char(to_date(substr(jk.yjdhsj, :"SYS_B_04", :"SYS_B_05"), :"SYS_B_06"), :"SYS_B_07") || :"SYS_B_08" || to_char(to_date(substr(jk.yjdhsj, :"SYS_B_09", :"SYS_B_10"), :"SYS_B_11"), :"SYS_B_12") else to_char(to_date(substr(jk.yjdhsj, :"SYS_B_13", :"SYS_B_14"), :"SYS_B_15"), :"SYS_B_16") end dhrq from tlogicjhdmx jhdmx inner join tmeslldmx lldmx on lldmx.djh = jhdmx.djh and lldmx.djhh = jhdmx.djhh inner join tmeslld lld on lld.djh = lldmx.djh inner join mes2scf_mf05 jk on jk.djbh = lldmx.meslldh and jk.xqsbh = lldmx.meslldhh where jhdmx.jhqdh = :"SYS_B_17" and rownum = :"SYS_B_18" ) Dhsj, (SELECT lldmx.xggys FROM Tlogicjhdmx Jhdmx INNER JOIN tmeslldmx lldmx ON lldmx.djh =jhdmx.djh AND lldmx.djhh =jhdmx.djhh WHERE Jhdmx.Jhqdh=:"SYS_B_19" AND rownum = :"SYS_B_20" ) Gys, CASE WHEN (SELECT Lld.Xqlx FROM Tlogicjhdmx Jhdmx INNER JOIN Tmeslld Lld ON Lld.Djh = Jhdmx.Djh WHERE Jhdmx.Jhqdh = :"SYS_B_21" AND Rownum = :"SYS_B_22")=:"SYS_B
_23" THEN :"SYS_B_24" ELSE :"SYS_B_25" END AS YWFS FROM Tlogicjhd Jhd WHERE Jhqdh=:"SYS_B_26" |
2baqvamkstzv2 | begin pw_add_yjzsscpz(:1, :2, :3); end; |
2f8gjukz261fc | select distinct t.c_kjzq jhny from tw_xlhz t order by t.c_kjzq desc |
2g7sybaxj1fk0 | UPDATE MONITERTAB m SET m.DATACOUNT=(SELECT COUNT(:"SYS_B_0") FROM Mes2scf_Mf03 WHERE TRANSJOBID=:"SYS_B_1") WHERE m.TRANSJOBID=:"SYS_B_2" |
2ghbsfvq9mn3v | INSERT /*+ NO_PARTIAL_COMMIT REF_CASCADE_CURSOR */ INTO "SCF2"."TW_WLYDPZMX_XLH" ("NESTED_TABLE_ID", "COLUMN_VALUE") VALUES(:1, :2) |
2qd9gma0nnm1r | INSERT INTO TNOTEMONITOR (RWBH, BZR, BZRQ, JSR, JSDW, YWM, YWLX, RWZT, CLRQ) VALUES (SEQ_NOTEMONITOR.NEXTVAL, 'sys', SYSDATE, NVL(:B3 , :B2 ), NVL(:B3 , :B2 ), :B1 , '7010', '0', NULL) |
2tq3dknsjum6d | SELECT :"SYS_B_0" FROM DUAL |
32b5nn8haqrnf | UPDATE monitertab SET OUTTIME=null, TRANSTIME=sysdate WHERE ID=:"SYS_B_0" |
350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
36xv24xb072uq | BEGIN pkg_ifc_mes.prc_ifc_rxjhdd(:1, :2, :3, :4); END; |
393drhftjj4dt | BEGIN Pw_Add_Impmmdsap(:1, :2, :3); END; |
3c1kubcdjnppq | update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln |
3m8smr0v7v1m6 | INSERT INTO sys.wri$_adv_message_groups (task_id, id, seq, message#, fac, hdr, lm, nl, p1, p2, p3, p4, p5) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13) |
3utzy3g1xn2g3 |
SELECT HXM.C_ZSH, ZS.C_ZSLY, HXM.C_XMH, HXM.C_CKBM, CKZSJ.C_CKMC, HXM.C_WLBM, (SELECT WL.C_WLMC FROM T_WLZSJ WL WHERE WL.C_WLBM = HXM.C_WLBM AND ROWNUM = 1) C_WLMC, HXM.C_GYSBM C_ZSGYSBM, GYSZSJ.C_MC C_ZSGYSMC, HXM.C_WLTSYT, HXM.C_WLYSBM, (SELECT YSQD.C_YSMC FROM T_YSQD YSQD WHERE YSQD.C_YSBM = HXM.C_WLYSBM AND ROWNUM = 1) C_WLYSMC, HXM.C_WLBB, HXM.C_JLDW, HXM.C_SL, NVL(HXM.C_ZXSL, 0) C_ZXSL, HXM.C_GYSPC, HXM.C_DDH, HXM.C_DDHH, HXM.C_CKPZH, HXM.C_CKPZHH, HXM.C_SNP, HXM.C_XSQY, HXM.C_YDYY, (SELECT YDYY.C_WLYDYYMC FROM T_WLYDYY YDYY WHERE YDYY.C_WLYDYYBM = HXM.C_YDYY AND ROWNUM = 1) C_YDYYMC, HXM.C_WLCKBM, CKZSJ2.C_CKMC C_WLCKMC, HXM.C_CJR, HXM.C_CJSJ, HXM.C_XGR, HXM.C_XGSJ, NVL(HXM.C_QXBJ, '0') C_QXBJ, NVL(HXM.C_GBBJ, '0') C_GBBJ, HXM.C_ZXZT, NVL(DDMX.C_DGSL, 0) C_DGSL, NVL(ZT.C_ZTSL, 0) C_ZTSL, NVL(ZT.C_SRSL, 0) C_DHSL, WLMX.C_ZSH MXC_ZSH, WLMX.C_ZSXMH MXC_ZSXMH, WLMX.C_ZSHH MXC_ZSHH, WLMX.C_QWBM MXC_QWBM, WLMX.C_CWBM MXC_CWBM, WLMX.C_PC MXC_PC, FW_CONVERT_XLHTOFLAT(WLMX.C_XLH) MXC_XLH, WLMX.C_SL MXC_SL, WLMX.C_SJSL MXC_SJSL, WLMX.C_KCLX MXC_KCLX, WLMX.C_KCZT MXC_KCZT, WLMX.C_WLQWBM MXC_WLQWBM, WLMX.C_WLCWBM MXC_WLCWBM, WLMX.C_SFWLBM MXC_SFWLBM, WLMX.C_SFPC MXC_SFPC, WLMX.C_CJR MXC_CJR, WLMX.C_CJSJ MXC_CJSJ, WLMX.C_XGR MXC_XGR, WLMX.C_XGSJ MXC_MXXGSJ, WLMX.C_SCR MXC_SCR, WLMX.C_SCSJ MXC_SCSJ, WLMX.C_QRR MXC_QRR, WLMX.C_QRSJ MXC_QRSJ, WLMX.C_ZXZT MXC_ZXZT, PZZT.C_FCSL PZZTC_FCSL, PZZT.C_SRSL PZZTC_SRSL, PZZT.
C_ZTSL PZZTC_ZTSL, DDZT.C_SRSL DDZTC_SRSL, DDZT.C_FCSL DDZTC_FCSL, DDZT.C_ZTSL DDZTC_ZTSL, CJZT.C_FCSL CJZTC_FCSL, CJZT.C_SRSL CJZTC_SRSL, CJZT.C_ZTSL CJZTC_ZTSL, CKZT.C_FCSL CKZTC_FCSL, CKZT.C_SRSL CKZTC_SRSL, CKZT.C_ZTSL CKZTC_ZTSL, CGDD.C_CGLX C_CGLX, CGDD.C_DDZT, DDMX.C_DDHZT, PZMX.C_KCLX CMXC_CKPZKCLX, PZMX.C_KCZT CMXC_CKPZKCZT, FW_GET_BGYBM(ZS.C_ZZBM, HXM.C_CKBM, HXM.C_WLBM, WLMX.C_QWBM, WLMX.C_CWBM, NVL(HXM.C_GYSBM, WLMX.C_GYSBM)) C_BGYBM, (SELECT T.YGMC FROM TPRIYGZSJ T WHERE T.ZZBM = ZS.C_ZZBM AND T.YGBM = FW_GET_BGYBM(ZS.C_ZZBM, HXM.C_CKBM, HXM.C_WLBM, WLMX.C_QWBM, WLMX.C_CWBM, NVL(HXM.C_GYSBM, WLMX.C_GYSBM))) MXC_BGYXM, WLMX.C_GYSBM, MXGYS.C_MC C_GYSMC, HXM.C_BZ, HXM.C_PLX, TO_CHAR(HXM.C_DHSJ, 'yyyy-mm-dd hh24:mi:ss') C_DHSJ, HXM.C_LLLX, HXM.C_GCBGY, HXM.C_GCBGYMC, HXM.C_ZJHGXX, HXM.C_SAPPZXX, HXM.C_KCZT C_ZSKCZT, (SELECT ZD.C_MC FROM T_SJZD ZD WHERE ZD.C_CLBM = HXM.C_KCZT) C_ZSKCZTMC, TO_CHAR(HXM.C_JHSFSJ, 'yyyy-mm-dd hh24:mi:ss') C_JHSFSJ FROM TW_WLYDZSHXM HXM LEFT JOIN TW_WLYDZSWLMX WLMX ON HXM.C_ZSH = WLMX.C_ZSH AND HXM.C_XMH = WLMX.C_ZSXMH LEFT JOIN T_GYSZSJ MXGYS ON WLMX.C_GYSBM = MXGYS.C_GYSBM LEFT JOIN TW_WLYDZS ZS ON HXM.C_ZSH = ZS.C_ZSH LEFT JOIN T_GYSZSJ GYSZSJ ON HXM.C_GYSBM = GYSZSJ.C_GYSBM LEFT JOIN TW_CKZSJ CKZSJ ON HXM.C_CKBM = CKZSJ.C_CKBM LEFT JOIN TW_CKZSJ CKZSJ2 ON HXM.C_WLCKBM = CKZSJ2.C_CKBM LEFT JOIN TW_CJPZZT ZT ON HXM.C_DDH = ZT.C_PZH AND HXM.C_DDHH = ZT.C_PZHH LEFT JOIN T_CGDDMX DDMX ON HXM.C_DDH
= DDMX.C_CGDDH AND HXM.C_DDHH = DDMX.C_CGDDHH LEFT JOIN T_CGDD CGDD ON DDMX.C_CGDDH = CGDD.C_CGDDH LEFT JOIN TW_CJPZZT PZZT ON HXM.C_ZSH = PZZT.C_PZH AND HXM.C_XMH = PZZT.C_PZHH LEFT JOIN TW_CJPZZT DDZT ON HXM.C_DDH = DDZT.C_PZH AND HXM.C_DDHH = DDZT.C_PZHH LEFT JOIN TW_YWLBZSJ YWLB ON ZS.C_YWLBBM = YWLB.C_YWLBBM LEFT JOIN TW_CJZT CJZT ON DECODE(YWLB.C_JZFX, '-', CJZT.C_FHDWBM, '+', CJZT.C_SHDWBM) = ZS.C_ZZBM LEFT JOIN TW_CJZT CKZT ON DECODE(YWLB.C_JZFX, '-', CJZT.C_FHDWBM, '+', CJZT.C_SHDWBM) = HXM.C_CKBM LEFT JOIN TW_WLYDPZMX PZMX ON HXM.C_CKPZH = PZMX.C_PZH AND HXM.C_CKPZHH = PZMX.C_PZHH LEFT JOIN TW_WLYDPZ PZ ON HXM.C_CKPZH = PZ.C_PZH WHERE HXM.C_ZSH = :B1 ORDER BY HXM.C_WLBM ASC |
44m843r687ymt | BEGIN pkg_ifc_mes.IFC_MES_SCF_SCSJ(:1, :2); END; |
451q2032pshqm | select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# |
4m7m0t6fjcs5x | update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1 |
4spc68yrsgfnw | INSERT INTO tw_sapwlpz (jkbh, sgwlpzh, sgpzhh, gcbh, wlpzbh, cgbs) VALUES (:"SYS_B_0", :"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5") |
4tanzh2jp8tsn | select BO from SYSTASKBO where TASKID=:"SYS_B_0" |
4tw9rjrv9rusc | insert into MES2SCF_MF05_HIS (id, sessionid, DJBH, JHRQ, JHX, XQSBH, WLH, LBJMC, YS, JLDW, YHSL, SNP, BGYBM, BGYMC, SHCK, YJDHSJ, ZWDHSJ, GYSBM, TSYT, LLLX, BZ, SCX, GW, WLXHD, ZZBM, JJBJ, JJYY, CXH, FBSJ) values (seq_payment.nextval, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", :"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21", :"SYS_B_22", :"SYS_B_23", :"SYS_B_24", :"SYS_B_25", :"SYS_B_26", :"SYS_B_27") |
53bcag0kh0k2y | select distinct t1.wlbm c_wlbm, t2.C_WLMC, t2.C_JLDW, t1.gysbm c_gysbm, t1.gysmc c_gysmc, t3.ygbm as c_ygbm, t3.ygmc as c_ygmc, (Select C_Snp From T_Wlbz Bz Where Bz.C_Zzbm = :"SYS_B_0" And Bz.C_Gys = T1.Gysbm And Bz.C_Wlbm = T1.Wlbm and rownum=:"SYS_B_1") c_snp from tw_gysghcp t1 left join t_wlzsj t2 on t1.wlbm = t2.C_WLBM left join tpriygzsj t3 on fw_get_bgybm(:"SYS_B_2", :"SYS_B_3", t1.wlbm, :"SYS_B_4", :"SYS_B_5", t1.gysbm) = t3.ygbm where t1.gysbm in (:"SYS_B_6") |
546whxffw127p |
SELECT WLBM, WLMC, TSYT, TSYTMC, WLYS, YSMC, AQKC, DQKC, TO_CHAR(XQRQ, 'yyyy-MM-dd') XQRQ, XQSL, (DECODE(:B11 , '1', (DQKC - AQKC - XQZL), (DQKC - XQZL))) XQCY FROM (SELECT WLBM, (SELECT WLMC FROM TPRIWLZSJ WLZSJ WHERE WLZSJ.WLBM = XQHZ.WLBM) WLMC, TSYT, (SELECT C_MC FROM T_SJZD SJZD WHERE SJZD.C_CLBM = XQHZ.TSYT) TSYTMC, WLYS, (SELECT YSMC FROM TBASCOLOR COLOR WHERE XQHZ.WLYS = COLOR.YSBM) YSMC, NVL((SELECT C_AQKCSL FROM TW_GYSAQKCCSWH AQKC WHERE AQKC.C_GYSBM = :B3 AND AQKC.C_ZZBM = '8000' AND AQKC.C_WLBM = XQHZ.WLBM), 0) AQKC, NVL((SELECT SUM(C_ZMSL) FROM TW_RJZZ RJZZ INNER JOIN TW_PCZSJ PCZSJ ON RJZZ.C_ZZBM = PCZSJ.C_ZZBM AND RJZZ.C_PC = PCZSJ.C_PC WHERE PCZSJ.C_YSGYSBM = :B3 AND RJZZ.C_ZZBM = :B10 AND RJZZ.C_WLBM = XQHZ.WLBM AND DECODE(PCZSJ.C_WLTSYT, :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B4 ) = NVL(XQHZ.TSYT, :B4 ) AND NVL(PCZSJ.C_WLYSBM, '-') = NVL(XQHZ.WLYS, '-') ), 0) DQKC, XQRQ, SUM(XQSL) XQSL, NVL((SELECT SUM(XQSL) XQLJ FROM TMRPRDXQHZ B WHERE B.GYSBM = :B3 AND B.XQDW <> '8918' AND B.WLBM = XQHZ.WLBM AND B.XQRQ >= TRUNC(SYSDATE) AND B.XQRQ <= XQHZ.XQRQ AND NVL(B.WLYS, '-') = NVL(XQHZ.WLYS, '-') AND NVL(B.TSYT, :B4 ) = NVL(XQHZ.TSYT, :B4 )), 0) XQZL FROM TMRPRDXQHZ XQHZ WHERE GYSBM = :B3 AND XQDW <> '8918' AND (WLBM = '' OR WLBM LIKE '%' || :B2 || '%') AND XQRQ >= TRUNC(SYSDATE) AND XQRQ < TRUNC(SYSDATE) + :B1 GROUP BY XQHZ.WLBM, XQHZ.XQRQ, XQHZ.TSYT, XQHZ.WLYS) WHERE XQSL <> 0 ORDER BY WLBM, T
SYT, WLYS, XQRQ |
54aydkdm8fvdd | update TW_WLYDZSHXMTEMP t set t.c_dhsj=to_date(:"SYS_B_0", :"SYS_B_1") where t.c_ph=:"SYS_B_2" and t.c_xmh=:"SYS_B_3" |
5an8d9ctcysja | SELECT (case when snap_id = :startsn then 1 else 0 end) as start_snap, (case when name = 'maximum PGA allocated' then 1 when name = 'total PGA allocated' then 2 when name = 'over allocation count' then 3 when name = 'recompute count (total)' then 4 else 0 end) as stat_id, value FROM WRH$_PGASTAT pga WHERE pga.dbid = :dbid AND pga.instance_number = :instance_number AND (pga.snap_id = :startsn OR pga.snap_id = :endsn) AND pga.name IN ( 'maximum PGA allocated' , 'total PGA allocated' , 'over allocation count' , 'recompute count (total)' ) ORDER BY snap_id, stat_id |
5jxwda6s8nvc7 | select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b)) |
5ur69atw3vfhj | select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1 |
5utqvfqf8513d | BEGIN pkg_ifc_mes.prc_ifc_zsllkb(:1, :2); END; |
5wssrc6y3ypuf |
update SCF2SAP_SF17_GOODSMVT_ITEM set ACTIVITY=:1, ACTTYPE=:2, AMOUNT_LC=:3, AMOUNT_SV=:4, ASSET_NO=:5, BASE_UOM=:6, BATCH=:7, CALC_MOTIVE=:8, CMMT_ITEM=:9, CMMT_ITEM_LONG=:10, COMP_SHIP=:11, COSTCENTER=:12, COST_OBJ=:13, CO_BUSPROC=:14, CREATEDATE=:15, CUSTOMER=:16, DELIV_ITEM=:17, DELIV_ITEM_TO_SEARCH=:18, DELIV_NUMB=:19, DELIV_NUMB_TO_SEARCH=:20, EAN_UPC=:21, ENTRY_QNT=:22, ENTRY_UOM=:23, ENTRY_UOM_ISO=:24, EXPIRYDATE=:25, FUNC_AREA=:26, FUNC_AREA_LONG=:27, FUND=:28, FUNDS_CTR=:29, GL_ACCOUNT=:30, GRANT_NBR=:31, GR_NUMBER=:32, GR_RCPT=:33, GR_RCPTX=:34, IND_PROPOSE_QUANX=:35, ITEM_TEXT=:36, LINE_DEPTH=:37, LINE_ID=:38, MATDOC_TR_CANCEL=:39, MATERIAL=:40, MATERIAL_EXTERNAL=:41, MATERIAL_GUID=:42, MATERIAL_VERSION=:43, MATITEM_TR_CANCEL=:44, MATYEAR_TR_CANCEL=:45, MOVE_BATCH=:46, MOVE_MAT=:47, MOVE_MAT_EXTERNAL=:48, MOVE_MAT_GUID=:49, MOVE_MAT_VERSION=:50, MOVE_PLANT=:51, MOVE_REAS=:52, MOVE_STLOC=:53, MOVE_TYPE=:54, MOVE_VAL_TYPE=:55, MVT_IND=:56, NB_SLIPS=:57, NB_SLIPSX=:58, NETWORK=:59, NO_MORE_GR=:60, NO_PST_CHGNT=:61, NO_TRANSFER_REQ=:62, ORDERID=:63, ORDERPR_UN=:64, ORDERPR_UN_ISO=:65, ORDER_ITNO=:66, PARENT_ID=:67, PART_ACCT=:68, PAR_COMPCO=:69, PLANT=:70, PO_ITEM=:71, PO_NUMBER=:72, PO_PR_QNT=:73, PROD_DATE=:74, PROFIT_CTR=:75, PROFIT_SEGM_NO=:76, QUANTITY=:77, REF_DATE=:78, REF_DOC=:79, REF_DOC_IT=:80, REF_DOC_YR=:81, RESERV_NO=:82, RES_ITEM=:83, RES_TYPE=:84, RL_EST_KEY=:85, SALES_
ORD=:86, SCHED_LINE=:87, SERIALNO_AUTO_NUMBERASSIGNMENT=:88, SESSIONID=:89, SHIPPING=:90, SPEC_MVMT=:91, SPEC_STOCK=:92, STATUS=:93, STCK_TYPE=:94, STGE_BIN=:95, STGE_BIN_PC=:96, STGE_BIN_ST=:97, STGE_LOC=:98, STGE_TYPE=:99, STGE_TYPE_PC=:100, STGE_TYPE_ST=:101, ST_UN_QTYY_1=:102, ST_UN_QTYY_1_ISO=:103, ST_UN_QTYY_2=:104, ST_UN_QTYY_2_ISO=:105, SUB_NUMBER=:106, SUPPL_VEND=:107, SU_PL_STCK_1=:108, SU_PL_STCK_2=:109, S_ORD_ITEM=:110, TR_PART_BA=:111, UNITTYPE_1=:112, UNITTYPE_2=:113, UNLOAD_PT=:114, UNLOAD_PTX=:115, VAL_SALES_ORD=:116, VAL_S_ORD_ITEM=:117, VAL_TYPE=:118, VAL_WBS_ELEM=:119, VENDOR=:120, VENDRBATCH=:121, WBS_ELEM=:122, WITHDRAWN=:123, XSTOB=:124 where id=:125 |
66txdn782z8c4 | INSERT INTO T_CLRKJHMX (C_CLRKJHMXXLH, C_BBH, C_CLRKJHQDXLH, C_SCXBM, C_CXH, C_DPCH, C_SCJHCXH, C_XQMXXLH, C_BC, C_YSBM, C_DDH, C_CLSX, C_SCSX, C_QYSX, C_TXM, C_RKRQ, C_RKSL, C_RKDW, C_RKDD, C_RKPZFL, C_TQSJ, C_DPH) SELECT T_CLRKJHMX_SEQ.NEXTVAL, 0, :B3 , V.C_SCXBM, V.C_CXH, V.C_DPCH, V.C_SCJHCXH, V.C_XQMXXLH, '3501', V.C_YSBM, V.C_DDH, V.C_CLSX, V.C_SCSX, V.C_QYSX, V.C_TXM, (SELECT MIN(C.C_RQ) FROM T_YDZGZTZ A, T_YDZGZTZMX B, T_RDGZTZMX C WHERE A.C_SCXBM = V.C_SCXBM AND A.C_YDZGZTZXLH = B.C_YDZGZTZXLH AND B.C_YDZGZTZMXXLH = C.C_YDZGZTZMXXLH AND C.C_RQ >= V.C_RKRQ AND EXISTS (SELECT NULL FROM T_SCX SCX WHERE SCX.C_JHZZBM = :B4 AND SCX.C_SCXBM = A.C_SCXBM) AND C.C_KDXS <> '0') C_RKRQ, V.C_BYJC, V.C_RKDW, V.C_RKDD, '0704', V.C_TQSJ, V.C_DPH FROM T_YJCSJ V WHERE V.C_DPH NOT IN (SELECT NVL(MX.C_DPH, 'no_dph') FROM T_CLRKJHMX MX WHERE MX.C_CLRKJHQDXLH = :B3 AND MX.C_RKPZFL = '0704') AND C_RKRQ >= :B2 AND C_RKRQ <= :B1 AND EXISTS (SELECT NULL FROM T_SCX SCX WHERE V.C_SCXBM = SCX.C_SCXBM AND C_JHZZBM = :B4 ) |
6r58mcgr1p2mj | SELECT A.C_CWTS FROM TW_WLYDZSHXMTEMP A WHERE EXISTS (SELECT 1 FROM TW_WLYDZSHXM T WHERE T.C_CKBM = A.C_CKBM AND T.C_GYSBM = A.C_GYSBM AND T.C_WLBM = A.C_WLBM AND T.C_SL = A.C_SL AND T.C_LLLX = A.C_LLLX AND T.C_WLCKBM = A.C_WLCKBM AND TO_CHAR(T.C_CJSJ, 'yyyy-mm-dd') = TO_CHAR(A.C_CJSJ, 'yyyy-mm-dd') AND TO_CHAR(A.C_DHSJ, 'yyyy-mm-dd HH24:MI') = TO_CHAR(T.C_DHSJ, 'yyyy-mm-dd HH24:MI')) AND A.C_PH = :B1 FOR UPDATE OF A.C_CWTS |
7a14h94mg3817 | UPDATE MONITERTAB SET tradecount=tradecount+:"SYS_B_0" WHERE transjobid=:"SYS_B_1" |
7ccj64p5ga76t | INSERT INTO TEMP_CGBLJY (WLBM, WLMC, NCGBL, ZXRQ, JZRQ, FBRMC, CGBL) SELECT DISTINCT WLBM, WLMC, NCGBL, ZXRQ, JZRQ, FBRMC, CGBL FROM (SELECT X.C_WLBM WLBM, (SELECT WLMC FROM TPRIWLZSJ ZSJ WHERE ZSJ.WLBM = X.C_WLBM) WLMC, NVL(Z.NCGBL, 0) NCGBL, (SELECT NVL(SUM(NCGBL), 0) FROM TCGBLQD QD WHERE QD.ZZBM = Y.CGZZBM AND QD.WLBM = X.C_WLBM AND TO_CHAR(X.C_XQRQ, 'yyyymmdd') BETWEEN QD.ZXRQ AND QD.JZRQ) CGBL, Z.ZXRQ, Z.JZRQ, Z.FBRMC, Q.WLBM QXWLBM FROM (SELECT JG.C_WLBM, MX.C_XQRQ, MX.C_FLBM, MX.C_XQDW FROM T_CXBOMJGZB JG, TEMP_XQMX_L MX WHERE JG.C_CXH = MX.C_CXH AND JG.C_QYRQ = MX.C_TQSJ AND JG.C_SCSX = MX.C_SCSX AND JG.C_ZPLX <> 'JQ' AND JG.C_ZZLX = 'CK') X LEFT JOIN TPARXQKZCS P ON X.C_FLBM = P.ZZBM AND X.C_XQDW = P.XQDW LEFT JOIN TPRICGZFW Y ON P.SCDWBM = Y.XQDWBM LEFT JOIN (SELECT WLBM, ZZBM, SUM(NVL(NCGBL, 0)) NCGBL, ZXRQ, JZRQ, FBRMC FROM TCGBLQD GROUP BY WLBM, ZZBM, ZXRQ, JZRQ, FBRMC) Z ON X.C_WLBM = Z.WLBM AND Y.CGZZBM = Z.ZZBM AND TO_CHAR(X.C_XQRQ, 'yyyymmdd') BETWEEN Z.ZXRQ AND Z.JZRQ LEFT JOIN TWLZFQD Q ON Y.CGZBM = Q.CGZBM AND X.C_WLBM = Q.WLBM) WHERE QXWLBM IS NULL |
7f039z54cu4rx | SELECT * FROM TW_WLYDPZMX T WHERE T.C_PZH = :B2 AND T.C_PZHH = :B1 |
7rppp6v5grwqg | BEGIN PRC_MPS_IN_NO4STORAGE(:1, :2); END; |
7t3bfw6kvdunq |
SELECT a.sessionid, decode(a.status, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07") status, a.material, m.c_wlmc, a.plant, (SELECT zzmc FROM scf2.tprizzzsj WHERE zzbm = a.plant) plantname, a.stge_loc, a.batch, a.move_type, a.entry_qnt, a.entry_uom, a.item_text, a.mvt_ind, b.pstng_date, b.doc_date, (SELECT c.message FROM scf2sap_sf17_export c WHERE a.sessionid = c.sessionid AND regexp_like(a.item_text, :"SYS_B_08" || c.s_row || :"SYS_B_09") AND rownum = :"SYS_B_10") message, b.gr_gi_slip_no pzh, d.wlpzbh sappzh, e.c_cjr, (SELECT ygmc FROM tpriygzsj WHERE ygbm = e.c_cjr) cjr, a.vendor gysbm, (SELECT q.zzmc FROM scf2.tprizzjg q WHERE q.zzlx = :"SYS_B_11"
AND q.zzbm = a.vendor AND rownum = :"SYS_B_12") gysmc FROM scf2.scf2sap_sf17_goodsmvt_item a INNER JOIN scf2.scf2sap_sf17_import b ON b.sessionid = a.sessionid LEFT JOIN scf2.tw_sapwlpz d ON d.sgwlpzh || :"SYS_B_13" || d.sgpzhh = a.item_text AND d.gcbh = a.plant LEFT JOIN scf2.tw_wlydpz e ON e.c_pzh = :"SYS_B_14" || b.gr_gi_slip_no LEFT JOIN t_wlzsj m ON a.material = m.c_wlbm WHERE :"SYS_B_15"=:"SYS_B_16" AND PLANT = :"SYS_B_17" AND B.PSTNG_DATE >= :"SYS_B_18" AND B.PSTNG_DATE <= :"SYS_B_19" AND B.doc_date >= :"SYS_B_20" AND B.doc_date <= :"SYS_B_21"AND a.status IN (select column_value from table(collection_wrapper(fw_split_into_vc100(:"SYS_B_22")))) AND e.c_cjr in (select * from table(collection_wrapper(fw_split_into_vc100(:"SYS_B_23"))))
|
8dqa7bn175qhu | UPDATE WRH$_SQLTEXT SET snap_id = :lah_snap_id WHERE dbid = :dbid AND (SQL_ID) IN (SELECT STR1_KEWRATTR FROM X$KEWRATTRSTALE) |
8swypbbr0m372 | select order#, columns, types from access$ where d_obj#=:1 |
8x2vjs56gj3a6 | BEGIN PRC_MPS_problemDeliveryDate(:1, :2, :3, :4); END; |
95jdqszh5gv9s | SELECT MX.C_CXH, MX.C_SCJHCXH, MX.C_CLYS, MX.C_SCSX, MX.C_CLSX, MX.C_XSQY, MX.C_TQSJ, QD.C_XQDW, (SELECT C_NY FROM T_ZYRL WHERE QD.C_KSSJ BETWEEN C_QSRQ AND C_ZZRQ AND C_JHZZBM = :B2 ) C_NY, MX.C_DZL + NVL(ZX.C_WZXZL, 0) C_SL, MX.C_DDH, MX.C_XQMXXLH, MX.C_BZ, MX.C_BZ2, MX.C_BZ3 FROM T_XQQD QD, T_XQMX MX LEFT JOIN T_ZXXQMX ZX ON MX.C_XQMXXLH = ZX.C_XQMXXLH WHERE MX.C_XQQDXLH = :B1 AND QD.C_XQQDXLH = MX.C_XQQDXLH AND MX.C_XQLB IN ('0704', '0705') AND (MX.C_SCSX <> '0403' OR MX.C_SCSX = '0403' AND ((SELECT SUBSTR(MIN(SOPTAG), 0, 3) FROM T_KPCCXQD WHERE SCJHCX = MX.C_SCJHCXH AND MSOP = '0403')) NOT IN ('111')) AND ((QD.C_XQLX || QD.C_XQBBH = 'NO23401') OR INSTR((SELECT ', ' || STRCAT(NVL(C_MC, '-')) || ', ' FROM T_SJZD WHERE UPPER(C_QZ) = 'FLCC' AND C_CLBM LIKE '53%'), ', ' || MX.T_TBDW || ', ') = 0) AND MX.C_DZL + NVL(ZX.C_WZXZL, 0) > 0 |
9qfvjprb5psvp |
SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS.C_YWLBBM, YWLB.C_YWLBMC, YWLB.C_WLYDLXBM, ZS.C_ZZBM, ZZ.C_MC C_ZZMC, ZS.C_WLDWBM, DECODE(YWLB.C_WLDWLX, '1601', GYS.C_MC, '1602', KH.C_MC, '1603', WLDW.C_MC, '1604', CBZX.C_CBZXMC, '') C_WLDWMC, (SELECT TO_CHAR(MIN(H.C_JHSFSJ), 'YYYY-MM-DD') FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_JHSFSJ, (SELECT TO_CHAR(MAX(H.C_JHSFSJ), 'YYYY-MM-DD') FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_JHJSSJ, ZS.C_ZSLY, NVL(ZS.C_QXBJ, '0') C_QXBJ, NVL(ZS.C_GBBJ, '0') C_GBBJ, ZS.C_ZXZT, ZS.C_CJR, (SELECT YG.YGMC FROM TPRIYGZSJ YG WHERE YG.YGBM = ZS.C_CJR) C_CJRMC, TO_CHAR(ZS.C_CJSJ, 'yyyy-mm-dd hh24:mi:ss') C_CJSJ, ZS.C_XGR, (SELECT YG.YGMC FROM TPRIYGZSJ YG WHERE YG.YGBM = ZS.C_CJR) C_XGRMC, TO_CHAR(ZS.C_XGSJ, 'yyyy-mm-dd hh24:mi:ss') C_XGSJ FROM TW_WLYDZS ZS INNER JOIN TW_YWLBZSJ YWLB ON ZS.C_YWLBBM = YWLB.C_YWLBBM INNER JOIN T_ZZZSJ ZZ ON ZS.C_ZZBM = ZZ.C_ZZBM LEFT JOIN T_ZZZSJ WLDW ON ZS.C_WLDWBM = WLDW.C_ZZBM LEFT JOIN T_GYSZSJ GYS ON ZS.C_WLDWBM = GYS.C_GYSBM LEFT JOIN T_KHZSJ KH ON ZS.C_WLDWBM = KH.C_KHBM LEFT JOIN T_CBZXZSJ CBZX ON ZS.C_WLDWBM = CBZX.C_CBZXBH WHERE ZS.C_ZZBM = :B6 AND ZS.C_YWLBBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B7 ))) AND (:B2 IS NOT NULL OR :B5 = '1' OR (:B5 = '2' AND (ZS.C_CJSJ BETWEEN TO_DATE(:B4 || ' 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(:B3 || ' 23:59:59', 'yyyy-mm-dd hh24:mi:ss')))) AND (:B2 IS NULL OR INSTR(:B2 , ZS.C_ZSH) > 0) AND (:B1 IS NULL OR ZS.C_WLDWBM IN
(SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B1 )))) AND ZS.C_ZXZT IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B8 ))) AND NVL(ZS.C_QXBJ, '0') IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B9 ))) AND NVL(ZS.C_GBBJ, '0') IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B10 ))) AND EXISTS (SELECT 1 FROM TW_WLYDZSHXM HXM LEFT JOIN TM_ZZWLCS CS ON HXM.C_CKBM = CS.C_DHDBM LEFT JOIN TW_WLYDZSWLMX WLMX ON WLMX.C_ZSH = HXM.C_ZSH AND WLMX.C_ZSXMH = HXM.C_XMH WHERE HXM.C_ZSH = ZS.C_ZSH AND HXM.C_CKBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B15 ))) AND ((:B14 IS NULL) OR (HXM.C_DDH = :B14 )) AND (CS.C_ZZBM = ZS.C_ZZBM OR CS.C_ZZBM IS NULL) AND ((:B13 IS NULL) OR (FW_GET_BGYBM(ZS.C_ZZBM, HXM.C_CKBM, HXM.C_WLBM, WLMX.C_QWBM, WLMX.C_CWBM, NVL(HXM.C_GYSBM, HXM.C_GYSBM))) IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B13 )))) AND (:B2 IS NOT NULL OR :B5 = '2' OR (:B5 = '1' AND (HXM.C_JHSFSJ BETWEEN TO_DATE(:B4 || ' 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(:B3 || ' 23:59:59', 'yyyy-mm-dd hh24:mi:ss')))) AND (:B12 IS NULL OR (CS.C_ABCDFL IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B12 ))) OR CS.C_ABCDFL IS NULL)) AND (:B11 IS NULL OR HXM.C_WLBM IN (SELECT * FROM TABLE(FW_CONVERT_FLATTOXLH(:B11 ))))) |
9qmza4gnx5rj6 | insert into tw_pzdygxhxm(scfwlydpzh, scfwlydpzhh, wlydpzhh, cksl) select :"SYS_B_00", :"SYS_B_01", :"SYS_B_02", (select mx.c_sl from tw_wlydpzmx mx where mx.c_pzh=:"SYS_B_03" and mx.c_pzhh=:"SYS_B_04") cksl from tw_wlydpzmx t where t.c_pzh=:"SYS_B_05" and t.c_pzhh=:"SYS_B_06" and not exists (select :"SYS_B_07" from tw_pzdygxhxm gx where gx.scfwlydpzh=t.c_pzh and gx.scfwlydpzhh=:"SYS_B_08" and gx.wlydpzhh=:"SYS_B_09") and exists (select :"SYS_B_10" from tw_wlydpz pz where pz.c_pzh=t.c_pzh and pz.c_ywlbbm in (:"SYS_B_11", :"SYS_B_12")) |
a08ad1gmt11q9 | SELECT * FROM TW_WLYDPZMX WHERE C_PZH = :B1 |
akq326dzntuj6 | select distinct sessionid from SAP_06_REQUEST where STATUS=:"SYS_B_0" |
ayv0vhg5vbcg1 |
SELECT SQ.*, (SELECT ZZ.CKMC FROM TPRICKZSJ ZZ WHERE ZZ.CKBM = SQ.C_WLDWBM) C_SHDW, (SELECT YS.YSMC FROM TBASCOLOR YS WHERE YS.YSBM = SQ.C_WLYSBM) C_WLYSMC, (SELECT WL.C_WLMC FROM T_WLZSJ WL WHERE WL.C_WLBM = SQ.C_WLBM) C_WLMC FROM (SELECT KCZ.C_KJZQ, KCZ.C_ZZBM, KCZ.C_CKBM, KCZ.C_WLBM, KCZ.C_GYSBM, KCZ.C_WLYSBM, KCZ.C_KCZT, (SELECT ZD.MC FROM TPRISJZD ZD WHERE ZD.CLBM = KCZ.C_WLTSYT) C_WLTSYT, KCZ.C_QC, KCZ.C_BHGQC, BWBILL.C_RKPZH, BWBILL.C_RKSL, BWBILL.C_RKLB, BWBILL.C_RKRQ, BWBILL.C_CKPZH, BWBILL.C_CKSL, BWBILL.C_CKLB, BWBILL.C_CKRQ, BWBILL.C_WLDWBM, NVL(BWBILL.C_RKRQ, BWBILL.C_CKRQ) C_JZRQ FROM (SELECT T.C_KJZQ, T.C_ZZBM, T.C_CKBM, T.C_WLBM, T.C_KCZT, PCZSJ.C_YSGYSBM C_GYSBM, PCZSJ.C_WLYSBM, NVL(PCZSJ.C_WLTSYT, :B6 ) C_WLTSYT, (SELECT SUM(QC.C_QC) C_QC FROM TW_XLHZ QC LEFT JOIN TW_PCZSJ PC ON QC.C_ZZBM = PC.C_ZZBM AND QC.C_WLBM = PC.C_WLBM AND QC.C_PC = PC.C_PC WHERE QC.C_KJZQ = T.C_KJZQ AND QC.C_WLBM = T.C_WLBM AND QC.C_CKBM = T.C_CKBM AND QC.C_ZZBM = T.C_ZZBM AND PC.C_YSGYSBM = PCZSJ.C_YSGYSBM AND REGEXP_LIKE(:B9 , QC.C_KCZT) AND NVL(PC.C_WLTSYT, :B6 ) = NVL(PCZSJ.C_WLTSYT, :B6 ) AND NVL(PC.C_WLYSBM, '1') = NVL(PCZSJ.C_WLYSBM, '1')) C_QC, (SELECT SUM(QC.C_QC) C_QC FROM TW_XLHZ QC LEFT JOIN TW_PCZSJ PC ON QC.C_ZZBM = PC.C_ZZBM AND QC.C_WLBM = PC.C_WLBM AND QC.C_PC = PC.C_PC WHERE QC.C_KJZQ = T.C_KJZQ AND QC.C_WLBM = T.C_WLBM AND QC.C_CKBM = T.C_CKBM AND QC.C_ZZBM = T.C_ZZBM AND PC.C_YSGYSBM = PCZSJ.C_YSGYSBM AND REGEXP_LIKE(:B10 , Q
C.C_KCZT) AND NVL(PC.C_WLTSYT, :B6 ) = NVL(PCZSJ.C_WLTSYT, :B6 ) AND NVL(PC.C_WLYSBM, '1') = NVL(PCZSJ.C_WLYSBM, '1')) C_BHGQC FROM TW_XLHZ T LEFT JOIN TW_PCZSJ PCZSJ ON T.C_ZZBM = PCZSJ.C_ZZBM AND T.C_WLBM = PCZSJ.C_WLBM AND T.C_PC = PCZSJ.C_PC WHERE PCZSJ.C_YSGYSBM = :B2 AND T.C_KJZQ = :B5 AND T.C_ZZBM = :B4 AND T.C_CKBM = :B3 AND (:B1 IS NULL OR T.C_WLBM LIKE '%' || :B1 || '%') GROUP BY T.C_KJZQ, T.C_ZZBM, T.C_CKBM, T.C_WLBM, T.C_KCZT, PCZSJ.C_YSGYSBM, PCZSJ.C_WLYSBM, PCZSJ.C_WLTSYT) KCZ LEFT JOIN (SELECT M.C_KJZQ, M.C_ZZBM, S.C_CKBM, S.C_WLBM, S.C_KCZT, CASE WHEN REGEXP_LIKE(:B8 , B.C_YWLBBM) THEN M.C_PZH ELSE '' END C_RKPZH, CASE WHEN REGEXP_LIKE(:B8 , B.C_YWLBBM) THEN S.C_PZHH ELSE NULL END C_RKPZHH, CASE WHEN REGEXP_LIKE(:B8 , B.C_YWLBBM) THEN TO_CHAR(M.C_JZRQ, 'yyyy-mm-dd hh24:mi') ELSE NULL END C_RKRQ, CASE WHEN REGEXP_LIKE(:B8 , B.C_YWLBBM) THEN B.C_YWLBMC ELSE NULL END C_RKLB, CASE WHEN REGEXP_LIKE(:B8 , B.C_YWLBBM) THEN CASE B.C_JZFX WHEN '+' THEN C_SL ELSE C_SL * -1 END ELSE 0 END C_RKSL, CASE WHEN REGEXP_LIKE(:B7 , B.C_YWLBBM) THEN M.C_PZH ELSE '' END C_CKPZH, CASE WHEN REGEXP_LIKE(:B7 , B.C_YWLBBM) THEN S.C_PZHH ELSE NULL END C_CKPZHH, CASE WHEN REGEXP_LIKE(:B7 , B.C_YWLBBM) THEN TO_CHAR(M.C_JZRQ, 'yyyy-mm-dd hh24:mi') ELSE NULL END C_CKRQ, CASE WHEN REGEXP_LIKE(:B7 , B.C_YWLBBM) THEN B.C_YWLBMC ELSE NULL END C_CKLB, CASE WHEN REGEXP_LIKE(:B7 , B.C_YWLBBM) THEN S.C_WLCKBM ELSE NULL END C_WLDWBM, CASE WHEN REGEXP_LIKE(:B7 ,
B.C_YWLBBM) THEN CASE B.C_JZFX WHEN '-' THEN C_SL ELSE C_SL * -1 END ELSE 0 END C_CKSL, M.C_JZRQ, NVL(S.C_WLTSYT, :B6 ) C_WLTSYT, S.C_WLYSBM FROM TW_WLYDPZ M INNER JOIN TW_WLYDPZMX S ON M.C_PZH = S.C_PZH INNER JOIN TW_YWLBZSJ B ON M.C_YWLBBM = B.C_YWLBBM WHERE M.C_KJZQ = :B5 AND M.C_ZZBM = :B4 AND S.C_CKBM = :B3 AND S.C_GYSBM = :B2 AND (:B1 IS NULL OR S.C_WLBM LIKE '%' || :B1 || '%')) BWBILL ON BWBILL.C_KJZQ = KCZ.C_KJZQ AND BWBILL.C_ZZBM = KCZ.C_ZZBM AND BWBILL.C_CKBM = KCZ.C_CKBM AND BWBILL.C_WLBM = KCZ.C_WLBM AND BWBILL.C_KCZT = KCZ.C_KCZT AND BWBILL.C_WLTSYT = KCZ.C_WLTSYT ) SQ WHERE SQ.C_KJZQ = :B5 AND SQ.C_GYSBM = :B2 AND SQ.C_ZZBM = :B4 AND SQ.C_CKBM = :B3 AND (:B1 IS NULL OR SQ.C_WLBM LIKE '%' || :B1 || '%') ORDER BY SQ.C_ZZBM, SQ.C_GYSBM, SQ.C_WLBM, SQ.C_WLYSBM, SQ.C_WLTSYT, SQ.C_JZRQ |
b2qkbbfj29xxn | select monitertab.interfaceid, monitertab.transjobid, monitertab.TRANSTIME from monitertab, taskgroupscheduler where monitertab.interfaceid = taskgroupscheduler.interfaceid and monitertab.STATUS = :"SYS_B_0" and taskgroupscheduler.groupid = :"SYS_B_1" and monitertab.interfaceid not in (select interfaceid from interfaceconf where rs_status = :"SYS_B_2") order by TRANSTIME asc |
b5yyh2vc9g8tm | SELECT sx.id, sum(decode(e.snap_id, NULL, 0, 1)) as cnt FROM (SELECT s.snap_id, x.id, x.name FROM WRM$_SNAPSHOT s , X$KEHSQT x WHERE s.dbid = :dbid AND s.instance_number = :inst_num AND s.snap_id between :bid and :eid AND s.status = 0 AND x.ver_type = :exists_type ) sx, WRM$_SNAP_ERROR e WHERE e.dbid(+) = :dbid AND e.instance_number(+) = :inst_num AND e.snap_id(+) = sx.snap_id AND e.table_name(+) = sx.name GROUP BY sx.id |
b6cmfd9gfjmqd |
SELECT ZS.C_ZSH, ZS.C_ZSLB, ZS.C_YWLBBM, YWLB.C_YWLBMC, YWLB.C_WLYDLXBM, ZS.C_ZZBM, ZZ.C_MC C_ZZMC, ZS.C_WLDWBM, (SELECT WLCK.C_WLCKBM FROM (SELECT DISTINCT X.C_ZSH, X.C_WLCKBM, (SELECT C.C_CKMC FROM TW_CKZSJ C WHERE C.C_CKBM = X.C_WLCKBM) C_WLCKMC FROM TW_WLYDZSHXM X) WLCK WHERE WLCK.C_ZSH = ZS.C_ZSH) C_WLCKBM, (SELECT WLCK.C_WLCKMC FROM (SELECT DISTINCT X.C_ZSH, X.C_WLCKBM, (SELECT C.C_CKMC FROM TW_CKZSJ C WHERE C.C_CKBM = X.C_WLCKBM) C_WLCKMC FROM TW_WLYDZSHXM X) WLCK WHERE WLCK.C_ZSH = ZS.C_ZSH) C_WLCKMC, DECODE(YWLB.C_WLDWLX, '1601', GYS.C_MC, '1602', KH.C_MC, '1603', WLDW.C_MC, '1604', CBZX.C_CBZXMC, '') C_WLDWMC, (SELECT TO_CHAR(MIN(H.C_JHSFSJ), 'YYYY-MM-DD') FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_JHSFSJ, (SELECT TO_CHAR(MAX(H.C_JHSFSJ), 'YYYY-MM-DD') FROM TW_WLYDZSHXM H WHERE H.C_ZSH = ZS.C_ZSH) C_JHJSSJ, ZS.C_ZSLY, NVL(ZS.C_QXBJ, '0') C_QXBJ, NVL(ZS.C_GBBJ, '0') C_GBBJ, ZS.C_ZXZT, ZS.C_CJR, (SELECT YG.YGMC FROM TPRIYGZSJ YG WHERE YG.YGBM = ZS.C_CJR) C_CJRMC, TO_CHAR(ZS.C_CJSJ, 'yyyy-mm-dd hh24:mi:ss') C_CJSJ, ZS.C_XGR, (SELECT YG.YGMC FROM TPRIYGZSJ YG WHERE YG.YGBM = ZS.C_CJR) C_XGRMC, TO_CHAR(ZS.C_XGSJ, 'yyyy-mm-dd hh24:mi:ss') C_XGSJ, (SELECT HXM.C_LLLX FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = ZS.C_ZSH AND ROWNUM = 1) C_LLLX FROM TW_WLYDZS ZS INNER JOIN TW_YWLBZSJ YWLB ON ZS.C_YWLBBM = YWLB.C_YWLBBM INNER JOIN T_ZZZSJ ZZ ON ZS.C_ZZBM = ZZ.C_ZZBM LEFT JOIN T_ZZZSJ WLDW ON ZS.C_WLDWBM = WLDW.C_ZZBM LEFT JOIN T_GYSZSJ
GYS ON ZS.C_WLDWBM = GYS.C_GYSBM LEFT JOIN T_KHZSJ KH ON ZS.C_WLDWBM = KH.C_KHBM LEFT JOIN T_CBZXZSJ CBZX ON ZS.C_WLDWBM = CBZX.C_CBZXBH WHERE ZS.C_ZZBM = :B6 AND ZS.C_YWLBBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B7 )))) AND (:B2 IS NOT NULL OR :B5 = '1' OR (:B5 = '2' AND (ZS.C_CJSJ BETWEEN TO_DATE(:B4 || ' 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(:B3 || ' 23:59:59', 'yyyy-mm-dd hh24:mi:ss')))) AND (:B2 IS NULL OR INSTR(:B2 , ZS.C_ZSH) > 0) AND (:B1 IS NULL OR ZS.C_WLDWBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B1 ))))) AND ZS.C_ZXZT IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B8 )))) AND NVL(ZS.C_QXBJ, '0') IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B9 )))) AND NVL(ZS.C_GBBJ, '0') IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B10 )))) AND EXISTS (SELECT 1 FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = ZS.C_ZSH AND ((:B11 IS NULL) OR HXM.C_LLLX IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B11 )))))) AND EXISTS (SELECT 1 FROM TW_WLYDZSHXM HXM LEFT JOIN TM_ZZWLCS CS ON HXM.C_CKBM = CS.C_DHDBM LEFT JOIN TW_WLYDZSWLMX WLMX ON WLMX.C_ZSH = HXM.C_ZSH AND WLMX.C_ZSXMH = HXM.C_XMH WHERE HXM.C_ZSH = ZS.C_ZSH AND HXM.C_CKBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B16 )))) AND ((:B15 IS NULL) OR (HXM.C_DDH = :B15 )) AND (CS.C_ZZBM = ZS.C_ZZBM OR CS.C_ZZBM IS NULL) AND ((:B14 IS NULL) OR (FW_GET_BGYBM(ZS.C_ZZBM, HXM.C_CKBM, HXM
.C_WLBM, WLMX.C_QWBM, WLMX.C_CWBM, NVL(HXM.C_GYSBM, HXM.C_GYSBM))) IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B14 ))))) AND (:B2 IS NOT NULL OR :B5 = '2' OR (:B5 = '1' AND (HXM.C_JHSFSJ BETWEEN TO_DATE(:B4 || ' 00:00:00', 'yyyy-mm-dd hh24:mi:ss') AND TO_DATE(:B3 || ' 23:59:59', 'yyyy-mm-dd hh24:mi:ss')))) AND (:B13 IS NULL OR (CS.C_ABCDFL IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B13 )))) OR CS.C_ABCDFL IS NULL)) AND (:B12 IS NULL OR HXM.C_WLBM IN (SELECT * FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B12 )))))) |
b6zt3cfrux8x1 |
Select :"SYS_B_000" Lx, :"SYS_B_001" LXMC, Wlbm, (Select Wl.Wlmc From Tpriwlzsj Wl Where Wl.Wlbm = T.Wlbm) Wlmc, Gysbm, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T.Gysbm) Gysmc, Tsyt, (Select Zd.Mc From Tprisjzd Zd Where Zd.Clbm = T.Tsyt) Tsytmc, Wlys, (Select Color.Ysmc From Tbascolor Color Where Color.Ysbm = T.Wlys) Wlysmc, Xqdw, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T.Xqdw) Xqdwmc, Gyskc, SNP , sum(nvl(t.Y201306D13, :"SYS_B_002")) as Y201306D13, sum(nvl(t.Y201306D14, :"SYS_B_003")) as Y201306D14, sum(nvl(t.Y201306D15, :"SYS_B_004")) as Y201306D15, sum(nvl(t.Y201306D16, :"SYS_B_005")) as Y201306D16, sum(nvl(t.Y201306D17, :"SYS_B_006")) as Y201306D17, sum(nvl(t.Y201306D18, :"SYS_B_007")) as Y201306D18, sum(nvl(t.Y201306D19, :"SYS_B_008")) as Y201306D19, sum(nvl(t.Y201306D20, :"SYS_B_009")) as Y201306D20, sum(nvl(t.Y201306D21, :"SYS_B_010")) as Y201306D21, sum(nvl(t.Y201306D22, :"SYS_B_011")) as Y201306D22, sum(nvl(t.Y201306D23, :"SYS_B_012")) as Y201306D23, sum(nvl(t.Y201306D24, :"SYS_B_013")) as Y201306D24, sum(nvl(t.Y201306D25, :"SYS_B_014")) as Y201306D25, sum(nvl(t.Y201306D26, :"SYS_B_015")) as Y201306D26 From (Select Hz.Wlbm, Hz.Gysbm , decode(to_char(Hz.Xqrq, :"SYS_B_016"), :"SYS_B_017", SUM(Hz.Xqsl), :"SYS_B_018") Y201306D13, decode(to_c
har(Hz.Xqrq, :"SYS_B_019"), :"SYS_B_020", SUM(Hz.Xqsl), :"SYS_B_021") Y201306D14, decode(to_char(Hz.Xqrq, :"SYS_B_022"), :"SYS_B_023", SUM(Hz.Xqsl), :"SYS_B_024") Y201306D15, decode(to_char(Hz.Xqrq, :"SYS_B_025"), :"SYS_B_026", SUM(Hz.Xqsl), :"SYS_B_027") Y201306D16, decode(to_char(Hz.Xqrq, :"SYS_B_028"), :"SYS_B_029", SUM(Hz.Xqsl), :"SYS_B_030") Y201306D17, decode(to_char(Hz.Xqrq, :"SYS_B_031"), :"SYS_B_032", SUM(Hz.Xqsl), :"SYS_B_033") Y201306D18, decode(to_char(Hz.Xqrq, :"SYS_B_034"), :"SYS_B_035", SUM(Hz.Xqsl), :"SYS_B_036") Y201306D19, decode(to_char(Hz.Xqrq, :"SYS_B_037"), :"SYS_B_038", SUM(Hz.Xqsl), :"SYS_B_039") Y201306D20, decode(to_char(Hz.Xqrq, :"SYS_B_040"), :"SYS_B_041", SUM(Hz.Xqsl), :"SYS_B_042") Y201306D21, decode(to_char(Hz.Xqrq, :"SYS_B_043"), :"SYS_B_044", SUM(Hz.Xqsl), :"SYS_B_045") Y201306D22, decode(to_char(Hz.Xqrq, :"SYS_B_046"), :"SYS_B_047", SUM(Hz.Xqsl), :"SYS_B_048") Y201306D23, decode(to_char(Hz.Xqrq, :"SYS_B_049"), :"SYS_B_050", SUM(Hz.Xqsl), :"SYS_B_051") Y201306D24, decode(to_char(Hz.Xqrq, :"SYS_B_052"), :"SYS_B_053", SUM(Hz.Xqsl), :"SYS_B_054") Y201306D25, decode(to_char(Hz.Xqrq, :"SYS_
B_055"), :"SYS_B_056", SUM(Hz.Xqsl), :"SYS_B_057") Y201306D26 , Nvl((Select Sum(C_Zmsl) From Tw_Rjzz Rjzz Inner Join Tw_Pczsj Pczsj On Rjzz.C_Zzbm = Pczsj.C_Zzbm And Rjzz.C_Pc = Pczsj.C_Pc Where Pczsj.C_Ysgysbm = Hz.Gysbm And Rjzz.C_Zzbm In (Select Fw.Wlgsbm From Tpriwlgsfw Fw Where Fw.Gysbm = Hz.Gysbm) And Rjzz.C_Wlbm = Hz.Wlbm), :"SYS_B_058") Gyskc, (Select Bz.C_Snp From T_Wlbz Bz Where Bz.C_Zzbm = hz.Xqdw And Bz.C_Wlbm = hz.Wlbm And Bz.C_Gys = hz.Gysbm And Rownum = :"SYS_B_059") Snp, Hz.Tsyt, Hz.Wlys, Hz.Xqdw, Nvl((Select Sum(Xqsl) Xqsl From Tmrpydxqhz b Where B.Ny = :"SYS_B_060" And B.Gysbm = :"SYS_B_061" And B.Xqdw = Hz.Xqdw And B.Wlbm = Hz.Wlbm And B.Cgzxz = Hz.Cgzbm And Nvl(B.Wlys, :"SYS_B_062") = Nvl(Hz.Wlys, :"SYS_B_063") And Nvl(B.Tsyt, :"SYS_B_064") = Nvl(Hz.Tsyt, :"SYS_B_065")), :"SYS_B_066") Dhsl From Tmrprdxqhz Hz Where ((Trim(:"SYS_B_067") Is Null) Or Hz.Xqdw = :"SYS_B_068") And Hz.Ny = :"SYS_B_069" And ((:"SYS
_B_070" Is Null) Or hz.Gysbm = :"SYS_B_071") And ((Trim(:"SYS_B_072") Is Null) Or hz.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_073")))) And hz.xqrq Is Not Null Group By Wlbm, Gysbm, Xqrq, Tsyt, Wlys, Xqdw, Cgzbm) t Group By Wlbm, Gysbm, Tsyt, Wlys, Xqdw, GYSKC, SNP Union All Select :"SYS_B_074" Lx, :"SYS_B_075" LXMC, Wlbm, (Select Wl.Wlmc From Tpriwlzsj Wl Where Wl.Wlbm = T1.Wlbm) Wlmc, Gysbm, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T1.Gysbm) Gysmc, Tsyt, (Select Zd.Mc From Tprisjzd Zd Where Zd.Clbm = T1.Tsyt) Tsytmc, Wlys, (Select Color.Ysmc From Tbascolor Color Where Color.Ysbm = T1.Wlys) Wlysmc, Xqdw, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T1.Xqdw) Xqdwmc, Gyskc, SNP , sum(nvl(t1.Y201306D13, :"SYS_B_076")) as Y201306D13, sum(nvl(t1.Y201306D14, :"SYS_B_077")) as Y201306D14, sum(nvl(t1.Y201306D15, :"SYS_B_078")) as Y201306D15, sum(nvl(t1.Y201306D16, :"SYS_B_079")) as Y201306D16, sum(nvl(t1.Y201306D17, :"SYS_B_080")) as Y201306D17, sum(nvl(t1.Y201306D18, :"SYS_B_081")) as Y201306D18, sum(nvl(t1.Y201306D19, :"SYS_B_082")) as Y201306D19, sum(nvl(t1.Y201306D20, :"SYS_B_083")) as Y201306D20, sum(nvl(t1.Y201306D21, :"SYS_B_084")) as Y201306D21, sum(nvl(t1.Y201306D22, :"SYS_B_085")) as Y201306D22, sum(nvl(t1.Y201306D23, :"SYS_B_086")) as Y20130
6D23, sum(nvl(t1.Y201306D24, :"SYS_B_087")) as Y201306D24, sum(nvl(t1.Y201306D25, :"SYS_B_088")) as Y201306D25, sum(nvl(t1.Y201306D26, :"SYS_B_089")) as Y201306D26 From (Select Wlbm, Gysbm , decode(to_char(yfhz.Dhrq, :"SYS_B_090"), :"SYS_B_091", SUM(yfhz.qdsl), :"SYS_B_092") Y201306D13, decode(to_char(yfhz.Dhrq, :"SYS_B_093"), :"SYS_B_094", SUM(yfhz.qdsl), :"SYS_B_095") Y201306D14, decode(to_char(yfhz.Dhrq, :"SYS_B_096"), :"SYS_B_097", SUM(yfhz.qdsl), :"SYS_B_098") Y201306D15, decode(to_char(yfhz.Dhrq, :"SYS_B_099"), :"SYS_B_100", SUM(yfhz.qdsl), :"SYS_B_101") Y201306D16, decode(to_char(yfhz.Dhrq, :"SYS_B_102"), :"SYS_B_103", SUM(yfhz.qdsl), :"SYS_B_104") Y201306D17, decode(to_char(yfhz.Dhrq, :"SYS_B_105"), :"SYS_B_106", SUM(yfhz.qdsl), :"SYS_B_107") Y201306D18, decode(to_char(yfhz.Dhrq, :"SYS_B_108"), :"SYS_B_109", SUM(yfhz.qdsl), :"SYS_B_110") Y201306D19, decode(to_char(yfhz.Dhrq, :"SYS_B_111"), :"SYS_B_112", SUM(yfhz.qdsl), :"SYS_B_113") Y201306D20, decode(to_char(yfhz.Dhrq, :"SYS_B_114"), :"SYS_B_115", SUM(yfhz.qdsl), :"SYS_B_116") Y201306D21, decode(to_char(yfhz.Dhrq, :"SYS_B_117"), :"SYS_B_118", SUM(yfhz.qdsl), :"SYS_B_119") Y201306D22, decod
e(to_char(yfhz.Dhrq, :"SYS_B_120"), :"SYS_B_121", SUM(yfhz.qdsl), :"SYS_B_122") Y201306D23, decode(to_char(yfhz.Dhrq, :"SYS_B_123"), :"SYS_B_124", SUM(yfhz.qdsl), :"SYS_B_125") Y201306D24, decode(to_char(yfhz.Dhrq, :"SYS_B_126"), :"SYS_B_127", SUM(yfhz.qdsl), :"SYS_B_128") Y201306D25, decode(to_char(yfhz.Dhrq, :"SYS_B_129"), :"SYS_B_130", SUM(yfhz.qdsl), :"SYS_B_131") Y201306D26, Nvl((Select Sum(C_Zmsl) From Tw_Rjzz Rjzz Inner Join Tw_Pczsj Pczsj On Rjzz.C_Zzbm = Pczsj.C_Zzbm And Rjzz.C_Pc = Pczsj.C_Pc Where Pczsj.C_Ysgysbm = yfhz.Gysbm And Rjzz.C_Zzbm In (Select Fw.Wlgsbm From Tpriwlgsfw Fw Where Fw.Gysbm = yfhz.Gysbm) And Rjzz.C_Wlbm = yfhz.Wlbm), :"SYS_B_132") Gyskc, (Select Bz.C_Snp From T_Wlbz Bz Where Bz.C_Zzbm = yfhz.Xqdwbm And Bz.C_Wlbm = yfhz.Wlbm And Bz.C_Gys = yfhz.Gysbm And Rownum = :"SYS_B_133") Snp , yfhz.Wltsyt Tsyt, yfhz.Wlys, yfhz.Xqdwbm Xqdw, Null Dhsl From tmrpfjjhrdhz yfhz Where ((Trim(:"SYS_B_134") Is Null) Or yfhz.Xqdwbm = :"SYS_B_135") And yfhz.jhny = :"SYS_B_136" And ((:"SYS_B_137" Is Null) Or yfhz.Gysbm = :"SYS_B_138") And ((Trim(:"SYS_B_139") Is Null) Or yfhz.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_140")))) And yfhz.dhrq Is Not Null
Group By Wlbm, Gysbm, dhrq, wlTsyt, Wlys, Xqdwbm, Cgzbm) t1 Group By Wlbm, Gysbm, Tsyt, Wlys, Xqdw, GYSKC, SNP Union All Select :"SYS_B_141" Lx, :"SYS_B_142" LXMC, Wlbm, (Select Wl.Wlmc From Tpriwlzsj Wl Where Wl.Wlbm = T2.Wlbm) Wlmc, Gysbm, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T2.Gysbm) Gysmc, Tsyt, (Select Zd.Mc From Tprisjzd Zd Where Zd.Clbm = T2.Tsyt) Tsytmc, Wlys, (Select Color.Ysmc From Tbascolor Color Where Color.Ysbm = T2.Wlys) Wlysmc, Xqdw, (Select Jg.Zzmc From Tprizzjg Jg Where Jg.Zzbm = T2.Xqdw) Xqdwmc, Gyskc, SNP , sum(nvl(t2.Y201306D13, :"SYS_B_143")) as Y201306D13, sum(nvl(t2.Y201306D14, :"SYS_B_144")) as Y201306D14, sum(nvl(t2.Y201306D15, :"SYS_B_145")) as Y201306D15, sum(nvl(t2.Y201306D16, :"SYS_B_146")) as Y201306D16, sum(nvl(t2.Y201306D17, :"SYS_B_147")) as Y201306D17, sum(nvl(t2.Y201306D18, :"SYS_B_148")) as Y201306D18, sum(nvl(t2.Y201306D19, :"SYS_B_149")) as Y201306D19, sum(nvl(t2.Y201306D20, :"SYS_B_150")) as Y201306D20, sum(nvl(t2.Y201306D21, :"SYS_B_151")) as Y201306D21, sum(nvl(t2.Y201306D22, :"SYS_B_152")) as Y201306D22, sum(nvl(t2.Y201306D23, :"SYS_B_153")) as Y201306D23, sum(nvl(t2.Y201306D24, :"SYS_B_154")) as Y201306D24, sum(nvl(t2.Y201306D25, :"SYS_B_155")) as Y201306D25, sum(nvl(t2.Y201306D26, :"SYS_B_156")) as Y201306D26 From (S
elect Wlbm, Gysbm , decode(to_char(mx.Dhrq, :"SYS_B_157"), :"SYS_B_158", SUM(mx.qdsl), :"SYS_B_159") Y201306D13, decode(to_char(mx.Dhrq, :"SYS_B_160"), :"SYS_B_161", SUM(mx.qdsl), :"SYS_B_162") Y201306D14, decode(to_char(mx.Dhrq, :"SYS_B_163"), :"SYS_B_164", SUM(mx.qdsl), :"SYS_B_165") Y201306D15, decode(to_char(mx.Dhrq, :"SYS_B_166"), :"SYS_B_167", SUM(mx.qdsl), :"SYS_B_168") Y201306D16, decode(to_char(mx.Dhrq, :"SYS_B_169"), :"SYS_B_170", SUM(mx.qdsl), :"SYS_B_171") Y201306D17, decode(to_char(mx.Dhrq, :"SYS_B_172"), :"SYS_B_173", SUM(mx.qdsl), :"SYS_B_174") Y201306D18, decode(to_char(mx.Dhrq, :"SYS_B_175"), :"SYS_B_176", SUM(mx.qdsl), :"SYS_B_177") Y201306D19, decode(to_char(mx.Dhrq, :"SYS_B_178"), :"SYS_B_179", SUM(mx.qdsl), :"SYS_B_180") Y201306D20, decode(to_char(mx.Dhrq, :"SYS_B_181"), :"SYS_B_182", SUM(mx.qdsl), :"SYS_B_183") Y201306D21, decode(to_char(mx.Dhrq, :"SYS_B_184"), :"SYS_B_185", SUM(mx.qdsl), :"SYS_B_186") Y201306D22, decode(to_char(mx.Dhrq, :"SYS_B_187"), :"SYS_B_188", SUM(mx.qdsl), :"SYS_B_189") Y201306D23, decode(to_char(mx.Dhrq, :"SYS_B_190"), :"SYS_B_191", SUM(mx.qdsl), :"SYS_B_192") Y201306D24, dec
ode(to_char(mx.Dhrq, :"SYS_B_193"), :"SYS_B_194", SUM(mx.qdsl), :"SYS_B_195") Y201306D25, decode(to_char(mx.Dhrq, :"SYS_B_196"), :"SYS_B_197", SUM(mx.qdsl), :"SYS_B_198") Y201306D26, Nvl((Select Sum(C_Zmsl) From Tw_Rjzz Rjzz Inner Join Tw_Pczsj Pczsj On Rjzz.C_Zzbm = Pczsj.C_Zzbm And Rjzz.C_Pc = Pczsj.C_Pc Where Pczsj.C_Ysgysbm = qd.Gysbm And Rjzz.C_Zzbm In (Select Fw.Wlgsbm From Tpriwlgsfw Fw Where Fw.Gysbm = qd.Gysbm) And Rjzz.C_Wlbm = Mx.Wlbm), :"SYS_B_199") Gyskc, (Select Bz.C_Snp From T_Wlbz Bz Where Bz.C_Zzbm = mx.Xqdwbm And Bz.C_Wlbm = mx.Wlbm And Bz.C_Gys = qd.Gysbm And Rownum = :"SYS_B_200") Snp , mx.Wltsyt Tsyt, mx.Wlys, mx.Xqdwbm Xqdw, Null Dhsl From tmrpfjjhqd qd, tmrpfjjhmx mx where qd.cgjhh=mx.cgjhh and qd.jhy=mx.jhy and qd.zt=:"SYS_B_201" and mx.cgjhh=:"SYS_B_202" and ((Trim(:"SYS_B_203") Is Null) Or mx.Xqdwbm = :"SYS_B_204") and ((Trim(:"SYS_B_205") Is Null) Or mx.jhy = :"SYS_B_206") And qd.jhny = :"SYS_B_207" And ((:"SYS_B_208" Is Null) Or qd.Gysbm = :"SYS_B_209") And ((Trim(:"SYS_B_210") Is Null) Or mx.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_211")))) And mx.dhrq Is Not Null Group By Wlbm, Gysbm, dhrq, wlTsyt, Wlys, Xqdwbm, Cgzbm) t2 Group By Wlb
m, Gysbm, Tsyt, Wlys, Xqdw, GYSKC, SNP order by wlbm |
bm2vxqs97nq4d | select distinct sessionid from SCF2SAP_SF01_IMPORT where STATUS=:"SYS_B_0" |
bqnn4c3gjtmgu | insert into wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) select /*+ ordered use_nl(e) */ :snap_id, :dbid, :instance_number, e.event_id, sum(e.total_waits), sum(e.total_timeouts), sum(e.time_waited_micro) from v$session bgsids, v$session_event e where bgsids.type = 'BACKGROUND' and bgsids.sid = e.sid group by e.event_id |
buzx5wrw4dfgw | select * from gzlctree where dbjobbm = :"SYS_B_0" |
c1289gydrn00t | insert into MES2SCF_MF05 (id, sessionid, DJBH, JHRQ, JHX, XQSBH, WLH, LBJMC, YS, JLDW, YHSL, SNP, BGYBM, BGYMC, SHCK, YJDHSJ, ZWDHSJ, GYSBM, TSYT, LLLX, BZ, SCX, GW, WLXHD, ZZBM, JJBJ, JJYY, CXH, FBSJ) values (seq_payment.nextval, :"SYS_B_00", :"SYS_B_01", :"SYS_B_02", :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11", :"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20", :"SYS_B_21", :"SYS_B_22", :"SYS_B_23", :"SYS_B_24", :"SYS_B_25", :"SYS_B_26", :"SYS_B_27") |
c4y84wmu5yjph | select distinct sessionid from SCF2SAP_SF17_IMPORT where STATUS=:"SYS_B_0" |
cjsk3n312wbm0 | SELECT X.*, S.C_SAPCKBM FROM TW_WLYDPZMX X INNER JOIN TW_WLYDPZ M ON M.C_PZH = X.C_PZH INNER JOIN TW_CKZSJ S ON S.C_ZZBM = M.C_ZZBM AND S.C_CKBM = X.C_CKBM WHERE M.C_PZH = :B1 AND S.C_CKLB IN ('0', '1') AND S.C_SAPCKBM IS NOT NULL |
crvmbwtcbfb2d | BEGIN PKG_ZZKKC_SUBMIT.PRC_WLYDZSHXM_JY(:1, :2, :3); END; |
d2bxhdz2kcy7v |
select hxm.c_zsh, HXM.C_PLX, hxm.c_xmh, hxm.c_ckbm, hxm.c_wlbm, hxm.c_gysbm, hxm.c_wlbb, hxm.c_jldw, hxm.c_sl, nvl(hxm.c_zxsl, :"SYS_B_00") c_zxsl, nvl((hxm.c_sl-NvL(hxm.c_zxsl, :"SYS_B_01")), :"SYS_B_02") c_wzxsl, hxm.c_ddh, hxm.c_ddhh, hxm.c_ckpzh, hxm.c_ckpzhh, hxm.c_snp, hxm.c_ydyy, hxm.c_wlckbm, hxm.c_qxbj mxc_qxbj, hxm.c_gbbj mxc_gbbj, hxm.c_zxzt mxc_zxzt, hxm.c_jhsfsj mxc_jhsfsj, hxm.c_bz, zs.c_ywlbbm, zs.c_zslb, zs.c_zzbm, zs.c_wldwbm, decode(zs.c_qxbj, :"SYS_B_03", :"SYS_B_04", hxm.c_qxbj) c_qxbj, decode(zs.c_gbbj, :"SYS_B_05", :"SYS_B_06", hxm.c_gbbj) c_gbbj, zs.c_zxzt, TO_CHAR(zs.c_cjsj, :"SYS_B_07") C_CJSJ, zs.c_zsly, zz.c_mc c_zzmc, ck.c_ckmc, (select wl.C_WLMC from t_wlzsj wl where wl.C_WLBM = hxm.c_wlbm) C_Wlmc, gys.c_mc c_gysmc, zd1.c_mc c_tsyt, zd2.c_mc c_xsqy, ys.c_ysmc, (select c_ckmc from tw_ckzsj where c_ckbm = hxm.c_wlckbm) c_wlckmc, wldw.c_wldwmc, yw.c_ywlbmc, yw.c_wlydlxbm, case upper(zs.c_cjr) when :"SYS_B_08" then :"SYS_B_09" else (select yg.ygmc from tpriygzsj yg where yg.ygbm = zs.c_cjr) end C_Cjrxm , zs.C_CJR, (select c_wlydyymc from tw_wlydyy where c_wlydyybm=hxm.c_ydyy and rownum<=:"SYS_B_10") c_ydyymc from tw_wlydzshxm hxm left join tw_wlydzs zs on zs.c_zsh=hxm.c_zsh left join tw_ywlbzsj yw on yw.c_ywlbbm=zs.c_ywlbbm left join t_zzzsj zz on zz.c_zzbm=zs.c_zzbm left join tw_ckzsj c
k on ck.c_ckbm=hxm.c_ckbm left join t_gyszsj gys on gys.c_gysbm=hxm.c_gysbm left join t_sjzd zd1 on zd1.c_clbm=hxm.c_wltsyt left join t_sjzd zd2 on zd2.c_clbm=hxm.c_xsqy left join t_ysqd ys on ys.c_ysbm=hxm.c_wlysbm left join tw_ckzsj wlck on wlck.c_ckbm=hxm.c_wlckbm LEFT JOIN ( select c_gysbm c_wldwbm, c_mc c_wldwmc from t_gyszsj gys where not exists (select * from t_zzzsj where c_zzbm=gys.c_gysbm) union select c_khbm c_wldwbm, c_mc c_wldwmc from t_khzsj union select c_zzbm c_wldwbm, c_mc c_wldwmc from t_zzzsj union select c_cbzxbh c_wldwbm, c_cbzxmc c_wldwmc from t_cbzxzsj ) wldw on wldw.c_wldwbm=zs.c_wldwbm where :"SYS_B_11"=:"SYS_B_12" and zs.c_zzbm=:"SYS_B_13" and hxm.c_ckbm in (select * from table(fw_split_into_vc100(:"SYS_B_14"))) and zs.c_wldwbm in (select * from table(fw_split_into_vc100(:"SYS_B_15"))) and hxm.c_wlckbm in (select * from table(fw_split_into_vc100(:"SYS_B_16"))) and hxm.c_lllx in (select * from table(fw_split_into_vc100(:"SYS_B_17"))) and zs.c_zxzt IN (SELECT * FROM TABLE(fw_convert_flattoxlh(:"SYS_B_18"))) and nvl(zs.c_qxbj, :"SYS_B_19") in (select * from table(fw_convert_flattoxlh(:"SYS_B_20"))) and nvl(zs.c_gbbj, :"SYS_B_21") in (select * from table(fw_convert_flattoxlh(:"SYS_B_22"))) and hxm.c_jhsfsj between to_date(:"SYS_B_23", :"SYS_B_24") and to
_date(:"SYS_B_25", :"SYS_B_26") |
d80h6a7665f79 |
SELECT PZ.C_PZH, PZ.C_ZZBM, PZ.C_YWLBBM, PZ.C_WLYDLXBM C_YDLXBM, PZ.C_PZLB, PZ.C_WLDWBM, PZ.C_KJZQ, TO_CHAR(C_JZRQ, 'YYYY-MM-DD') C_PZRQ, PZ.C_CJR, PZ.C_CJSJ, PZ.C_ZDSCBJ, PZ.C_BZ, ZZ.C_MC C_ZZMC, WLDW.C_WLDWMC, YW.C_YWLBMC, YW.C_DYMBBM, YG.C_YGMC C_ZDR, (SELECT WLPZBH FROM TW_SAPWLPZ WHERE SGWLPZH = PZ.C_PZH AND ROWNUM = 1) C_SAPPZH, BGY.C_BGY, (SELECT DECODE(NVL(DY.C_DYCS, '0'), '0', '', 'R') C_DYZT FROM TW_DYJL DY WHERE DY.C_PZH = PZ.C_PZH AND DY.C_PZLX = '1') C_DYZT, (SELECT YW.C_JZFX FROM TW_YWLBZSJ YW WHERE YW.C_YWLBBM = PZ.C_YWLBBM) C_JZFX FROM TW_WLYDPZ PZ LEFT JOIN T_ZZZSJ ZZ ON ZZ.C_ZZBM = PZ.C_ZZBM LEFT JOIN TW_YWLBZSJ YW ON YW.C_YWLBBM = PZ.C_YWLBBM LEFT JOIN T_YGZSJ YG ON YG.C_YGBM = PZ.C_CJR LEFT JOIN (SELECT C_GYSBM C_WLDWBM, C_MC C_WLDWMC FROM T_GYSZSJ GYS WHERE NOT EXISTS (SELECT 1 FROM T_ZZZSJ WHERE C_ZZBM = GYS.C_GYSBM) UNION SELECT C_KHBM C_WLDWBM, C_MC C_WLDWMC FROM T_KHZSJ UNION SELECT C_ZZBM C_WLDWBM, C_MC C_WLDWMC FROM T_ZZZSJ UNION SELECT C_CBZXBH C_WLDWBM, C_CBZXMC C_WLDWMC FROM T_CBZXZSJ) WLDW ON WLDW.C_WLDWBM = PZ.C_WLDWBM LEFT JOIN (SELECT DISTINCT T1.C_PZH, YG.C_YGMC C_BGY FROM TW_WLYDPZMX T1 LEFT JOIN TW_CKQWZSJ CKQW ON T1.C_CKBM = CKQW.C_CKBM AND T1.C_QWBM = CKQW.C_QWBM LEFT JOIN T_YGZSJ YG ON YG.C_YGBM = CKQW.C_BGYBM1 WHERE EXISTS (SELECT 1 FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B1 ))) FF WHERE FF.COLUMN_VALUE = T1.C_PZH)) BGY ON PZ.C_PZH = BGY.C_PZH WHERE PZ.C_ZZBM = :B2 AND PZ.C_PZH IN (SELECT * FROM
TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B1 )))) ORDER BY C_PZH |
d8kbp93qjp4up | DELETE /*+ REF_CASCADE_CURSOR */ FROM "SCF2"."TW_WLYDPZMXTEMP_XLH" WHERE "NESTED_TABLE_ID" = :1 |
dn8fxy9kcv288 | SELECT COUNT(1) FROM TW_PZDYGXHXM A INNER JOIN TW_WLYDPZ B ON A.SCFWLYDPZH = B.C_PZH INNER JOIN TW_YWLBZSJ C ON B.C_YWLBBM = C.C_YWLBBM INNER JOIN TW_WLYDPZMX S ON A.SCFWLYDPZH = S.C_PZH AND A.WLYDPZHH = S.C_PZHH LEFT JOIN TW_ZZJBYYCS P ON B.C_WLDWBM = P.C_ZZBM LEFT JOIN TW_CKZSJ T ON B.C_WLDWBM = T.C_ZZBM AND S.C_WLCKBM = T.C_CKBM WHERE A.SCFWLYDPZH = :B2 AND REGEXP_LIKE(:B1 , B.C_YWLBBM) AND EXISTS (SELECT 1 FROM TW_PZB PZB WHERE PZB.LX = 'A001' AND PZB.BM = B.C_WLDWBM) AND (NVL(P.C_WMSGLBJ, '0') = '0' OR NVL(T.C_WMSGLBJ, '0') = '0') AND NOT EXISTS (SELECT 1 FROM SCF2SAP_SF02_IMPORT ZB, SCF2SAP_SF02_T_MOVEDATA MX WHERE ZB.SESSIONID = MX.SESSIONID AND MX.DOCNR = :B3 ) |
dv30311zhn1b4 | SELECT MAX(C_JSSJ), MAX(XS.C_BCLB) FROM T_YDZGZTZ YD, T_YDZGZTZMX MX, T_RDGZTZMX RD, T_KDXS XS WHERE YD.C_SCXBM = :B2 AND YD.C_YDZGZTZXLH = MX.C_YDZGZTZXLH AND MX.C_YDZGZTZMXXLH = RD.C_YDZGZTZMXXLH AND RD.C_RQ = TO_DATE(SUBSTR(:B1 , 1, 8), 'yyyy-mm-dd') AND RD.C_KDXS = XS.C_KDXSBM AND RD.C_KDXS <> '0' |
fby16d9fz7k72 | BEGIN PKG_MPS_CHECKREQUIREMENT.PRC_MPS_FLCCCL(:1, :2, :3, :4); END; |
ff0vbqq869ycu | select Count(*) NewMessage from tnotemonitor where :"SYS_B_0"=:"SYS_B_1" and RWZT=:"SYS_B_2" and jsr = :"SYS_B_3" |
g00cj285jmgsw | update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn |
ga3b3mvp75u5r | UPDATE monitertab SET status=:"SYS_B_0", comm=:"SYS_B_1", OUTTIME=sysdate WHERE ID=:"SYS_B_2" |
gbx9vh9y655p6 |
INSERT INTO TW_WLYDZSHXM (C_ZSH, C_XMH, C_CKBM, C_WLBM, C_GYSBM, C_WLTSYT, C_WLYSBM, C_WLBB, C_JLDW, C_SL, C_ZXSL, C_GYSPC, C_DDH, C_DDHH, C_CKPZH, C_CKPZHH, C_SNP, C_XSQY, C_YDYY, C_WLCKBM, C_CJR, C_CJSJ, C_XGR, C_XGSJ, C_QXBJ, C_GBBJ, C_ZXZT, C_JHSFSJ, C_BZ, C_PLX, C_DHSJ, C_LLLX, C_GCBGY, C_GCBGYMC, C_ZJHGXX, C_SAPPZXX, C_KCZT) SELECT :B18 , ROWNUM, GX.C_CKBM, T.WLH, T.GYSBM, CASE WHEN REGEXP_LIKE('C', T.TSYT) THEN '5001' ELSE '' END, YS.C_YSBM, NULL, 'EA', T.YHSL, 0, NULL, NULL, NULL, T.DJBH, T.XQSBH, T.SNP, NULL, NULL, T.SHCK, 'sys', SYSDATE, NULL, NULL, '0', :B17 , '0', :B15 , NVL2(:B16 , :B16 || '/' || T.BZ, T.BZ), T.JHX, :B15 , :B14 , T.BGYBM, T.BGYMC, NULL, NULL, NULL FROM MES2SCF_MF05 T LEFT JOIN TPRIWLGSFW FW ON T.GYSBM = FW.GYSBM LEFT JOIN TW_ZZJBYYCS CS ON FW.WLGSBM = CS.C_ZZBM LEFT JOIN TW_CKYGYSDYGX GX ON GX.C_ZZBM = CS.C_ZZBM AND GX.C_GYSBM = T.GYSBM AND GX.C_ZT = '1' LEFT JOIN T_YSQD YS ON T.YS = YS.C_YSMC WHERE T.SESSIONID = :B13 AND T.LLLX = '1' AND T.ZZBM = :B12 AND T.GYSBM = :B11 AND CS.C_WMSGLBJ = '1' AND NVL(T.SCX, '*') = NVL(:B10 , '*') AND T.SHCK = :B9 AND NVL(T.BGYBM, '*') = NVL(:B8 , '*') AND NVL(T.BGYMC, '*') = NVL(:B7 , '*') AND NVL(FW.WLGSBM, '*') = NVL(:B6 , '*') AND NVL(GX.C_CKBM, '*') = NVL(:B5 , '*') AND T.LY = :B4 AND SUBSTR(T.YJDHSJ, 1, 12) = :B3 AND SUBSTR(T.FBSJ, 1, 12) = :B2 AND T.JJBJ = '0' AND NVL(T.JHRQ, '*') = NVL(:B1 , '*')
|
gdn3ysuyssf82 | SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1 |
gj73u9azpmf9t |
select :"SYS_B_00" Lx, count(:"SYS_B_01") JLS from Tgysjfnltc t where (T.Zt = :"SYS_B_02" or T.Zt = :"SYS_B_03") and exists (select :"SYS_B_04" from Tsysyhsjqx Qx where Qx.Ywlx = :"SYS_B_05" and Qx.Fl = T.Wlbm and Qx.Zzbm = T.Cgzbm and Qx.Ygbm = :"SYS_B_06" and Rownum = :"SYS_B_07") union all select :"SYS_B_08" Lx, count(:"SYS_B_09") JLS from tmrpddfk zb where zb.zt=:"SYS_B_10" and zb.jhy=:"SYS_B_11" union all select :"SYS_B_12" Lx, count(:"SYS_B_13") JLS from tmrpfjjhqd zb where zb.zt=:"SYS_B_14" and zb.jhy=:"SYS_B_15" union all select :"SYS_B_16" Lx, count(:"SYS_B_17") JLS from tmesjjlld zb where zb.clzt = :"SYS_B_18" and zb.jhybm=:"SYS_B_19" union all SELECT :"SYS_B_20" lx, COUNT(:"SYS_B_21") jls FROM tw_wlydzs zs WHERE zs.c_zzbm = :"SYS_B_22" AND EXISTS (SELECT :"SYS_B_23" FROM tw_wlydzshxm hxm WHERE hxm.c_zsh = zs.c_zsh AND (hxm.c_zxzt = :"SYS_B_24" OR hxm.c_zxzt = :"SYS_B_25") AND hxm.c_qxbj = :"SYS_B_26" AND hxm
.c_gbbj = :"SYS_B_27" AND hxm.c_lllx = :"SYS_B_28" AND trunc(hxm.c_jhsfsj) >= (trunc(SYSDATE) - :"SYS_B_29") AND trunc(hxm.c_jhsfsj) <= (trunc(SYSDATE) + :"SYS_B_30")) AND zs.c_qxbj = :"SYS_B_31" AND zs.c_gbbj = :"SYS_B_32" AND zs.c_zxzt < :"SYS_B_33" AND zs.c_ywlbbm IN (:"SYS_B_34", :"SYS_B_35") UNION ALL SELECT :"SYS_B_36" lx, COUNT(:"SYS_B_37") jls FROM tw_wlydzs zs WHERE zs.c_zzbm = :"SYS_B_38" AND EXISTS (SELECT :"SYS_B_39" FROM tw_wlydzshxm hxm WHERE hxm.c_zsh = zs.c_zsh AND (hxm.c_zxzt = :"SYS_B_40" OR hxm.c_zxzt = :"SYS_B_41") AND hxm.c_qxbj = :"SYS_B_42" AND hxm.c_gbbj = :"SYS_B_43" AND nvl(hxm.c_lllx, :"SYS_B_44") = :"SYS_B_45" AND trunc(hxm.c_jhs
fsj) >= (trunc(SYSDATE) - :"SYS_B_46") AND trunc(hxm.c_jhsfsj) <= (trunc(SYSDATE) + :"SYS_B_47")) AND zs.c_qxbj = :"SYS_B_48" AND zs.c_gbbj = :"SYS_B_49" AND zs.c_zxzt < :"SYS_B_50" AND zs.c_ywlbbm IN (:"SYS_B_51", :"SYS_B_52") UNION ALL SELECT :"SYS_B_53" lx, COUNT(:"SYS_B_54") jls FROM tw_wlydzs zs WHERE zs.c_zzbm = :"SYS_B_55" AND EXISTS (SELECT :"SYS_B_56" FROM tw_wlydzshxm hxm WHERE hxm.c_zsh = zs.c_zsh AND (hxm.c_zxzt = :"SYS_B_57" OR hxm.c_zxzt = :"SYS_B_58") AND hxm.c_qxbj = :"SYS_B_59" AND hxm.c_gbbj = :"SYS_B_60" AND hxm.c_lllx IN (:"SYS_B_61", :"SYS_B_62") AND trunc(hxm.c_jhsfsj) >= (trunc(SYSDATE) - :"SYS_B_63") AND trunc(hxm.c_jhsfsj) <= (trunc(SYSDATE) + :"SYS_B_64")) AND zs.c_qxbj = :"SYS_B_65
" AND zs.c_gbbj = :"SYS_B_66" AND zs.c_zxzt < :"SYS_B_67" AND zs.c_ywlbbm = :"SYS_B_68" UNION ALL SELECT :"SYS_B_69" lx, COUNT(:"SYS_B_70") jls FROM tw_wlydzs zs WHERE zs.c_zzbm = :"SYS_B_71" AND EXISTS (SELECT :"SYS_B_72" FROM tw_wlydzshxm hxm WHERE hxm.c_zsh = zs.c_zsh AND (hxm.c_zxzt = :"SYS_B_73" OR hxm.c_zxzt = :"SYS_B_74") AND hxm.c_qxbj = :"SYS_B_75" AND hxm.c_gbbj = :"SYS_B_76" AND hxm.c_lllx = :"SYS_B_77" AND trunc(hxm.c_jhsfsj) >= (trunc(SYSDATE) - :"SYS_B_78") AND trunc(hxm.c_jhsfsj) <= (trunc(SYSDATE) + :"SYS_B_79")) AND zs.c_qxbj = :"SYS_B_80" AND zs.c_gbbj = :"SYS_B_81" AND zs.c_zxzt < :"SYS_B_82"
AND zs.c_ywlbbm = :"SYS_B_83" |
gmzva85wy3h8n | SELECT COUNT(:"SYS_B_0") c_hs, substr(c_xlh, :"SYS_B_1", :"SYS_B_2") c_wlqz, :"SYS_B_3" c_sftq, :"SYS_B_4" c_tqsj FROM tw_xlhz wl GROUP BY substr(c_xlh, :"SYS_B_5", :"SYS_B_6") ORDER BY c_hs |
grwydz59pu6mc | select text from view$ where rowid=:1 |