ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN CD6EC65DD6894713E0530100007FC979 CE GL Cash Accounts (Secured) Y select distinct gcck.concatenated_segments value, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_desc', 'SQLGL', 'GL#', gcck.chart_of_accounts_id, NULL, gcck.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') description from gl_code_combinations_kfv gcck where gcck.code_combination_id in ( select distinct case col.cnum when 1 then cba.asset_code_combination_id when 2 then cgac.asset_code_combination_id when 3 then cgac.ap_asset_ccid when 4 then cgac.ar_asset_ccid when 5 then cgac.xtr_asset_ccid end from ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_gl_accounts_ccid cgac, ce_security_profiles_v cspv, ( select 1 as cnum from dual union all select 2 as cnum from dual union all select 3 as cnum from dual union all select 4 as cnum from dual union all select 5 as cnum from dual ) col where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and cbaua.bank_account_id = cba.bank_account_id and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) and cgac.bank_acct_use_id = cbaua.bank_acct_use_id and ((cbaua.org_id = cspv.organization_id and cspv.organization_type in ('OPERATING_UNIT','BUSINESS_GROUP')) or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') ) ) order by gcck.concatenated_segments US CE GL Cash Accounts secured by CE Security Profile C8A7FD7AC922667BE0530100007F4469 CE Internal Bank Account Currency (Secured) Y select distinct cba.currency_code value, fcv.name description from ce_bank_accounts cba, fnd_currencies_vl fcv where fcv.currency_code = cba.currency_code and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) ) order by cba.currency_code US CE Internal Bank Account Curency Codes secured by CE Security Profile C8A7FD7AC920667BE0530100007F4469 CE Internal Bank Account Name (Secured) Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.bank_account_name value, hpb.party_name||' ('||cba.currency_code||') Account#: ' || cba.masked_account_num description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.bank_account_name US CE Internal Bank Account Names secured by CE Security Profile C8A7FD7AC91F667BE0530100007F4469 CE Internal Bank Account Number (secured, masked) Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.masked_account_num value, hpb.party_name||' ('||cba.currency_code||') Account:' || cba.bank_account_name description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.masked_account_num US CE Internal Bank Account Numbers secured by CE Security Profile CB5B97B15AC6A126E05362FB09055DE0 CE Internal Bank Branch Names Y select cbbv.bank_branch_name value, cbbv.bank_name description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) and cbbv.bank_name = nvl(:$flex$.Bank_name,cbbv.bank_name) order by cbbv.bank_branch_name, cbbv.bank_name US CE Internal Bank Branch Names CB5B97B15AC5A126E05362FB09055DE0 CE Internal Bank Names Y select distinct cbbv.bank_name value, null description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) order by cbbv.bank_name US CE Internal Bank Names C9C878DC04AA0259E0530100007FB368 CE Legal Entities Y select distinct xep.name value, null description from xle_entity_profiles xep, ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where xep.legal_entity_id = cba.account_owner_org_id and cba.bank_account_id = cbaua.bank_account_id and ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) US CE Legal Entities CD662379B9167FD2E0530100007F3204 select x.cash_account, x.cash_account_desc, x.cash_account_assignment, x.bank_account_name, x.bank_account_num, x.bank_account_currency, x.bank_name, x.branch_name, x.owning_legal_entity, x.primary_ledger, -- x.usage_org_type, x.usage_organization, x.ap_usage, x.ar_usage, x.treasury_usage, x.payoll_usage, case count(distinct x.bank_account_id) over (partition by x.cash_account_ccid) when 1 then null else 'Y' end multiple_bank_account_usage, case count(distinct x.cash_account_ccid) over (partition by x.bank_account_id) when 1 then null else 'Y' end multiple_cash_account_usage, listagg(x.cash_account_assignment,', ') within group (order by x.cash_account_assignment) over (partition by x.cash_account_ccid, x.bank_account_id) cash_bank_account_all_usages, -- x.cash_account || ' (' || x.cash_account_desc || ')' cash_account_pivot_label, x.bank_name || ' - ' || x.bank_account_num || ' - ' || x.bank_account_name || ' (' || x.bank_account_currency || ')' bank_account_pivot_label from ( select -- gcck.concatenated_segments cash_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_desc', 'SQLGL', 'GL#', gcck.chart_of_accounts_id, NULL, gcck.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') cash_account_desc, 'Bank Account Cash Account' cash_account_assignment, cba.bank_account_name bank_account_name, cba.masked_account_num bank_account_num, cba.currency_code bank_account_currency, hpb.party_name bank_name, hpbb.party_name branch_name, xep.name owning_legal_entity, gl.name primary_ledger, -- null usage_org_type, null usage_organization, cba.ap_use_allowed_flag ap_usage, cba.ar_use_allowed_flag ar_usage, cba.xtr_use_allowed_flag treasury_usage, cba.pay_use_allowed_flag payoll_usage, -- cba.bank_account_id bank_account_id, gcck.code_combination_id cash_account_ccid, gcck.chart_of_accounts_id chart_of_accounts_id from ce_bank_accounts cba, xle_entity_profiles xep, gl_ledgers gl, hz_parties hpb, hz_parties hpbb, gl_code_combinations_kfv gcck where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and xep.legal_entity_id = cba.account_owner_org_id and gl.ledger_id = ce_bat_utils.get_ledger_id(cba.account_owner_org_id) and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and gcck.code_combination_id = cba.asset_code_combination_id and cba.bank_account_id in (select cbaua.bank_account_id from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type in ('OPERATING_UNIT','BUSINESS_GROUP')) or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) union select gcck2.concatenated_segments cash_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_desc', 'SQLGL', 'GL#', gcck2.chart_of_accounts_id, NULL, gcck2.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') cash_account_desc, col.cname cash_account_assignment, cba.bank_account_name bank_account_name, cba.masked_account_num bank_account_num, cba.currency_code bank_account_currency, hpb.party_name bank_name, hpbb.party_name branch_name, xep.name owning_legal_entity, gl.name primary_ledger, -- case when cbaua.legal_entity_id is null then --ce_bank_and_account_validation.get_org_type(cbaua.org_id) case when pay_use_enable_flag = 'Y' then xxen_util.meaning('HR_BG','ORG_CLASS',3) end || case when pay_use_enable_flag = 'Y' and (ap_use_enable_flag = 'Y' or ar_use_enable_flag = 'Y') then ', ' end || case when ap_use_enable_flag = 'Y' or ar_use_enable_flag = 'Y' then xxen_util.meaning('OPERATING_UNIT','ORG_CLASS',3) end else xxen_util.meaning('LEGAL_ENTITY','ORGANIZATION_TYPE',260) end usage_org_type, case when cbaua.legal_entity_id is null then fnd_access_control_util.get_org_name(cbaua.org_id) else xep2.name end usage_organization, cbaua.ap_use_enable_flag ap_usage, cbaua.ar_use_enable_flag ar_usage, cbaua.xtr_use_enable_flag treasury_usage, cbaua.pay_use_enable_flag payoll_usage, -- cba.bank_account_id bank_account_id, gcck2.code_combination_id cash_account_ccid, gcck2.chart_of_accounts_id chart_of_accounts_id from ce_bank_accounts cba, xle_entity_profiles xep, gl_ledgers gl, hz_parties hpb, hz_parties hpbb, gl_code_combinations_kfv gcck, -- ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv, xle_entity_profiles xep2, ce_gl_accounts_ccid cgac, gl_code_combinations_kfv gcck2, (select 1 as cnum, 'Bank Account Usage Cash Account' cname from dual union all select 2 as cnum, 'Payables' cname from dual union all select 3 as cnum, 'Receivables' cname from dual union all select 4 as cnum, 'Payroll' cname from dual union all select 5 as cnum, 'Treasury' cname from dual ) col where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and xep.legal_entity_id = cba.account_owner_org_id and gl.ledger_id = ce_bat_utils.get_ledger_id(cba.account_owner_org_id) and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and gcck.code_combination_id (+) = cba.asset_code_combination_id and -- cbaua.bank_account_id = cba.bank_account_id and nvl(cbaua.end_date,sysdate) >= trunc(sysdate) and xep2.legal_entity_id (+) = cbaua.legal_entity_id and cgac.bank_acct_use_id = cbaua.bank_acct_use_id and -- gcck2.code_combination_id = case col.cnum when 1 then cgac.asset_code_combination_id when 2 then nvl(cgac.ap_asset_ccid,decode(cbaua.ap_use_enable_flag,'Y',cgac.asset_code_combination_id)) when 3 then nvl(cgac.ar_asset_ccid,decode(cbaua.ar_use_enable_flag,'Y',cgac.asset_code_combination_id)) when 4 then decode(cbaua.pay_use_enable_flag,'Y',cgac.asset_code_combination_id) when 5 then nvl(cgac.xtr_asset_ccid,decode(cbaua.xtr_use_enable_flag,'Y',cgac.asset_code_combination_id)) end and -- ((col.cnum = 1 and cbaua.xtr_use_enable_flag = 'Y' and cgac.asset_code_combination_id != cgac.xtr_asset_ccid) or (col.cnum = 1 and cbaua.ap_use_enable_flag = 'Y' and cgac.asset_code_combination_id != cgac.ap_asset_ccid) or (col.cnum = 1 and cbaua.ar_use_enable_flag = 'Y' and cgac.asset_code_combination_id != cgac.ar_asset_ccid) or (col.cnum = 1 and nvl(cbaua.ar_use_enable_flag,'N') != 'Y' and nvl(cbaua.ap_use_enable_flag,'N') != 'Y' and nvl(cbaua.pay_use_enable_flag,'N') != 'Y' and nvl(cbaua.xtr_use_enable_flag,'N') != 'Y') or (col.cnum = 2 and cbaua.ap_use_enable_flag = 'Y') or (col.cnum = 3 and cbaua.ar_use_enable_flag = 'Y') or (col.cnum = 4 and cbaua.pay_use_enable_flag = 'Y') or (col.cnum = 5 and cbaua.xtr_use_enable_flag = 'Y') ) and -- ((cspv.organization_id = cbaua.org_id and cspv.organization_type in ('OPERATING_UNIT','BUSINESS_GROUP')) or (cspv.organization_id = cbaua.legal_entity_id and cspv.organization_type = 'LEGAL_ENTITY') ) ) x where 1=1 order by x.cash_account, x.owning_legal_entity, x.bank_name, x.bank_account_name, x.usage_org_type nulls first, x.usage_organization nulls first, x.cash_account_assignment Y CE #,##0.00;[Red]-#,##0.00 US CE General Ledger Cash Account Usage Application: Cash Management Description: Cash Account Usage This report details the General Ledger Cash Accounts assigned to Bank Accounts, and their usage. The following templates are available: Pivot: Bank Accounts, Assigned Cash Accounts - Pivot by Bank Account, Cash Account showing cash account usage within each bank account. Pivot: Cash Account, Assigned Bank Accounts - Pivot by Cash Account, Bank Account, showing cash account usage within each bank account. Enginatics R12 only 1=1 1 10 1=1 x.owning_legal_entity=:p_legal_entity LOV CE Legal Entities C9C878DC04AA0259E0530100007FB368 Y select distinct xep.name value, null description from xle_entity_profiles xep, ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where xep.legal_entity_id = cba.account_owner_org_id and cba.bank_account_id = cbaua.bank_account_id and ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) F Entité légale US Legal Entity 2 20 1=1 x.bank_name=:p_bank_name LOV CE Internal Bank Names CB5B97B15AC5A126E05362FB09055DE0 Y select distinct cbbv.bank_name value, null description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) order by cbbv.bank_name F Nom de la banque US Bank Name 3 30 1=1 x.branch_name=:p_bank_branch_name LOV CE Internal Bank Branch Names CB5B97B15AC6A126E05362FB09055DE0 Y select cbbv.bank_branch_name value, cbbv.bank_name description from ce_bank_branches_v cbbv where cbbv.branch_party_id in (select cba.bank_branch_id from ce_bank_accounts cba where cba.account_classification='INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' ) and cbbv.bank_name = nvl(:$flex$.Bank_name,cbbv.bank_name) order by cbbv.bank_branch_name, cbbv.bank_name F Succursale bancaire US Bank Branch 4 40 1=1 x.bank_account_name=:p_bank_account_name LOV CE Internal Bank Account Name (Secured) C8A7FD7AC920667BE0530100007F4469 Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.bank_account_name value, hpb.party_name||' ('||cba.currency_code||') Account#: ' || cba.masked_account_num description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.bank_account_name F Nom du compte bancaire US Bank Account Name 5 50 1=1 x.bank_account_num=:p_bank_account_num LOV CE Internal Bank Account Number (secured, masked) C8A7FD7AC91F667BE0530100007F4469 Y with ce_sec_v as (select /*+ materialize */ cbaua.bank_account_id, cspv.organization_type from ce_bank_acct_uses_all cbaua, ce_security_profiles_v cspv where ((cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT') or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') or (cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP') ) and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) ) select cba.masked_account_num value, hpb.party_name||' ('||cba.currency_code||') Account:' || cba.bank_account_name description from ce_bank_accounts cba, hz_parties hpb, hz_parties hpbb where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and hpb.party_id = cba.bank_id and hpbb.party_id = cba.bank_branch_id and (:$flex$.legal_entity is null or cba.account_owner_org_id in (select xep.legal_entity_id from xle_entity_profiles xep where xxen_util.contains(:$flex$.legal_entity,xep.name) = 'Y') ) and hpb.party_name = nvl(:$flex$.bank_name,hpb.party_name) and hpbb.party_name = nvl(:$flex$.bank_branch,hpbb.party_name) and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'OPERATING_UNIT') ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'LEGAL_ENTITY') ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_sec_v where ce_sec_v.bank_account_id = cba.bank_account_id and ce_sec_v.organization_type = 'BUSINESS_GROUP') ) ) order by cba.masked_account_num F Numéro de compte bancaire US Bank Account Number 6 60 1=1 x.bank_account_currency=:p_bank_account_currency LOV CE Internal Bank Account Currency (Secured) C8A7FD7AC922667BE0530100007F4469 Y select distinct cba.currency_code value, fcv.name description from ce_bank_accounts cba, fnd_currencies_vl fcv where fcv.currency_code = cba.currency_code and ( ((cba.ap_use_allowed_flag = 'Y' or cba.ar_use_allowed_flag ='Y') and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'OPERATING_UNIT' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) or (cba.xtr_use_allowed_flag ='Y' and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) or (cba.pay_use_allowed_flag ='Y' and exists (select null from ce_bank_acct_uses_all cbaua,ce_security_profiles_v cspv where cbaua.bank_account_id = cba.bank_account_id and cbaua.org_id = cspv.organization_id and cspv.organization_type = 'BUSINESS_GROUP' and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate)) ) ) order by cba.currency_code F Devise du compte bancaire US Bank Account Currency 7 70 1=1 x.cash_account=:p_gl_cash_account LOV CE GL Cash Accounts (Secured) CD6EC65DD6894713E0530100007FC979 Y select distinct gcck.concatenated_segments value, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_desc', 'SQLGL', 'GL#', gcck.chart_of_accounts_id, NULL, gcck.code_combination_id, 'ALL', 'Y', 'DESCRIPTION') description from gl_code_combinations_kfv gcck where gcck.code_combination_id in ( select distinct case col.cnum when 1 then cba.asset_code_combination_id when 2 then cgac.asset_code_combination_id when 3 then cgac.ap_asset_ccid when 4 then cgac.ar_asset_ccid when 5 then cgac.xtr_asset_ccid end from ce_bank_accounts cba, ce_bank_acct_uses_all cbaua, ce_gl_accounts_ccid cgac, ce_security_profiles_v cspv, ( select 1 as cnum from dual union all select 2 as cnum from dual union all select 3 as cnum from dual union all select 4 as cnum from dual union all select 5 as cnum from dual ) col where cba.account_classification = 'INTERNAL' and nvl(cba.netting_acct_flag,'N') = 'N' and cbaua.bank_account_id = cba.bank_account_id and trunc(nvl(cbaua.end_date,sysdate)) >= trunc(sysdate) and cgac.bank_acct_use_id = cbaua.bank_acct_use_id and ((cbaua.org_id = cspv.organization_id and cspv.organization_type in ('OPERATING_UNIT','BUSINESS_GROUP')) or (cbaua.legal_entity_id = cspv.organization_id and cspv.organization_type = 'LEGAL_ENTITY') ) ) order by gcck.concatenated_segments F Compte de trésorerie US Cash Account :$flex$.Bank_name Bank Name Bank Branch :$flex$.bank_branch Bank Branch Bank Account Name :$flex$.bank_branch Bank Branch Bank Account Number :$flex$.bank_name Bank Name Bank Account Name :$flex$.bank_name Bank Name Bank Account Number :$flex$.legal_entity Legal Entity Bank Account Name :$flex$.legal_entity Legal Entity Bank Account Number Pivot: Bank Accounts, Assigned Cash Accounts Pivot by Bank Account, Cash Account showing cash account usage within each bank account. SYSADMIN 13 AP_USAGE 14 AR_USAGE 3 BANK_ACCOUNT_CURRENCY 1 BANK_ACCOUNT_NAME 3 2 BANK_ACCOUNT_NUM 20 BANK_ACCOUNT_PIVOT_LABEL 5 BANK_NAME 2 4 BRANCH_NAME 9 CASH_ACCOUNT 7 8 CASH_ACCOUNT_ASSIGNMENT 4 10 CASH_ACCOUNT_DESC 19 CASH_ACCOUNT_PIVOT_LABEL 17 MULTIPLE_BANK_ACCOUNT_USAGE 18 MULTIPLE_CASH_ACCOUNT_USAGE 6 OWNING_LEGAL_ENTITY 1 16 PAYOLL_USAGE 7 PRIMARY_LEDGER 15 TREASURY_USAGE 12 USAGE_ORGANIZATION 6 11 USAGE_ORG_TYPE 5 BANK_ACCOUNT_CURRENCY FILTER 7 BANK_ACCOUNT_NAME FILTER 5 BANK_ACCOUNT_NUM FILTER 6 BANK_ACCOUNT_PIVOT_LABEL ROW 1 BANK_NAME FILTER 3 BRANCH_NAME FILTER 4 CASH_ACCOUNT_ASSIGNMENT VALUE 1 COUNT CASH_ACCOUNT_ASSIGNMENT COLUMN 1 CASH_ACCOUNT_PIVOT_LABEL ROW 2 OWNING_LEGAL_ENTITY FILTER 1 PRIMARY_LEDGER FILTER 2 USAGE_ORGANIZATION FILTER 9 USAGE_ORG_TYPE FILTER 8 S Site Pivot: Cash Account, Assigned Bank Accounts Pivot by Cash Account, Bank Account, showing cash account usage within each bank account. SYSADMIN 13 AP_USAGE 14 AR_USAGE 6 BANK_ACCOUNT_CURRENCY 4 BANK_ACCOUNT_NAME 4 5 BANK_ACCOUNT_NUM 20 BANK_ACCOUNT_PIVOT_LABEL 7 BANK_NAME 3 8 BRANCH_NAME 1 CASH_ACCOUNT 1 3 CASH_ACCOUNT_ASSIGNMENT 5 2 CASH_ACCOUNT_DESC 19 CASH_ACCOUNT_PIVOT_LABEL 17 MULTIPLE_BANK_ACCOUNT_USAGE 18 MULTIPLE_CASH_ACCOUNT_USAGE 9 OWNING_LEGAL_ENTITY 2 16 PAYOLL_USAGE 10 PRIMARY_LEDGER 15 TREASURY_USAGE 12 USAGE_ORGANIZATION 7 11 USAGE_ORG_TYPE 6 BANK_ACCOUNT_CURRENCY FILTER 7 BANK_ACCOUNT_NAME FILTER 5 BANK_ACCOUNT_NUM FILTER 6 BANK_ACCOUNT_PIVOT_LABEL ROW 2 BANK_NAME FILTER 3 BRANCH_NAME FILTER 4 CASH_ACCOUNT_ASSIGNMENT VALUE 1 COUNT CASH_ACCOUNT_ASSIGNMENT COLUMN 1 CASH_ACCOUNT_PIVOT_LABEL ROW 1 OWNING_LEGAL_ENTITY FILTER 1 PRIMARY_LEDGER FILTER 2 USAGE_ORGANIZATION FILTER 9 USAGE_ORG_TYPE FILTER 8 S Site Pivot: Cash Account, Assigned Bank Accounts