| 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'))
|
| Statistic | Total | per Second | per Trans |
|---|
| ASSM cbk:blocks examined | 699 | 0.05 | 0.01 |
| ASSM cbk:blocks marked full | 154 | 0.01 | 0.00 |
| ASSM gsp:L1 bitmaps examined | 659 | 0.05 | 0.01 |
| ASSM gsp:L2 bitmap full | 6 | 0.00 | 0.00 |
| ASSM gsp:L2 bitmaps examined | 298 | 0.02 | 0.01 |
| ASSM gsp:L3 bitmaps examined | 0 | 0.00 | 0.00 |
| ASSM gsp:Optimized reject DB | 0 | 0.00 | 0.00 |
| ASSM gsp:Optimized reject l1 | 0 | 0.00 | 0.00 |
| ASSM gsp:Optimized reject l2 | 0 | 0.00 | 0.00 |
| ASSM gsp:Search all | 5 | 0.00 | 0.00 |
| ASSM gsp:Search hint | 18 | 0.00 | 0.00 |
| ASSM gsp:Search steal | 1 | 0.00 | 0.00 |
| ASSM gsp:bump HWM | 1 | 0.00 | 0.00 |
| ASSM gsp:get free block | 543 | 0.04 | 0.01 |
| ASSM gsp:get free data block | 0 | 0.00 | 0.00 |
| ASSM gsp:get free index block | 0 | 0.00 | 0.00 |
| ASSM gsp:good hint | 236 | 0.02 | 0.00 |
| ASSM gsp:reject L1 | 0 | 0.00 | 0.00 |
| ASSM gsp:reject L2 | 0 | 0.00 | 0.00 |
| ASSM gsp:reject db | 2 | 0.00 | 0.00 |
| ASSM rsv:alloc from reserve | 0 | 0.00 | 0.00 |
| ASSM rsv:alloc from reserve succ | 0 | 0.00 | 0.00 |
| ASSM rsv:clear reserve | 0 | 0.00 | 0.00 |
| ASSM rsv:fill reserve | 0 | 0.00 | 0.00 |
| ASSM wasted db state change | 195 | 0.01 | 0.00 |
| Batched IO (bound) vector count | 285,652 | 19.84 | 5.57 |
| Batched IO (full) vector count | 119 | 0.01 | 0.00 |
| Batched IO (space) vector count | 0 | 0.00 | 0.00 |
| Batched IO block miss count | 37,563 | 2.61 | 0.73 |
| Batched IO buffer defrag count | 201 | 0.01 | 0.00 |
| Batched IO double miss count | 14,941 | 1.04 | 0.29 |
| Batched IO same unit count | 10,727 | 0.75 | 0.21 |
| Batched IO single block count | 299,098 | 20.78 | 5.84 |
| Batched IO slow jump count | 61 | 0.00 | 0.00 |
| Batched IO vector block count | 11,113 | 0.77 | 0.22 |
| Batched IO vector read count | 1,496 | 0.10 | 0.03 |
| Block Cleanout Optim referenced | 221 | 0.02 | 0.00 |
| CCursor + sql area evicted | 298 | 0.02 | 0.01 |
| CPU used by this session | 577,728 | 40.14 | 11.27 |
| CPU used when call started | 574,500 | 39.91 | 11.21 |
| CR blocks created | 33,951 | 2.36 | 0.66 |
| Cached Commit SCN referenced | 254,658 | 17.69 | 4.97 |
| Client Advertised Receive Window | 0 | 0.00 | 0.00 |
| Client Advertised Send Window | 0 | 0.00 | 0.00 |
| Client Data Segments In | 0 | 0.00 | 0.00 |
| Client Data Segments Out | 0 | 0.00 | 0.00 |
| Client Path Maximum Transmission Unit(MTU) | 0 | 0.00 | 0.00 |
| Client Send Congestion Window | 0 | 0.00 | 0.00 |
| Client Time (usec) Busy Sending Data | 0 | 0.00 | 0.00 |
| Client Time (usec) Last Ack Received | 0 | 0.00 | 0.00 |
| Client Time (usec) Last Data Received | 0 | 0.00 | 0.00 |
| Client Time (usec) Last Data Sent | 0 | 0.00 | 0.00 |
| Client Time (usec) Round Trip Time | 0 | 0.00 | 0.00 |
| Client Time (usec) Round Trip Time Variance | 0 | 0.00 | 0.00 |
| Client Total Bytes Acked | 0 | 0.00 | 0.00 |
| Client Total Bytes Received | 0 | 0.00 | 0.00 |
| Client Total Number of Retransmitted Packets | 0 | 0.00 | 0.00 |
| Commit SCN cached | 10 | 0.00 | 0.00 |
| DFO trees parallelized | 382 | 0.03 | 0.01 |
| DML statements parallelized | 0 | 0.00 | 0.00 |
| DML statements retried | 0 | 0.00 | 0.00 |
| Effective IO time | 720,627 | 50.06 | 14.06 |
| HCC scan CUs predicates applied | 0 | 0.00 | 0.00 |
| HCC scan CUs predicates optimized | 4,426 | 0.31 | 0.09 |
| HCC scan CUs predicates received | 426 | 0.03 | 0.01 |
| HCC scan cell CUs columns accessed | 10,618 | 0.74 | 0.21 |
| HCC scan cell CUs decompressed | 4,397 | 0.31 | 0.09 |
| HCC scan cell CUs decompression time | 0 | 0.00 | 0.00 |
| HCC scan cell CUs optimized read | 0 | 0.00 | 0.00 |
| HCC scan cell CUs processed for uncompressed | 699 | 0.05 | 0.01 |
| HCC scan cell CUs pruned | 0 | 0.00 | 0.00 |
| HCC scan cell CUs row pieces accessed | 4,397 | 0.31 | 0.09 |
| HCC scan cell CUs sent uncompressed | 653 | 0.05 | 0.01 |
| HCC scan cell bytes compressed | 1,051,990,286 | 73,083.94 | 20,524.64 |
| HCC scan cell bytes decompressed | 185,520,599 | 12,888.50 | 3,619.56 |
| HCC scan cell columns theoretical max | 157,571 | 10.95 | 3.07 |
| HCC scan cell rows | 32,179,801 | 2,235.60 | 627.84 |
| HSC Heap Segment Block Changes | 5,362,045 | 372.51 | 104.62 |
| HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
| Heap Segment Array Deletes | 28 | 0.00 | 0.00 |
| Heap Segment Array Inserts | 4,943 | 0.34 | 0.10 |
| Heap Segment Array Updates | 724 | 0.05 | 0.01 |
| Heatmap BlkLevel Flushed | 0 | 0.00 | 0.00 |
| Heatmap BlkLevel Flushed to BF | 0 | 0.00 | 0.00 |
| Heatmap BlkLevel Ranges Flushed | 0 | 0.00 | 0.00 |
| KTFB alloc myinst | 1 | 0.00 | 0.00 |
| KTFB alloc req | 170 | 0.01 | 0.00 |
| KTFB alloc search FFB | 1 | 0.00 | 0.00 |
| KTFB alloc space (block) | 176,226,432 | 12,242.81 | 3,438.23 |
| KTFB alloc time (ms) | 49,203 | 3.42 | 0.96 |
| KTFB apply req | 169 | 0.01 | 0.00 |
| KTFB apply time (ms) | 4,744 | 0.33 | 0.09 |
| KTFB commit req | 0 | 0.00 | 0.00 |
| KTFB commit time (ms) | 0 | 0.00 | 0.00 |
| KTFB free req | 0 | 0.00 | 0.00 |
| KTFB free space (block) | 0 | 0.00 | 0.00 |
| KTFB free time (ms) | 0 | 0.00 | 0.00 |
| LOB table id lookup cache misses | 2 | 0.00 | 0.00 |
| Number of read IOs issued | 9 | 0.00 | 0.00 |
| PX local messages recv'd | 4,902 | 0.34 | 0.10 |
| PX local messages sent | 5,855 | 0.41 | 0.11 |
| PX remote messages recv'd | 850 | 0.06 | 0.02 |
| PX remote messages sent | 1,599 | 0.11 | 0.03 |
| Parallel operations downgraded 1 to 25 pct | 0 | 0.00 | 0.00 |
| Parallel operations downgraded 25 to 50 pct | 0 | 0.00 | 0.00 |
| Parallel operations downgraded 50 to 75 pct | 0 | 0.00 | 0.00 |
| Parallel operations downgraded to serial | 2 | 0.00 | 0.00 |
| Parallel operations not downgraded | 382 | 0.03 | 0.01 |
| Requests to/from client | 833,053 | 57.87 | 16.25 |
| RowCR - row contention | 574 | 0.04 | 0.01 |
| RowCR attempts | 403,890 | 28.06 | 7.88 |
| RowCR hits | 403,322 | 28.02 | 7.87 |
| SQL*Net roundtrips to/from client | 833,200 | 57.88 | 16.26 |
| active txn count during cleanout | 10 | 0.00 | 0.00 |
| blocks cleaned out using minact | 13,166 | 0.91 | 0.26 |
| blocks decrypted | 1,040,351 | 72.28 | 20.30 |
| blocks encrypted | 53,536 | 3.72 | 1.04 |
| branch node splits | 0 | 0.00 | 0.00 |
| buffer is not pinned count | 282,392,259 | 19,618.37 | 5,509.56 |
| buffer is pinned count | 215,683,236 | 14,983.96 | 4,208.04 |
| bytes received via SQL*Net from client | 112,771,794 | 7,834.49 | 2,200.21 |
| bytes sent via SQL*Net to client | 123,364,841 | 8,570.41 | 2,406.88 |
| calls to get snapshot scn: kcmgss | 217,471,169 | 15,108.17 | 4,242.93 |
| calls to kcmadj | 49,919 | 3.47 | 0.97 |
| calls to kcmgas | 88,163 | 6.12 | 1.72 |
| calls to kcmgcs | 501,352 | 34.83 | 9.78 |
| cell IO uncompressed bytes | 9,011,376,599 | 626,038.94 | 175,814.59 |
| cell RDMA reads | 553,638 | 38.46 | 10.80 |
| cell blocks helped by commit cache | 0 | 0.00 | 0.00 |
| cell blocks helped by minscn optimization | 1,996,934 | 138.73 | 38.96 |
| cell blocks pivoted | 8 | 0.00 | 0.00 |
| cell blocks processed by cache layer | 1,996,940 | 138.73 | 38.96 |
| cell blocks processed by data layer | 1,077,375 | 74.85 | 21.02 |
| cell blocks processed by txn layer | 1,996,940 | 138.73 | 38.96 |
| cell blocks returned by data layer | 237,089 | 16.47 | 4.63 |
| cell blocks sent | 119 | 0.01 | 0.00 |
| cell chained row pieces fetched | 0 | 0.00 | 0.00 |
| cell chained rows processed | 0 | 0.00 | 0.00 |
| cell chained rows rejected | 0 | 0.00 | 0.00 |
| cell chained rows skipped | 0 | 0.00 | 0.00 |
| cell commit cache queries | 0 | 0.00 | 0.00 |
| cell flash cache read hits | 163,195 | 11.34 | 3.18 |
| cell flash cache read hits for controlfile reads | 0 | 0.00 | 0.00 |
| cell flash cache read hits for smart IO | 26,019 | 1.81 | 0.51 |
| cell flash cache read hits for temp IO | 0 | 0.00 | 0.00 |
| cell logical write IO requests | 8 | 0.00 | 0.00 |
| cell num bytes in block IO during predicate offload | 0 | 0.00 | 0.00 |
| cell num fast response sessions | 0 | 0.00 | 0.00 |
| cell num fast response sessions continuing to smart scan | 0 | 0.00 | 0.00 |
| cell num smartio automem buffer allocation attempts | 83 | 0.01 | 0.00 |
| cell num smartio transient cell failures | 0 | 0.00 | 0.00 |
| cell overwrites in flash cache | 0 | 0.00 | 0.00 |
| cell partial writes in flash cache | 0 | 0.00 | 0.00 |
| cell physical IO bytes eligible for predicate offload | 39,411,105,792 | 2,737,970.88 | 768,922.17 |
| cell physical IO bytes eligible for smart IOs | 36,368,982,016 | 2,526,628.26 | 709,569.45 |
| cell physical IO bytes processed for IM capacity | 1,121,452,032 | 77,909.59 | 21,879.86 |
| cell physical IO bytes saved by columnar cache | 443,678,720 | 30,823.28 | 8,656.30 |
| cell physical IO bytes saved by storage index | 25,979,068,416 | 1,804,819.51 | 506,859.20 |
| cell physical IO interconnect bytes | 8,847,589,120 | 614,660.28 | 172,619.04 |
| cell physical IO interconnect bytes returned by smart scan | 314,695,424 | 21,862.54 | 6,139.80 |
| cell pmem cache read hits | 156,415 | 10.87 | 3.05 |
| cell scan CUs pcode aggregation pushdown | 0 | 0.00 | 0.00 |
| cell scan CUs pcode pred evaled | 4,421 | 0.31 | 0.09 |
| cell scan CUs pcode pred evaled using rowsets | 0 | 0.00 | 0.00 |
| cell scan CUs pcode selective done | 3 | 0.00 | 0.00 |
| cell scan rows pcode aggregated | 0 | 0.00 | 0.00 |
| cell scans | 83 | 0.01 | 0.00 |
| cell smart IO session cache hits | 47 | 0.00 | 0.00 |
| cell smart IO session cache hwm | 0 | 0.00 | 0.00 |
| cell smart IO session cache lookups | 47 | 0.00 | 0.00 |
| cell smart IO session cache soft misses | 44 | 0.00 | 0.00 |
| cell transactions found in commit cache | 0 | 0.00 | 0.00 |
| cell writes to flash cache | 24 | 0.00 | 0.00 |
| cell writes to flash cache for temp IO | 0 | 0.00 | 0.00 |
| cellmemory IM load CUs for capacity | 370 | 0.03 | 0.01 |
| cellmemory IM scan CUs processed for capacity | 4,443 | 0.31 | 0.09 |
| cellmemory IM scan CUs rejected for capacity | 2,464 | 0.17 | 0.05 |
| change write time | 6,360 | 0.44 | 0.12 |
| cleanout - number of ktugct calls | 20,535 | 1.43 | 0.40 |
| cleanouts and rollbacks - consistent read gets | 15,285 | 1.06 | 0.30 |
| cleanouts only - consistent read gets | 56 | 0.00 | 0.00 |
| cluster key scan block gets | 56,247 | 3.91 | 1.10 |
| cluster key scans | 41,658 | 2.89 | 0.81 |
| commit batch performed | 0 | 0.00 | 0.00 |
| commit batch requested | 0 | 0.00 | 0.00 |
| commit batch/immediate performed | 2 | 0.00 | 0.00 |
| commit batch/immediate requested | 2 | 0.00 | 0.00 |
| commit cleanout failures: block lost | 193 | 0.01 | 0.00 |
| commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
| commit cleanout failures: callback failure | 89 | 0.01 | 0.00 |
| commit cleanout failures: cannot pin | 49 | 0.00 | 0.00 |
| commit cleanouts | 163,427 | 11.35 | 3.19 |
| commit cleanouts successfully completed | 163,096 | 11.33 | 3.18 |
| commit immediate performed | 2 | 0.00 | 0.00 |
| commit immediate requested | 2 | 0.00 | 0.00 |
| commit txn count during cleanout | 3,375 | 0.23 | 0.07 |
| consistent changes | 303,105 | 21.06 | 5.91 |
| consistent gets | 346,410,699 | 24,065.87 | 6,758.57 |
| consistent gets direct | 4,810,935 | 334.23 | 93.86 |
| consistent gets examination | 239,223,154 | 16,619.33 | 4,667.31 |
| consistent gets examination (fastpath) | 238,944,088 | 16,599.94 | 4,661.87 |
| consistent gets from cache | 341,599,764 | 23,731.64 | 6,664.71 |
| consistent gets pin | 102,376,610 | 7,112.31 | 1,997.40 |
| consistent gets pin (fastpath) | 101,435,879 | 7,046.96 | 1,979.04 |
| cumulative DB time in requests | 228,222,060,986 | 15,855,057.72 | 4,452,678.98 |
| cursor authentications | 315 | 0.02 | 0.01 |
| cursor reload failures | 2 | 0.00 | 0.00 |
| data blocks consistent reads - undo records applied | 266,908 | 18.54 | 5.21 |
| db block changes | 10,981,942 | 762.94 | 214.26 |
| db block gets | 5,709,877 | 396.68 | 111.40 |
| db block gets direct | 0 | 0.00 | 0.00 |
| db block gets from cache | 5,709,877 | 396.68 | 111.40 |
| db block gets from cache (fastpath) | 5,555,758 | 385.97 | 108.39 |
| deferred (CURRENT) block cleanout applications | 112,505 | 7.82 | 2.20 |
| dirty buffers inspected | 3,153 | 0.22 | 0.06 |
| enqueue conversions | 2,226 | 0.15 | 0.04 |
| enqueue releases | 219,455 | 15.25 | 4.28 |
| enqueue requests | 286,278 | 19.89 | 5.59 |
| enqueue timeouts | 66,962 | 4.65 | 1.31 |
| enqueue waits | 44,155 | 3.07 | 0.86 |
| error count cleared by cell | 119 | 0.01 | 0.00 |
| exchange deadlocks | 9 | 0.00 | 0.00 |
| execute count | 212,168,387 | 14,739.78 | 4,139.47 |
| failed probes on index block reclamation | 2 | 0.00 | 0.00 |
| fastpath consistent get quota limit | 94,363 | 6.56 | 1.84 |
| file io service time | 0 | 0.00 | 0.00 |
| flashback cache read optimizations for block new | 78 | 0.01 | 0.00 |
| flashback direct read optimizations for block new | 0 | 0.00 | 0.00 |
| frame signature mismatch | 0 | 0.00 | 0.00 |
| free buffer inspected | 1,291,719 | 89.74 | 25.20 |
| free buffer requested | 1,166,302 | 81.03 | 22.75 |
| gc cr anti locks expanded | 0 | 0.00 | 0.00 |
| gc cr anti locks shrunk | 0 | 0.00 | 0.00 |
| gc cr block receive time | 45 | 0.00 | 0.00 |
| gc cr blocks received | 1,757 | 0.12 | 0.03 |
| gc cr blocks received with BPS | 0 | 0.00 | 0.00 |
| gc cr bypass requests | 0 | 0.00 | 0.00 |
| gc cr multiblock grant time | 7,097 | 0.49 | 0.14 |
| gc cr multiblock grants received | 128,472 | 8.93 | 2.51 |
| gc current block receive time | 637 | 0.04 | 0.01 |
| gc current blocks received | 27,607 | 1.92 | 0.54 |
| gc current blocks received with BPS | 0 | 0.00 | 0.00 |
| gc force cr read cr | 2 | 0.00 | 0.00 |
| gc force cr read current | 0 | 0.00 | 0.00 |
| gc hash slot added | 42,688 | 2.97 | 0.83 |
| gc hash slot removed | 21,221 | 1.47 | 0.41 |
| gc local grants | 725,902 | 50.43 | 14.16 |
| gc merge pi fg | 980 | 0.07 | 0.02 |
| gc reader bypass grants | 73 | 0.01 | 0.00 |
| gc reader bypass waits | 10 | 0.00 | 0.00 |
| gc remote block being modified | 0 | 0.00 | 0.00 |
| gc remote block read | 10 | 0.00 | 0.00 |
| gc remote disk read | 0 | 0.00 | 0.00 |
| gc remote disk read failure | 0 | 0.00 | 0.00 |
| gc remote grants | 350,605 | 24.36 | 6.84 |
| gc remote lease failure | 0 | 0.00 | 0.00 |
| gc status messages received | 258,522 | 17.96 | 5.04 |
| gc undo block disk read | 0 | 0.00 | 0.00 |
| gcs affinity lock failures | 1,058 | 0.07 | 0.02 |
| gcs affinity lock grants | 326,860 | 22.71 | 6.38 |
| gcs data block access record drops | 0 | 0.00 | 0.00 |
| gcs data block access records | 1,025,239 | 71.23 | 20.00 |
| gcs messages sent | 380,286 | 26.42 | 7.42 |
| gcs read-mostly lock failures | 0 | 0.00 | 0.00 |
| gcs read-mostly lock grants | 213,023 | 14.80 | 4.16 |
| gcs stats management (SCM) process posts | 80 | 0.01 | 0.00 |
| ges messages sent | 56,328 | 3.91 | 1.10 |
| global enqueue gets sync | 2,979,614 | 207.00 | 58.13 |
| global enqueue releases | 2,910,503 | 202.20 | 56.78 |
| heap block compress | 802 | 0.06 | 0.02 |
| hot buffers moved to head of LRU | 791,021 | 54.95 | 15.43 |
| immediate (CR) block cleanout applications | 15,341 | 1.07 | 0.30 |
| immediate (CURRENT) block cleanout applications | 1,470 | 0.10 | 0.03 |
| index crx state invalidation | 0 | 0.00 | 0.00 |
| index crx upgrade (positioned) | 48,112 | 3.34 | 0.94 |
| index crx upgrade (prefetch) | 2 | 0.00 | 0.00 |
| index fast full scans (direct read) | 0 | 0.00 | 0.00 |
| index fast full scans (full) | 0 | 0.00 | 0.00 |
| index fast full scans (rowid ranges) | 0 | 0.00 | 0.00 |
| index fetch by key | 229,127,092 | 15,917.93 | 4,470.34 |
| index range scans | 13,321,054 | 925.44 | 259.90 |
| index reclamation/extension switch | 0 | 0.00 | 0.00 |
| index split cancel op set | 0 | 0.00 | 0.00 |
| index split cancel wait clean | 7 | 0.00 | 0.00 |
| index split cancel wait noclean | 47 | 0.00 | 0.00 |
| java call heap collected bytes | 0 | 0.00 | 0.00 |
| java call heap collected count | 0 | 0.00 | 0.00 |
| java call heap gc count | 0 | 0.00 | 0.00 |
| java call heap live object count | 0 | 0.00 | 0.00 |
| java call heap live object count max | 0 | 0.00 | 0.00 |
| java call heap live size | 0 | 0.00 | 0.00 |
| java call heap live size max | 0 | 0.00 | 0.00 |
| java call heap object count | 0 | 0.00 | 0.00 |
| java call heap object count max | 0 | 0.00 | 0.00 |
| java call heap total size | 0 | 0.00 | 0.00 |
| java call heap total size max | 0 | 0.00 | 0.00 |
| java call heap used size | 0 | 0.00 | 0.00 |
| java call heap used size max | 0 | 0.00 | 0.00 |
| java session heap live size | 0 | 0.00 | 0.00 |
| java session heap live size max | 0 | 0.00 | 0.00 |
| java session heap used size | 0 | 0.00 | 0.00 |
| java session heap used size max | 0 | 0.00 | 0.00 |
| leaf node 90-10 splits | 27 | 0.00 | 0.00 |
| leaf node splits | 155 | 0.01 | 0.00 |
| lob reads | 600 | 0.04 | 0.01 |
| lob writes | 243 | 0.02 | 0.00 |
| lob writes unaligned | 243 | 0.02 | 0.00 |
| logical read bytes from cache | 2,845,160,579,072 | 197,659,179.02 | 55,509,912.77 |
| logons cumulative | 1,255 | 0.09 | 0.02 |
| messages sent | 35,001 | 2.43 | 0.68 |
| min active SCN optimization applied on CR | 4,258 | 0.30 | 0.08 |
| no buffer to keep pinned count | 22,828 | 1.59 | 0.45 |
| no work - consistent read gets | 101,090,427 | 7,022.96 | 1,972.30 |
| non-idle wait count | 3,151,774 | 218.96 | 61.49 |
| opened cursors cumulative | 211,531,485 | 14,695.53 | 4,127.04 |
| parse count (describe) | 0 | 0.00 | 0.00 |
| parse count (failures) | 280 | 0.02 | 0.01 |
| parse count (hard) | 1,082 | 0.08 | 0.02 |
| parse count (total) | 145,570 | 10.11 | 2.84 |
| parse time cpu | 9,330 | 0.65 | 0.18 |
| parse time elapsed | 30,404 | 2.11 | 0.59 |
| physical read IO requests | 916,012 | 63.64 | 17.87 |
| physical read bytes | 47,933,530,112 | 3,330,041.29 | 935,197.15 |
| physical read partial requests | 27 | 0.00 | 0.00 |
| physical read requests optimized | 923,472 | 64.16 | 18.02 |
| physical read total IO requests | 924,431 | 64.22 | 18.04 |
| physical read total bytes | 47,943,409,664 | 3,330,727.64 | 935,389.91 |
| physical read total bytes optimized | 47,560,630,272 | 3,304,135.17 | 927,921.77 |
| physical read total multi block requests | 77,489 | 5.38 | 1.51 |
| physical reads | 5,851,261 | 406.50 | 114.16 |
| physical reads cache | 1,040,083 | 72.26 | 20.29 |
| physical reads cache prefetch | 209,525 | 14.56 | 4.09 |
| physical reads direct | 4,811,178 | 334.24 | 93.87 |
| physical reads direct (lob) | 252 | 0.02 | 0.00 |
| physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical reads for flashback new | 7,820 | 0.54 | 0.15 |
| physical reads prefetch warmup | 0 | 0.00 | 0.00 |
| physical write IO requests | 8 | 0.00 | 0.00 |
| physical write bytes | 196,608 | 13.66 | 3.84 |
| physical write total IO requests | 8 | 0.00 | 0.00 |
| physical write total bytes | 196,608 | 13.66 | 3.84 |
| physical write total bytes optimized | 196,608 | 13.66 | 3.84 |
| physical write total multi block requests | 0 | 0.00 | 0.00 |
| physical writes | 24 | 0.00 | 0.00 |
| physical writes direct | 24 | 0.00 | 0.00 |
| physical writes direct (lob) | 24 | 0.00 | 0.00 |
| physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
| physical writes non checkpoint | 24 | 0.00 | 0.00 |
| pinned buffers inspected | 21,450 | 1.49 | 0.42 |
| pinned cursors current | 10 | 0.00 | 0.00 |
| prefetch clients - default | 0 | 0.00 | 0.00 |
| prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
| prefetched blocks aged out before use | 18,376 | 1.28 | 0.36 |
| process last non-idle time | 14,422 | 1.00 | 0.28 |
| queries parallelized | 228 | 0.02 | 0.00 |
| recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
| recursive calls | 389,902,636 | 27,087.34 | 7,607.11 |
| recursive cpu usage | 524,566 | 36.44 | 10.23 |
| redo buffer allocation retries | 0 | 0.00 | 0.00 |
| redo entries | 6,333,908 | 440.03 | 123.58 |
| redo entries for lost write detection | 822,454 | 57.14 | 16.05 |
| redo log space requests | 0 | 0.00 | 0.00 |
| redo ordering marks | 1 | 0.00 | 0.00 |
| redo size | 1,330,390,192 | 92,424.95 | 25,956.30 |
| redo size for direct writes | 0 | 0.00 | 0.00 |
| redo size for lost write detection | 73,780,440 | 5,125.68 | 1,439.48 |
| redo subscn max counts | 950 | 0.07 | 0.02 |
| redo synch fast sync all sleep (100us) | 1,179 | 0.08 | 0.02 |
| redo synch fast sync all sleep (120us) | 169 | 0.01 | 0.00 |
| redo synch fast sync all sleep (160us) | 145 | 0.01 | 0.00 |
| redo synch fast sync all sleep (20us) | 0 | 0.00 | 0.00 |
| redo synch fast sync all sleep (240us) | 204 | 0.01 | 0.00 |
| redo synch fast sync all sleep (400us) | 182 | 0.01 | 0.00 |
| redo synch fast sync all sleep (40us) | 0 | 0.00 | 0.00 |
| redo synch fast sync all sleep (60us) | 0 | 0.00 | 0.00 |
| redo synch fast sync all sleep (720us) | 122 | 0.01 | 0.00 |
| redo synch fast sync all sleep (80us) | 109 | 0.01 | 0.00 |
| redo synch fast sync all sleep (inf) | 84 | 0.01 | 0.00 |
| redo synch fast sync all sleep (usec) | 449,129 | 31.20 | 8.76 |
| redo synch fast sync all sleep count | 2,194 | 0.15 | 0.04 |
| redo synch fast sync backoff (usec) | 850,383 | 59.08 | 16.59 |
| redo synch fast sync backoff count | 872 | 0.06 | 0.02 |
| redo synch fast sync sleep (usec) | 257,462 | 17.89 | 5.02 |
| redo synch fast sync sleep count | 513 | 0.04 | 0.01 |
| redo synch fast sync spin (usec) | 153,743 | 10.68 | 3.00 |
| redo synch fast sync spin count | 809 | 0.06 | 0.02 |
| redo synch long waits | 153 | 0.01 | 0.00 |
| redo synch poll writes | 2,529 | 0.18 | 0.05 |
| redo synch polls | 6,970,417 | 484.25 | 135.99 |
| redo synch time | 2,043 | 0.14 | 0.04 |
| redo synch time (usec) | 20,506,786 | 1,424.65 | 400.09 |
| redo synch time overhead (usec) | 9,834,477 | 683.22 | 191.87 |
| redo synch time overhead count ( 2ms) | 18,911 | 1.31 | 0.37 |
| redo synch time overhead count ( 8ms) | 345 | 0.02 | 0.01 |
| redo synch time overhead count ( 32ms) | 90 | 0.01 | 0.00 |
| redo synch time overhead count (128ms) | 37 | 0.00 | 0.00 |
| redo synch time overhead count (inf) | 6 | 0.00 | 0.00 |
| redo synch writes | 22,507 | 1.56 | 0.44 |
| redo write broadcast ack count | 641 | 0.04 | 0.01 |
| redo write broadcast ack time | 993,014 | 68.99 | 19.37 |
| redo write info find | 19,394 | 1.35 | 0.38 |
| redo write info find fail | 5 | 0.00 | 0.00 |
| rollback changes - undo records applied | 4 | 0.00 | 0.00 |
| rollbacks only - consistent read gets | 18,964 | 1.32 | 0.37 |
| root node splits | 0 | 0.00 | 0.00 |
| rows fetched via callback | 10,834,271 | 752.68 | 211.38 |
| scan rdbms pivoted blocks | 656 | 0.05 | 0.01 |
| scan rdbms pivoted columns accessed | 7,245 | 0.50 | 0.14 |
| scan rdbms pivoted columns theoretical max | 60,293 | 4.19 | 1.18 |
| scan rdbms pivoted rows | 1,637,073 | 113.73 | 31.94 |
| securefile allocation bytes | 196,608 | 13.66 | 3.84 |
| securefile allocation chunks | 8 | 0.00 | 0.00 |
| securefile bytes non-transformed | 175,828 | 12.22 | 3.43 |
| securefile direct read bytes | 1,990,656 | 138.29 | 38.84 |
| securefile direct read ops | 175 | 0.01 | 0.00 |
| securefile direct write bytes | 196,608 | 13.66 | 3.84 |
| securefile direct write ops | 8 | 0.00 | 0.00 |
| securefile inode itree redo | 0 | 0.00 | 0.00 |
| securefile inode lhb redo | 0 | 0.00 | 0.00 |
| securefile number of non-transformed flushes | 8 | 0.00 | 0.00 |
| segment cfs allocations | 0 | 0.00 | 0.00 |
| segment chunks allocation from dispenser | 8 | 0.00 | 0.00 |
| segment dispenser allocations | 8 | 0.00 | 0.00 |
| segment dispenser load empty | 0 | 0.00 | 0.00 |
| segment dispenser load tasks | 0 | 0.00 | 0.00 |
| segment prealloc tasks | 0 | 0.00 | 0.00 |
| segment total chunk allocation | 0 | 0.00 | 0.00 |
| session connect time | 0 | 0.00 | 0.00 |
| session cursor cache hits | 211,516,359 | 14,694.48 | 4,126.75 |
| session logical reads | 352,120,262 | 24,462.52 | 6,869.97 |
| shared hash latch upgrades - no wait | 550,702 | 38.26 | 10.74 |
| shared hash latch upgrades - wait | 9,507 | 0.66 | 0.19 |
| shared io pool buffer get success | 135 | 0.01 | 0.00 |
| sorts (disk) | 0 | 0.00 | 0.00 |
| sorts (memory) | 494,451 | 34.35 | 9.65 |
| sorts (rows) | 581,114 | 40.37 | 11.34 |
| sql area evicted | 308 | 0.02 | 0.01 |
| sql area purged | 280 | 0.02 | 0.01 |
| switch current caused by our pin | 60,347 | 4.19 | 1.18 |
| switch current to new buffer | 60,401 | 4.20 | 1.18 |
| table fetch by rowid | 132,905,541 | 9,233.22 | 2,593.03 |
| table fetch continued row | 59,543 | 4.14 | 1.16 |
| table scan blocks gotten | 12,093,516 | 840.16 | 235.95 |
| table scan disk non-IMC rows gotten | 838,838,797 | 58,275.86 | 16,365.99 |
| table scan rows gotten | 838,841,524 | 58,276.05 | 16,366.04 |
| table scan rs1 | 7 | 0.00 | 0.00 |
| table scan rs2 | 0 | 0.00 | 0.00 |
| table scans (direct read) | 83 | 0.01 | 0.00 |
| table scans (long tables) | 251 | 0.02 | 0.00 |
| table scans (rowid ranges) | 0 | 0.00 | 0.00 |
| table scans (short tables) | 142,844 | 9.92 | 2.79 |
| temp space allocated (bytes) | 50,331,648 | 3,496.64 | 981.99 |
| transaction lock foreground requests | 0 | 0.00 | 0.00 |
| transaction rollbacks | 2 | 0.00 | 0.00 |
| transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
| transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
| txn cache local empty slot misses | 0 | 0.00 | 0.00 |
| txn cache local preset misses | 62 | 0.00 | 0.00 |
| txn cache local proc misses | 0 | 0.00 | 0.00 |
| txn cache local read hits | 30,861 | 2.14 | 0.60 |
| txn cache local read misses | 0 | 0.00 | 0.00 |
| txn cache local seq num misses | 0 | 0.00 | 0.00 |
| txn cache local writes | 141,298 | 9.82 | 2.76 |
| txn cache lookup fail read even version | 0 | 0.00 | 0.00 |
| txn cache remote empty slot misses | 0 | 0.00 | 0.00 |
| txn cache remote fetch double pass | 0 | 0.00 | 0.00 |
| txn cache remote proc misses | 0 | 0.00 | 0.00 |
| txn cache remote read hits | 368 | 0.03 | 0.01 |
| txn cache remote read misses | 69 | 0.00 | 0.00 |
| txn cache remote read msg sent | 205 | 0.01 | 0.00 |
| txn cache remote requested xid count | 291 | 0.02 | 0.01 |
| txn cache remote seq num misses | 291 | 0.02 | 0.01 |
| txn cache remote usn hash read misses | 0 | 0.00 | 0.00 |
| txn cache remote writes | 88 | 0.01 | 0.00 |
| undo blocks prefetched | 48,277 | 3.35 | 0.94 |
| undo change vector size | 379,069,420 | 26,334.74 | 7,395.75 |
| user calls | 916,855 | 63.70 | 17.89 |
| user commits | 34,403 | 2.39 | 0.67 |
| user logons cumulative | 394 | 0.03 | 0.01 |
| user logouts cumulative | 411 | 0.03 | 0.01 |
| user rollbacks | 16,852 | 1.17 | 0.33 |
| workarea executions - multipass | 0 | 0.00 | 0.00 |
| workarea executions - onepass | 0 | 0.00 | 0.00 |
| workarea executions - optimal | 375,808 | 26.11 | 7.33 |
| write clones created in foreground | 4 | 0.00 | 0.00 |