WORKLOAD REPOSITORY PDB report (root snapshots)

DB Name	DB Id	Unique Name	Role	Edition	Release	RAC	CDB
CDBFINI2	43681096	CDBFINI2	PRIMARY	XP	19.0.0.0.0	YES	YES

Instance	Inst Num	Startup Time	User Name	System Data Visible
CDBFINI22	2	02-Nov-24 12:15	SYS	YES

Container DB Id	Container Name	Open Time
4009012992	PDBFINI2	02-Nov-24 12:16

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
etic1pdb04	Linux x86 64-bit	4	2	2	393.16

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	16511	07-Feb-25 19:00:32	265	16.9
End Snap:	16515	07-Feb-25 23:00:26	248	17.2
Elapsed:		239.90 (mins)
DB Time:		207.46 (mins)

Report Summary

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.9	0.2	0.00	0.01
DB CPU(s):	0.4	0.1	0.00	0.01
Background CPU(s):	0.0	0.0	0.00	0.00
Redo size (bytes):	92,425.0	25,956.3
Logical read (blocks):	24,462.5	6,870.0
Block changes:	762.9	214.3
Physical read (blocks):	406.5	114.2
Physical write (blocks):	0.0	0.0
Read IO requests:	63.6	17.9
Write IO requests:	0.0	0.0
Read IO (MB):	3.2	0.9
Write IO (MB):	0.0	0.0
IM scan rows:	0.0	0.0
Session Logical Read IM:	0.0	0.0
Global Cache blocks received:	2.0	0.6
Global Cache blocks served:	0.0	0.0
User calls:	63.7	17.9
Parses (SQL):	10.1	2.8
Hard parses (SQL):	0.1	0.0
SQL Work Area (MB):	98.4	27.7
Logons:	0.1	0.0
User logons:	0.0	0.0
Executes (SQL):	14,739.8	4,139.5
Rollbacks:	1.2	0.3
Transactions:	3.6

Top 10 Foreground Events by Total Wait Time

Wait Classes by Total Wait Time

IO Profile

	Read+Write Per Second	Read per Second	Write Per Second
Total Requests:	64.2	64.2	0.0
Database Requests:	63.6	63.6	0.0
Optimized Requests:	64.2	64.2	0.0
Redo Requests:
Total (MB):	3.2	3.2	0.0
Database (MB):	3.2	3.2	0.0
Optimized Total (MB):	3.2	3.2	0.0
Redo (MB):
Database (blocks):	406.5	406.5	0.0
Via Buffer Cache (blocks):	72.3	72.3	0.0
Direct (blocks):	334.2	334.2	0.0

Database Resource Limits

	Begin	End
CPUs:	8	4
SGA Target:	7,969,177,600	7,969,177,600
PGA Target:	5,242,880,000	5,242,880,000
Memory Target	0	0

Main Report

• Report Summary
• Wait Events Statistics
• SQL Statistics
• Instance Activity Statistics
• IO Stats
• Wait Statistics
• Undo Statistics
• Segment Statistics
• Dictionary Cache Statistics
• Library Cache Statistics
• Initialization Parameters
• Active Session History (ASH) Report
• ADDM Reports

Wait Events Statistics

• Time Model Statistics
• Foreground Wait Class
• Foreground Wait Events
• Service Statistics
• Service Wait Class Stats
• Top Process Types by Wait Class
• Top Process Types by CPU Used

Time Model Statistics

• DB Time represents total time in user calls
• DB CPU represents CPU time of foreground processes
• Total CPU Time represents foreground and background processes
• Statistics including the word "background" measure background process time, therefore do not contribute to the DB time statistic
• Ordered by % of DB time in descending order, followed by Statistic Name

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond, us - microsecond, ns - nanosecond
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 54.6% of Total DB time 12,447.84 (s)
• Total FG Wait Time: 849.94 (s) DB CPU time: 5,950.47 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

• s - second, ms - millisecond, us - microsecond, ns - nanosecond
• Only events with Total Wait Time (s) >= .001 are shown
• ordered by wait time desc, waits desc (idle events last)
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

• Wait Class info for services in the Service Statistics section.
• Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
• Time Waited (Wt Time) in seconds

Back to Wait Events Statistics
Back to Top

Top Process Types by Wait Class

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Top Process Types by CPU Used

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Offload Eligible Bytes
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• SQL ordered by Cluster Wait Time
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 61.6% of Total DB Time (s): 12,448
• Captured PL/SQL account for 82.8% of Total DB Time (s): 12,448

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 47.2% of Total CPU Time (s): 5,950
• Captured PL/SQL account for 85.0% of Total CPU Time (s): 5,950

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - User I/O Time as a percentage of Total User I/O Wait time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 58.1% of Total User I/O Wait Time (s): 245
• Captured PL/SQL account for 5.5% of Total User I/O Wait Time (s): 245

Back to SQL Statistics
Back to Top

SQL ordered by Gets

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - Buffer Gets as a percentage of Total Buffer Gets
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Buffer Gets: 352,120,262
• Captured SQL account for 100.3% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 5,851,261
• Captured SQL account for 102.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqs - (Optimized Read Reqs - Cell Flash Cache Read Hits for Controlfile)
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 916,012
• Captured SQL account for 160.6% of Total
• Total UnOptimized Read Requests: 1
• Captured SQL account for 1.0E+05% of Total
• Total Optimized Read Requests: 923,472
• Captured SQL account for 159.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Offload Eligible Bytes

• Offload Eligible Bytes are eligible for offload on Exadata
• %Ret SS - percentage of Interconnect GB returned for Smart Scan
• %Cell Eff - Cell Offload Efficiency
• %Total - Offload Eligible Bytes as a percentage of Total Offload Elig Bytes
• Total Offload Eligible GB: 37
• Captured SQL account for 69.8% of Total
• Total IO Interconnect GB: 8
• Captured SQL account for 173.5% of Total
• Total Uncompressed GB: 8
• Captured SQL account for 45.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 212,168,387
• Captured SQL account for 99.8% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 145,570
• Captured SQL account for 43.2% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

