| SQL Id | SQL Text |
|---|
| 2atabfx3t44z9 |
select refcon, mvtident, OPCVM, SICOVAM, TYPESICO,
DATENEG-to_date(:"SYS_B_00", :"SYS_B_01"), HEURENEG,
DATEVAL-to_date(:"SYS_B_02", :"SYS_B_03"), TYPE, QUANTITE, MONTANT,
FRAISMARCHE, FRAISCOURTAGE, FRAISCOUNTERPARTY, QUANTITE*COURS,
MONTANTCOURU, MONTANTCOURU2, DATEJOUISSANCE-to_date(:"SYS_B_04",
:"SYS_B_05"), DEVISEPAY, TAUXCHANGE, CERTAIN, COMMISSION,
COMMISSION_DATE-to_date(:"SYS_B_06", :"SYS_B_07"), CONTREPARTIE, ENTITE,
DELIVERY_DATE-to_date(:"SYS_B_08", :"SYS_B_09"), TEMPLATE_ID,
AJUSTEMENT, forceLoad, ACCRUED_ON_NEXT_DATE, COMPONENT_CODE,
DEPOSITAIRE , courtier, operateur from INTEREST_REPORTING h where
exists (select :"SYS_B_10" from OPCVMFORREPORTING ofr where ofr.OPCVM =
h.OPCVM) and (:"SYS_B_11"=:"SYS_B_12") and ((TYPE != :"SYS_B_13" or
(TYPE = :"SYS_B_14" and DATEVAL-to_date(:"SYS_B_15", :"SYS_B_16") =
:"SYS_B_17"))) AND BACKOFFICE IN (:"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", :"SYS_B_62", :"SYS_B_63") AND :"SYS_B_64"=:"SYS_B_65" and
DATENEG-to_date(:"SYS_B_66", :"SYS_B_67")<=:"SYS_B_68" and
(dateneg>=to_date(:"SYS_B_69", :"SYS_B_70")-:"SYS_B_71" or
dateval>=:"SYS_B_72"+to_date(:"SYS_B_73", :"SYS_B_74")) |
| 2b064ybzkwf1y | BEGIN EMD_NOTIFICATION.QUEUE_READY(:1, :2, :3); END; |
| 2wr75u83fvxcm | select
SICOVAM, LIBELLE, TYPE, BETA, DeviseCTT, MNEMO_v2, externref,
Affectation, PERIMETERID, reference, oldDevise,
oldDateDevise-TO_DATE(:"SYS_B_0", :"SYS_B_1"), proprietaire, STATUS,
marche from TITRES order by sicovam |
| 32jr6drbk3t3c | select count(*) from ireporting_worker_domain where worker = :"SYS_B_0" |
| 35fzc3454qy0y | /* OracleOEM */
SELECT PROPAGATION_NAME, TOTAL_NUMBER, TOTAL_BYTES/:"SYS_B_0" KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q
WHERE P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND MESSAGE_DELIVERY_MODE=:"SYS_B_1"
|
| 3nun77byv5ky4 | select
min(SOPHIS_IDENT) from EXTRNL_REFERENCES_INSTRUMENTS where REF_IDENT in
(select REF_IDENT from EXTRNL_REFERENCES_DEFINITION where
REDUNDANCY=:"SYS_B_0") and VALUE = :refext |
| 4cy191jvb369v | SELECT
event#, sql_id, sql_plan_hash_value, sql_opcode, session_id,
session_serial#, module, action, client_id, DECODE(wait_time,
:"SYS_B_0", :"SYS_B_1", :"SYS_B_2"), :"SYS_B_3", time_waited,
service_hash, user_id, program, sample_time, p1, p2, p3,
current_file#, current_obj#, current_block#, qc_session_id,
qc_instance_id, plsql_object_id, plsql_subprogram_id,
qc_session_serial# FROM v$active_session_history WHERE sample_time >
:1 AND sample_time <= :2 |
| 4tg8mr2bvy6gr | select
smontabv.cnt, smontab.time_mp, smontab.scn, smontab.num_mappings,
smontab.tim_scn_map from smon_scn_time smontab, (select
max(scn) scnmax, count(*)+sum(NVL2(TIM_SCN_MAP,
NUM_MAPPINGS, 0)) cnt from smon_scn_time) smontabv
where smontab.scn = smontabv.scnmax |
| 4w5mkcpzsupu9 | LOCK TABLE IREPORTING_TASKS IN EXCLUSIVE MODE |
| 5vunv8rxugwu7 | SELECT SUBSTR(:B2 , 0, :B1 - 1) FROM DUAL |
| 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end; |
| 6f1nsj01f6tjn | select
id, parentid, workflow_id, worker_name, api_user_name, ERRORMSG,
status, processortype, starttime, endtime, REPORTING_DATE,
DESCRIPTION, FOLIO_ID, FUND_ID, CONTEXT_ID, DEDICATED_API,
API_ARGS, DOMAIN, PRIORITY, PERIMETER_FILTER, WFTaskReRunInfo from
IREPORTING_TASKS where status=:"SYS_B_0" and worker_name=:"SYS_B_1" |
| 6gq4c990xjfnt | SELECT INSTR(:B1 , ':') FROM DUAL |
| 6gvch1xu9ca3g | DECLARE
job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN
:= FALSE; BEGIN EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); :mydate :=
next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 6gwxfcsw5vqfx | SELECT
DISTINCT API_USER_NAME FROM IREPORTING_TASKS WHERE STATUS = 1 AND
PROCESSORTYPE NOT IN (SELECT PROCESSORTYPE FROM LOCKED_PROC_TYPE) AND
ROWNUM=1 AND PROCESSORTYPE <> 'WFTask' AND DOMAIN IN (SELECT
DOMAIN FROM IREPORTING_WORKER_DOMAIN WHERE WORKER = :B1 ) |
| 78mbs4dcxzj87 | begin ASSIGNIREPORTINGTASK('SophisWorker_228:3', 0, '', ''); end; |
| 7j3uv43ss9zm3 | select
id, dataref, datatype, elementtype, when-to_date(:"SYS_B_0",
:"SYS_B_1"), latest_dataref, status, historical from DS_UPDATE_RESULTS
where dataref=:1 and datatype=:2 and elementtype=:3 and historical=:4
order by latest_dataref desc, when desc |
| 88tjsk5qm71a2 | SELECT COUNT(*) FROM IREPORTING_WORKER_DOMAIN WHERE WORKER = :B1 |
| 8u809k64x3nzd | begin DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT(); end; |
| ad9skf36dd96v |
SELECT decode(bitand(t.property, :"SYS_B_00"), :"SYS_B_01", ts.name,
:"SYS_B_02") tablespace_name, decode(bitand(t.property,
:"SYS_B_03"+:"SYS_B_04"), :"SYS_B_05", mod(t.pctfree$, :"SYS_B_06"),
:"SYS_B_07", :"SYS_B_08", -:"SYS_B_09") pct_free,
decode(bitand(ts.flags, :"SYS_B_10"), :"SYS_B_11",
to_number(-:"SYS_B_12"), decode(bitand(t.property,
:"SYS_B_13"+:"SYS_B_14"), :"SYS_B_15", t.pctused$, :"SYS_B_16",
:"SYS_B_17", -:"SYS_B_18")) pct_used, decode(bitand(t.property,
:"SYS_B_19"), :"SYS_B_20", t.initrans, -:"SYS_B_21") ini_trans,
decode(bitand(t.property, :"SYS_B_22"), :"SYS_B_23", t.maxtrans,
-:"SYS_B_24") max_trans, (NVL(s.iniexts * ts.blocksize, -:"SYS_B_25") /
:"SYS_B_26") init_extent, (NVL(decode(bitand(ts.flags, :"SYS_B_27"),
:"SYS_B_28", to_number(NULL), s.extsize * ts.blocksize),
-:"SYS_B_29")/:"SYS_B_30") next_extent, NVL(s.minexts, -:"SYS_B_31")
min_extents, NVL(s.maxexts, -:"SYS_B_32") max_extents,
NVL(decode(bitand(ts.flags, :"SYS_B_33"), :"SYS_B_34",
to_number(NULL), s.extpct), -:"SYS_B_35") pct_increase,
NVL(decode(bitand(ts.flags, :"SYS_B_36"), :"SYS_B_37",
to_number(NULL), decode(bitand(o.flags, :"SYS_B_38"), :"SYS_B_39",
:"SYS_B_40", decode(s.lists, :"SYS_B_41", :"SYS_B_42", s.lists))),
-:"SYS_B_43") freelists, NVL(decode(bitand(ts.flags, :"SYS_B_44"),
:"SYS_B_45", to_number(NULL), decode(bitand(o.flags, :"SYS_B_46"),
:"SYS_B_47", :"SYS_B_48", decode(s.groups, :"SYS_B_49", :"SYS_B_50",
s.groups))), -:"SYS_B_51") freelist_groups, decode(bitand(o.flags,
:"SYS_B_52"), :"SYS_B_53", :"SYS_B_54", decode(s.cachehint,
:"SYS_B_55", :"SYS_B_56", :"SYS_B_57", :"SYS_B_58", :"SYS_B_59",
:"SYS_B_60", :"SYS_B_61")) buffer_pool, decode(bitand(t.property,
:"SYS_B_62"), :"SYS_B_63", -:"SYS_B_64", decode(bitand(t.flags,
:"SYS_B_65"), :"SYS_B_66", :"SYS_B_67", :"SYS_B_68")) logging,
decode(u.COMPRESSION, :"SYS_B_69", decode (u.COMPRESS_FOR,
:"SYS_B_70", :"SYS_B_71", :"SYS_B_72"), :"SYS_B_73", :"SYS_B_74",
-:"SYS_B_75") compression FROM sys.ts$ ts, sys.seg$ s, sys.tab$ t,
sys.obj$ o, sys.dba_tables u WHERE o.obj#=:1 AND o.obj# = t.obj# AND
bitand(t.property, :"SYS_B_76") = :"SYS_B_77" AND t.ts# = ts.ts# AND
t.file# = s.file# (+) AND t.block# = s.block# (+) AND t.ts# = s.ts# (+)
AND u.TABLE_NAME = o.name |
| ax2hpnygtdxum | select
id, parentid, workflow_id, worker_name, api_user_name, ERRORMSG,
status, processortype, starttime, endtime, REPORTING_DATE,
DESCRIPTION, FOLIO_ID, FUND_ID, CONTEXT_ID, DEDICATED_API,
API_ARGS, DOMAIN, PRIORITY, PERIMETER_FILTER, WFTaskReRunInfo from
IREPORTING_TASKS where id= :"SYS_B_0" |
| az08f63va5rnb | SELECT
SNAP_ID, SUM(DECODE(STAT_ID, 572264820, VALUE, 0))
CPU_WHEN_CALL_STARTED, SUM(DECODE(STAT_ID, 582481098, VALUE, 0))
USER_COMMITS, SUM(DECODE(STAT_ID, 3671147913, VALUE, 0))
USER_ROLLBACKS, SUM(DECODE(STAT_ID, 2666645286, VALUE, 0))
LOGONS_CUMULATIVE, SUM(DECODE(STAT_ID, 2263124246, VALUE, 0))
PHYSICAL_READS, SUM(DECODE(STAT_ID, 1236385760, VALUE, 0)) REDO_SIZE
FROM DBA_HIST_SYSSTAT WHERE DBID = :B52 AND INSTANCE_NUMBER = :B51 AND
SNAP_ID BETWEEN :B50 AND :B1 AND STAT_ID IN (572264820, 582481098,
3671147913, 2666645286, 2263124246, 1236385760) GROUP BY SNAP_ID
HAVING SNAP_ID IN (:B50 , :B49 , :B48 , :B47 , :B46 , :B45 , :B44 , :B43
, :B42 , :B41 , :B40 , :B39 , :B38 , :B37 , :B36 , :B35 , :B34 , :B33 ,
:B32 , :B31 , :B30 , :B29 , :B28 , :B27 , :B26 , :B25 , :B24 , :B23 ,
:B22 , :B21 , :B20 , :B19 , :B18 , :B17 , :B16 , :B15 , :B14 , :B13 ,
:B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1
) ORDER BY SNAP_ID |
| by8y29h8f6ynm | select
TASK_ID, PARAMETER_NAME, PARAMETER_VALUE, IN_OUT from
IREPORTING_TASKS_PARAMETERS where TASK_ID in (select id from
IREPORTING_TASKS where status=:"SYS_B_0" and worker_name=:"SYS_B_1" ) |
| c1h5xknydmdmp | select refcon from HISTOMVTS where infosbackoffice = :refext |
| 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# |
| du5k0q2c680ka | select
e.echeance, o.typecallput, o.strike, s.quotite, o.MNEMO, e.ident
from MO_ECHEANCE e, LISTEDOPTION_KEY o, MO_SUPPORT s,
EXTRNL_REFERENCES_DEFINITION f, EXTRNL_REF_LISTEDOPTIONS l where
f.ref_name = :"SYS_B_0" and f.ref_ident = l.ref_ident and
e.ident=o.echeance and l.listedoption_ident = o.ident and s.mnemo =
o.mnemo and l.value = :"SYS_B_1" |
| fby7d0mqtffg6 | SELECT ERRORXML from IREPORTING_TASKS where id= :"SYS_B_0" |
| fsnj0uhv3x2bz | select sicovam from TITRES where EXTERNREF = :refext |
| fth4vxkjdf11c | select TASK_ID, PARAMETER_NAME, PARAMETER_VALUE, IN_OUT from IREPORTING_TASKS_PARAMETERS where TASK_ID= :"SYS_B_0" |
| fzjufg4jts1gq | ** SQL Text Not Available ** |
| g7kcvccanqxcd | begin ASSIGNIREPORTINGTASK('SophisWorker_229:2', 0, '', ''); end; |
| gdffwc2xnmqz0 | select
count(*) from IREPORTING_TASKS where processortype <> :"SYS_B_0"
CONNECT by parentid = prior id start with id = :"SYS_B_1" |
| gfkxrbcdk88kt | select
SOPHIS_IDENT from EXTRNL_REFERENCES_INSTRUMENTS where VALUE =
:"SYS_B_0" and REF_IDENT in (select REF_IDENT from
EXTRNL_REFERENCES_DEFINITION where REF_NAME = :"SYS_B_1") |
| gn8fdqny7vj4y | select
count(*) from IREPORTING_TASKS where processortype <> :"SYS_B_0"
and status = :"SYS_B_1" CONNECT by parentid = prior id start with id =
:"SYS_B_2" |