SQL Id | SQL Text |
04xtrk7uyhknh | select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null |
0dwr2vd6vbqzs |
SELECT count(*) over () as total_count, sd_xe_ash_nm.event_name, sd_xe_ash_nm.event_id, sd_xe_ash_nm.parameter1 as p1text, (CASE WHEN (sd_xe_ash_nm.parameter1 is NULL OR sd_xe_ash_nm.parameter1 = '0') THEN 0 ELSE 1 END) as p1valid, sd_xe_ash_nm.parameter2 as p2text, (CASE WHEN (sd_xe_ash_nm.parameter2 is NULL OR sd_xe_ash_nm.parameter2 = '0') THEN 0 ELSE 1 END) as p2valid, sd_xe_ash_nm.parameter3 as p3text, (CASE WHEN (sd_xe_ash_nm.parameter3 is NULL OR sd_xe_ash_nm.parameter3 = '0') THEN 0 ELSE 1 END) as p3valid, sd_xe_ash_nm.keh_evt_id, nvl(xc.class#, 0) as class_num, sd_xe_ash_nm.wait_class_id, nvl(xc.keh_id, 0) as keh_ecl_id, sd_xe_ash_nm.ash_cnt, sd_xe_ash_nm.tot_wts_diff, sd_xe_ash_nm.tot_tmo_diff, sd_xe_ash_nm.tim_wait_diff FROM ( SELECT sd_xe_ash.*, evtname.event_name, evtname.wait_class_id, evtname.parameter1, evtname.parameter2, evtname.parameter3 FROM ( SELECT sd_xe.*, nvl(ash.cnt, 0) as ash_cnt FROM ( SELECT nvl(xe.keh_id, 0) as keh_evt_id, nvl(sd.event_id, xe.event_hash) as event_id, nvl(sd.tot_wts_diff, 0) as tot_wts_diff, nvl(sd.tot_tmo_diff, 0) as tot_tmo_diff,
nvl(sd.tim_wait_diff, 0) as tim_wait_diff FROM ( SELECT endsn.event_id as event_id, (endsn.total_waits - nvl(begsn.total_waits, 0)) as tot_wts_diff, (endsn.total_timeouts - nvl(begsn.total_timeouts, 0)) as tot_tmo_diff, (endsn.time_waited_micro - nvl(begsn.time_waited_micro, 0)) as tim_wait_diff FROM ( SELECT end_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) end_snap WHERE end_snap.dbid = :dbid and end_snap.instance_number = :instance_number and end_snap.snap_id = :end_snap ) endsn LEFT OUTER JOIN ( SELECT beg_snap.* FROM (SELECT t1.* FROM WRH$_SYSTEM_EVENT t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_SYSTEM_EVENT_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) beg_snap WHERE beg_snap.dbid = :dbid and beg_snap.instance_number
= :instance_number and beg_snap.snap_id = :beg_snap ) begsn ON endsn.event_id = begsn.event_id ) sd FULL OUTER JOIN X$KEHEVTMAP xe ON sd.event_id = xe.event_hash ) sd_xe LEFT OUTER JOIN (SELECT a.event_id, count(*) as cnt FROM (SELECT t1.* FROM WRH$_ACTIVE_SESSION_HISTORY t1, WRM$_SNAPSHOT s1 WHERE t1.dbid = s1.dbid AND t1.instance_number = s1.instance_number AND t1.snap_id = s1.snap_id AND s1.bl_moved = 0 UNION ALL SELECT t2.* FROM WRH$_ACTIVE_SESSION_HISTORY_BL t2, WRM$_SNAPSHOT s2 WHERE t2.dbid = s2.dbid AND t2.instance_number = s2.instance_number AND t2.snap_id = s2.snap_id AND s2.bl_moved <> 0) a WHERE a.dbid = :dbid and a.instance_number = :instance_number and a.snap_id > :beg_snap and a.snap_id <= :end_snap and a.wait_time = 0 GROUP BY a.event_id) ash ON sd_xe.event_id = ash.event_id ) sd_xe_ash, WRH$_EVENT_NAME evtname WHERE evtname.event_id = sd_xe_ash.event_id and evtname.event_id > 0 and evtname.dbid = :dbid ) sd_xe_ash_nm, X$KEHECLMAP xc WHERE sd_xe_ash_nm.wait_class_id = xc.class_hash ORDER BY sd_xe_ash_nm.wait_class_id, sd_xe_ash_nm.tim_wait_diff DESC, sd_xe_ash_nm.event_id
|
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") |
0pxsqp3jpy0kn | select c.nyr, c.dd, nyrview from (SELECT distinct to_char(A.XQRQ, :"SYS_B_00") AS nyr, :"SYS_B_01" || to_char(A.XQRQ, :"SYS_B_02") || :"SYS_B_03" || to_char(A.XQRQ, :"SYS_B_04") nyrview, to_char(A.XQRQ, :"SYS_B_05") dd, A.XQRQ FROM TMRPRDXQHZ A where :"SYS_B_06"=:"SYS_B_07" and a.ny =:"SYS_B_08" and (:"SYS_B_09"=:"SYS_B_10") and upper(a.wlbm)=:"SYS_B_11" and a.cgzbm=:"SYS_B_12" and a.ny =:"SYS_B_13" and (:"SYS_B_14"=:"SYS_B_15") and upper(a.wlbm)=:"SYS_B_16" and a.cgzbm=:"SYS_B_17" GROUP BY A.XQRQ, a.gysbm) c order by c.XQRQ |
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 |
0sv6rmy7ys3mn | SELECT T.* FROM TW_YWLBZSJ T WHERE T.C_YWLBBM = :B1 |
0v3dvmc22qnam | insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time) |
15z9yzrsff0p6 | SELECT DISTINCT CUR.MBLNR FROM SAP2SCF_SF03_EXPORT_MSEG CUR WHERE CUR.SESSIONID = :B1 AND CUR.STATUS = '0' |
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 |
1gu8t96d0bdmu | select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) |
1xybtqw3288aw | SELECT * FROM SAP2SCF_SF03_EXPORT_MSEG DOC WHERE DOC.SESSIONID = :B2 AND DOC.MBLNR = :B1 AND DOC.SGTXT IS NOT NULL |
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; |
2ghbsfvq9mn3v | INSERT /*+ NO_PARTIAL_COMMIT REF_CASCADE_CURSOR */ INTO "SCF2"."TW_WLYDPZMX_XLH" ("NESTED_TABLE_ID", "COLUMN_VALUE") VALUES(:1, :2) |
2tq3dknsjum6d | SELECT :"SYS_B_0" FROM DUAL |
2v4q7k45ffnwt |
SELECT MX.C_PZH, MX.C_PZHH, MX.C_CKBM, MX.C_QWBM, MX.C_CWBM, MX.C_PC, MX.C_WLBM, MX.C_WLTSYT, MX.C_WLYSBM, (SELECT QD.C_YSMC FROM T_YSQD QD WHERE QD.C_YSBM = MX.C_WLYSBM) C_WLYSMC, MX.C_KCLX, MX.C_KCZT, MX.C_JLDW, MX.C_SL, MX.C_GYSPC, MX.C_WLCKBM, MX.C_WLQWBM, MX.C_WLCWBM, MX.C_SFWLBM, MX.C_SFPC, MX.C_CKPZH, MX.C_CKPZHH, MX.C_ZSH, MX.C_ZSXMH, MX.C_ZSHH, DECODE(YWLB.C_DYMBDDHQZFS, '1', SAP.DDH, MX.C_DDH) C_CGDDH, DECODE(YWLB.C_DYMBDDHQZFS, '1', SAP.DDHH, MX.C_DDHH) C_DDHH, MX.C_CXPZH, MX.C_CXPZHH, MX.C_WLYDYYBM, MX.C_GYSBM, MX.C_BZ, (SELECT WL.C_WLMC FROM T_WLZSJ WL WHERE WL.C_WLBM = MX.C_WLBM AND ROWNUM = 1) C_WLMC, CK.C_CKMC, ZD1.C_MC C_TSYT, YS.C_YSMC, ZD2.C_MC C_XSQY, ZD3.C_MC C_KCLXMC, ZD4.C_MC C_KCZTMC, CK2.C_CKMC C_WLCKMC, (SELECT YY.C_WLYDYYMC FROM TW_WLYDYY YY WHERE YY.C_YWLBBM = PZ.C_YWLBBM AND YY.C_WLYDYYBM = MX.C_WLYDYYBM AND ROWNUM = 1) C_WLYDYYMC, WLDW.C_WLDWMC C_GYSMC, (SELECT BZ.C_SNP FROM T_WLBZ BZ WHERE BZ.C_ZZBM = PZ.C_ZZBM AND BZ.C_WLBM = MX.C_WLBM AND BZ.C_GYS = MX.C_GYSBM AND ROWNUM = 1) C_SNP, NULL C_JHY, YG2.C_YGMC C_BGY, 0 C_BZJG, 1 C_JGDW, DECODE(MX.C_WLBB, 'HX', '', (SELECT HXM.C_PLX FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = MX.C_ZSH AND HXM.C_XMH = MX.C_ZSXMH AND ROWNUM = 1)) C_PLX, (SELECT HXM.C_SL FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = MX.C_ZSH AND HXM.C_XMH = MX.C_ZSXMH AND ROWNUM = 1) C_ZSSL, (SELECT HXM.C_GCBGY FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = MX.C_ZSH AND HXM.C_XMH = MX.C_ZSXMH AN
D ROWNUM = 1) C_WLBGYBM, (SELECT HXM.C_GCBGYMC FROM TW_WLYDZSHXM HXM WHERE HXM.C_ZSH = MX.C_ZSH AND HXM.C_XMH = MX.C_ZSXMH AND ROWNUM = 1) C_WLBGYMC, (SELECT TO_CHAR(S.C_DHSJ, 'yyyy-mm-dd HH24:MI') C_JHSFSJ FROM TW_WLYDZSHXM S WHERE S.C_ZSH = MX.C_ZSH AND S.C_XMH = MX.C_ZSXMH AND ROWNUM = 1) C_JHSFSJ FROM TW_WLYDPZMX MX INNER JOIN TW_WLYDPZ PZ ON PZ.C_PZH = MX.C_PZH INNER JOIN TW_CKZSJ CK ON CK.C_CKBM = MX.C_CKBM LEFT JOIN TW_CKZSJ CK2 ON CK2.C_CKBM = MX.C_WLCKBM LEFT JOIN T_YSQD YS ON YS.C_YSBM = MX.C_WLYSBM LEFT JOIN T_SJZD ZD1 ON ZD1.C_CLBM = MX.C_WLTSYT LEFT JOIN T_SJZD ZD2 ON ZD2.C_CLBM = MX.C_XSQY LEFT JOIN T_SJZD ZD3 ON ZD3.C_CLBM = MX.C_KCLX LEFT JOIN T_SJZD ZD4 ON ZD4.C_CLBM = MX.C_KCZT LEFT JOIN (SELECT C_GYSBM C_WLDWBM, C_MC C_WLDWMC FROM T_GYSZSJ UNION SELECT C_KHBM C_WLDWBM, C_MC C_WLDWMC FROM T_KHZSJ) WLDW ON WLDW.C_WLDWMC = MX.C_GYSBM LEFT JOIN TW_CKQWZSJ CKQW ON MX.C_CKBM = CKQW.C_CKBM AND MX.C_QWBM = CKQW.C_QWBM LEFT JOIN T_YGZSJ YG2 ON YG2.C_YGBM = CKQW.C_BGYBM1 LEFT JOIN TW_YWLBZSJ YWLB ON YWLB.C_YWLBBM = PZ.C_YWLBBM LEFT JOIN TW_SAPWLPZ SAP ON SAP.SGWLPZH = PZ.C_PZH AND GCBH = PZ.C_ZZBM WHERE 1 = 1 AND EXISTS (SELECT 1 FROM TABLE(COLLECTION_WRAPPER(FW_SPLIT_INTO_VC100(:B1 ))) FF WHERE FF.COLUMN_VALUE = MX.C_PZH) ORDER BY MX.C_PZH, MX.C_PZHH |
2ym6hhaq30r73 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
2z80gcnamvmu9 |
select c.sfjj, c.djh, c.djhh, c.zdgys as gysbm, c.wlbm, c.wltsyt, c.wlys, c.snp, c.qdsl, c.yghsl, c.yzxsl, c.jhymc, c.bgymc, (select zzmc from tprizzjg tp where tp.zzbm = c.fhdw)fhdw, c.dhdw, c.dhd, c.dhrq, c.xqrq, c.lllx, c.gysmc, c.wlmc, c.meslldh, c.meslldhh from (select :"SYS_B_00" SFJJ, a.djh, a.djhh, a.zdgys, a.wlbm, (select mc from tprisjzd p where p.clbm = a.wltsyt) as wltsyt, (select ygmc from tpriygzsj where ygbm = (select ygbm from tsysyhsjqx q where q.fl = a.wlbm and a.djh = b.djh and q.zzbm = b.cgzbm and q.YWLX = :"SYS_B_01")) jhymc, a.bgymc, (select ysmc from tbascolor t where t.ysbm = a.wlys) as wlys, a.snp, a.qdsl, a.yghsl, a.yzxsl, b.gysbm fhdw, (select zzmc from tprizzzsj jp where jp.zzbm = b.dhdwbm) as dhdw, (select ckmc from tprickzsj j where j.ckbm = a.dhd) as dhd, b.dhrq, a.xqrq, (select mc from TPRISJZD d where d.sjfl = :"SYS_B_02" and d.clbm = b.xqlx) as lllx, a.meslldh, a.meslldhh, (select ygmc from tpriygzsj where tpriygzsj.ygbm = a.xggys) gysmc, (select wlmc from TPRIWLZSJ where TPRIWLZSJ.wlbm = a.wlbm) wlmc from tmeslld b, tmeslldmx a where a.djh = b.djh
and b.dhrq >=to_date(:"SYS_B_03", :"SYS_B_04") and b.dhrq<=to_date(:"SYS_B_05", :"SYS_B_06") union select :"SYS_B_07" SFJJ, djbh, null djhh, t.gysbm, t.wlh wlbm, (select mc from tprisjzd p where p.clbm = tsyt) wltsyt, (select ygmc from tpriygzsj where ygbm = t.jhybm) jhymc, t.bgymc, (select ysmc from tbascolor t where t.ysbm = ys) wlys, to_number(snp) snp, to_number(yhsl) qdsl, null yzxsl, null yghsl, (case when cs.c_wmsglbj = :"SYS_B_08" then (select max(g.c_zzbm) from tw_ckygysdygx g where g.c_gysbm = t.gysbm) else t.gysbm end) fhdw, (select zzmc from tprizzzsj jp where jp.zzbm = t.zzbm) dhdw, (select ckmc from tprickzsj j where j.ckbm = t.shck) dhd, to_date(substr(yjdhsj, :"SYS_B_09", :"SYS_B_10"), :"SYS_B_11") dhrq, to_date(substr(jhrq, :"SYS_B_12", :"SYS_B_13"), :"SYS_B_14") xqrq, (case when t.lllx = :"SYS_B_15" then :"SYS_B_16" else :"SYS_B_17" end) lllx, null meslldh, null meslldhh, (select ygmc
from tpriygzsj where tpriygzsj.ygbm = t.gysbm) gysmc, (select wlmc from TPRIWLZSJ where TPRIWLZSJ.wlbm = t.wlh) wlmc from tmesjjlld t LEFT JOIN tpriwlgsfw fw ON t.gysbm = fw.gysbm LEFT JOIN tw_zzjbyycs cs ON fw.wlgsbm = cs.c_zzbm where :"SYS_B_18" = :"SYS_B_19" and clzt = :"SYS_B_20" and to_date(substr(t.yjdhsj, :"SYS_B_21", :"SYS_B_22"), :"SYS_B_23")>=to_date(:"SYS_B_24", :"SYS_B_25") and to_date(substr(yjdhsj, :"SYS_B_26", :"SYS_B_27"), :"SYS_B_28")<=to_date(:"SYS_B_29", :"SYS_B_30")) c where :"SYS_B_31"=:"SYS_B_32" |
32b5nn8haqrnf | UPDATE monitertab SET OUTTIME=null, TRANSTIME=sysdate WHERE ID=:"SYS_B_0" |
350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
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 |
3uvgj2xtjzbpx | UPDATE SAP2SCF_SF03_EXPORT_MSEG T4 SET T4.STATUS = 1 WHERE SESSIONID = :B2 AND T4.MBLNR = :B1 |
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 |
4tanzh2jp8tsn | select BO from SYSTASKBO where TASKID=:"SYS_B_0" |
4wmmawv1xc9na | insert into tw_pzdygx(scfwlydpzh, scfwlydpzhh, sjly, cjsj) select :"SYS_B_00", :"SYS_B_01", (select Decode(count(:"SYS_B_02"), :"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06") Sjly from Tw_Wlydpz Pz where pz.c_ywlbbm in (:"SYS_B_07", :"SYS_B_08") and exists (select :"SYS_B_09" from Tw_Pzb Pzb where Pzb.Lx = :"SYS_B_10" and Pzb.Bm = Pz.C_Wldwbm) and Pz.C_Pzh = :"SYS_B_11"), sysdate from dual where not exists (select :"SYS_B_12" from tw_pzdygx gx where gx.scfwlydpzh=:"SYS_B_13" and gx.scfwlydpzhh=:"SYS_B_14") |
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 |
61y0t64h2d92j | BEGIN SAP2SCF_TOTABLE.Sap03(:1); END; |
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 |
7b7676zfuur7t | BEGIN PRC_MES_JHDDY(:1, :2, :3); END; |
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 |
7d6k1q0qwhnq2 |
SELECT x.*, y.c_llsxsj, y.c_llxxsj, y.c_zjsj, y.c_rksj FROM (SELECT :"SYS_B_0" c_bbh, Tclpxjhmx.C_CLZPJHMXXLH, Tclpxjhmx.C_CXH, Tclpxjhmx.c_dpch, Tclpxjhmx.C_DDH, Tclpxjhmx.C_JHKSRQ, Tclpxjhmx.C_DPH, mx.c_ysbm c_yysbm, (SELECT ys.c_ysjc FROM t_ysqd ys WHERE ys.c_ysbm = mx.C_YSBM) C_PCQYSMC, Tclpxjhmx.C_YSBM C_UPDATEYSBM, DECODE(TCLPXJHMX.c_ddh, NULL, NULL, (SELECT YS.C_YSJC FROM T_YSQD YS WHERE YS.C_YSBM = TCLPXJHMX.C_YSBM)) C_UPDATEYSMC, mx.C_TXM ytxm, Tclpxjhmx.C_TXM C_UPDATETXM, Tclpxjhmx.C_CLSX, (SELECT sj.C_MC FROM T_SJZD sj WHERE sj.C_CLBM = Tclpxjhmx.C_CLSX) c_clsxmc, Tclpxjhmx.C_SCSX, (SELECT sj.C_MC FROM T_SJZD sj WHERE sj.C_CLBM = Tclpxjhmx.C_SCSX) C_SCSXmc, Tclpxjhmx.C_XSQY, (SELECT sj.C_MC FROM T_SJZD sj WHERE sj.C_CLBM = Tclpxjhmx.C_XSQY) C_XSQYmc, Tclpxjhmx.C_DTSX, (SELECT zz.C_MC FROM T_ZZZSJ zz, t_scx scx WHERE zz.C_ZZBM = scx.c_zzbm and scx.c_scxbm = Tclpxjhmx.c_scxbm) c_gc, (SELECT scx.C_MC FROM t_scx scx WHERE scx.C_SCXBM = Tclpxjhmx.C_SCXBM) c_scxmc, Fun_Return_Xqdw(TCLPXJHMX.C_XQMXXLH) C_XQDWMC FROM T_L_CLZPJHMX Tclpxjhmx, T_CLZPJHMX mx WHERE Tclpxjhmx.C_YCLZPJHMXXLH = mx.C_CLZPJHMXXLH and Tclpxjhmx.c_jhzzbm = :"SYS_B_1" AND :"SYS_B_2" = :"SYS_B_3") x LEFT JOIN (SELECT zp.C_CLZPJHMXXLH, strcat(DECODE(pz.C_JCD, :"SYS_B_4", jc.C_LLSJ)) c_llsxsj, strcat(DECODE(pz.C_JCD, :"SYS_B_5", jc.C_LLSJ)) c_llxxsj, strcat(DECODE(pz.C_JCD, :"SYS_B_6", jc.C_LLSJ)) c_zjsj, strcat(DECODE(pz.C
_JCD, :"SYS_B_7", jc.c_llsj)) c_rksj FROM T_l_CXJCDMX jc, t_l_clzpjhmx zp, T_CXSJJKDPZ pz WHERE jc.C_CLZPJHMXXLH = zp.C_CLZPJHMXXLH AND jc.C_CXSJJKDPZXLH = pz.C_CXSJJKDPZXLH and zp.c_jhzzbm = :"SYS_B_8" AND pz.c_scxbm = zp.c_scxbm GROUP BY zp.C_CLZPJHMXXLH) y ON x.c_clzpjhmxxlh = y.c_clzpjhmxxlh |
7f039z54cu4rx | SELECT * FROM TW_WLYDPZMX T WHERE T.C_PZH = :B2 AND T.C_PZHH = :B1 |
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"))))
|
85np1pfuxhgy6 | UPDATE TWLXQZKQD_HIS SET XQLX='2503' WHERE XQLX IS NULL |
8sdq50a3vjgbn | select c.nyr, c.dd, nyrview from (SELECT distinct to_char(A.XQRQ, :"SYS_B_0") AS nyr, :"SYS_B_1" || to_char(A.XQRQ, :"SYS_B_2") || :"SYS_B_3" || to_char(A.XQRQ, :"SYS_B_4") nyrview, to_char(A.XQRQ, :"SYS_B_5") dd, A.XQRQ FROM TMRPRDXQHZ A where :"SYS_B_6"=:"SYS_B_7" and a.ny=:"SYS_B_8" and a.GYSBM = :"SYS_B_9" GROUP BY A.XQRQ, a.gysbm) c order by c.XQRQ |
8swypbbr0m372 | select order#, columns, types from access$ where d_obj#=:1 |
8x2vjs56gj3a6 | BEGIN PRC_MPS_problemDeliveryDate(:1, :2, :3, :4); END; |
92kcbw0qn13za | select distinct t.ny jhny from Tmrprdxqhz t where t.ny is not null order by t.ny desc |
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 |
98jypbmtc6sgc | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN prc_CGDDJK_SS; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
9h4fy0p489gu3 | update TASKGROUPSTATES set STATES=:"SYS_B_0" where groupid= :"SYS_B_1" and STATES=:"SYS_B_2" |
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 |
a49buuashyhmn |
explain plan set statement_id = 'SCF2' for
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"))
))
|
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 |
b2gnxm5z6r51n | lock table sys.col_usage$ in exclusive mode nowait |
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 |
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 )))))) |
bs8uw9gjz14ts | SELECT C_MC FROM T_ZZZSJ X, T_XQQD Y, T_XQMX Z WHERE Y.C_XQQDXLH = Z.C_XQQDXLH AND Z.C_XQMXXLH = :B1 AND X.C_ZZBM = Y.C_XQDW AND ROWNUM = 1 |
buzx5wrw4dfgw | select * from gzlctree where dbjobbm = :"SYS_B_0" |
cf0wmg632udvh | begin pw_add_wlydpzs(:1, :2, :3, :4, :5); end; |
crvmbwtcbfb2d | BEGIN PKG_ZZKKC_SUBMIT.PRC_WLYDZSHXM_JY(:1, :2, :3); END; |
cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# |
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 |
dc1gr75uzn5z8 | SELECT mx.*
FROM tw_wlydpzmxtemp mx
LEFT JOIN tw_wlydzshxm zs
ON mx.c_zsh = zs.c_zsh
AND mx.c_zsxmh = zs.c_xmh
WHERE mx.c_pzh = :"SYS_B_00" AND mx.c_ckbm = :"SYS_B_01" AND mx.c_wlbm = :"SYS_B_02" AND nvl(mx.c_wltsyt, :"SYS_B_03") = nvl(:"SYS_B_04", :"SYS_B_05") AND NVL(mx.c_gysbm, :"SYS_B_06") = NVL(:"SYS_B_07", :"SYS_B_08") AND NVL(zs.c_gcbgy, :"SYS_B_09") = NVL(:"SYS_B_10", :"SYS_B_11") AND NVL(zs.c_lllx, :"SYS_B_12") = NVL(:"SYS_B_13", :"SYS_B_14") AND :"SYS_B_15" = :"SYS_B_16" ORDER BY mx.c_kczt, mx.c_pc |
dgh4xu8hcq1cc | SELECT mx.*
FROM tw_wlydpzmxtemp mx
LEFT JOIN tw_wlydzshxm zs
ON mx.c_zsh = zs.c_zsh
AND mx.c_zsxmh = zs.c_xmh
WHERE mx.c_pzh = :"SYS_B_0" AND mx.c_ckbm = :"SYS_B_1" AND mx.c_wlbm = :"SYS_B_2" AND nvl(mx.c_wltsyt, :"SYS_B_3") = nvl(:"SYS_B_4", :"SYS_B_5") AND :"SYS_B_6" = :"SYS_B_7" ORDER BY mx.c_kczt, mx.c_pc |
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 ) |
dps90d8mpnuzv | SELECT YGH, CGZXLH, CGZBM, WLBM, WLMC, WLTSYT, WLTSYTMC, WLYS, WLYSMC, XQDW, XQDWMC, NVL(TO_CHAR(XQRQ, 'yyyy-MM-dd'), JHNY || 'TOTAL') XQRQ, JHNY, JHYBM, ( SELECT YGMC FROM TPRIYGZSJ YGZSJ WHERE YGZSJ.YGBM = JHYBM ) JHYMC, SUM(DGSL) DGSL FROM (SELECT '' YGH, CGZXLH, CGZBM, WLBM, (SELECT WLMC FROM TPRIWLZSJ WLZSJ WHERE WLZSJ.WLBM = MX.WLBM ) WLMC, WLYS, (SELECT COLOR.YSMC FROM TBASCOLOR COLOR WHERE COLOR.YSBM = MX.WLYS ) WLYSMC, TSYT WLTSYT, (SELECT C_MC FROM T_SJZD SJZD WHERE SJZD.C_CLBM = MX.TSYT ) WLTSYTMC, XQDW, (SELECT ZZMC FROM TPRIZZZSJ ZZZSJ WHERE ZZZSJ.ZZBM = MX.XQDW ) XQDWMC, XQSL DGSL, XQRQ, NY JHNY, (SELECT YGBM FROM TSYSYHSJQX WHERE FL = WLBM AND YWLX = '18' AND ZZBM = CGZBM ) JHYBM FROM TMRPRDYGXQHZ MX WHERE NY BETWEEN (:B6 ) AND (:B5 ) AND GYSBM = :B4 AND ZSLX = :B3 AND (:B2 = '-1' OR XQDW = :B2 ) AND (MX.WLBM = '' OR MX.WLBM LIKE '%' || :B1 || '%') ) GROUP BY GROUPING SETS((YGH, CGZXLH, CGZBM, XQRQ, WLBM, WLMC, WLTSYT, WLTSYTMC, WLYS, WLYSMC, XQDW, XQDWMC, JHNY, JHYBM), (WLBM, WLTSYT, WLYS, JHNY)) ORDER BY WLBM, XQRQ |
f77qar2jsz9fx |
SELECT NY, TO_CHAR(XQRQ, 'yyyy-mm-dd') XQRQ, CGZBM, XQDW, DHDW, DHD, GYSBM, (SELECT C_MC FROM T_GYSZSJ WHERE C_GYSBM = BZJ.GYSBM) GYSMC, WLBM, (SELECT WL.C_WLMC FROM T_WLZSJ WL WHERE WL.C_WLBM = WLBM) WLMC, XQSL, TSYT, (SELECT ZD.MC FROM TPRISJZD ZD WHERE ZD.CLBM = TSYT) TSYTMC, WLYS, (SELECT YS.YSJC FROM TBASCOLOR YS WHERE YS.YSBM = WLYS) WLYSMC, DQKC, (SYKC - XQSL) SYKC, ZZBM, (SELECT JG.ZZMC FROM TPRIZZJG JG WHERE JG.ZZBM = BZJ.ZZBM) ZZMC, CKBM, (SELECT C_CKMC FROM TW_CKZSJ WHERE C_CKBM = BZJ.CKBM) CKMC, AQKC FROM (SELECT T.NY, T.XQRQ, T.CGZBM, T.XQDW, T.DHDW, T.DHD, T.GYSBM, T.WLBM, T.XQSL, T.TSYT, T.WLYS, (SELECT SUM(ZZ.C_ZMSL) FROM TW_RJZZ ZZ WHERE ZZ.C_ZZBM = ZZK.C_ZZBM AND ZZ.C_CKBM = ZZK.C_CKBM AND ZZ.C_WLBM = T.WLBM AND EXISTS (SELECT 1 FROM TW_PCZSJ PC WHERE PC.C_PC = ZZ.C_PC AND PC.C_ZZBM = ZZ.C_ZZBM AND PC.C_YSGYSBM = T.GYSBM)) DQKC, FW_QRY_SYKC(ZZK.C_ZZBM, ZZK.C_CKBM, T.XQDW, T.WLBM, T.GYSBM, TO_CHAR(T.XQRQ, 'yyyy-mm-dd'), T.NY, 'wms') SYKC, ZZK.C_ZZBM ZZBM, ZZK.C_CKBM CKBM, (SELECT KC.C_AQKCSL FROM TW_GYSAQKCCSWH KC WHERE KC.C_ZZBM = ZZK.C_ZZBM AND ZZK.C_GYSBM = KC.C_GYSBM AND KC.C_GYSBM = T.GYSBM AND KC.C_WLBM = T.WLBM AND ROWNUM = 1) AQKC FROM TMRPRDXQHZ T, TW_CKYGYSDYGX ZZK WHERE 1 = 1 AND EXISTS (SELECT 1 FROM TW_RJZZ RZZ WHERE RZZ.C_ZZBM = ZZK.C_ZZBM AND ZZK.C_CKBM = RZZ.C_CKBM AND EXISTS (SELECT 1 FROM TW_PCZSJ PC WHERE PC.C_PC = RZZ.C_PC AND PC.C_ZZBM = RZZ.C_ZZBM AND PC.C_YSGYSBM = ZZK.C_GYSBM)) AND T.GYSBM
= ZZK.C_GYSBM AND T.XQRQ IN (SELECT XQRQ FROM (SELECT HZ.XQRQ FROM TMRPRDXQHZ HZ WHERE TO_CHAR(HZ.XQRQ, 'yyyy-mm-dd') >= TO_CHAR(SYSDATE, 'yyyy-mm-dd') GROUP BY HZ.XQRQ ORDER BY HZ.XQRQ ASC) WHERE ROWNUM <= :B5 ) AND ((:B4 IS NULL) OR ZZK.C_ZZBM = :B4 ) AND ((:B3 IS NULL) OR (ZZK.C_CKBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B3 ))))) AND ((:B2 IS NULL) OR (T.GYSBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B2 ))))) AND ((:B1 IS NULL) OR (T.WLBM IN (SELECT * FROM TABLE(FW_SPLIT_INTO_VC100(:B1 )))))) BZJ WHERE BZJ.DQKC IS NOT NULL ORDER BY BZJ.ZZBM ASC, BZJ.CKBM ASC, BZJ.GYSBM ASC, BZJ.WLBM ASC |
f8gnxvnu28cqf |
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, sum(nvl(t.Y201307D01, :"SYS_B_016")) as Y201307D01, sum(nvl(t.Y201307D03, :"SYS_B_017")) as Y201307D03, sum(nvl(t.Y201307D06, :"SYS_B_018&qu
ot;)) as Y201307D06 From (Select Hz.Wlbm, Hz.Gysbm , decode(to_char(Hz.Xqrq, :"SYS_B_019"), :"SYS_B_020", SUM(Hz.Xqsl), :"SYS_B_021") Y201306D13, decode(to_char(Hz.Xqrq, :"SYS_B_022"), :"SYS_B_023", SUM(Hz.Xqsl), :"SYS_B_024") Y201306D14, decode(to_char(Hz.Xqrq, :"SYS_B_025"), :"SYS_B_026", SUM(Hz.Xqsl), :"SYS_B_027") Y201306D15, decode(to_char(Hz.Xqrq, :"SYS_B_028"), :"SYS_B_029", SUM(Hz.Xqsl), :"SYS_B_030") Y201306D16, decode(to_char(Hz.Xqrq, :"SYS_B_031"), :"SYS_B_032", SUM(Hz.Xqsl), :"SYS_B_033") Y201306D17, decode(to_char(Hz.Xqrq, :"SYS_B_034"), :"SYS_B_035", SUM(Hz.Xqsl), :"SYS_B_036") Y201306D18, decode(to_char(Hz.Xqrq, :"SYS_B_037"), :"SYS_B_038", SUM(Hz.Xqsl), :"SYS_B_039") Y201306D19, decode(to_char(Hz.Xqrq, :"SYS_B_040"), :"SYS_B_041", SUM(Hz.Xqsl), :"SYS_B_042") Y201306D20, decode(to_char(Hz.Xqrq, :"SYS_B_043"), :"SYS_B_044", SUM(Hz.Xqsl), :"SYS_B_045") Y201306D21, decode(to_char(Hz.Xqrq, :"SYS_B_046"), :"SYS_B_047", SUM(Hz.Xqsl), :"SYS_B_048") Y201306D22, decode(to_char(Hz.Xqrq, :"SYS_B_049"), :"SYS_B_050", SUM(Hz.Xqsl), :"SYS_B_051") Y201306D23, decode(to_char(Hz.Xqrq, :"SYS_B_052"), :"SYS_B_053", SUM(Hz.Xqsl), :&quo
t;SYS_B_054") Y201306D24, decode(to_char(Hz.Xqrq, :"SYS_B_055"), :"SYS_B_056", SUM(Hz.Xqsl), :"SYS_B_057") Y201306D25, decode(to_char(Hz.Xqrq, :"SYS_B_058"), :"SYS_B_059", SUM(Hz.Xqsl), :"SYS_B_060") Y201306D26, decode(to_char(Hz.Xqrq, :"SYS_B_061"), :"SYS_B_062", SUM(Hz.Xqsl), :"SYS_B_063") Y201307D01, decode(to_char(Hz.Xqrq, :"SYS_B_064"), :"SYS_B_065", SUM(Hz.Xqsl), :"SYS_B_066") Y201307D03, decode(to_char(Hz.Xqrq, :"SYS_B_067"), :"SYS_B_068", SUM(Hz.Xqsl), :"SYS_B_069") Y201307D06 , 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_070") 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_071") Snp, Hz.Tsyt, Hz.Wlys, Hz.Xqdw, Nvl((Select Sum(Xqsl) Xqsl From Tmrpydxqhz b Where B.Ny = :"SYS_B_072" And B.Gysb
m = :"SYS_B_073" And B.Xqdw = Hz.Xqdw And B.Wlbm = Hz.Wlbm And B.Cgzxz = Hz.Cgzbm And Nvl(B.Wlys, :"SYS_B_074") = Nvl(Hz.Wlys, :"SYS_B_075") And Nvl(B.Tsyt, :"SYS_B_076") = Nvl(Hz.Tsyt, :"SYS_B_077")), :"SYS_B_078") Dhsl From Tmrprdxqhz Hz Where ((Trim(:"SYS_B_079") Is Null) Or Hz.Xqdw = :"SYS_B_080") And Hz.Ny = :"SYS_B_081" And ((:"SYS_B_082" Is Null) Or hz.Gysbm = :"SYS_B_083") And ((Trim(:"SYS_B_084") Is Null) Or hz.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_085")))) 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_086" Lx, :"SYS_B_087" 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_088")) as Y201306D13, sum(nvl(t1.Y201306D14, :"SYS_B_089")) as Y201306D14, sum(nvl(t1.
Y201306D15, :"SYS_B_090")) as Y201306D15, sum(nvl(t1.Y201306D16, :"SYS_B_091")) as Y201306D16, sum(nvl(t1.Y201306D17, :"SYS_B_092")) as Y201306D17, sum(nvl(t1.Y201306D18, :"SYS_B_093")) as Y201306D18, sum(nvl(t1.Y201306D19, :"SYS_B_094")) as Y201306D19, sum(nvl(t1.Y201306D20, :"SYS_B_095")) as Y201306D20, sum(nvl(t1.Y201306D21, :"SYS_B_096")) as Y201306D21, sum(nvl(t1.Y201306D22, :"SYS_B_097")) as Y201306D22, sum(nvl(t1.Y201306D23, :"SYS_B_098")) as Y201306D23, sum(nvl(t1.Y201306D24, :"SYS_B_099")) as Y201306D24, sum(nvl(t1.Y201306D25, :"SYS_B_100")) as Y201306D25, sum(nvl(t1.Y201306D26, :"SYS_B_101")) as Y201306D26, sum(nvl(t1.Y201307D01, :"SYS_B_102")) as Y201307D01, sum(nvl(t1.Y201307D03, :"SYS_B_103")) as Y201307D03, sum(nvl(t1.Y201307D06, :"SYS_B_104")) as Y201307D06 From (Select Wlbm, Gysbm , decode(to_char(yfhz.Dhrq, :"SYS_B_105"), :"SYS_B_106", SUM(yfhz.qdsl), :"SYS_B_107") Y201306D13, decode(to_char(yfhz.Dhrq, :"SYS_B_108"), :"SYS_B_109", SUM(yfhz.qdsl), :"SYS_B_110") Y201306D14, decode(to_char(yfhz.Dhrq, :"SYS_B_111"), :"SYS_B_112", SUM(yfhz.qdsl), :"SYS_B_113") Y201306D15, decode(to_char(yfhz.Dhrq, :"SYS_B_114"), :"SYS_B_115", SUM(yfhz.qdsl), :"SYS_B_116") Y201306D16, decode(to_char(yf
hz.Dhrq, :"SYS_B_117"), :"SYS_B_118", SUM(yfhz.qdsl), :"SYS_B_119") Y201306D17, decode(to_char(yfhz.Dhrq, :"SYS_B_120"), :"SYS_B_121", SUM(yfhz.qdsl), :"SYS_B_122") Y201306D18, decode(to_char(yfhz.Dhrq, :"SYS_B_123"), :"SYS_B_124", SUM(yfhz.qdsl), :"SYS_B_125") Y201306D19, decode(to_char(yfhz.Dhrq, :"SYS_B_126"), :"SYS_B_127", SUM(yfhz.qdsl), :"SYS_B_128") Y201306D20, decode(to_char(yfhz.Dhrq, :"SYS_B_129"), :"SYS_B_130", SUM(yfhz.qdsl), :"SYS_B_131") Y201306D21, decode(to_char(yfhz.Dhrq, :"SYS_B_132"), :"SYS_B_133", SUM(yfhz.qdsl), :"SYS_B_134") Y201306D22, decode(to_char(yfhz.Dhrq, :"SYS_B_135"), :"SYS_B_136", SUM(yfhz.qdsl), :"SYS_B_137") Y201306D23, decode(to_char(yfhz.Dhrq, :"SYS_B_138"), :"SYS_B_139", SUM(yfhz.qdsl), :"SYS_B_140") Y201306D24, decode(to_char(yfhz.Dhrq, :"SYS_B_141"), :"SYS_B_142", SUM(yfhz.qdsl), :"SYS_B_143") Y201306D25, decode(to_char(yfhz.Dhrq, :"SYS_B_144"), :"SYS_B_145", SUM(yfhz.qdsl), :"SYS_B_146") Y201306D26, decode(to_char(yfhz.Dhrq, :"SYS_B_147"), :"SYS_B_148", SUM(yfhz.qdsl), :"SYS_B_149") Y201307D01, decode(to_char(yfhz.Dhrq, :"SYS_B_150"), :"SYS_B_151", SUM(yfhz.qdsl), :"SYS_B_152") Y2013
07D03, decode(to_char(yfhz.Dhrq, :"SYS_B_153"), :"SYS_B_154", SUM(yfhz.qdsl), :"SYS_B_155") Y201307D06, 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_156") 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_157") Snp , yfhz.Wltsyt Tsyt, yfhz.Wlys, yfhz.Xqdwbm Xqdw, Null Dhsl From tmrpfjjhrdhz yfhz Where ((Trim(:"SYS_B_158") Is Null) Or yfhz.Xqdwbm = :"SYS_B_159") And yfhz.jhny = :"SYS_B_160" And ((:"SYS_B_161" Is Null) Or yfhz.Gysbm = :"SYS_B_162") And ((Trim(:"SYS_B_163") Is Null) Or yfhz.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_164")))) 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_165" Lx, :"SYS_B_166" 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_167")) as Y201306D13, sum(nvl(t2.Y201306D14, :"SYS_B_168")) as Y201306D14, sum(nvl(t2.Y201306D15, :"SYS_B_169")) as Y201306D15, sum(nvl(t2.Y201306D16, :"SYS_B_170")) as Y201306D16, sum(nvl(t2.Y201306D17, :"SYS_B_171")) as Y201306D17, sum(nvl(t2.Y201306D18, :"SYS_B_172")) as Y201306D18, sum(nvl(t2.Y201306D19, :"SYS_B_173")) as Y201306D19, sum(nvl(t2.Y201306D20, :"SYS_B_174")) as Y201306D20, sum(nvl(t2.Y201306D21, :"SYS_B_175")) as Y201306D21, sum(nvl(t2.Y201306D22, :"SYS_B_176")) as Y201306D22, sum(nvl(t2.Y201306D23, :"SYS_B_177")) as Y201306D23, sum(nvl(t2.Y201306D24, :"SYS_B_178")) as Y201306D24, sum(nvl(t2.Y201306D25, :"SYS_B_179")) as Y201306D25, sum(nvl(t2.Y201306D26, :"SYS_B_180")) as Y201306D26, sum(nvl(t2.Y201307D01, :"SYS_B_181")) as Y201307D01, sum(nvl(t2.Y201307D03, :"SYS_B_182")) as Y201307D03, sum(nvl(t2.Y201307D06, :"SYS_B_183")) as Y201307D06 From (Select Wlbm, Gysbm , decode(to_char(mx.Dhrq, :"SYS_B_184"), :"SYS_B_185", SUM(mx.qdsl), :"SYS_B_186") Y201306D13, decode(to_char(mx.Dhrq, :"SY
S_B_187"), :"SYS_B_188", SUM(mx.qdsl), :"SYS_B_189") Y201306D14, decode(to_char(mx.Dhrq, :"SYS_B_190"), :"SYS_B_191", SUM(mx.qdsl), :"SYS_B_192") Y201306D15, decode(to_char(mx.Dhrq, :"SYS_B_193"), :"SYS_B_194", SUM(mx.qdsl), :"SYS_B_195") Y201306D16, decode(to_char(mx.Dhrq, :"SYS_B_196"), :"SYS_B_197", SUM(mx.qdsl), :"SYS_B_198") Y201306D17, decode(to_char(mx.Dhrq, :"SYS_B_199"), :"SYS_B_200", SUM(mx.qdsl), :"SYS_B_201") Y201306D18, decode(to_char(mx.Dhrq, :"SYS_B_202"), :"SYS_B_203", SUM(mx.qdsl), :"SYS_B_204") Y201306D19, decode(to_char(mx.Dhrq, :"SYS_B_205"), :"SYS_B_206", SUM(mx.qdsl), :"SYS_B_207") Y201306D20, decode(to_char(mx.Dhrq, :"SYS_B_208"), :"SYS_B_209", SUM(mx.qdsl), :"SYS_B_210") Y201306D21, decode(to_char(mx.Dhrq, :"SYS_B_211"), :"SYS_B_212", SUM(mx.qdsl), :"SYS_B_213") Y201306D22, decode(to_char(mx.Dhrq, :"SYS_B_214"), :"SYS_B_215", SUM(mx.qdsl), :"SYS_B_216") Y201306D23, decode(to_char(mx.Dhrq, :"SYS_B_217"), :"SYS_B_218", SUM(mx.qdsl), :"SYS_B_219") Y201306D24, decode(to_char(mx.Dhrq, :"SYS_B_220"), :"SYS_B_221", SUM(mx.qdsl), :"SYS_B_222") Y201306D25, decode(to_char(mx.Dhrq, :"SYS_B_223"), :"S
YS_B_224", SUM(mx.qdsl), :"SYS_B_225") Y201306D26, decode(to_char(mx.Dhrq, :"SYS_B_226"), :"SYS_B_227", SUM(mx.qdsl), :"SYS_B_228") Y201307D01, decode(to_char(mx.Dhrq, :"SYS_B_229"), :"SYS_B_230", SUM(mx.qdsl), :"SYS_B_231") Y201307D03, decode(to_char(mx.Dhrq, :"SYS_B_232"), :"SYS_B_233", SUM(mx.qdsl), :"SYS_B_234") Y201307D06, 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_235") 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_236") 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_237" and mx.cgjhh=:"SYS_B_238" and ((Trim(:"SYS_B_239") Is Null) Or mx.Xqdwbm = :"SYS_B_240") and ((Trim(:"SYS_B_241") Is Null) Or mx.jhy = :"SYS_B_242") And qd.jhny = :"SYS_B_243" And ((:"SYS_B_244" Is Null) Or qd.Gysbm = :"SYS_B_245") And ((Trim(:"SYS_B_246") Is Null)
Or mx.Wlbm In (Select * From Table(Fw_Split_Into_Vc100(:"SYS_B_247")))) And mx.dhrq Is Not Null Group By Wlbm, Gysbm, dhrq, wlTsyt, Wlys, Xqdwbm, Cgzbm) t2 Group By Wlbm, Gysbm, Tsyt, Wlys, Xqdw, GYSKC, SNP order by wlbm |
fby16d9fz7k72 | BEGIN PKG_MPS_CHECKREQUIREMENT.PRC_MPS_FLCCCL(:1, :2, :3, :4); END; |
fhy8k6wf4unkp |
SELECT pz.c_zzbm, pz.c_ywlbbm, yw.c_ywlbmc, pz.c_wlydlxbm, pz.c_pzlb, pz.c_wldwbm, pz.c_kjzq, to_char(pz.c_jzrq, :"SYS_B_00") c_jzrq, :"SYS_B_01" c_xlh, mx.c_pzh, mx.c_pzhh, mx.c_ckbm, mx.c_qwbm, mx.c_cwbm, mx.c_pc, mx.c_wlbm, mx.c_kclx, mx.c_kczt, mx.c_jldw, DECODE(C_PZLB, :"SYS_B_02", mx.c_sl, :"SYS_B_03", :"SYS_B_04" - mx.c_sl, :"SYS_B_05") c_sl, mx.c_gyspc, mx.c_wlckbm, mx.c_wlqwbm, mx.c_wlcwbm, mx.c_sfwlbm, mx.c_sfpc, mx.c_ckpzh, mx.c_ckpzhh, mx.c_zsh, mx.c_zsxmh, mx.c_zshh, mx.c_ddh, mx.c_ddhh, mx.c_cxpzh, mx.c_cxpzhh, mx.c_wlydyybm, mx.c_gysbm, G.C_MC c_gysmc, wldw.c_wldwmc, wl.c_wlmc, ck.c_ckmc, yy.c_wlydyymc, zd1.c_mc c_tsyt, zd2.c_mc c_xsqy, ys.c_ysmc, yg.c_ygmc c_cjrxm, bz.c_snp, (Select Hxm.C_Plx From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Plx, (Select To_Char(Hxm.C_Dhsj, :"SYS_B_06") C_Dhsj From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Dhsj, (Select Hxm.C_Lllx From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Lllx, (Select Hxm.C_ZJHGXX From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_ZJHGXX, (Select Hxm.C_SAPPZXX From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_SAPPZXX, (select c_ckmc from tw_ckzsj where c_ckbm=:"SYS_B_07" ) c_wlckmc, pz.c_Bz, to_char(pz.c_cjsj, :"SYS_B_0
8") c_cjsj , dc.wlpzbh C_SAPPZH, MX.C_BZ C_MXBZ FROM TW_WLYDPZMX mx LEFT JOIN TW_WLYDPZ pz ON pz.c_pzh=mx.c_pzh LEFT JOIN T_GYSZSJ G ON G.C_GYSBM = MX.C_GYSBM LEFT JOIN TW_YWLBZSJ yw ON yw.c_ywlbbm=pz.c_ywlbbm LEFT JOIN T_WLZSJ wl on wl.c_wlbm=mx.c_wlbm LEFT JOIN TW_CKZSJ ck on ck.c_ckbm=mx.c_ckbm 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=pz.c_wldwbm LEFT JOIN TW_WLYDYY yy on yy.c_wlydyybm=mx.c_wlydyybm and yy.c_ywlbbm=pz.c_ywlbbm LEFT JOIN T_SJZD zd1 on zd1.c_clbm=mx.c_wltsyt LEFT JOIN T_SJZD zd2 on zd2.c_clbm=mx.c_xsqy LEFT JOIN T_YSQD ys on ys.c_ysbm=mx.c_wlysbm left join t_ygzsj yg on yg.c_ygbm=pz.c_cjr left join t_wlbz bz on bz.c_zzbm= pz.c_zzbm and bz.c_wlbm=mx.c_wlbm and bz.c_gys = mx.c_gysbm LEFT JOIN tw_sapwlpz dc ON dc.gcbh = pz.c_zzbm AND mx.c_pzhh = dc.sgpzhh AND lpad(dc.sgwlpzh, :"SYS_B_09", :"SYS_B_10") = pz.c_pzh where :"SYS_B_11"=:"SYS_B_12" and pz.c_zzbm=:"SYS_B_13" and mx.c_ckbm in (select * from table(fw_split_into_vc100(:"SYS_B_14"))) and pz.c_ywlbbm in (select * from table(fw_split_into_vc100(:"SYS_B_15"))) and ( :"SYS_B_16"=:"
SYS_B_17" ) and pz.c_jzrq between to_date(:"SYS_B_18", :"SYS_B_19") and to_date(:"SYS_B_20", :"SYS_B_21") and pz.c_Cjsj between to_date(:"SYS_B_22", :"SYS_B_23") and to_date(:"SYS_B_24", :"SYS_B_25") Order By Mx.C_Pzh Desc, Mx.C_Pzhh Asc |
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 |
g20awzjss95wu |
SELECT pz.c_zzbm, pz.c_ywlbbm, yw.c_ywlbmc, pz.c_wlydlxbm, pz.c_pzlb, pz.c_wldwbm, pz.c_kjzq, to_char(pz.c_jzrq, :"SYS_B_00") c_jzrq, :"SYS_B_01" c_xlh, mx.c_pzh, mx.c_pzhh, mx.c_ckbm, mx.c_qwbm, mx.c_cwbm, mx.c_pc, mx.c_wlbm, mx.c_kclx, mx.c_kczt, mx.c_jldw, DECODE(C_PZLB, :"SYS_B_02", mx.c_sl, :"SYS_B_03", :"SYS_B_04" - mx.c_sl, :"SYS_B_05") c_sl, mx.c_gyspc, mx.c_wlckbm, mx.c_wlqwbm, mx.c_wlcwbm, mx.c_sfwlbm, mx.c_sfpc, mx.c_ckpzh, mx.c_ckpzhh, mx.c_zsh, mx.c_zsxmh, mx.c_zshh, mx.c_ddh, mx.c_ddhh, mx.c_cxpzh, mx.c_cxpzhh, mx.c_wlydyybm, mx.c_gysbm, G.C_MC c_gysmc, wldw.c_wldwmc, wl.c_wlmc, ck.c_ckmc, yy.c_wlydyymc, zd1.c_mc c_tsyt, zd2.c_mc c_xsqy, ys.c_ysmc, yg.c_ygmc c_cjrxm, bz.c_snp, (Select Hxm.C_Plx From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Plx, (Select To_Char(Hxm.C_Dhsj, :"SYS_B_06") C_Dhsj From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Dhsj, (Select Hxm.C_Lllx From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_Lllx, (Select Hxm.C_ZJHGXX From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_ZJHGXX, (Select Hxm.C_SAPPZXX From Tw_Wlydzshxm Hxm Where Hxm.C_Zsh = Mx.C_Zsh And Hxm.C_Xmh = Mx.C_Zsxmh) C_SAPPZXX, (select c_ckmc from tw_ckzsj where c_ckbm=:"SYS_B_07" ) c_wlckmc, pz.c_Bz, to_char(pz.c_cjsj, :"SYS_B_0
8") c_cjsj , dc.wlpzbh C_SAPPZH, MX.C_BZ C_MXBZ FROM TW_WLYDPZMX mx LEFT JOIN TW_WLYDPZ pz ON pz.c_pzh=mx.c_pzh LEFT JOIN T_GYSZSJ G ON G.C_GYSBM = MX.C_GYSBM LEFT JOIN TW_YWLBZSJ yw ON yw.c_ywlbbm=pz.c_ywlbbm LEFT JOIN T_WLZSJ wl on wl.c_wlbm=mx.c_wlbm LEFT JOIN TW_CKZSJ ck on ck.c_ckbm=mx.c_ckbm 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=pz.c_wldwbm LEFT JOIN TW_WLYDYY yy on yy.c_wlydyybm=mx.c_wlydyybm and yy.c_ywlbbm=pz.c_ywlbbm LEFT JOIN T_SJZD zd1 on zd1.c_clbm=mx.c_wltsyt LEFT JOIN T_SJZD zd2 on zd2.c_clbm=mx.c_xsqy LEFT JOIN T_YSQD ys on ys.c_ysbm=mx.c_wlysbm left join t_ygzsj yg on yg.c_ygbm=pz.c_cjr left join t_wlbz bz on bz.c_zzbm= pz.c_zzbm and bz.c_wlbm=mx.c_wlbm and bz.c_gys = mx.c_gysbm LEFT JOIN tw_sapwlpz dc ON dc.gcbh = pz.c_zzbm AND mx.c_pzhh = dc.sgpzhh AND lpad(dc.sgwlpzh, :"SYS_B_09", :"SYS_B_10") = pz.c_pzh where :"SYS_B_11"=:"SYS_B_12" and pz.c_zzbm=:"SYS_B_13" and mx.c_ckbm in (select * from table(fw_split_into_vc100(:"SYS_B_14"))) and mx.c_wlbm in (select * from table(fw_split_into_vc100(:"SYS_B_15"))) and ( :"SYS_B_16"=:"SY
S_B_17" ) and pz.c_jzrq between to_date(:"SYS_B_18", :"SYS_B_19") and to_date(:"SYS_B_20", :"SYS_B_21") and pz.c_Cjsj between to_date(:"SYS_B_22", :"SYS_B_23") and to_date(:"SYS_B_24", :"SYS_B_25") Order By Mx.C_Pzh Desc, Mx.C_Pzhh Asc |
gf4thkbsgfd45 |
SELECT C_CXH, C_CLYS, C_SCSX, C_CLSX, C_XSQY, C_TQSJ, C_NY, C_ZXZL C_DZL, C_DDH, C_SOP, C_TSXX, C_BZ, (SELECT C_MC FROM T_SJZD WHERE C_CLBM = DECODE(C_YWM, 'NO1', C_ZXSCSX, DECODE(C_ZXSCSX || SUBSTR(C_SOP, 0, 3), '0403111', '0403', '0402'))) C_ZXSCSX, DECODE(SUBSTR(C_SOP, 6, 1), '1', 0, (SELECT COUNT(1) FROM T_CLRKSJ A WHERE A.C_CXH = B.C_DPCH AND A.C_YSBM=B.C_CLYSA AND C_RKSL = 1 AND TRUNC(A.C_RQ) BETWEEN (SELECT MIN(C_QSRQ) FROM T_ZYRL WHERE C_NY >= TO_CHAR(ADD_MONTHS(TO_DATE(B.C_NY, 'yyyymm'), -13), 'yyyymm') AND C_JHZZBM = :B4 ) AND (SELECT MAX(C_ZZRQ) FROM T_ZYRL WHERE C_JHZZBM=:B4 AND C_NY = TO_CHAR(ADD_MONTHS(TO_DATE(B.C_NY, 'yyyymm'), -1), 'yyyymm')))) C_SL FROM (SELECT C_CXH, (SELECT YS.C_YSJC FROM T_YSQD YS WHERE C_YSBM = C_CLYS) C_CLYS, C_CLYS C_CLYSA, (SELECT C_MC FROM T_SJZD WHERE C_CLBM = C_SCSX) C_SCSX, (SELECT C_MC FROM T_SJZD WHERE C_CLBM = C_CLSX) C_CLSX, (SELECT C_MC FROM T_SJZD WHERE C_CLBM = C_XSQY) C_XSQY, C_TQSJ, TO_CHAR(P.C_JSSJ - 7, 'yyyymm') C_NY, C_ZXZL, 'c_Tsxx' C_BKPCYY, C_DDH, QD.SOPTAG C_SOP, QD.QYRQ C_TSXX, C_BZ, C_BZ2, C_BZ3, C_SCSX C_ZXSCSX, SUBSTR(:B1 , 0, 3) C_YWM, C_DPCH FROM T_XQMX T, T_XQQD P, (SELECT DISTINCT QYRQ, SCJHCX, SOPTAG FROM T_KPCCXQD) QD WHERE P.C_JHZZBM = :B4 AND ((:B2 <> 0 AND P.C_XQDW = :B3 ) OR :B2 =0) AND T.C_XQQDXLH = P.C_XQQDXLH AND P.C_XQH = :B1 AND T.C_SCJHCXH = QD.SCJHCX AND INSTR(QD.SOPTAG, '0') > 0) B
|
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 |
gp2srf6v3th3r | select s.synonym_name object_name, o.object_type
from all_synonyms s,
sys.all_objects o
where s.owner in (:"SYS_B_0", :schema)
and o.owner = s.table_owner
and o.object_name = s.table_name
and o.object_type in (:"SYS_B_1", :"SYS_B_2", :"SYS_B_3", :"SYS_B_4", :"SYS_B_5", :"SYS_B_6", :"SYS_B_7")
|
grwydz59pu6mc | select text from view$ where rowid=:1 |