• %Total - Cluster Time as a percentage of Total Cluster Wait Time
• %Clu - Cluster Time as a percentage of Elapsed Time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Only SQL with Cluster Wait Time > .005 seconds is reported
• Total Cluster Wait Time (s): 141
• Captured SQL account for 50.2% of Total

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
01d5n1nm17r2h	select nvl2(stale_stats, decode(stale_stats, 'NO', 3, 1), 2) from dba_ind_statistics where owner=:1 and index_name=:2
05uqdabhzncdc	select role# from defrole$ d, user$ u where d.user#=:1 and u.user#=d.user# and u.defrole=2 union select privilege# from sysauth$ s, user$ u where (grantee#=:1 or grantee#=1) and privilege#>0 and not exists (select null from defrole$ where user#=:1 and role#=s.privilege#) and u.user#=:1 and u.defrole=3
0ass0z50uzu86	select substr(haou.name, 4, 4) || '_' || substr(haou.name, 1, 3) || '_' || acra.cash_receipt_id || '_' || acrahist.cash_receipt_history_id Identifiant, acra.cash_receipt_id as "ID_Reglement_OA", acrahist.cash_receipt_history_id, arc.name as Mode_reglement, vue.remit_bank_account Compte_bancaire, vue.remit_bank_name Banque_remise, vue.remit_bank_branch Agence_remise, gcc1.segment3, acra.receipt_number "Numero reglement_OA", -- acrahist.status as Statut_Hist, decode(acrahist.status, 'REVERSED', 'Annulation', 'CONFIRMED', 'Confirme', 'CLEARED', 'Creation', 'REMITTED', 'Creation', 'Creation') as Statut_Rglt, --acra.status as Statut_Rglt, acrahist.gl_date, haou.name AS "UO", substr(haou.name, 1, 3) AS "Region", substr(haou.name, 4, 4) AS "Societe", rc.customer_number as "Numero Client", rc.customer_name as "Client", hcsu.location as "Adresse", acra.currency_code Devise, case when acrahist.status ='REVERSED' then acra.amount else acra.amount *-1 end as "Montant reglement AR", to_char(acrahist.creation_date, 'DD/MM/YYYY HH24:MI:SS') as "Date creation", acra.attribute4 as Date_du_Prelevement, fnd.user_name, fnd.description "Cree par", case when araa.status = 'APP' then rcta.trx_number when araa.status = 'ACTIVITY' then (select receipt_number from ar_payment_schedules_all apsa, ar_cash_receipts_all acr where apsa.payment_schedule_id = araa.applied_payment_schedule_id and acr.cash_receipt_id = apsa.cash_receipt_id) when araa.status = 'ACC' then 'En Compte' end as "N? Facture", case when araa.status = 'APP' and araa.application_ref_num not like '%DOUTEUX' then 'Facture' when araa.status = 'APP' and araa.application_ref_num like '%DOUTEUX' then 'Reliquat' when araa.status = 'ACTIVITY' then 'Reglement' end as "Classe", araa.amount_applied Montant_Lettre from ar_cash_receipts_all acra, AR_CASH_RECEIPTS_V vue, hr_all_organization_units haou, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, ar_receipt_methods arm, ar_receipt_classes arc, gl_code_combinations_kfv gcc, ar_customers rc, hz_cust_accounts hca, AR_RECEIPT_METHOD_ACCOUNTS_all armaa, fnd_user fnd, AR_CASH_RECEIPT_HISTORY_ALL acrahist, gl_code_combinations_kfv gcc1, ar_receivable_applications_all araa, ra_customer_trx_all rcta where acra.receipt_method_id = arm.receipt_method_id -- and acra.creation_date <=to_date('27/05/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J -- AND acrahist.creation_date >=to_date('27/12/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J-1 AND acra.pay_from_customer = rc.customer_id (+) and hcsu.cust_acct_site_id = hcas.cust_acct_site_id(+) AND hcsu.org_id = hcas.org_id(+) AND hcas.cust_account_id = hca.cust_account_id(+) and hcsu.gl_id_rec = gcc.code_combination_id(+) and acra.org_id = haou.organization_id AND acra.customer_site_use_id = hcsu.Site_use_id(+) AND arm.receipt_class_id = arc.receipt_class_id and armaa.receipt_method_id =arm.receipt_method_id and fnd.user_id = acrahist.created_by and acra.cash_receipt_id = acrahist.cash_receipt_id and acra.cash_receipt_id = vue.cash_receipt_id and vue.remit_bank_acct_use_id = armaa.remit_bank_acct_use_id and acrahist.account_code_combination_id = gcc1.code_combination_id --- and substr(haou.name, 4, 4) in ('0490', '0491', '0492', '0493', '0498') ---and acra.cash_receipt_id ='2624378' AND acra.org_id = armaa.org_id ---and hcsu.location in ('0512152H', '0514250P') --- Ref ANAEL ---and rc.customer_number = '00046919' and acrahist.status !='CONFIRMED' and araa.cash_receipt_id = acra.cash_receipt_id and araa.display ='Y' and acra.creation_date >='01/01/2024' ---and arc.name !='PRELEVEMENT' and substr(haou.name, 1, 3) in ('DMS', 'DEW') --- and acra.cash_receipt_id ='3201098' and araa.applied_customer_trx_id = rcta.customer_trx_id (+) order by acrahist.cash_receipt_id, acrahist.cash_receipt_history_id
0dbcsb3z1ygcq	SELECT 60 * (to_number(decode(dp.Limit, 'UNLIMITED', '-1', 'DEFAULT', (SELECT to_char(60 * (to_number(decode(Limit, 'UNLIMITED', '-1', Limit)))) FROM DBA_PROFILES WHERE Profile = 'DEFAULT' AND Resource_Name = 'IDLE_TIME'), dp.Limit))) FROM USER_USERS uu, DBA_USERS du, DBA_PROFILES dp WHERE uu.User_Id = du.User_Id AND du.Profile = dp.Profile AND dp.Resource_Name = 'IDLE_TIME'
0f6qspdu164f9	SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :1 and table_name = :2 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :3 and table_name = :4 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :5 and table_name = :6 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :7 and table_name = :8 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :9 and table_name = :10 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :11 and table_name = :12 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :13 and table_name = :14 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :15 and table_name = :16 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :17 and table_name = :18 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :19 and table_name = :20 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :21 and table_name = :22 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :23 and table_name = :24 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :25 and table_name = :26 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :27 and table_name = :28 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :29 and table_name = :30 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :31 and table_name = :32 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :33 and table_name = :34 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :35 and table_name = :36 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :37 and table_name = :38 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :39 and table_name = :40 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :41 and table_name = :42
0mqcv3mx5vy0g	merge into sys.col_group_usage$ d using (select :1 obj#, :2 cols from dual) s on (d.obj# = s.obj# and d.cols = s.cols) when matched then update set d.timestamp = :3, d.flags = d.flags + :4 - bitand(d.flags, :4) when not matched then insert (obj#, cols, timestamp, flags) values (:1, :2, :3, :4)
0rchqc9t7puxd	SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE) OPT_PARAM('_ENABLE_VIEW_PDB', 'FALSE') */ "OWNER", "OWNERID", "SYNONYM_NAME", "OBJECT_TYPE#", "BASE_OBJ_OWNER", "BASE_OBJ_NAME" FROM NO_CROSS_CONTAINER("SYS"."_INT$_ALL_SYNONYMS_FOR_AO") "_INT$_ALL_SYNONYMS_FOR_AO" WHERE 1=1
121ffmrc95v7g	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), nvl(i.evaledition#, 1), nvl(i.unusablebefore#, 0), nvl(i.unusablebeginning#, 0), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(intcols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
142rj761ckuwk	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((602, 48122)) OR (R.REQUEST_CLASS_APPLICATION_ID, R.CONCURRENT_REQUEST_CLASS_ID) IN ((0, 4))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
1awncyx9pyhvm	SELECT SP.ORG_ID, SOB.CHART_OF_ACCOUNTS_ID, SOB.SET_OF_BOOKS_ID, SOB.NAME, FC.CURRENCY_CODE, SP.ACCOUNTING_METHOD, SP.ACCRUE_INTEREST, SP.UNEARNED_DISCOUNT, SP.PARTIAL_DISCOUNT_FLAG, SP.PRINT_REMIT_TO, SP.DEFAULT_CB_DUE_DATE, SP.AUTO_SITE_NUMBERING, SP.CASH_BASIS_SET_OF_BOOKS_ID, SP.CODE_COMBINATION_ID_GAIN, SP.AUTOCASH_HIERARCHY_ID, SP.RUN_GL_JOURNAL_IMPORT_FLAG, SP.CER_SPLIT_AMOUNT, SP.CER_DSO_DAYS, SP.POSTING_DAYS_PER_CYCLE, SP.ADDRESS_VALIDATION, SP.CALC_DISCOUNT_ON_LINES_FLAG, SP.CHANGE_PRINTED_INVOICE_FLAG, SP.CODE_COMBINATION_ID_LOSS, SP.CREATE_RECIPROCAL_FLAG, SP.DEFAULT_COUNTRY, SP.DEFAULT_TERRITORY, SP.GENERATE_CUSTOMER_NUMBER, SP.INVOICE_DELETION_FLAG, SP.LOCATION_STRUCTURE_ID, SP.SITE_REQUIRED_FLAG, ZXPO.TAX_ALLOW_COMPOUND_FLAG, SP.TAX_HEADER_LEVEL_FLAG, ZXPO.ALLOW_TAX_ROUNDING_OVRD_FLAG, SP.TAX_INVOICE_PRINT, ZXPO.TAX_METHOD_CODE, ZXPO.TAX_USE_CUSTOMER_EXEMPT_FLAG, SP.TAX_USE_CUST_EXC_RATE_FLAG, ZXPO.TAX_USE_LOC_EXC_RATE_FLAG, ZXPO.TAX_USE_PRODUCT_EXEMPT_FLAG, SP.TAX_USE_PROD_EXC_RATE_FLAG, SP.TAX_USE_SITE_EXC_RATE_FLAG, SP.AI_LOG_FILE_MESSAGE_LEVEL, SP.AI_MAX_MEMORY_IN_BYTES, SP.AI_ACCT_FLEX_KEY_LEFT_PROMPT, SP.AI_MTL_ITEMS_KEY_LEFT_PROMPT, SP.AI_TERRITORY_KEY_LEFT_PROMPT, SP.AI_PURGE_INTERFACE_TABLES_FLAG, SP.AI_ACTIVATE_SQL_TRACE_FLAG, SP.DEFAULT_GROUPING_RULE_ID, SP.SALESREP_REQUIRED_FLAG, SP.AUTO_REC_INVOICES_PER_COMMIT, SP.AUTO_REC_RECEIPTS_PER_COMMIT, SP.PAY_UNRELATED_INVOICES_FLAG, SP.PRINT_HOME_COUNTRY_FLAG, SP.LOCATION_TAX_ACCOUNT, SP.FROM_POSTAL_CODE, SP.TO_POSTAL_CODE, SP.TAX_REGISTRATION_NUMBER, SP.POPULATE_GL_SEGMENTS_FLAG, SP.UNALLOCATED_REVENUE_CCID, SOB.PERIOD_SET_NAME, FC.PRECISION, FC.EXTENDED_PRECISION, FC.MINIMUM_ACCOUNTABLE_UNIT, RS.NAME, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING( 'YES/NO', 'Y'), ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING( 'YES/NO', 'N'), ARPT_SQL_FUNC_UTIL.GET_FNDLOOKUP_MEANING('ZX_EXEMPTION_CONTROL', 'S'), ZXPO.INCLUSIVE_TAX_USED_FLAG, SP.TAX_ENFORCE_ACCOUNT_FLAG, SP.TA_INSTALLED_FLAG, SP.BILLS_RECEIVABLE_ENABLED_FLAG, SP.ATTRIBUTE_CATEGORY, SP.ATTRIBUTE1, SP.ATTRIBUTE2, SP.ATTRIBUTE3, SP.ATTRIBUTE4, SP.ATTRIBUTE5, SP.ATTRIBUTE6, SP.ATTRIBUTE7, SP.ATTRIBUTE8, SP.ATTRIBUTE9, SP.ATTRIBUTE10, SP.ATTRIBUTE11, SP.ATTRIBUTE12, SP.ATTRIBUTE13, SP.ATTRIBUTE14, SP.ATTRIBUTE15, SP.CREATED_BY, SP.CREATION_DATE, SP.LAST_UPDATED_BY, SP.LAST_UPDATE_DATE, SP.LAST_UPDATE_LOGIN, ZXPO.TAX_CLASSIFICATION_CODE, SP.TAX_CURRENCY_CODE, ZXPO.TAX_MINIMUM_ACCOUNTABLE_UNIT, ZXPO.TAX_PRECISION, ZXPO.TAX_ROUNDING_RULE, SP.TAX_USE_ACCOUNT_EXC_RATE_FLAG, SP.TAX_USE_SYSTEM_EXC_RATE_FLAG, SP.TAX_HIER_SITE_EXC_RATE, SP.TAX_HIER_CUST_EXC_RATE, SP.TAX_HIER_PROD_EXC_RATE, SP.TAX_HIER_ACCOUNT_EXC_RATE, SP.TAX_HIER_SYSTEM_EXC_RATE, SP.TAX_DATABASE_VIEW_SET, SP.GLOBAL_ATTRIBUTE1, SP.GLOBAL_ATTRIBUTE2, SP.GLOBAL_ATTRIBUTE3, SP.GLOBAL_ATTRIBUTE4, SP.GLOBAL_ATTRIBUTE5, SP.GLOBAL_ATTRIBUTE6, SP.GLOBAL_ATTRIBUTE7, SP.GLOBAL_ATTRIBUTE8, SP.GLOBAL_ATTRIBUTE9, SP.GLOBAL_ATTRIBUTE10, SP.GLOBAL_ATTRIBUTE11, SP.GLOBAL_ATTRIBUTE12, SP.GLOBAL_ATTRIBUTE13, SP.GLOBAL_ATTRIBUTE14, SP.GLOBAL_ATTRIBUTE15, SP.GLOBAL_ATTRIBUTE16, SP.GLOBAL_ATTRIBUTE17, SP.GLOBAL_ATTRIBUTE18, SP.GLOBAL_ATTRIBUTE19, SP.GLOBAL_ATTRIBUTE20, SP.GLOBAL_ATTRIBUTE_CATEGORY, SP.RULE_SET_ID, SP.CODE_COMBINATION_ID_ROUND, SP.TRX_HEADER_LEVEL_ROUNDING, SP.TRX_HEADER_ROUND_CCID, SP.FINCHRG_RECEIVABLES_TRX_ID, SP.SALES_TAX_GEOCODE, SP.REV_TRANSFER_CLEAR_CCID, SP.SALES_CREDIT_PCT_LIMIT, SP.MAX_WRTOFF_AMOUNT, SP.IREC_CC_RECEIPT_METHOD_ID, SP.SHOW_BILLING_NUMBER_FLAG, SP.CROSS_CURRENCY_RATE_TYPE, SP.DOCUMENT_SEQ_GEN_LEVEL, 'Y', SP.IREC_BA_RECEIPT_METHOD_ID, AR_MO_CACHE_UTILS.TM_INSTALLED (SP.ORG_ID), AR_MO_CACHE_UTILS.TM_DEFAULT_SETUP (SP.ORG_ID), SP.PAYMENT_THRESHOLD, SP.STANDARD_REFUND, SP.CREDIT_CLASSIFICATION1, SP.CREDIT_CLASSIFICATION2, SP.CREDIT_CLASSIFICATION3, SP.UNMTCH_CLAIM_CREATION_FLAG, SP.MATCHED_CLAIM_CREATION_FLAG, SP.MATCHED_CLAIM_EXCL_CM_FLAG, SP.MIN_WRTOFF_AMOUNT, SP.MIN_REFUND_AMOUNT, SP.CREATE_DETAILED_DIST_FLAG, SP.DEFAULT_RCT_MTHD_FOR_LC_INV FROM GL_SETS_OF_BOOKS SOB, FND_CURRENCIES FC, JTF_RS_SALESREPS RS, AR_SYSTEM_PARAMETERS SP, ZX_PRODUCT_OPTIONS ZXPO WHERE SP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID AND SOB.CURRENCY_CODE = FC.CURRENCY_CODE AND NVL(SP.ORG_ID, -99) = NVL(RS.ORG_ID, -99) AND SP.ORG_ID = NVL(:B1 , SP.ORG_ID) AND RS.SALESREP_ID = -3 AND ZXPO.APPLICATION_ID (+) = 222 AND ZXPO.ORG_ID (+) = SP.ORG_ID
1x50pj41r0yjw	SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :1 and table_name = :2 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :3 and table_name = :4 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :5 and table_name = :6 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :7 and table_name = :8
23s96rf87635s	select count(*) from sys.col_group_usage$ where obj# = :1 and cols = :2 and trunc(sysdate) = trunc(timestamp) and bitand(flags, :3) = :3
2gfw51wrma0wc	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((101, 20215), (50001, 64527)) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((50, 44069), (50, 46333), (200, 37306), (200, 55405), (222, 42109), (222, 42110), (602, 48093), (602, 48096)))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
2hzcxxcjkvrz9	SELECT ROW_ID, SRC_INVOICING_RULE_ID, ARM_PAYMENT_CHANNEL_CODE, APBA_INACTIVE_DATE, DEFAULT_TAX_EXEMPT_FLAG, ORG_ID, LEGAL_ENTITY_ID, BS_BATCH_SOURCE_NAME, TRX_NUMBER, SOA_AGREEMENT_NAME, RAB_BATCH_NAME, RAC_BILL_TO_CUSTOMER_NAME, RAC_BILL_TO_CUSTOMER_NUM, RAA_BILL_TO_CONCAT_ADDRESS, RAA_BILL_TO_ADDRESS1, RAA_BILL_TO_ADDRESS2, RAA_BILL_TO_ADDRESS3, RAA_BILL_TO_ADDRESS3_DB, RAA_BILL_TO_CITY, FT_BILL_TO_COUNTRY, RAA_BILL_TO_COUNTY, RAA_BILL_TO_POSTAL_CODE, RAA_BILL_TO_PROVINCE, RAA_BILL_TO_STATE, RACO_BILL_TO_CONTACT_NAME, BILL_TO_TAXPAYER_ID, SU_BILL_TO_LOCATION, OF_SHIP_VIA_NAME, CTT_CLASS, COMMENTS, END_DATE_COMMITMENT, START_DATE_COMMITMENT, COMPLETE_FLAG, CT_RELATED_TRX_NUMBER, APBA_BANK_ACCOUNT_NAME, APBA_BANK_ACCOUNT_NUM, APB_CUSTOMER_BANK_BRANCH_NAME, APB_CUSTOMER_BANK_NAME, CUSTOMER_REFERENCE, CUSTOMER_REFERENCE_DATE, INVOICE_CURRENCY_CODE, AL_DEFAULT_TAX_EXEMPT_FLAG, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, PS_DISPUTE_AMOUNT, PS_DISPUTE_DATE, DOC_SEQUENCE_VALUE, TERM_DUE_DATE, BILLING_DATE, EXCHANGE_DATE, EXCHANGE_RATE, GDCT_USER_EXCHANGE_RATE_TYPE, AL_FOB_MEANING, FINANCE_CHARGES, GD_GL_DATE, INVOICING_RULE_ID, CT_MODEL_TRX_NUMBER, PRINTING_ORIGINAL_DATE, CT_INVOICE_FOR_CB, PURCHASE_ORDER_DATE, PURCHASE_ORDER_REVISION, SU_PAYING_CUSTOMER_LOCATION, RAC_PAYING_CUSTOMER_NAME, RAC_PAYING_CUSTOMER_NUM, ARM_RECEIPT_METHOD_NAME, PRINTING_COUNT, PRINTING_LAST_PRINTED, PRINTING_OPTION, PURCHASE_ORDER, CT_REFERENCE, RAA_CONCAT_REMIT_TO_ADDRESS, RAA_REMIT_TO_ADDRESS1, RAA_REMIT_TO_ADDRESS2, RAA_REMIT_TO_ADDRESS3, RAA_REMIT_TO_ADDRESS3_DB, RAA_REMIT_TO_CITY, RAA_REMIT_TO_COUNTY, RAA_REMIT_TO_STATE, RAA_REMIT_TO_PROVINCE, RAA_REMIT_TO_POSTAL_CODE, FT_REMIT_TO_COUNTRY, CREDIT_METHOD_FOR_RULES, RAS_PRIMARY_SALESREP_NAME, RAS_PRIMARY_SALESREP_NUM, SHIP_DATE_ACTUAL, RAA_SHIP_TO_CONCAT_ADDRESS, RAA_SHIP_TO_ADDRESS1, RAA_SHIP_TO_ADDRESS2, RAA_SHIP_TO_ADDRESS3, RAA_SHIP_TO_ADDRESS3_DB, RAA_SHIP_TO_CITY, RAA_SHIP_TO_COUNTY, RAA_SHIP_TO_STATE, RAA_SHIP_TO_PROVINCE, RAA_SHIP_TO_POSTAL_CODE, FT_SHIP_TO_COUNTRY, RAC_SHIP_TO_CUSTOMER_NAME, RACO_SHIP_TO_CONTACT_NAME, RAC_SHIP_TO_CUSTOMER_NUM, SU_SHIP_TO_LOCATION, SHIP_TO_TAXPAYER_ID, RAC_SOLD_TO_CUSTOMER_NAME, RAC_SOLD_TO_CUSTOMER_NUM, INTERNAL_NOTES, CREDIT_METHOD_FOR_INSTALLMENTS, STATUS_TRX, RAT_TERM_NAME, DEFAULT_USSGL_TRANSACTION_CODE, TRX_DATE, INTERFACE_HEADER_CONTEXT, INTERFACE_HEADER_ATTRIBUTE1, INTERFACE_HEADER_ATTRIBUTE2, INTERFACE_HEADER_ATTRIBUTE3, INTERFACE_HEADER_ATTRIBUTE4, INTERFACE_HEADER_ATTRIBUTE5, INTERFACE_HEADER_ATTRIBUTE6, INTERFACE_HEADER_ATTRIBUTE7, INTERFACE_HEADER_ATTRIBUTE8, INTERFACE_HEADER_ATTRIBUTE9, INTERFACE_HEADER_ATTRIBUTE10, INTERFACE_HEADER_ATTRIBUTE11, INTERFACE_HEADER_ATTRIBUTE12, INTERFACE_HEADER_ATTRIBUTE13, INTERFACE_HEADER_ATTRIBUTE14, INTERFACE_HEADER_ATTRIBUTE15, CTT_TYPE_NAME, WAYBILL_NUMBER, CUSTOMER_TRX_ID, PREVIOUS_CUSTOMER_TRX_ID, INITIAL_CUSTOMER_TRX_ID, RELATED_BATCH_SOURCE_ID, RELATED_CUSTOMER_TRX_ID, CUST_TRX_TYPE_ID, BATCH_ID, BATCH_SOURCE_ID, REASON_CODE, TERM_ID, PRIMARY_SALESREP_ID, AGREEMENT_ID, RECEIPT_METHOD_ID, SHIP_VIA, FOB_POINT, CUSTOMER_BANK_ACCOUNT_ID, PAYMENT_TRXN_EXTENSION_ID, RECURRED_FROM_TRX_NUMBER, SOLD_TO_CUSTOMER_ID, SOLD_TO_SITE_USE_ID, SOLD_TO_CONTACT_ID, BILL_TO_CUSTOMER_ID, BILL_TO_SITE_USE_ID, BILL_TO_CONTACT_ID, SHIP_TO_CUSTOMER_ID, SHIP_TO_SITE_USE_ID, SHIP_TO_CONTACT_ID, REMIT_TO_ADDRESS_ID, CREATED_FROM, PRINTING_PENDING, LAST_PRINTED_SEQUENCE_NUM, EXCHANGE_RATE_TYPE, TERRITORY_ID, DOC_SEQUENCE_ID, PAYING_CUSTOMER_ID, PAYING_SITE_USE_ID, DH_MAX_DISPUTE_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, BS_AUTO_TRX_NUMBERING_FLAG, BS_BATCH_SOURCE_TYPE, REV_RECOG_RUN_FLAG, CTT_OPEN_RECEIVABLES_FLAG, CTT_ALLOW_FREIGHT_FLAG, CTT_POST_TO_GL_FLAG, CTT_CREATION_SIGN, CTT_ALLOW_OVERAPPLICATION_FLAG, CTT_NATURAL_APP_ONLY_FLAG, CTT_TAX_CALCULATION_FLAG, CTT_DEFAULT_STATUS, CTT_DEFAULT_TERM, CTT_DEFAULT_PRINTING_OPTION, RAA_BILL_TO_ADDRESS_ID, RAA_SHIP_TO_ADDRESS_ID, ARC_CREATION_METHOD_CODE, ARM_PAYMENT_TYPE_CODE, RAT_TERM_IN_USE_FLAG, RULES_FLAG, ACTIVITY_FLAG, PRINTED_FLAG, POSTED_FLAG, CM_AGAINST_TRX_FLAG, SELECTED_FOR_PAYMENT_FLAG, OVERRIDE_TERMS, COMMITMENTS_EXIST_FLAG, AGREEMENTS_EXIST_FLAG, ATCHMT_FLAG, GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20, GLOBAL_ATTRIBUTE_CATEGORY, ORIG_SYSTEM_BATCH_NAME, OLD_TRX_NUMBER, BS_COPY_DOC_NUMBER_FLAG, DEFAULT_REFERENCE FROM RA_CUSTOMER_TRX_PARTIAL_V WHERE (CUSTOMER_TRX_ID=:1) order by CUSTOMER_TRX_ID
2kyc2y1tvfgj5	select count(*) from user_editioning$ where user#=:1 and type#=:2
2mwvn9xwq1tz3	select (RUNNING_PROCESSES-MAX_PROCESSES) , MAX_PROCESSES , NVL(SLEEP_SECONDS, 0) , DIAGNOSTIC_LEVEL into :b0, :b1, :b2, :b3:b4 from FND_CONCURRENT_QUEUES where ((APPLICATION_ID=:b5 and CONCURRENT_QUEUE_ID=:b6) and (TARGET_NODE=:b7 or (TARGET_NODE is null and :b7 is null )))
2wvqc30x0t8jf	select * from ( select substr(haou.name, 4, 4) || '_' || substr(haou.name, 1, 3) || '_' || acra.cash_receipt_id || '_' || acrahist.cash_receipt_history_id Identifiant, acra.cash_receipt_id as "ID_Reglement_OA", acrahist.cash_receipt_history_id, arc.name as Mode_reglement, vue.remit_bank_account Compte_bancaire, vue.remit_bank_name Banque_remise, vue.remit_bank_branch Agence_remise, gcc1.segment3, acra.receipt_number "Numero reglement_OA", -- acrahist.status as Statut_Hist, decode(acrahist.status, 'REVERSED', 'Annulation', 'CONFIRMED', 'Confirme', 'CLEARED', 'Creation', 'REMITTED', 'Creation', 'Creation') as Statut_Rglt, --acra.status as Statut_Rglt, acrahist.gl_date, haou.name AS "UO", substr(haou.name, 1, 3) AS "Region", substr(haou.name, 4, 4) AS "Societe", rc.customer_number as "Numero Client", rc.customer_name as "Client", hcsu.location as "Adresse", acra.currency_code Devise, case when acrahist.status ='REVERSED' then acra.amount else acra.amount *-1 end as "Montant reglement AR", to_char(acrahist.creation_date, 'DD/MM/YYYY HH24:MI:SS') as "Date creation", acra.attribute4 as Date_du_Prelevement, fnd.user_name, fnd.description "Cree par", rcta.attribute1, case when araa.status = 'APP' then rcta.trx_number when araa.status = 'ACTIVITY' then (select receipt_number from ar_payment_schedules_all apsa, ar_cash_receipts_all acr where apsa.payment_schedule_id = araa.applied_payment_schedule_id and acr.cash_receipt_id = apsa.cash_receipt_id) when araa.status = 'ACC' then 'En Compte' end as "N? Facture", case when araa.status = 'APP' and araa.application_ref_num not like '%DOUTEUX' then 'Facture' when araa.status = 'APP' and araa.application_ref_num like '%DOUTEUX' then 'Reliquat' when araa.status = 'ACTIVITY' then 'Reglement' end as "Classe", araa.amount_applied Montant_Lettre from ar_cash_receipts_all acra, AR_CASH_RECEIPTS_V vue, hr_all_organization_units haou, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, ar_receipt_methods arm, ar_receipt_classes arc, gl_code_combinations_kfv gcc, ar_customers rc, hz_cust_accounts hca, AR_RECEIPT_METHOD_ACCOUNTS_all armaa, fnd_user fnd, AR_CASH_RECEIPT_HISTORY_ALL acrahist, gl_code_combinations_kfv gcc1, ar_receivable_applications_all araa, ra_customer_trx_all rcta where acra.receipt_method_id = arm.receipt_method_id -- and acra.creation_date <=to_date('27/05/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J -- AND acrahist.creation_date >=to_date('27/12/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J-1 AND acra.pay_from_customer = rc.customer_id (+) and hcsu.cust_acct_site_id = hcas.cust_acct_site_id(+) AND hcsu.org_id = hcas.org_id(+) AND hcas.cust_account_id = hca.cust_account_id(+) and hcsu.gl_id_rec = gcc.code_combination_id(+) and acra.org_id = haou.organization_id AND acra.customer_site_use_id = hcsu.Site_use_id(+) AND arm.receipt_class_id = arc.receipt_class_id and armaa.receipt_method_id =arm.receipt_method_id and fnd.user_id = acrahist.created_by and acra.cash_receipt_id = acrahist.cash_receipt_id and acra.cash_receipt_id = vue.cash_receipt_id and vue.remit_bank_acct_use_id = armaa.remit_bank_acct_use_id and acrahist.account_code_combination_id = gcc1.code_combination_id --- and substr(haou.name, 4, 4) in ('0490', '0491', '0492', '0493', '0498') ---and acra.cash_receipt_id ='2624378' AND acra.org_id = armaa.org_id ---and hcsu.location in ('0512152H', '0514250P') --- Ref ANAEL ---and rc.customer_number = '00046919' and acrahist.status !='CONFIRMED' and araa.cash_receipt_id = acra.cash_receipt_id and araa.display ='Y' and rcta.attribute1 = 'CYC' and acra.creation_date >='01/01/2024' ---and arc.name !='PRELEVEMENT' and substr(haou.name, 1, 3) in ('DMS', 'DEW') --- and acra.cash_receipt_id ='3201098' and araa.applied_customer_trx_id = rcta.customer_trx_id (+) order by acrahist.cash_receipt_id, acrahist.cash_receipt_history_id ) sub1 order by 4 asc
2ygnt73ck3jk8	begin dbms_utility.expand_sql_text ( input_sql_text => :sql, output_sql_text => :x ); end;
31xj50fad0329	SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :1 and table_name = :2 and column_name like :3 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :4 and table_name = :5 and column_name like :6 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :7 and table_name = :8 and column_name like :9 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :10 and table_name = :11 and column_name like :12 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :13 and table_name = :14 and column_name like :15 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :16 and table_name = :17 and column_name like :18 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :19 and table_name = :20 and column_name like :21 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :22 and table_name = :23 and column_name like :24 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :25 and table_name = :26 and column_name like :27 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :28 and table_name = :29 and column_name like :30 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :31 and table_name = :32 and column_name like :33 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :34 and table_name = :35 and column_name like :36 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :37 and table_name = :38 and column_name like :39 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :40 and table_name = :41 and column_name like :42 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :43 and table_name = :44 and column_name like :45 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :46 and table_name = :47 and column_name like :48 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :49 and table_name = :50 and column_name like :51 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :52 and table_name = :53 and column_name like :54 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :55 and table_name = :56 and column_name like :57 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :58 and table_name = :59 and column_name like :60 union all select case type# when 7 then 'PROCEDURE' when 8 then 'FUNCTION' when 9 then 'PACKAGE' when 33 then 'OPERATOR' end type, ''||o.owner# owner, name object_name, null column_name, null column_id, null data_type FROM sys.obj$ o where name not like 'BIN%' and type# in (7, 8, 9) and rownum <=50 and name like :61 union all SELECT 'SEQUENCE' type, USER owner, object_name, 'NEXTVAL' column_name, null column_id, null data_type FROM sys.user_objects WHERE object_type = 'SEQUENCE' and rownum <=50 and object_name like :62
3cnhac923hbu9	SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE) OPT_PARAM('_ENABLE_VIEW_PDB', 'FALSE') */ "OWNER", "OBJECT_NAME", "OBJECT_TYPE#", "PACKAGE_NAME", "OBJECT_ID", "OVERLOAD", "ARGUMENT_NAME", "POSITION", "DATA_TYPE", "DEFAULTED" FROM NO_CROSS_CONTAINER("SYS"."INT$DBA_ARGUMENTS") "INT$DBA_ARGUMENTS" WHERE "INT$DBA_ARGUMENTS"."ARGUMENT_NAME" IS NOT NULL AND "INT$DBA_ARGUMENTS"."OBJECT_NAME"=:5
3dbzmtf9ahvzt	merge /* KSXM:OPTIM_DML_INF */ into sys.mon_mods_all$ m using dual on (m.obj# = :objn and (:pobjn = 0 or m.obj# = :pobjn or m.obj# in (select obj# from tabpart$ where bo# = :pobjn and obj# = :objn union all select obj# from tabcompart$ where bo# = :pobjn and obj# = :objn union all select tsp.obj# from tabsubpart$ tsp, tabcompart$ tcp where tsp.pobj# = tcp.obj# and (tcp.bo# = :pobjn or tcp.obj# = :pobjn) and tsp.obj# = :objn))) when matched then update set inserts = decode(:reset, 1, 0, inserts) + :ins, updates = decode(:reset, 1, 0, updates) + :upd, deletes = decode(:reset, 1, 0, deletes) + :del, flags = decode(:reset, 1, 0, flags - bitand(flags, :flag)) + :flag, drop_segments = decode(:reset, 1, 0, drop_segments) + :dropseg, timestamp = :time when NOT matched then insert (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:objn, :ins, :upd, :del, :time, :flag, :dropseg) where :ins != 0 or :upd != 0 or :del != 0 or :flag != 0 or :dropseg !=0
3kvszgx9p4mhp	BEGIN DKA_SARSOLDEAVOIR_PKG.main(:errbuf, :rc); END;
3ppkc2qq9ks8d	select nvl(s.bytes, 0) from dba_segments s where s.owner=:1 and s.segment_name=:2
3un99a0zwp4vd	select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, flags, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
3y5b3uba1419p	SELECT RCTTA.NAME , HOU.ORGANIZATION_ID, HCSUA.SITE_USE_ID, RCTA.BILL_TO_CUSTOMER_ID, RCTA.CUSTOMER_TRX_ID ID_AVOIR, HOU.NAME UO, HCP.SITE_USE_ID SUT, HP.PARTY_NAME NOM_CLIENT, HCA.ACCOUNT_NUMBER CODE_CLIENT_ORACLE, RCTA.TRX_NUMBER NUM_AVOIR, (SELECT DISTINCT EXTPAYERSEO.DEBIT_ADVICE_EMAIL FROM IBY_EXTERNAL_PAYERS_ALL EXTPAYERSEO WHERE HP.PARTY_ID = EXTPAYERSEO.PARTY_ID AND HOU.ORGANIZATION_ID = EXTPAYERSEO.ORG_ID AND HCSUA.SITE_USE_ID = EXTPAYERSEO.ACCT_SITE_USE_ID AND HCA.CUST_ACCOUNT_ID = EXTPAYERSEO.CUST_ACCOUNT_ID ) MAIL, RCTA.TRX_DATE DATE_AVOIR, SUM(RCTL.EXTENDED_AMOUNT) MONTANT_AVOIR, PS.AMOUNT_DUE_REMAINING MONTANT_NON_SOLDE, RCTA.ATTRIBUTE7 COMMENTAIRE, SUBSTR(RCTA.ATTRIBUTE12, 1, 100) REF_VIR_CLI, PS.CLASS, RCTA.ATTRIBUTE6, HCA.CUST_ACCOUNT_ID, HP.ADDRESS2 || ' ' || HP.ADDRESS3 || ' ' || HP.ADDRESS4 || ' ' || HP.CITY SITE_ORACLE, RCTA.ORG_ID, HP.PARTY_ID, ( CASE WHEN ( SELECT COUNT(EBA.IBAN) FROM HZ_CUST_ACCOUNTS CA, IBY_EXTERNAL_PAYERS_ALL EPA, IBY_PMT_INSTR_USES_ALL PIU, IBY_EXT_BANK_ACCOUNTS EBA WHERE CA.CUST_ACCOUNT_ID = EPA.CUST_ACCOUNT_ID AND PIU.EXT_PMT_PARTY_ID = EPA.EXT_PAYER_ID AND PIU.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT' AND EBA.EXT_BANK_ACCOUNT_ID = PIU.INSTRUMENT_ID AND CA.PARTY_ID = HP.PARTY_ID AND NVL(PIU.END_DATE, SYSDATE+1) > SYSDATE AND PIU.START_DATE <= SYSDATE AND RCTA.BILL_TO_CUSTOMER_ID =CA.CUST_ACCOUNT_ID AND EPA.ORG_ID = RCTA.ORG_ID ) < 2 THEN ( SELECT EBA.IBAN FROM HZ_CUST_ACCOUNTS CA, IBY_EXTERNAL_PAYERS_ALL EPA, IBY_PMT_INSTR_USES_ALL PIU, IBY_EXT_BANK_ACCOUNTS EBA WHERE CA.CUST_ACCOUNT_ID = EPA.CUST_ACCOUNT_ID AND PIU.EXT_PMT_PARTY_ID = EPA.EXT_PAYER_ID AND PIU.PAYMENT_FUNCTION = 'CUSTOMER_PAYMENT' AND EBA.EXT_BANK_ACCOUNT_ID = PIU.INSTRUMENT_ID AND CA.PARTY_ID = HP.PARTY_ID AND NVL(PIU.END_DATE, SYSDATE+1) > SYSDATE AND PIU.START_DATE <= SYSDATE AND RCTA.BILL_TO_CUSTOMER_ID =CA.CUST_ACCOUNT_ID AND EPA.ORG_ID = RCTA.ORG_ID ) ELSE NULL END ) IBAN, AR.NAME CODE_CHARGE_RECOUVR, HCASA.ATTRIBUTE3 CODE_ANAEL, (CASE WHEN RCTA.ATTRIBUTE6 = 'OUI' THEN RCTA.ATTRIBUTE9 ELSE NULL END )MOTIF_REJET FROM HZ_CUST_ACCOUNTS HCA, RA_CUSTOMER_TRX_ALL RCTA, RA_CUSTOMER_TRX_LINES_ALL RCTL, AR_PAYMENT_SCHEDULES_ALL PS, HZ_PARTIES HP, HR_OPERATING_UNITS HOU, XLE_ENTITY_PROFILES XEP, HZ_CUST_SITE_USES_ALL HCSUA, AR.HZ_CUSTOMER_PROFILES HCP, AR_COLLECTORS AR, HZ_CUST_ACCT_SITES_ALL HCASA, HZ_PARTY_SITES HPS, RA_CUST_TRX_TYPES_ALL RCTTA WHERE 1 = 1 AND RCTA.BILL_TO_SITE_USE_ID = HCP.SITE_USE_ID AND HCA.PARTY_ID = HCP.PARTY_ID AND HCASA.PARTY_SITE_ID = HPS.PARTY_SITE_ID AND AR.COLLECTOR_ID = HCP.COLLECTOR_ID AND HCASA.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID AND HCSUA.CUST_ACCT_SITE_ID = HCASA.CUST_ACCT_SITE_ID AND HCP.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID AND HCP.SITE_USE_ID = HCSUA.SITE_USE_ID AND HP.PARTY_ID = HCA.PARTY_ID AND HCA.CUST_ACCOUNT_ID = RCTA.BILL_TO_CUSTOMER_ID AND RCTA.CUSTOMER_TRX_ID = RCTL.CUSTOMER_TRX_ID AND RCTA.ORG_ID = HOU.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = HCSUA.ORG_ID AND PS.CUSTOMER_TRX_ID = RCTA.CUSTOMER_TRX_ID AND NVL(PS.AMOUNT_DUE_REMAINING, 0) <> 0 AND PS.CLASS = 'CM' AND XEP.LEGAL_ENTITY_ID = HOU.DEFAULT_LEGAL_CONTEXT_ID AND RCTA.CUST_TRX_TYPE_ID = RCTTA.CUST_TRX_TYPE_ID AND RCTTA.NAME IN ('MAN_AVOIR', 'SI_AMONT_AVOIR') AND RCTA.ATTRIBUTE6 = 'OUI' AND HOU.ORGANIZATION_ID IN (SELECT DISTINCT HOUI.ORGANIZATION_ID FROM HR_ALL_ORGANIZATION_UNITS HOUI WHERE SUBSTR(HOUI.NAME, 1, 3) = NVL(:B1 , SUBSTR(HOUI.NAME, 1, 3))) GROUP BY HOU.ORGANIZATION_ID, HCSUA.SITE_USE_ID, HCA.CUST_ACCOUNT_ID, RCTA.BILL_TO_CUSTOMER_ID, HOU.NAME, AR.NAME, HCP.SITE_USE_ID, RCTA.CUSTOMER_TRX_ID, HCASA.ATTRIBUTE3, HCSUA.CUST_ACCT_SITE_ID, HCSUA.SITE_USE_ID, HCA.ACCOUNT_NUMBER, RCTA.TRX_NUMBER, RCTA.TRX_DATE, PS.AMOUNT_DUE_REMAINING, RCTA.ATTRIBUTE7, RCTA.ATTRIBUTE12, PS.CLASS, HCA.CUST_ACCOUNT_ID, RCTA.ATTRIBUTE6, HP.PARTY_NAME, HP.ADDRESS2, HP.ADDRESS3, HP.ADDRESS4, HP.CITY, RCTA.ORG_ID, HP.PARTY_ID, RCTA.ATTRIBUTE9, RCTTA.NAME ORDER BY MONTANT_AVOIR, NOM_CLIENT, NUM_AVOIR
3ybyy62dar9c3	update fnd_conflicts_domain set runalone_flag = :ra where cd_id = :cdid
46cav1a1ytfww	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.REQUEST_CLASS_APPLICATION_ID, R.CONCURRENT_REQUEST_CLASS_ID) IN ((0, 6), (50001, 10))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
4dck8dxwd753p	select 'X' into :b0 from FND_CONCURRENT_QUEUES where ((APPLICATION_ID=:b1 and CONCURRENT_QUEUE_ID=:b2) and RUNNING_PROCESSES>MAX_PROCESSES) for update of RUNNING_PROCESSES
4f42cs7kpqbvb	SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel */ NVL(C1, 0), NVL(C2, 0), NVL(C3, 0) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "O2") */ 4294967295 AS C1, COUNT(*) AS C2, SUM(CASE WHEN ("O2"."TYPE#"=88) THEN 1 ELSE 0 END) AS C3 FROM "SYS"."OBJ$" "O2" WHERE ("O2"."TYPE#"=88)) innerQuery
4jbsu2sp1uwmp	SELECT DISTINCT R.APPLICATION_ID, R.RESPONSIBILITY_ID, S.SECURITY_GROUP_ID, R.RESPONSIBILITY_NAME, S.SECURITY_GROUP_NAME FROM FND_RESPONSIBILITY_VL R, FND_USER_RESP_GROUPS U, FND_SECURITY_GROUPS_VL S WHERE U.USER_ID = :A00 AND SYSDATE BETWEEN U.START_DATE AND NVL(U.END_DATE, SYSDATE) AND R.VERSION IN ('4', 'W') AND R.APPLICATION_ID = U.RESPONSIBILITY_APPLICATION_ID AND R.RESPONSIBILITY_ID = U.RESPONSIBILITY_ID AND SYSDATE BETWEEN R.START_DATE AND NVL(R.END_DATE, SYSDATE) AND U.SECURITY_GROUP_ID = S.SECURITY_GROUP_ID AND S.SECURITY_GROUP_ID >= 0 AND (S.SECURITY_GROUP_KEY = :A01 OR :A02 IS NULL) AND (R.RESPONSIBILITY_KEY = :A03 OR :A04 IS NULL) AND R.APPLICATION_ID = NVL(:A05, R.APPLICATION_ID) AND NVL(:A06, 1) <= NVL(FND_PROFILE.VALUE_SPECIFIC('APPL_SERVER_TRUST_LEVEL', U.USER_ID, R.RESPONSIBILITY_ID, R.APPLICATION_ID), 1) ORDER BY RESPONSIBILITY_NAME, SECURITY_GROUP_NAME
4pd7payd3ycgx	SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :1 and table_name = :2 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :3 and table_name = :4 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :5 and table_name = :6 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :7 and table_name = :8 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :9 and table_name = :10 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :11 and table_name = :12 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :13 and table_name = :14 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :15 and table_name = :16 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :17 and table_name = :18 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :19 and table_name = :20 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :21 and table_name = :22 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :23 and table_name = :24 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :25 and table_name = :26 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :27 and table_name = :28 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :29 and table_name = :30 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :31 and table_name = :32 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :33 and table_name = :34 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :35 and table_name = :36 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :37 and table_name = :38 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :39 and table_name = :40
4s2v1trm8kabf	BEGIN DKA_SARSELECAVOIR_PKG.main(:errbuf, :rc, :A0, :A1); END;
4twxwvtqj9188	SELECT DATA_LENGTH FROM ALL_TAB_COLUMNS WHERE OWNER = 'SYS' AND TABLE_NAME = 'V_$SESSION' AND COLUMN_NAME = :B1
4v6cw4yxwg7gr	SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :1 and table_name = :2 and column_name like :3 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :4 and table_name = :5 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :6 and table_name = :7 and column_name like :8 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :9 and table_name = :10 and column_name like :11 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :12 and table_name = :13 and column_name like :14 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :15 and table_name = :16 and column_name like :17 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :18 and table_name = :19 and column_name like :20 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :21 and table_name = :22 and column_name like :23 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :24 and table_name = :25 and column_name like :26 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :27 and table_name = :28 and column_name like :29 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :30 and table_name = :31 and column_name like :32 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :33 and table_name = :34 and column_name like :35 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :36 and table_name = :37 and column_name like :38 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :39 and table_name = :40 and column_name like :41 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :42 and table_name = :43 and column_name like :44 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :45 and table_name = :46 and column_name like :47 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :48 and table_name = :49 and column_name like :50 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :51 and table_name = :52 and column_name like :53 union all select case type# when 7 then 'PROCEDURE' when 8 then 'FUNCTION' when 9 then 'PACKAGE' when 33 then 'OPERATOR' end type, ''||o.owner# owner, name object_name, null column_name, null column_id, null data_type FROM sys.obj$ o where name not like 'BIN%' and type# in (7, 8, 9) and rownum <=50 and name like :54 union all SELECT 'SEQUENCE' type, USER owner, object_name, 'NEXTVAL' column_name, null column_id, null data_type FROM sys.user_objects WHERE object_type = 'SEQUENCE' and rownum <=50 and object_name like :55 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :56 and table_name = :57 and column_name like :58
4wtaa174wd6un	SELECT BANK_ACCOUNT_NUM FROM CE_BANK_ACCOUNTS WHERE BANK_ACCOUNT_ID = :B1
4xm1ruvkx3awx	DECLARE job BINARY_INTEGER := :job; next_date TIMESTAMP WITH TIME ZONE := :mydate; broken BOOLEAN := FALSE; job_name VARCHAR2(128) := :job_name; job_subname VARCHAR2(128) := :job_subname; job_owner VARCHAR2(128) := :job_owner; job_start TIMESTAMP WITH TIME ZONE := :job_start; job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start; window_start TIMESTAMP WITH TIME ZONE := :window_start; window_end TIMESTAMP WITH TIME ZONE := :window_end; chain_id VARCHAR2(14) := :chainid; credential_owner VARCHAR2(128) := :credown; credential_name VARCHAR2(128) := :crednam; destination_owner VARCHAR2(128) := :destown; destination_name VARCHAR2(128) := :destnam; job_dest_id varchar2(14) := :jdestid; log_id number := :log_id; BEGIN DECLARE ename VARCHAR2(30); exec_task BOOLEAN; BEGIN -- check if tuning pack is enabled exec_task := prvt_advisor.is_pack_enabled( dbms_management_packs.TUNING_PACK); -- check if we are in a pdb, -- since auto sqltune is not run in a pdb IF (exec_task AND -- tuning pack enabled sys_context('userenv', 'con_id') <> 0 AND -- not in non-cdb sys_context('userenv', 'con_id') <> 1 ) THEN -- not in root exec_task := FALSE; END IF; -- execute auto sql tuning task IF (exec_task) THEN ename := dbms_sqltune.execute_tuning_task( 'SYS_AUTO_SQL_TUNING_TASK'); END IF; -- check whether we are in non-CDB or a PDB -- auto SPM evolve only runs in a non-CDB or a PDB, not the root. IF (sys_context('userenv', 'con_id') = 0 OR sys_context('userenv', 'con_id') > 2) THEN exec_task := TRUE; ELSE exec_task := FALSE; END IF; -- execute auto SPM evolve task IF (exec_task) THEN ename := dbms_spm.execute_evolve_task('SYS_AUTO_SPM_EVOLVE_TASK'); END IF; END; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
569n2zsswkp8p	SELECT BA.BANK_ACCT_USE_ID, RC.CREATION_STATUS, RC.CREATION_METHOD_CODE, RMA.START_DATE RMA_START_DATE, RMA.END_DATE RMA_END_DATE, RM.START_DATE RM_START_DATE, RM.END_DATE RM_END_DATE, BA.END_DATE BAU_END_DATE, RMA.ORG_ID RMA_ORG_ID FROM AR_RECEIPT_METHODS RM, CE_BANK_ACCOUNTS CBA, CE_BANK_ACCT_USES BA, AR_RECEIPT_METHOD_ACCOUNTS RMA , AR_RECEIPT_CLASSES RC WHERE RM.RECEIPT_METHOD_ID = :B4 AND (:B3 BETWEEN RM.START_DATE AND NVL(RM.END_DATE, :B3 )) AND ((RC.CREATION_METHOD_CODE = DECODE(:B2 , 'BR_REMITTED', 'BR_REMIT', 'BR_FACTORED_WITH_RECOURSE', 'BR_REMIT', 'BR_FACTORED_WITHOUT_RECOURSE', 'BR_REMIT', '@*%?&')) OR (RC.CREATION_METHOD_CODE = 'MANUAL') OR (RC.CREATION_METHOD_CODE = 'AUTOMATIC' AND RC.CONFIRM_FLAG = DECODE(:B2 , 'AUTORECAPI', RC.CONFIRM_FLAG, 'N'))) AND CBA.ACCOUNT_CLASSIFICATION = 'INTERNAL' AND NVL(BA.END_DATE, :B3 +1) > :B3 AND :B3 BETWEEN RMA.START_DATE AND NVL(RMA.END_DATE, :B3 ) AND CBA.CURRENCY_CODE = DECODE(CBA.RECEIPT_MULTI_CURRENCY_FLAG, 'Y', CBA.CURRENCY_CODE, :B1 ) AND RC.RECEIPT_CLASS_ID = RM.RECEIPT_CLASS_ID AND RM.RECEIPT_METHOD_ID = RMA.RECEIPT_METHOD_ID AND RMA.REMIT_BANK_ACCT_USE_ID = BA.BANK_ACCT_USE_ID AND BA.BANK_ACCOUNT_ID = CBA.BANK_ACCOUNT_ID AND ((NVL(:B2 , '*&#$') <> 'MISC') OR (RM.RECEIPT_CLASS_ID NOT IN ( SELECT ARC.RECEIPT_CLASS_ID FROM AR_RECEIPT_CLASSES ARC WHERE ARC.NOTES_RECEIVABLE='Y' OR ARC.BILL_OF_EXCHANGE_FLAG='Y'))) ORDER BY DECODE(RMA.PRIMARY_FLAG, 'Y', 1, 'N', 2, 3), DECODE(CBA.CURRENCY_CODE, :B1 , 1, 2), CBA.BANK_BRANCH_ID, CBA.BANK_ACCOUNT_NAME, BA.BANK_ACCT_USE_ID
5cu0x10yu88sw	merge into sys.wri$_index_usage iu using dual on (iu.obj# = :objn) when matched then update set iu.total_access_count = iu.total_access_count + :ns, iu.total_rows_returned = iu.total_rows_returned + :rr, iu.total_exec_count = iu.total_exec_count + :ne, iu.bucket_0_access_count = iu.bucket_0_access_count + :nsh0, iu.bucket_1_access_count = iu.bucket_1_access_count + :nsh1, iu.bucket_2_10_access_count = iu.bucket_2_10_access_count + :nsh2_10, iu.bucket_2_10_rows_returned = iu.bucket_2_10_rows_returned + :nrh2_10, iu.bucket_11_100_access_count = iu.bucket_11_100_access_count + :nsh11_100, iu.bucket_11_100_rows_returned = iu.bucket_11_100_rows_returned + :nrh11_100, iu.bucket_101_1000_access_count = iu.bucket_101_1000_access_count + :nsh101_1000, iu.bucket_101_1000_rows_returned = iu.bucket_101_1000_rows_returned + :nrh101_1000, iu.bucket_1000_plus_access_count = iu.bucket_1000_plus_access_count + :nsh1000plus, iu.bucket_1000_plus_rows_returned = iu.bucket_1000_plus_rows_returned + :nrh1000plus, last_used = SYSDATE when NOT matched then insert (iu.obj#, iu.total_access_count, iu.total_rows_returned, iu.total_exec_count, iu.bucket_0_access_count, iu.bucket_1_access_count, iu.bucket_2_10_access_count, iu.bucket_2_10_rows_returned, iu.bucket_11_100_access_count, iu.bucket_11_100_rows_returned, iu.bucket_101_1000_access_count, iu.bucket_101_1000_rows_returned, iu.bucket_1000_plus_access_count, iu.bucket_1000_plus_rows_returned, iu.last_used) values (:objn, :ns, :rr, :ne, :nsh0, :nsh1, :nsh2_10, :nrh2_10, :nsh11_100, :nrh11_100, :nsh101_1000, :nrh101_1000, :nsh1000plus, :nrh1000plus, SYSDATE)
5dqz0hqtp9fru	select /*+ connect_by_filtering index(sysauth$ i_sysauth1) */ privilege#, bitand(nvl(option$, 0), 72), grantee#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
5jvjp89rgqk2d	SELECT BASEPATH FROM FND_APPLICATION WHERE APPLICATION_ID = :ID
5us2xwzatpnwy	begin fnd_dcp.check_process_status_by_handle (:h, :r, :a); end;
609bhbrtfrd9s	select substr(haou.name, 4, 4) || '_' || substr(haou.name, 1, 3) || '_' || acra.cash_receipt_id || '_' || acrahist.cash_receipt_history_id Identifiant, acra.cash_receipt_id as "ID_Reglement_OA", acrahist.cash_receipt_history_id, arc.name as Mode_reglement, vue.remit_bank_account Compte_bancaire, vue.remit_bank_name Banque_remise, vue.remit_bank_branch Agence_remise, gcc1.segment3, acra.receipt_number "Numero reglement_OA", -- acrahist.status as Statut_Hist, decode(acrahist.status, 'REVERSED', 'Annulation', 'CONFIRMED', 'Confirme', 'CLEARED', 'Creation', 'REMITTED', 'Creation', 'Creation') as Statut_Rglt, --acra.status as Statut_Rglt, acrahist.gl_date, haou.name AS "UO", substr(haou.name, 1, 3) AS "Region", substr(haou.name, 4, 4) AS "Societe", rc.customer_number as "Numero Client", rc.customer_name as "Client", hcsu.location as "Adresse", acra.currency_code Devise, case when acrahist.status ='REVERSED' then acra.amount else acra.amount *-1 end as "Montant reglement AR", to_char(acrahist.creation_date, 'DD/MM/YYYY HH24:MI:SS') as "Date creation", acra.attribute4 as Date_du_Prelevement, fnd.user_name, fnd.description "Cree par", rcta.attribute1, case when araa.status = 'APP' then rcta.trx_number when araa.status = 'ACTIVITY' then (select receipt_number from ar_payment_schedules_all apsa, ar_cash_receipts_all acr where apsa.payment_schedule_id = araa.applied_payment_schedule_id and acr.cash_receipt_id = apsa.cash_receipt_id) when araa.status = 'ACC' then 'En Compte' end as "N? Facture", case when araa.status = 'APP' and araa.application_ref_num not like '%DOUTEUX' then 'Facture' when araa.status = 'APP' and araa.application_ref_num like '%DOUTEUX' then 'Reliquat' when araa.status = 'ACTIVITY' then 'Reglement' end as "Classe", araa.amount_applied Montant_Lettre, (select RCTLGD.AMOUNT from RA_CUST_TRX_LINE_GL_DIST_ALL RCTLGD where rctlgd.account_class = 'REC' and rctlgd.customer_trx_id = rcta.customer_trx_id) as Mt_Fact from ar_cash_receipts_all acra, AR_CASH_RECEIPTS_V vue, hr_all_organization_units haou, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, ar_receipt_methods arm, ar_receipt_classes arc, gl_code_combinations_kfv gcc, ar_customers rc, hz_cust_accounts hca, AR_RECEIPT_METHOD_ACCOUNTS_all armaa, fnd_user fnd, AR_CASH_RECEIPT_HISTORY_ALL acrahist, gl_code_combinations_kfv gcc1, ar_receivable_applications_all araa, ra_customer_trx_all rcta where acra.receipt_method_id = arm.receipt_method_id -- and acra.creation_date <=to_date('27/05/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J -- AND acrahist.creation_date >=to_date('27/12/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J-1 AND acra.pay_from_customer = rc.customer_id (+) and hcsu.cust_acct_site_id = hcas.cust_acct_site_id(+) AND hcsu.org_id = hcas.org_id(+) AND hcas.cust_account_id = hca.cust_account_id(+) and hcsu.gl_id_rec = gcc.code_combination_id(+) and acra.org_id = haou.organization_id AND acra.customer_site_use_id = hcsu.Site_use_id(+) AND arm.receipt_class_id = arc.receipt_class_id and armaa.receipt_method_id =arm.receipt_method_id and fnd.user_id = acrahist.created_by and acra.cash_receipt_id = acrahist.cash_receipt_id and acra.cash_receipt_id = vue.cash_receipt_id and vue.remit_bank_acct_use_id = armaa.remit_bank_acct_use_id and acrahist.account_code_combination_id = gcc1.code_combination_id --- and substr(haou.name, 4, 4) in ('0490', '0491', '0492', '0493', '0498') ---and acra.cash_receipt_id ='2624378' AND acra.org_id = armaa.org_id ---and hcsu.location in ('0512152H', '0514250P') --- Ref ANAEL ---and rc.customer_number = '00046919' and acrahist.status !='CONFIRMED' and araa.cash_receipt_id = acra.cash_receipt_id and araa.display ='Y' and rcta.attribute1 = 'CYC' and acra.creation_date >='01/01/2024' --- and arc.name ='PRELEVEMENT' and substr(haou.name, 1, 3) in ('DMS', 'DEW') --- and acra.cash_receipt_id ='3201098' and araa.applied_customer_trx_id = rcta.customer_trx_id (+) order by acrahist.cash_receipt_id, acrahist.cash_receipt_history_id
626sy9z0712mb	select substr(haou.name, 4, 4) || '_' || substr(haou.name, 1, 3) || '_' || acra.cash_receipt_id || '_' || acrahist.cash_receipt_history_id Identifiant, acra.cash_receipt_id as "ID_Reglement_OA", acrahist.cash_receipt_history_id, g.name "Nom Societe", substr(haou.name, 4, 4) AS "Societe", substr(haou.name, 1, 3) AS "Region", haou.name AS "UO", arc.name as Mode_reglement, 'Standard' as "Type Reglement", (select arm.name from AR_RECEIPT_METHODS arm where acra.receipt_method_id = arm.receipt_method_id) as Mode_Reglement, vue.remit_bank_account Compte_bancaire, vue.remit_bank_name Banque_remise, vue.remit_bank_branch Agence_remise, rc.customer_number as "Numero Client", rc.customer_name as "Client", hcsu.location as "Adresse", 'Creation' as "Type Action", acra.receipt_number "Numero reglement_OA", case when acrahist.status ='REVERSED' then acra.amount else acra.amount *-1 end as "Montant reglement AR", acra.currency_code Devise, acra.comments as Commentaires, 'LETTRAGE MANUEL' as "TYPE_MAJ", '' as "MOTIF ANNULATION", '' as "COMMENTAIRES_ANNULATION", '' as NUM_DOCUMENT, '' as DATE_CREATION_REGLEMENT, '' as DATE_REGLEMENT, '' as DATE_EXIGIBILITE, '' as DATE_PRELEVEMENT, '' as DATE_ANNULATION_REGLEMENT, '' as DATE_LETTRAGE, '' as DATE_DELETTRAGE, '' as REGLEMENT_CREE_PAR, '' as NUMERO_PIECE_AR, '' as IDENTIFIANT_PIECE_SYRUS, '' as NUM_PIECE_AMONT, '' as CODE_FOLIO, '' as LIBELLE_FOLIO, '' as TYPE_PIECE_AR, '' as MONTANT_PIECE_AR, '' as MONTANT_LETTRE, '' as MONTANT_DELETTRE, '' as DATE_VALEUR_RB, '' as DATE_OPERATION_RB, '' as DATE_RAPPROCHEMENT_RB, '' as REF_RAPPROCHEMENT_RB, gcc1.segment3, -- acrahist.status as Statut_Hist, decode(acrahist.status, 'REVERSED', 'Annulation', 'CONFIRMED', 'Confirme', 'CLEARED', 'Creation', 'REMITTED', 'Creation', 'Creation') as Statut_Rglt, --acra.status as Statut_Rglt, acrahist.gl_date, to_char(acrahist.creation_date, 'DD/MM/YYYY HH24:MI:SS') as "Date creation", acra.attribute4 as Date_du_Prelevement, fnd.user_name, fnd.description "Cree par", rcta.attribute1, case when araa.status = 'APP' then rcta.trx_number when araa.status = 'ACTIVITY' then (select receipt_number from ar_payment_schedules_all apsa, ar_cash_receipts_all acr where apsa.payment_schedule_id = araa.applied_payment_schedule_id and acr.cash_receipt_id = apsa.cash_receipt_id) when araa.status = 'ACC' then 'En Compte' end as "N? Facture", case when araa.status = 'APP' and araa.application_ref_num not like '%DOUTEUX' then 'Facture' when araa.status = 'APP' and araa.application_ref_num like '%DOUTEUX' then 'Reliquat' when araa.status = 'ACTIVITY' then 'Reglement' end as "Classe", araa.amount_applied Montant_Lettre, (select RCTLGD.AMOUNT from RA_CUST_TRX_LINE_GL_DIST_ALL RCTLGD where rctlgd.account_class = 'REC' and rctlgd.customer_trx_id = rcta.customer_trx_id) as Mt_Fact from ar_cash_receipts_all acra, AR_CASH_RECEIPTS_V vue, hr_all_organization_units haou, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, ar_receipt_methods arm, ar_receipt_classes arc, gl_code_combinations_kfv gcc, ar_customers rc, hz_cust_accounts hca, AR_RECEIPT_METHOD_ACCOUNTS_all armaa, fnd_user fnd, AR_CASH_RECEIPT_HISTORY_ALL acrahist, gl_code_combinations_kfv gcc1, ar_receivable_applications_all araa, gl_ledgers g, ra_customer_trx_all rcta where acra.receipt_method_id = arm.receipt_method_id -- and acra.creation_date <=to_date('27/05/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J -- AND acrahist.creation_date >=to_date('27/12/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J-1 AND acra.pay_from_customer = rc.customer_id (+) and hcsu.cust_acct_site_id = hcas.cust_acct_site_id(+) AND hcsu.org_id = hcas.org_id(+) AND hcas.cust_account_id = hca.cust_account_id(+) and hcsu.gl_id_rec = gcc.code_combination_id(+) and acra.org_id = haou.organization_id AND acra.customer_site_use_id = hcsu.Site_use_id(+) AND arm.receipt_class_id = arc.receipt_class_id and armaa.receipt_method_id =arm.receipt_method_id and fnd.user_id = acrahist.created_by and acra.cash_receipt_id = acrahist.cash_receipt_id and acra.cash_receipt_id = vue.cash_receipt_id and vue.remit_bank_acct_use_id = armaa.remit_bank_acct_use_id and acrahist.account_code_combination_id = gcc1.code_combination_id --- and substr(haou.name, 4, 4) in ('0490', '0491', '0492', '0493', '0498') ---and acra.cash_receipt_id ='2624378' AND acra.org_id = armaa.org_id ---and hcsu.location in ('0512152H', '0514250P') --- Ref ANAEL ---and rc.customer_number = '00046919' and acrahist.status !='CONFIRMED' and araa.cash_receipt_id = acra.cash_receipt_id and araa.display ='Y' and rcta.attribute1 = 'CYC' and acra.creation_date >='01/01/2024' and g.short_name = substr(haou.Name, 4, 4) --- and arc.name ='PRELEVEMENT' and substr(haou.name, 1, 3) in ('DMS', 'DEW') and acra.cash_receipt_id in ('3723614', '2655231') and araa.applied_customer_trx_id = rcta.customer_trx_id (+) order by acrahist.cash_receipt_id, acrahist.cash_receipt_history_id
63knw6q34xswa	select substr(haou.name, 4, 4) || '_' || substr(haou.name, 1, 3) || '_' || acra.cash_receipt_id || '_' || acrahist.cash_receipt_history_id Identifiant, acra.cash_receipt_id as "ID_Reglement_OA", acrahist.cash_receipt_history_id, arc.name as Mode_reglement, vue.remit_bank_account Compte_bancaire, vue.remit_bank_name Banque_remise, vue.remit_bank_branch Agence_remise, gcc1.segment3, acra.receipt_number "Numero reglement_OA", -- acrahist.status as Statut_Hist, decode(acrahist.status, 'REVERSED', 'Annulation', 'CONFIRMED', 'Confirme', 'CLEARED', 'Creation', 'REMITTED', 'Creation', 'Creation') as Statut_Rglt, --acra.status as Statut_Rglt, acrahist.gl_date, haou.name AS "UO", substr(haou.name, 1, 3) AS "Region", substr(haou.name, 4, 4) AS "Societe", rc.customer_number as "Numero Client", rc.customer_name as "Client", hcsu.location as "Adresse", acra.currency_code Devise, case when acrahist.status ='REVERSED' then acra.amount else acra.amount *-1 end as "Montant reglement AR", to_char(acrahist.creation_date, 'DD/MM/YYYY HH24:MI:SS') as "Date creation", acra.attribute4 as Date_du_Prelevement, fnd.user_name, fnd.description "Cree par", case when araa.status = 'APP' then rcta.trx_number when araa.status = 'ACTIVITY' then (select receipt_number from ar_payment_schedules_all apsa, ar_cash_receipts_all acr where apsa.payment_schedule_id = araa.applied_payment_schedule_id and acr.cash_receipt_id = apsa.cash_receipt_id) when araa.status = 'ACC' then 'En Compte' end as "N? Facture", case when araa.status = 'APP' and araa.application_ref_num not like '%DOUTEUX' then 'Facture' when araa.status = 'APP' and araa.application_ref_num like '%DOUTEUX' then 'Reliquat' when araa.status = 'ACTIVITY' then 'Reglement' end as "Classe", araa.amount_applied Montant_Lettre from ar_cash_receipts_all acra, AR_CASH_RECEIPTS_V vue, hr_all_organization_units haou, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, ar_receipt_methods arm, ar_receipt_classes arc, gl_code_combinations_kfv gcc, ar_customers rc, hz_cust_accounts hca, AR_RECEIPT_METHOD_ACCOUNTS_all armaa, fnd_user fnd, AR_CASH_RECEIPT_HISTORY_ALL acrahist, gl_code_combinations_kfv gcc1, ar_receivable_applications_all araa, ra_customer_trx_all rcta where acra.receipt_method_id = arm.receipt_method_id -- and acra.creation_date <=to_date('27/05/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J -- AND acrahist.creation_date >=to_date('27/12/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J-1 AND acra.pay_from_customer = rc.customer_id (+) and hcsu.cust_acct_site_id = hcas.cust_acct_site_id(+) AND hcsu.org_id = hcas.org_id(+) AND hcas.cust_account_id = hca.cust_account_id(+) and hcsu.gl_id_rec = gcc.code_combination_id(+) and acra.org_id = haou.organization_id AND acra.customer_site_use_id = hcsu.Site_use_id(+) AND arm.receipt_class_id = arc.receipt_class_id and armaa.receipt_method_id =arm.receipt_method_id and fnd.user_id = acrahist.created_by and acra.cash_receipt_id = acrahist.cash_receipt_id and acra.cash_receipt_id = vue.cash_receipt_id and vue.remit_bank_acct_use_id = armaa.remit_bank_acct_use_id and acrahist.account_code_combination_id = gcc1.code_combination_id --- and substr(haou.name, 4, 4) in ('0490', '0491', '0492', '0493', '0498') ---and acra.cash_receipt_id ='2624378' AND acra.org_id = armaa.org_id ---and hcsu.location in ('0512152H', '0514250P') --- Ref ANAEL ---and rc.customer_number = '00046919' --and acrahist.status !='CONFIRMED' and araa.cash_receipt_id = acra.cash_receipt_id and araa.display ='Y' and acra.creation_date >='01/01/2024' ---and arc.name !='PRELEVEMENT' and substr(haou.name, 1, 3) in ('DMS', 'DEW') -- and acra.cash_receipt_id ='3201098' and araa.applied_customer_trx_id = rcta.customer_trx_id (+) order by acrahist.cash_receipt_id, acrahist.cash_receipt_history_id
6451cyrxb8fms	SELECT COUNT (*) FROM V$THREAD
6v7bjphkfr51s	select hca.ACCOUNT_NUMBER, hp.PARTY_NAME, hcsua.LOCATION lieu, rcta.trx_number num_facture, TO_CHAR(rcta.CREATION_DATE, 'DD/MM/YYYY HH24:MI:SS')CREATION_DATE, --EDB381 SHO rcta.PURCHASE_ORDER bon_commande, --EDB336 ARA SUM(rctl.EXTENDED_AMOUNT) mnt_facture, TO_CHAR(rcta.TRX_DATE, 'DD/MM/YYYY') TRX_DATE, hou.name organisation, TO_CHAR(ps.GL_DATE, 'DD/MM/YYYY') GL_DATE, ps.amount_due_remaining mnt_prelever, TO_CHAR(ps.DUE_DATE, 'DD/MM/YYYY') DUE_DATE, ppa.segment1 projet_name, ARM.name mode_reg, rcta.ATTRIBUTE5 code_blocage, arc.name agent_recouvrement, bank_infos.BANK_ACCOUNT_NAME baque_principale_UO, instr_infos.iban compte_bancaire, instr_infos.bank_account_num compte_bancaire_num, instr_infos.authorization_reference_number, NVL(rcta.ATTRIBUTE5, 'OUI') reg_automatic, xep.name societe from hz_cust_accounts hca, ra_customer_trx_all rcta, RA_CUSTOMER_TRX_LINES_ALL rctl, ar_payment_schedules_all ps, hr_operating_units hou, AR_RECEIPT_METHODS ARM, HZ_PARTIES hp, PA_PROJECTS_ALL ppa, ar.hz_customer_profiles hcp, ar.hz_cust_profile_classes hcpc, ar.ar_collectors arc, HZ_CUST_SITE_USES_ALL hcsua, ---------------- (SELECT arma.org_id, CEA.BANK_ACCOUNT_NAME FROM AR_RECEIPT_METHODS arm1, ar_receipt_method_accounts_all arma, CE_BANK_ACCT_USES_ALL cbaua, CE_BANK_ACCOUNTS CEA WHERE ARM1.NAME = 'PRELEVT' AND ARM1.receipt_method_id = ARMA.receipt_method_id AND arma.primary_flag = 'Y' AND arma.REMIT_BANK_ACCT_USE_ID(+) = cbaua.BANK_ACCT_USE_ID AND cbaua.BANK_ACCOUNT_ID = CEA.bank_account_id) bank_infos, ---------------- (SELECT ieba.iban, ieba.bank_account_num, ida.authorization_reference_number, extn.TRXN_EXTENSION_ID FROM iby_ext_bank_accounts ieba, iby_pmt_instr_uses_all u, iby_fndcpt_tx_extensions extn, IBY_DEBIT_AUTHORIZATIONS ida WHERE ieba.ext_bank_account_id = u.instrument_id AND extn.instr_assignment_id = u.instrument_payment_use_id AND u.payment_function = 'CUSTOMER_PAYMENT' AND extn.trxn_ref_number1 = 'TRANSACTION' AND extn.payment_channel_code = 'BANK_ACCT_XFER' AND extn.DEBIT_AUTHORIZATION_ID = ida.debit_authorization_id(+)) instr_infos, --------------------------- XLE_ENTITY_PROFILES xep where 1 = 1 AND hca.cust_account_id = rcta.BILL_TO_CUSTOMER_ID AND hp.PARTY_ID = hca.PARTY_ID AND rcta.CUSTOMER_TRX_ID = rctl.CUSTOMER_TRX_ID AND rcta.ORG_ID = hou.organization_id AND ps.CUSTOMER_TRX_ID = rcta.CUSTOMER_TRX_ID AND NVL(ps.amount_due_remaining, 0) <> 0 AND ARM.RECEIPT_METHOD_ID = rcta.RECEIPT_METHOD_ID AND ARM.NAME = 'PRELEVT' AND rcta.ATTRIBUTE11 = ppa.PROJECT_ID(+) AND ps.selected_for_receipt_batch_id IS NULL --------------------------- AND hcp.party_id = hp.party_id AND hca.cust_account_id = hcp.cust_account_id AND hcp.site_use_id IS NULL AND hcpc.profile_class_id = hcp.profile_class_id AND arc.collector_id = hcpc.collector_id AND hcsua.site_use_id = rcta.bill_to_site_use_id ------------------BANQUE UO--------- AND hou.organization_id = bank_infos.org_id(+) ----------------------IBAN CUSTOMER ---------------- AND rcta.payment_trxn_extension_id = instr_infos.TRXN_EXTENSION_ID(+) -------------------------------------------------------- AND xep.legal_entity_id = hou.default_legal_context_id ----------------------Parameters------------------------- AND trunc(ps.DUE_DATE) <= trunc(:P_DATE) AND substr(hou.name, 1, 3) = :P_REGION --Region AND NVL(:P_SOCIETE, substr(hou.name, -4) ) = substr(hou.name, -4) --Societe AND NVL(:P_RECOUVR_DE, arc.name) <= arc.name AND NVL(:P_RECOUVR_A, arc.name) >= arc.name group by hca.ACCOUNT_NUMBER, hp.PARTY_NAME, hcsua.LOCATION, rcta.trx_number, rcta.CREATION_DATE, --EDB381 SHO rcta.PURCHASE_ORDER, TO_CHAR(rcta.TRX_DATE, 'DD/MM/YYYY'), hou.name, TO_CHAR(ps.GL_DATE, 'DD/MM/YYYY'), ps.amount_due_remaining, TO_CHAR(ps.DUE_DATE, 'DD/MM/YYYY'), ps.amount_due_original, ppa.segment1, ARM.name, rcta.ATTRIBUTE5, arc.name, bank_infos.BANK_ACCOUNT_NAME, instr_infos.iban, instr_infos.bank_account_num, instr_infos.authorization_reference_number, xep.name order by hou.name, hca.ACCOUNT_NUMBER, TO_CHAR(ps.DUE_DATE, 'DD/MM/YYYY'), rcta.trx_number
6xvp6nxs4a9n4	select nvl(sum(space), 0) from recyclebin$ where ts# = :1
75r3t7hw0n9a9	Select S.SERVICE_HANDLE, S.CARTRIDGE_HANDLE, Q.CONTEXT_BUFFER, Q.SERVICE_PARAMETERS, S.DEVELOPER_PARAMETERS, '', '', S.ENV_FILE_NAME, SMQ.DIAGNOSTIC_LEVEL, Q.DIAGNOSTIC_LEVEL, DECODE(S.ALLOW_RCG, 'Y', Q.RESOURCE_CONSUMER_GROUP, ''), ALLOW_MULTIPLE_PROC_INSTANCE, ALLOW_MULTIPLE_PROC_NODE, MIGRATE_ON_FAILURE, SERVER_TYPE, ALLOW_SUSPEND, ALLOW_VERIFY, ALLOW_PARAMETER, ALLOW_START, ALLOW_RESTART, PARAMETER_CHANGE_ACTION, nvl(q.TARGET_NODE, :icmnode), A.BASEPATH, NVL(S.CARTRIDGE_APPLICATION_ID, 0), ALLOW_MULTIPLE_PROC_SI From Fnd_Concurrent_Queues Q, fnd_cp_services S, Fnd_Concurrent_Queues smq, fnd_application A Where to_number(q.manager_type) >999 and q.enabled_flag = 'Y' and q.manager_type = S.SERVICE_ID and q.APPLICATION_ID = A.APPLICATION_ID and smq.NODE_NAME = nvl(q.TARGET_NODE, :icmnode2) and smq.manager_type = 6 and smq.enabled_flag = 'Y' and Q.concurrent_queue_id = :mgr_id
7b5w34atn8q1h	BEGIN FND_CP_OPP_IPC.Get_Message(:1, :2, :3, :4, :5, :6, :7, :8); END;
7zbux2tx7m42w	SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel */ NVL(C1, 0), NVL(C2, 0), NVL(C3, 0) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "ZX_LINES_DET_FACTORS") */ 4294967295 AS C1, COUNT(*) AS C2, SUM(CASE WHEN ("ZX_LINES_DET_FACTORS"."APPLICATION_ID"=:B1) THEN 1 ELSE 0 END) AS C3 FROM "ZX"."ZX_LINES_DET_FACTORS" "ZX_LINES_DET_FACTORS" WHERE ("ZX_LINES_DET_FACTORS"."APPLICATION_ID"=:B2)) innerQuery
80p35tcj54nfv	SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :1 and table_name = :2 and column_name like :3 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :4 and table_name = :5 and column_name like :6 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :7 and table_name = :8 and column_name like :9 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :10 and table_name = :11 and column_name like :12 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :13 and table_name = :14 and column_name like :15 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :16 and table_name = :17 and column_name like :18 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :19 and table_name = :20 and column_name like :21 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :22 and table_name = :23 and column_name like :24 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :25 and table_name = :26 and column_name like :27 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :28 and table_name = :29 and column_name like :30 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :31 and table_name = :32 and column_name like :33 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :34 and table_name = :35 and column_name like :36 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :37 and table_name = :38 and column_name like :39 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :40 and table_name = :41 and column_name like :42 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :43 and table_name = :44 and column_name like :45 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :46 and table_name = :47 and column_name like :48 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :49 and table_name = :50 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :51 and table_name = :52 and column_name like :53 union all select case type# when 7 then 'PROCEDURE' when 8 then 'FUNCTION' when 9 then 'PACKAGE' when 33 then 'OPERATOR' end type, ''||o.owner# owner, name object_name, null column_name, null column_id, null data_type FROM sys.obj$ o where name not like 'BIN%' and type# in (7, 8, 9) and rownum <=50 and name like :54 union all SELECT 'SEQUENCE' type, USER owner, object_name, 'NEXTVAL' column_name, null column_id, null data_type FROM sys.user_objects WHERE object_type = 'SEQUENCE' and rownum <=50 and object_name like :55
84cb0f7f6g0q0	SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel */ NVL(C1, 0), NVL(C2, 0), NVL(C3, 0) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "RCTLGD") */ 4294967295 AS C1, COUNT(*) AS C2, SUM(CASE WHEN ("RCTLGD"."ACCOUNT_CLASS"='REC') THEN 1 ELSE 0 END) AS C3 FROM "AR"."RA_CUST_TRX_LINE_GL_DIST_ALL" "RCTLGD" WHERE ("RCTLGD"."ACCOUNT_CLASS"='REC')) innerQuery
85yg51mb2tc1t	Update fnd_concurrent_queues set CONTEXT_BUFFER = :cbuf, SERVICE_PARAMETERS = :para Where CONCURRENT_QUEUE_ID = :qid
88c7bj5twy20k	SELECT 'ARGUMENT' type, null owner, a.owner||'.'||a.package_name||'.'||a.object_name||'.'||a.overload object_name, a.argument_name||'=>'||substr(a.argument_name, 1, 1)||'/*'||a.data_type||' '||a.defaulted||'*/' column_name, a.position column_id, null data_type FROM all_arguments a, all_objects o WHERE a.object_id=o.object_id and rownum <=50 and argument_name is not null and (o.object_name = :1 and a.package_name = :2 or o.owner=:3 ) and o.object_name = :4 and a.object_name = :5
8bbsrny4tygph	select substr(haou.name, 4, 4) || '_' || substr(haou.name, 1, 3) || '_' || acra.cash_receipt_id || '_' || acrahist.cash_receipt_history_id Identifiant, acra.cash_receipt_id as "ID_Reglement_OA", acrahist.cash_receipt_history_id, arc.name as Mode_reglement, vue.remit_bank_account Compte_bancaire, vue.remit_bank_name Banque_remise, vue.remit_bank_branch Agence_remise, gcc1.segment3, acra.receipt_number "Numero reglement_OA", -- acrahist.status as Statut_Hist, decode(acrahist.status, 'REVERSED', 'Annulation', 'CONFIRMED', 'Confirme', 'CLEARED', 'Creation', 'REMITTED', 'Creation', 'Creation') as Statut_Rglt, --acra.status as Statut_Rglt, acrahist.gl_date, haou.name AS "UO", substr(haou.name, 1, 3) AS "Region", substr(haou.name, 4, 4) AS "Societe", rc.customer_number as "Numero Client", rc.customer_name as "Client", hcsu.location as "Adresse", acra.currency_code Devise, case when acrahist.status ='REVERSED' then acra.amount else acra.amount *-1 end as "Montant reglement AR", to_char(acrahist.creation_date, 'DD/MM/YYYY HH24:MI:SS') as "Date creation", acra.attribute4 as Date_du_Prelevement, fnd.user_name, fnd.description "Cree par", rcta.attribute1, case when araa.status = 'APP' then rcta.trx_number when araa.status = 'ACTIVITY' then (select receipt_number from ar_payment_schedules_all apsa, ar_cash_receipts_all acr where apsa.payment_schedule_id = araa.applied_payment_schedule_id and acr.cash_receipt_id = apsa.cash_receipt_id) when araa.status = 'ACC' then 'En Compte' end as "N? Facture", case when araa.status = 'APP' and araa.application_ref_num not like '%DOUTEUX' then 'Facture' when araa.status = 'APP' and araa.application_ref_num like '%DOUTEUX' then 'Reliquat' when araa.status = 'ACTIVITY' then 'Reglement' end as "Classe", araa.amount_applied Montant_Lettre from ar_cash_receipts_all acra, AR_CASH_RECEIPTS_V vue, hr_all_organization_units haou, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, ar_receipt_methods arm, ar_receipt_classes arc, gl_code_combinations_kfv gcc, ar_customers rc, hz_cust_accounts hca, AR_RECEIPT_METHOD_ACCOUNTS_all armaa, fnd_user fnd, AR_CASH_RECEIPT_HISTORY_ALL acrahist, gl_code_combinations_kfv gcc1, ar_receivable_applications_all araa, ra_customer_trx_all rcta where acra.receipt_method_id = arm.receipt_method_id -- and acra.creation_date <=to_date('27/05/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J -- AND acrahist.creation_date >=to_date('27/12/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J-1 AND acra.pay_from_customer = rc.customer_id (+) and hcsu.cust_acct_site_id = hcas.cust_acct_site_id(+) AND hcsu.org_id = hcas.org_id(+) AND hcas.cust_account_id = hca.cust_account_id(+) and hcsu.gl_id_rec = gcc.code_combination_id(+) and acra.org_id = haou.organization_id AND acra.customer_site_use_id = hcsu.Site_use_id(+) AND arm.receipt_class_id = arc.receipt_class_id and armaa.receipt_method_id =arm.receipt_method_id and fnd.user_id = acrahist.created_by and acra.cash_receipt_id = acrahist.cash_receipt_id and acra.cash_receipt_id = vue.cash_receipt_id and vue.remit_bank_acct_use_id = armaa.remit_bank_acct_use_id and acrahist.account_code_combination_id = gcc1.code_combination_id --- and substr(haou.name, 4, 4) in ('0490', '0491', '0492', '0493', '0498') ---and acra.cash_receipt_id ='2624378' AND acra.org_id = armaa.org_id ---and hcsu.location in ('0512152H', '0514250P') --- Ref ANAEL ---and rc.customer_number = '00046919' and acrahist.status !='CONFIRMED' and araa.cash_receipt_id = acra.cash_receipt_id and araa.display ='Y' and rcta.attribute1 = 'CYC' and acra.creation_date >='01/01/2024' ---and arc.name !='PRELEVEMENT' and substr(haou.name, 1, 3) in ('DMS', 'DEW') --- and acra.cash_receipt_id ='3201098' and araa.applied_customer_trx_id = rcta.customer_trx_id (+) order by acrahist.cash_receipt_id, acrahist.cash_receipt_history_id
8m2tu4r76nchq	SELECT value FROM v$parameter WHERE lower(name) = 'resource_limit'
8r1hh6xb00pkk	delete from FND_ENV_CONTEXT where CONCURRENT_PROCESS_ID=:b0
8swypbbr0m372	select order#, columns, types from access$ where d_obj#=:1
97nd2ugpfgjun	SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel */ NVL(SUM(C1), 0) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "FND_LOG_MESSAGES") */ 1 AS C1 FROM "APPLSYS"."FND_LOG_MESSAGES" SAMPLE BLOCK(11.8605, 8) SEED(5) "FND_LOG_MESSAGES") innerQuery
98j69vs3ymzjv	SELECT DECODE(:B2 , 'UTF8', FL.UTF8_DATE_LANGUAGE, 'AL32UTF8', FL.UTF8_DATE_LANGUAGE, FL.LOCAL_DATE_LANGUAGE ) DATA_RTN FROM FND_LANGUAGES FL WHERE FL.NLS_LANGUAGE = :B1 AND FL.INSTALLED_FLAG <>'D'
98n7q1kq9p5a7	declare l_theCursor integer default dbms_sql.open_cursor; l_status integer default -1 ; insqlsix VARCHAR2(6); begin insqlsix:=upper(substr(ltrim(:1 ), 1, 6)); -- Check to see if the statement is a DML statement. Ignore DDL -- (DBMS_SQL.PARSE will execute DDL on the parse) if ((insqlsix in ( 'INSERT', 'UPDATE', 'DELETE', 'SELECT') ) OR(substr(insqlsix, 1, 5)='MERGE') OR(substr(insqlsix, 1, 4)='WITH') OR (substr(insqlsix, 1, 1)='(')) then begin l_status := -2; dbms_sql.parse( l_theCursor, :2 , dbms_sql.native ); exception when others then l_status := dbms_sql.last_error_position; end; dbms_sql.close_cursor( l_theCursor ); end if; :3 := l_status; end;
a8kv2zwganrzm	SELECT /*+ NO_STATEMENT_QUEUING RESULT_CACHE (SYSOBJ=TRUE SHELFLIFE=30) OPT_PARAM('_ENABLE_VIEW_PDB', 'FALSE') */ "OWNER", "DIRECTORY_NAME", "OBJECT_ID", "OBJECT_TYPE#", "DIRECTORY_PATH" FROM NO_CROSS_CONTAINER("SYS"."INT$DBA_DIRECTORIES") "INT$DBA_DIRECTORIES" WHERE "INT$DBA_DIRECTORIES"."DIRECTORY_PATH"=:1
acmvv4fhdc9zh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2, spare3, signature, spare7, spare8, spare9, nvl(dflcollid, 16382), creappid, creverid, modappid, modverid, crepatchid, modpatchid from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
ajjfb86j5vx58	SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel */ NVL(C1, 0), NVL(C2, 0), NVL(C3, 0) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "OT") */ 4294967295 AS C1, COUNT(*) AS C2, SUM(CASE WHEN ("OT"."TYPE#"=13) THEN 1 ELSE 0 END) AS C3 FROM "SYS"."OBJ$" "OT" WHERE ("OT"."TYPE#"(+)=13)) innerQuery
au7f6hpnhxpkx	select ts# from ts$ where dflmaxext =:1 and bitand(flags, 1024) =1024 and online$=1
aztyg62fuxvds	SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel */ NVL(SUM(C1), 0) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "T") */ 1 AS C1 FROM "SYS"."TAB$" "T" WHERE (BITAND("T"."PROPERTY", 512)=512 OR BITAND("T"."PROPERTY", 8192)=8192 OR BITAND("T"."PROPERTY", 36893488147419103232)=36893488147419103232)) innerQuery
b13g21mgg8y98	insert /* KSXM:TAKE_SNPSHOT */ into sys.optstat_snapshot$ (obj#, inserts, updates, deletes, timestamp, flags) (select m.obj#, m.inserts, m.updates, m.deletes, systimestamp, dbms_stats_advisor.compute_volatile_flag( m.obj#, m.flags, :flags, m.inserts, m.updates, m.deletes, s.inserts, s.updates, s.deletes, null, nvl(to_number(p.valchar), :global_stale_pcnt), s.gather) flags from sys.mon_mods_all$ m, (select si.obj#, max(si.inserts) inserts, max(si.updates) updates, max(si.deletes) deletes, decode(bitand(max(si.flags), :gather_flag), 0, 'NO_GATHER', 'GATHER') gather, max(si.timestamp) timestamp from sys.optstat_snapshot$ si, (select obj#, max(timestamp) ts from sys.optstat_snapshot$ group by obj#) sm where si.obj# = sm.obj# and si.timestamp = sm.ts group by si.obj#) s, sys.optstat_user_prefs$ p where m.obj# = s.obj#(+) and m.obj# = p.obj#(+) and pname(+) = 'STALE_PERCENT' and dbms_stats_advisor.check_mmon_policy_violation(rownum, 6, 2) = 0)
cb21bacyh3c7d	select metadata from kopm$ where name='DB_FDO'
cggmjx35rzaum	SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :1 and table_name = :2 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :3 and table_name = :4 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :5 and table_name = :6 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :7 and table_name = :8 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :9 and table_name = :10 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :11 and table_name = :12 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :13 and table_name = :14 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :15 and table_name = :16 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :17 and table_name = :18 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :19 and table_name = :20 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :21 and table_name = :22 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :23 and table_name = :24 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :25 and table_name = :26 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :27 and table_name = :28 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :29 and table_name = :30 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :31 and table_name = :32 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :33 and table_name = :34 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :35 and table_name = :36 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=999 and owner = :37 and table_name = :38
cqdg389h77u5w	select substr(haou.name, 4, 4) || '_' || substr(haou.name, 1, 3) || '_' || acra.cash_receipt_id || '_' || acrahist.cash_receipt_history_id Identifiant, acra.cash_receipt_id as "ID_Reglement_OA", acrahist.cash_receipt_history_id, arc.name as Mode_reglement, vue.remit_bank_account Compte_bancaire, vue.remit_bank_name Banque_remise, vue.remit_bank_branch Agence_remise, gcc1.segment3, acra.receipt_number "Numero reglement_OA", -- acrahist.status as Statut_Hist, decode(acrahist.status, 'REVERSED', 'Annulation', 'CONFIRMED', 'Confirme', 'CLEARED', 'Creation', 'REMITTED', 'Creation', 'Creation') as Statut_Rglt, --acra.status as Statut_Rglt, acrahist.gl_date, haou.name AS "UO", substr(haou.name, 1, 3) AS "Region", substr(haou.name, 4, 4) AS "Societe", rc.customer_number as "Numero Client", rc.customer_name as "Client", hcsu.location as "Adresse", acra.currency_code Devise, case when acrahist.status ='REVERSED' then acra.amount else acra.amount *-1 end as "Montant reglement AR", to_char(acrahist.creation_date, 'DD/MM/YYYY HH24:MI:SS') as "Date creation", acra.attribute4 as Date_du_Prelevement, fnd.user_name, fnd.description "Cree par", case when araa.status = 'APP' then rcta.trx_number when araa.status = 'ACTIVITY' then (select receipt_number from ar_payment_schedules_all apsa, ar_cash_receipts_all acr where apsa.payment_schedule_id = araa.applied_payment_schedule_id and acr.cash_receipt_id = apsa.cash_receipt_id) when araa.status = 'ACC' then 'En Compte' end as "N? Facture", case when araa.status = 'APP' and araa.application_ref_num not like '%DOUTEUX' then 'Facture' when araa.status = 'APP' and araa.application_ref_num like '%DOUTEUX' then 'Reliquat' when araa.status = 'ACTIVITY' then 'Reglement' end as "Classe", araa.amount_applied Montant_Lettre from ar_cash_receipts_all acra, AR_CASH_RECEIPTS_V vue, hr_all_organization_units haou, hz_cust_site_uses_all hcsu, hz_cust_acct_sites_all hcas, ar_receipt_methods arm, ar_receipt_classes arc, gl_code_combinations_kfv gcc, ar_customers rc, hz_cust_accounts hca, AR_RECEIPT_METHOD_ACCOUNTS_all armaa, fnd_user fnd, AR_CASH_RECEIPT_HISTORY_ALL acrahist, gl_code_combinations_kfv gcc1, ar_receivable_applications_all araa, ra_customer_trx_all rcta where acra.receipt_method_id = arm.receipt_method_id -- and acra.creation_date <=to_date('27/05/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J -- AND acrahist.creation_date >=to_date('27/12/2022 07:00:00', 'DD/MM/YYYY HH24:MI:SS') --- Mettre a jour les dates J-1 AND acra.pay_from_customer = rc.customer_id (+) and hcsu.cust_acct_site_id = hcas.cust_acct_site_id(+) AND hcsu.org_id = hcas.org_id(+) AND hcas.cust_account_id = hca.cust_account_id(+) and hcsu.gl_id_rec = gcc.code_combination_id(+) and acra.org_id = haou.organization_id AND acra.customer_site_use_id = hcsu.Site_use_id(+) AND arm.receipt_class_id = arc.receipt_class_id and armaa.receipt_method_id =arm.receipt_method_id and fnd.user_id = acrahist.created_by and acra.cash_receipt_id = acrahist.cash_receipt_id and acra.cash_receipt_id = vue.cash_receipt_id and vue.remit_bank_acct_use_id = armaa.remit_bank_acct_use_id and acrahist.account_code_combination_id = gcc1.code_combination_id --- and substr(haou.name, 4, 4) in ('0490', '0491', '0492', '0493', '0498') ---and acra.cash_receipt_id ='2624378' AND acra.org_id = armaa.org_id ---and hcsu.location in ('0512152H', '0514250P') --- Ref ANAEL ---and rc.customer_number = '00046919' and acrahist.status !='CONFIRMED' and araa.cash_receipt_id = acra.cash_receipt_id and araa.display ='Y' and acra.creation_date >='01/01/2022' and arc.name !='PRELEVEMENT' and substr(haou.name, 1, 3) in ('DMS', 'DEW') -- and acra.cash_receipt_id ='3201098' and araa.applied_customer_trx_id = rcta.customer_trx_id (+) order by acrahist.cash_receipt_id, acrahist.cash_receipt_history_id
csnp95dz2r8ss	select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0
ctnvx1m6a3yrt	select directory_name from all_directories where directory_path = :1
d85f34j2phffz	/* SQL Analyze(99, 1) */ SELECT DOCS.CALLING_APP_ID CALLING_APP_ID, DOCS.CALLING_APP_DOC_UNIQUE_REF1 CALLING_APP_DOC_ID1, DOCS.CALLING_APP_DOC_UNIQUE_REF2 CALLING_APP_DOC_ID2, DOCS.CALLING_APP_DOC_UNIQUE_REF3 CALLING_APP_DOC_ID3, DOCS.CALLING_APP_DOC_UNIQUE_REF4 CALLING_APP_DOC_ID4, DOCS.CALLING_APP_DOC_UNIQUE_REF5 CALLING_APP_DOC_ID5, DOCS.PAY_PROC_TRXN_TYPE_CODE PAY_PROC_TRXN_TYPE_CD, DOCS.DOCUMENT_PAYABLE_ID DOCUMENT_ID, DOCS.PAYMENT_AMOUNT DOCUMENT_AMOUNT, DOCS.PAYMENT_CURRENCY_CODE DOCUMENT_PAY_CURRENCY, DOCS.EXCLUSIVE_PAYMENT_FLAG EXCLUSIVE_PAYMENT_FLAG, DOCS.DELIVERY_CHANNEL_CODE DELIVERY_CHANNEL_CODE, DEL_CHN.FORMAT_VALUE DELIVERY_CHN_FORMAT_VAL, DOCS.UNIQUE_REMITTANCE_IDENTIFIER UNIQUE_REMIT_ID_CODE, DOCS.PAYMENT_REASON_COMMENTS PAYMENT_REASON_COMMENTS, DOCS.SETTLEMENT_PRIORITY SETTLEMENT_PRIORITY, DOCS.REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE1, DOCS.REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE2, DOCS.REMITTANCE_MESSAGE3 REMITTANCE_MESSAGE3, DOCS.URI_CHECK_DIGIT URI_CHECK_DIGIT, DOCS.EXTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID, IBA_BNK_BRANCH.BANK_NUMBER INT_BANK_NUM, IBA_BNK_BRANCH.BANK_NAME INT_BANK_NAME, IBA_BNK_BRANCH.BANK_NAME_ALT INT_BANK_NAME_ALT, IBA_BNK_BRANCH.BRANCH_NUMBER INT_BANK_BRANCH_NUM, IBA_BNK_BRANCH.BANK_BRANCH_NAME INT_BANK_BRANCH_NAME, IBA_BNK_BRANCH.BANK_BRANCH_NAME_ALT INT_BANK_BRANCH_NAME_ALT, IBA_BNK_BRANCH.BANK_BRANCH_TYPE INT_BANK_BRANCH_TYPE, IBA.BANK_ACCOUNT_NUM INT_BANK_ACC_NUM, IBA.BANK_ACCOUNT_NAME INT_BANK_ACC_NAME, IBA.BANK_ACCOUNT_NAME_ALT INT_BANK_ACC_NAME_ALT, IBA.BANK_ACCOUNT_TYPE INT_BANK_ACC_TYPE, IBA.IBAN_NUMBER INT_BANK_ACC_IBAN, IBA.CURRENCY_CODE INT_BANK_ACC_CURR, '' INT_BANK_ASSIGNED_ID1, '' INT_BANK_ASSIGNED_ID2, IBA.EFT_USER_NUM INT_EFT_USER_NUMBER, IBA.CHECK_DIGITS INT_BANK_ACC_CHK_DGTS, IBA.EFT_REQUESTER_IDENTIFIER INT_EFT_REQ_IDENTIFIER, IBA.SHORT_ACCOUNT_NAME INT_BANK_ACC_SHORT_NAME, IBA.ACCOUNT_HOLDER_NAME INT_BANK_ACC_HOLDER_NAME, IBA.ACCOUNT_HOLDER_NAME_ALT INT_BANK_ACC_HOLDER_NAME_ALT, PAYER.PARTY_LEGAL_NAME PAYER_LE_NAME, PAYER.PARTY_ADDRESS_COUNTRY PAYER_LE_COUNTRY, PAYER.PARTY_PHONE PAYER_PHONE, PAYER.PARTY_REGISTRATION_NUMBER PAYER_REGISTRATION_NUMBER, IBY_FD_EXTRACT_GEN_PVT. GET_FP_TAXREGISTRATION (DOCS.LEGAL_ENTITY_ID) PAYER_TAX_REGISTRATION_NUMBER, EBA.BANK_NUMBER EXT_BANK_NUM, EBA.BANK_NAME EXT_BANK_NAME, EBA_BANK_BRANCH.BANK_NAME_ALT EXT_BANK_NAME_ALT, EBA.BRANCH_NUMBER EXT_BANK_BRANCH_NUM, EBA.BANK_BRANCH_NAME EXT_BANK_BRANCH_NAME, EBA_BANK_BRANCH.BANK_BRANCH_NAME_ALT EXT_BANK_BRANCH_NAME_ALT, EBA_BANK_BRANCH.BANK_BRANCH_TYPE EXT_BANK_BRANCH_TYPE, EBA.COUNTRY_CODE EXT_BANK_COUNTRY, EBA_BANK_BRANCH.ADDRESS_LINE1 EXT_BANK_BRANCH_ADDR1, NVL(EBA_BANK_BRANCH.COUNTRY, EBA_BANK_BRANCH.BANK_HOME_COUNTRY) EXT_BANK_BRANCH_COUNTRY, EBA.BANK_ACCOUNT_NUMBER EXT_BANK_ACC_NUM, EBA.BANK_ACCOUNT_NAME EXT_BANK_ACC_NAME, EBA.ALTERNATE_ACCOUNT_NAME EXT_BANK_ACC_NAME_ALT, EBA.BANK_ACCOUNT_TYPE EXT_BANK_ACC_TYPE, EBA.IBAN_NUMBER EXT_BANK_ACC_IBAN, EBA.CHECK_DIGITS EXT_BANK_ACC_CHK_DGTS, EBA.SHORT_ACCT_NAME EXT_BANK_ACC_SHORT_NAME, EBA.PRIMARY_ACCT_OWNER_NAME EXT_BANK_ACC_HOLDER_NAME, '' EXT_BANK_ACC_HOLDER_NAME_ALT, EBA.EFT_SWIFT_CODE EXT_EFT_SWIFT_CODE, PAYEE.PARTY_NAME PAYEE_PARTY_NAME, PAYEE_LOC.ADDRESS1 PAYEE_PARTY_ADDR1, PAYEE_LOC.ADDRESS2 PAYEE_PARTY_ADDR2, PAYEE_LOC.ADDRESS3 PAYEE_PARTY_ADDR3, PAYEE_LOC.CITY PAYEE_PARTY_CITY, PAYEE_LOC.STATE PAYEE_PARTY_STATE, PAYEE_LOC.PROVINCE PAYEE_PARTY_PROVINCE, PAYEE_LOC.COUNTY PAYEE_PARTY_COUNTY, PAYEE_LOC.POSTAL_CODE PAYEE_PARTY_POSTAL, PAYEE_LOC.COUNTRY PAYEE_PARTY_COUNTRY, DOCS.BANK_CHARGE_BEARER BANK_CHARGE_BEARER, DOCS.PAYMENT_REASON_CODE PAYMENT_REASON_CODE, DOCS.PAYMENT_METHOD_CODE PAYMENT_METHOD_CD, DOCS.PAYMENT_FORMAT_CODE PAYEE_PAYMENT_FORMAT_CD, PAYEESITE.PARTY_SITE_NAME PAYEE_PARTY_SITE_NAME FROM IBY_DOCS_PAYABLE_GT DOCS, IBY_PP_FIRST_PARTY_V PAYER, HZ_PARTIES PAYEE, HZ_PARTY_SITES PAYEESITE, HZ_LOCATIONS PAYEE_LOC, CE_BANK_ACCOUNTS IBA, CE_BANK_BRANCHES_V IBA_BNK_BRANCH, IBY_EXT_BANK_ACCOUNTS_INT_V EBA, CE_BANK_BRANCHES_V EBA_BANK_BRANCH, IBY_DELIVERY_CHANNELS_B DEL_CHN WHERE DOCS.DOCUMENT_PAYABLE_ID = :B1 AND DOCS.LEGAL_ENTITY_ID = PAYER.PARTY_LEGAL_ID AND DOCS.PAYEE_PARTY_ID = PAYEE.PARTY_ID AND DOCS.PAYEE_PARTY_SITE_ID = PAYEESITE.PARTY_SITE_ID (+) AND PAYEESITE.LOCATION_ID = PAYEE_LOC.LOCATION_ID(+) AND DOCS.INTERNAL_BANK_ACCOUNT_ID = IBA.BANK_ACCOUNT_ID (+) AND IBA_BNK_BRANCH.BRANCH_PARTY_ID (+) = IBA.BANK_BRANCH_ID AND DOCS.EXTERNAL_BANK_ACCOUNT_ID = EBA.EXT_BANK_ACCOUNT_ID(+) AND EBA.BANK_PARTY_ID = EBA_BANK_BRANCH.BANK_PARTY_ID(+) AND EBA.BRANCH_PARTY_ID = EBA_BANK_BRANCH.BRANCH_PARTY_ID(+) AND DOCS.DELIVERY_CHANNEL_CODE = DEL_CHN.DELIVERY_CHANNEL_CODE(+)
djk9d9064d8xz	Update fnd_concurrent_processes set PROCESS_CONTEXT = :ctxtinfo , PROCESS_STATUS_CODE = :status, OS_PROCESS_ID = :ospid, LOGFILE_NAME = :logfile, SERVICE_PARAMETERS = :params, NODE_NAME = :node Where CONCURRENT_PROCESS_ID = :cpid
dm5qmv0xq5qbn	select obj# from obj$ o where name=:1 and owner#=:2
f2c368adbbbbx	SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.Application_ID, P.Concurrent_Program_ID, P.Concurrent_Program_Name, R.Enable_Trace, R.Restart, DECODE(R.Increment_Dates, 'Y', 'Y', 'N'), R.NLS_Compliant, R.OUTPUT_FILE_TYPE, E.Executable_Name, E.Execution_File_Name, A2.Basepath, DECODE(R.Stale, 'Y', 'C', P.Execution_Method_Code), P.Print_Flag, P.Execution_Options, DECODE(P.Srs_Flag, 'Y', 'Y', 'Q', 'Y', 'N'), P.Argument_Method_Code, R.Print_Style, R.Argument_Input_Method_Code, R.Queue_Method_Code, R.Responsibility_ID, R.Responsibility_Application_ID, R.Requested_By, R.Number_Of_Copies, R.Save_Output_Flag, R.Printer, R.Print_Group, R.Priority, U.User_Name, O.Oracle_Username, O.Encrypted_Oracle_Password, R.Cd_Id, A.Basepath, A.Application_Short_Name, TO_CHAR(R.Requested_Start_Date, 'YYYY/MM/DD HH24:MI:SS'), R.Nls_Language, R.Nls_Territory, R.Nls_Numeric_Characters, DECODE(R.Parent_Request_ID, NULL, 0, R.Parent_Request_ID), R.Priority_Request_ID, R.Single_Thread_Flag, R.Has_Sub_Request, R.Is_Sub_Request, R.Req_Information, R.Description, R.Resubmit_Time, TO_CHAR(R.Resubmit_Interval), R.Resubmit_Interval_Type_Code, R.Resubmit_Interval_Unit_Code, TO_CHAR(R.Resubmit_End_Date, 'YYYY/MM/DD HH24:MI:SS'), Decode(E.Execution_File_Name, NULL, 'N', Decode(E.Subroutine_Name, NULL, Decode(E.Execution_Method_Code, 'I', 'Y', 'J', 'Y', 'N'), 'Y')), R.Argument1, R.Argument2, R.Argument3, R.Argument4, R.Argument5, R.Argument6, R.Argument7, R.Argument8, R.Argument9, R.Argument10, R.Argument11, R.Argument12, R.Argument13, R.Argument14, R.Argument15, R.Argument16, R.Argument17, R.Argument18, R.Argument19, R.Argument20, R.Argument21, R.Argument22, R.Argument23, R.Argument24, R.Argument25, X.Argument26, X.Argument27, X.Argument28, X.Argument29, X.Argument30, X.Argument31, X.Argument32, X.Argument33, X.Argument34, X.Argument35, X.Argument36, X.Argument37, X.Argument38, X.Argument39, X.Argument40, X.Argument41, X.Argument42, X.Argument43, X.Argument44, X.Argument45, X.Argument46, X.Argument47, X.Argument48, X.Argument49, X.Argument50, X.Argument51, X.Argument52, X.Argument53, X.Argument54, X.Argument55, X.Argument56, X.Argument57, X.Argument58, X.Argument59, X.Argument60, X.Argument61, X.Argument62, X.Argument63, X.Argument64, X.Argument65, X.Argument66, X.Argument67, X.Argument68, X.Argument69, X.Argument70, X.Argument71, X.Argument72, X.Argument73, X.Argument74, X.Argument75, X.Argument76, X.Argument77, X.Argument78, X.Argument79, X.Argument80, X.Argument81, X.Argument82, X.Argument83, X.Argument84, X.Argument85, X.Argument86, X.Argument87, X.Argument88, X.Argument89, X.Argument90, X.Argument91, X.Argument92, X.Argument93, X.Argument94, X.Argument95, X.Argument96, X.Argument97, X.Argument98, X.Argument99, X.Argument100, R.number_of_arguments, C.CD_Name, NVL(R.Security_Group_ID, 0), NVL(R.org_id, -1), NVL(R.request_type, 'R') FROM fnd_concurrent_requests R, fnd_concurrent_programs P, fnd_application A, fnd_user U, fnd_oracle_userid O, fnd_conflicts_domain C, fnd_concurrent_queues Q, fnd_application A2, fnd_executables E, fnd_conc_request_arguments X WHERE R.Status_code = 'I' And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) And R.Request_ID = X.Request_ID(+) And R.Program_Application_Id = P.Application_Id(+) And R.Concurrent_Program_Id = P.Concurrent_Program_Id(+) And R.Program_Application_Id = A.Application_Id(+) And P.Executable_Application_Id = E.Application_Id(+) And P.Executable_Id = E.Executable_Id(+) And P.Executable_Application_Id = A2.Application_Id(+) And R.Requested_By = U.User_Id(+) And R.Cd_Id = C.Cd_Id(+) And R.Oracle_Id = O.Oracle_Id(+) And Q.Application_Id = :q_applid And Q.Concurrent_Queue_Id = :queue_id And (P.Enabled_Flag is NULL OR P.Enabled_Flag = 'Y') And R.Hold_Flag = 'N' And R.Requested_Start_Date <= Sysdate And ( R.Enforce_Seriality_Flag = 'N' OR ( C.RunAlone_Flag = P.Run_Alone_Flag And (P.Run_Alone_Flag = 'N' OR Not Exists (Select Null From Fnd_Concurrent_Requests Sr Where Sr.Status_Code In ('R', 'T') And Sr.Enforce_Seriality_Flag = 'Y' And Sr.CD_id = C.CD_Id)))) And Q.Running_Processes <= Q.Max_Processes And R.Rowid = :reqname And ((P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((50, 44069), (50, 46333), (200, 55405), (222, 42109), (222, 42110), (401, 33045), (401, 41579), (510, 40112), (510, 40113), (510, 41497), (510, 41498), (530, 41859), (530, 41860), (535, 41492), (535, 41493), (535, 41494), (50001, 64527), (50001, 92568)) AND ((R.REQUEST_CLASS_APPLICATION_ID IS NULL AND R.CONCURRENT_REQUEST_CLASS_ID IS NULL) OR (R.REQUEST_CLASS_APPLICATION_ID, R.CONCURRENT_REQUEST_CLASS_ID) NOT IN ((0, 4), (0, 5), (0, 6), (0, 7), (0, 8), (0, 9), (0, 24), (50001, 10)))) FOR UPDATE OF R.status_code NoWait
f3ww8rgva3hrs	update /* KSXM:FLUSH COL */ 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), flags = flags + :flag - bitand(flags, :flag), timestamp = :time where obj# = :objn and intcol# = :coln
fzgxy8kf6t5ys	Select R.Rowid From Fnd_Concurrent_Requests R Where R.Hold_Flag = 'N' And R.Status_Code = 'I' And R.Requested_Start_Date <= Sysdate And (R.Node_Name1 is null or (R.Node_Name1 is not null and FND_DCP.target_node_mgr_chk(R.request_id) = 1)) And (R.Edition_Name is null or R.Edition_Name <= sys_context('userenv', 'current_edition_name')) AND EXISTS ( Select Null From Fnd_Concurrent_Programs P Where P.Enabled_Flag = 'Y' And R.Program_Application_Id = P.Application_Id And R.Concurrent_Program_Id = P.Concurrent_Program_Id AND EXISTS ( Select Null From Fnd_Oracle_Userid O Where R.Oracle_Id = O.Oracle_Id AND EXISTS ( Select Null From Fnd_Conflicts_Domain C Where P.Run_Alone_Flag = C.RunAlone_Flag And R.CD_Id = C.CD_Id ) ) And (P.Execution_Method_Code != 'S' OR (R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) IN ((0, 98), (0, 100), (0, 31721), (0, 31722), (0, 31757)))) AND ((R.PROGRAM_APPLICATION_ID, R.CONCURRENT_PROGRAM_ID) NOT IN ((50, 44069), (50, 46333), (200, 55405), (222, 42109), (222, 42110), (401, 33045), (401, 41579), (510, 40112), (510, 40113), (510, 41497), (510, 41498), (530, 41859), (530, 41860), (535, 41492), (535, 41493), (535, 41494), (50001, 64527), (50001, 92568)) AND ((R.REQUEST_CLASS_APPLICATION_ID IS NULL AND R.CONCURRENT_REQUEST_CLASS_ID IS NULL) OR (R.REQUEST_CLASS_APPLICATION_ID, R.CONCURRENT_REQUEST_CLASS_ID) NOT IN ((0, 4), (0, 5), (0, 6), (0, 7), (0, 8), (0, 9), (0, 24), (50001, 10)))) ORDER BY NVL(R.priority, 999999999), R.Priority_Request_ID, R.Request_ID
g0t052az3rx44	select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0), nvl(evaledition#, 1), nvl(unusablebefore#, 0), nvl(unusablebeginning#, 0), case when (type# in (1, 8, 9, 96, 112)) then nvl(collid, 16382) else 0 end case, nvl(collintcol#, 0), nvl(acdrrescol#, 0), nvl(spare7, 0), nvl(spare9, 0), nvl(spare10, 0) from col$ where obj#=:1 order by intcol#
g22f2h8s9vfrz	select nvl2(stale_stats, decode(stale_stats, 'NO', 3, 1), 2) from dba_tab_statistics where owner=:1 and table_name=:2
gdhgcsvtpycsr	SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :1 and table_name = :2 and column_name like :3 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :4 and table_name = :5 and column_name like :6 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :7 and table_name = :8 and column_name like :9 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :10 and table_name = :11 and column_name like :12 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :13 and table_name = :14 and column_name like :15 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :16 and table_name = :17 and column_name like :18 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :19 and table_name = :20 and column_name like :21 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :22 and table_name = :23 and column_name like :24 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :25 and table_name = :26 and column_name like :27 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :28 and table_name = :29 and column_name like :30 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :31 and table_name = :32 and column_name like :33 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :34 and table_name = :35 and column_name like :36 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :37 and table_name = :38 and column_name like :39 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :40 and table_name = :41 and column_name like :42 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :43 and table_name = :44 and column_name like :45 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :46 and table_name = :47 and column_name like :48 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :49 and table_name = :50 and column_name like :51 union all SELECT 'COLUMN' type, owner, table_name object_name, column_name, column_id, data_type FROM sys.all_tab_cols WHERE hidden_column = 'NO' and rownum <=50 and owner = :52 and table_name = :53 and column_name like :54 union all select case type# when 7 then 'PROCEDURE' when 8 then 'FUNCTION' when 9 then 'PACKAGE' when 33 then 'OPERATOR' end type, ''||o.owner# owner, name object_name, null column_name, null column_id, null data_type FROM sys.obj$ o where name not like 'BIN%' and type# in (7, 8, 9) and rownum <=50 and name like :55 union all SELECT 'SEQUENCE' type, USER owner, object_name, 'NEXTVAL' column_name, null column_id, null data_type FROM sys.user_objects WHERE object_type = 'SEQUENCE' and rownum <=50 and object_name like :56
gnmx1qp3hujtr	SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel */ NVL(C1, 0), NVL(C2, 0), NVL(C3, 0) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "ZX_LINES_DET_FACTORS") */ 4294967295 AS C1, COUNT(*) AS C2, SUM(CASE WHEN ("ZX_LINES_DET_FACTORS"."APPLICATION_ID"=:B1) THEN 1 ELSE 0 END) AS C3 FROM "ZX"."ZX_LINES_DET_FACTORS" SAMPLE BLOCK(21.0048, 8) SEED(4) "ZX_LINES_DET_FACTORS" WHERE ("ZX_LINES_DET_FACTORS"."APPLICATION_ID"=:B2)) innerQuery
grwydz59pu6mc	select text from view$ where rowid=:1
gsswt92nz5avu	SELECT 'Y' FROM MO_GLOB_ORG_ACCESS_TMP WHERE ORGANIZATION_ID = :B1
gxy0nyzkys651	select table_owner, table_name from all_synonyms where owner in (user, 'PUBLIC') and synonym_name=:1 and not exists ( select user, object_name from user_objects where object_name=:2 and object_type in ('TABLE', 'VIEW', 'PACKAGE'))

Back to SQL Statistics
Back to Top

Instance Activity Statistics

• Key Instance Activity Stats
• Instance Activity Stats
• Instance Activity Stats - Absolute Values

Key Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats

• Ordered by statistic name

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

IO Stats

• IOStat by Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Filetype summary

• 'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
• Small Read and Large Read are average service times
• Ordered by (Data Read + Write) desc

Back to IO Stats
Back to Top

Tablespace IO Stats

No data exists for this section of the report.

Back to IO Stats
Back to Top

File IO Stats

No data exists for this section of the report.

Back to IO Stats
Back to Top

Buffer Wait Statistics

• ordered by wait time desc, waits desc

Back to Top

Undo Statistics

• Undo Segment Summary
• Undo Segment Stats

Undo Segment Summary

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Undo Segment Stats

No data exists for this section of the report.

Back to Undo Statistics
Back to Top

Segment Statistics

• Segments by Logical Reads
• Segments by Physical Reads
• Segments by Physical Read Requests
• Segments by UnOptimized Reads
• Segments by Optimized Reads
• Segments by Direct Physical Reads
• Segments by Physical Writes
• Segments by Physical Write Requests
• Segments by Direct Physical Writes
• Segments by Table Scans
• Segments by DB Blocks Changes
• Segments by Row Lock Waits
• Segments by ITL Waits
• Segments by Buffer Busy Waits
• Segments by Global Cache Buffer Busy
• Segments by CR Blocks Received
• Segments by Current Blocks Received
• Segments by Global Cache Remote Grants

Segments by Logical Reads

• Total Logical Reads: 352,120,262
• Captured Segments account for 107.3% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Physical Reads

• Total Physical Reads: 5,851,261
• Captured Segments account for 105.3% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

• Total Physical Read Requests: 916,012
• Captured Segments account for 165.1% of Total
• When ** MISSING ** occurs, some of the object attributes may not be available