ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN CA011D4BA5BE62B6E0530100007FF184 CE Business Groups Y select clbovv.name value, null description from ce_le_bg_ou_vs_v clbovv where clbovv.organization_type='BUSINESS_GROUP' order by clbovv.name US CE Business Groups 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 CA012435B5946734E0530100007FFFA2 CE Operating Units Y select clbovv.name value, null description from ce_le_bg_ou_vs_v clbovv where clbovv.organization_type='OPERATING_UNIT' order by clbovv.name US CE Operating Units CB5A430475176689E05362FB0905CB94 with q_cleared_transactions as ( select --Q1 Cleared Payments cbagv.bank_account_id bank_account_id, cbagv.bank_account_name bank_account_name, cbagv.masked_account_num bank_account_num, hp_bank.party_name bank_name, hp_branch.party_name branch_name, xep.name legal_entity, 'PAYMENT' type1, 'PAYMENT' type2, aca.vendor_name supplier_customer, aca.check_date trx_date, aca.future_pay_due_date maturity_date, to_char(aca.check_number) trx_number, ipmv.payment_method_name payment_method, aca.currency_code transaction_currency, 30 transaction_order, ipa.payment_instruction_id batch_id, nvl2(ipa.payment_instruction_id ,aca.checkrun_name,null) batch_name, to_char(ipa.payment_instruction_id) remittance_number, ipia.payment_currency_code batch_currency, nvl2(cbagv2.masked_account_num, hp_batch_bank.party_name || ' - ' || cbagv2.masked_account_num || ' - ' || cbagv2.bank_account_name, null) batch_bank_account, ipa.payment_date batch_date, aca.cleared_date cleared_date, aca.amount amount, decode( aca.currency_code , cbagv.currency_code, aca.amount , nvl(aca.base_amount,aca.amount) ) account_amount, decode(aca.currency_code , cbagv.currency_code, aca.cleared_amount , nvl(aca.cleared_base_amount,aca.cleared_amount) ) account_cleared_amount, cspg.name org_name, cbagv.currency_code bacurr, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid from ap_checks_all aca, iby_payment_methods_vl ipmv, iby_payments_all ipa, iby_pay_instructions_all ipia, ce_bank_accts_gt_v cbagv, ce_bank_accts_gt_v cbagv2, hz_parties hp_bank, hz_parties hp_branch, hz_parties hp_batch_bank, ce_bank_acct_uses_all cbaua, ce_security_profiles_gt cspg, xle_entity_profiles xep, hr_all_organization_units haou, gl_code_combinations gcc where aca.cleared_date is not null and ipmv.payment_method_code = aca.payment_method_code and ipa.payment_id (+) = aca.payment_id and ipia.payment_instruction_id (+) = ipa.payment_instruction_id and cbagv2.bank_account_id (+) = ipia.internal_bank_account_id and hp_batch_bank.party_id (+) = cbagv2.bank_id and cbagv.bank_branch_id = hp_branch.party_id and cbagv.bank_id = hp_bank.party_id and cbagv.bank_account_id = cbaua.bank_account_id and cbaua.bank_acct_use_id = aca.ce_bank_acct_use_id and cbaua.ap_use_enable_flag = 'Y' and cbaua.org_id = cspg.organization_id and cspg.organization_type = 'OPERATING_UNIT' and cbaua.org_id = aca.org_id and xep.legal_entity_id = cbagv.account_owner_org_id and haou.organization_id = cbaua.org_id and gcc.code_combination_id = cbagv.asset_code_combination_id and aca.cleared_date >= nvl(:p_date_from, aca.cleared_date) and aca.cleared_date <= nvl(:p_date_to, aca.cleared_date) and :p_batch_or_trx = 'T' and :p_type in ('AR_AND_AP', 'PAYMENTS','ALL') and haou.name = nvl(:p_operating_unit,haou.name) union all select --Q2 Cleared Receipts cbagv.bank_account_id, cbagv.bank_account_name, cbagv.masked_account_num, hp_bank.party_name bank_name, hp_branch.party_name branch_name, xep.name legal_entity, 'RECEIPT' type1, 'RECEIPT' type2, hp.party_name supplier_customer, acr.receipt_date trx_date, apsa.due_date maturity_date, acr.receipt_number trx_number, arm.name payment_method, acr.currency_code transaction_currency, 10 transaction_order, aba.batch_id batch_id, aba.name batch_name, aba.bank_deposit_number remittance_number, aba.currency_code batch_currency, nvl2(cbagv2.masked_account_num, hp_batch_bank.party_name || ' - ' || cbagv2.masked_account_num || ' - ' || cbagv2.bank_account_name, null) batch_bank_account, aba.batch_date batch_date, acrha.trx_date cleared_date, acr.amount amount, decode(acr.currency_code, cbagv.currency_code, acrha.amount, nvl(acrha.acctd_amount, acrha.amount)) account_amount, decode(acr.currency_code, cbagv.currency_code, acrha.amount, nvl(acrha.acctd_amount, acrha.amount)) account_cleared_amount, cspg.name org_name, cbagv.currency_code bacurr, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid from ar_cash_receipts acr, ar_cash_receipt_history_all acrha, ar_batches_all aba, ce_bank_accts_gt_v cbagv, ce_bank_acct_uses_all cbaua2, ce_bank_accts_gt_v cbagv2, ce_lookups cl, hz_cust_accounts hca, hz_parties hp, ar_payment_schedules_all apsa, ar_receipt_methods arm, hz_parties hp_bank, hz_parties hp_branch, hz_parties hp_batch_bank, ce_bank_acct_uses_all cbaua, ce_security_profiles_gt cspg, xle_entity_profiles xep, hr_all_organization_units haou, gl_code_combinations gcc where cl.lookup_type = 'TRX_TYPE' and cl.lookup_code = acr.type and acr.cash_receipt_id = acrha.cash_receipt_id and aba.batch_id (+) = acrha.batch_id and cbaua2.bank_acct_use_id (+) = aba.remit_bank_acct_use_id and cbaua2.org_id (+) = aba.org_id and cbagv2.bank_account_id (+) = cbaua2.bank_account_id and hp_batch_bank.party_id (+) = cbagv2.bank_id and hca.cust_account_id(+) = acr.pay_from_customer and hp.party_id(+) = hca.party_id and apsa.cash_receipt_id(+) = acr.cash_receipt_id and arm.receipt_method_id = acr.receipt_method_id and cbagv.bank_branch_id = hp_branch.party_id and cbagv.bank_id = hp_bank.party_id and cbagv.bank_account_id = cbaua.bank_account_id and cbaua.ar_use_enable_flag = 'Y' and cbaua.org_id = cspg.organization_id and cspg.organization_type = 'OPERATING_UNIT' and cbaua.bank_acct_use_id = acr.remit_bank_acct_use_id and cbaua.org_id = acr.org_id and xep.legal_entity_id = cbagv.account_owner_org_id and haou.organization_id = cbaua.org_id and gcc.code_combination_id = cbagv.asset_code_combination_id and acrha.status in ('CLEARED', 'RISK_ELIMINATED') and acrha.current_record_flag = 'Y' and acrha.trx_date >= nvl(:p_date_from, acrha.trx_date) and acrha.trx_date <= nvl(:p_date_to, acrha.trx_date) and :p_batch_or_trx = 'T' and :p_type in ('AR_AND_AP', 'RECEIPTS', 'ALL') and haou.name = nvl(:p_operating_unit,haou.name) union all --Q5 payroll payments select cbagv.bank_account_id, cbagv.bank_account_name, cbagv.masked_account_num, hp_bank.party_name bank_name, hp_branch.party_name branch_name, xep.name legal_entity, 'PAYROLL' type1, 'PAYMENT' type2, c801rv.vendor_name supplier_customer, c801rv.trx_date trx_date, c801rv.maturity_date maturity_date, c801rv.trx_number trx_number, popm.org_payment_method_name payment_method, c801rv.currency_code transaction_currency, 40 transaction_order, to_number(null) batch_id, null batch_name, null remittance_number, null batch_currency, null batch_bank_account, to_date(null) batch_date, c801rv.cleared_date cleared_date, c801rv.amount amount, c801rv.bank_account_amount account_amount, c801rv.amount_cleared account_cleared_amount, fnd_access_control_util.get_org_name(c801rv.org_id) org_name, cbagv.currency_code bacurr, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid from ce_801_reconciled_v c801rv, hz_parties hp_bank, hz_parties hp_branch, ce_bank_accts_gt_v cbagv, pay_pre_payments ppp, pay_assignment_actions paa, pay_org_payment_methods_f popm, xle_entity_profiles xep, hr_all_organization_units haou, gl_code_combinations gcc where ppp.org_payment_method_id = popm.org_payment_method_id and paa.assignment_action_id = c801rv.trx_id and paa.pre_payment_id = ppp.pre_payment_id and cbagv.bank_account_id = c801rv.bank_account_id and cbagv.bank_branch_id = hp_branch.party_id and cbagv.bank_id = hp_bank.party_id and xep.legal_entity_id = cbagv.account_owner_org_id and haou.organization_id = c801rv.org_id and gcc.code_combination_id = cbagv.asset_code_combination_id and c801rv.cleared_date >= nvl(:p_date_from, c801rv.cleared_date) and c801rv.cleared_date <= nvl(:p_date_to, c801rv.cleared_date) and c801rv.trx_date between popm.effective_start_date and popm.effective_end_date and :p_batch_or_trx = 'T' and :p_type in ( 'PAYROLLS', 'ALL') and haou.name = nvl(:p_business_group, haou.name) union all --Q6 eft payroll select cbagv.bank_account_id, cbagv.bank_account_name, cbagv.masked_account_num, hp_bank.party_name bank_name, hp_branch.party_name branch_name, xep.name legal_entity, 'PAYROLL' type1, 'PAYMENT' type2, c801erv.vendor_name supplier_customer, c801erv.trx_date trx_date, c801erv.maturity_date maturity_date, c801erv.trx_number trx_number, popm.org_payment_method_name payment_method, c801erv.currency_code transaction_currency, 40 transaction_order, c801erv.batch_id batch_id, c801erv.batch_name batch_name, null remittance_number, null batch_currency, null batch_bank_account, to_date(null) batch_date, c801erv.cleared_date cleared_date, c801erv.amount amount, c801erv.bank_account_amount account_amount, c801erv.amount_cleared account_cleared_amount, fnd_access_control_util.get_org_name(c801erv.org_id) org_name, cbagv.currency_code bacurr, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid from ce_801_eft_reconciled_v c801erv, ce_bank_accts_gt_v cbagv, hz_parties hp_bank, hz_parties hp_branch, pay_pre_payments ppp, pay_assignment_actions paa, pay_org_payment_methods_f popm, xle_entity_profiles xep, hr_all_organization_units haou, gl_code_combinations gcc where ppp.org_payment_method_id = popm.org_payment_method_id and paa.assignment_action_id = c801erv.trx_id and paa.pre_payment_id = ppp.pre_payment_id and cbagv.bank_account_id = c801erv.bank_account_id and cbagv.bank_branch_id = hp_branch.party_id and cbagv.bank_id = hp_bank.party_id and xep.legal_entity_id = cbagv.account_owner_org_id and haou.organization_id = c801erv.org_id and gcc.code_combination_id = cbagv.asset_code_combination_id and c801erv.cleared_date >= nvl(:p_date_from, c801erv.cleared_date) and c801erv.cleared_date <= nvl(:p_date_to, c801erv.cleared_date) and c801erv.trx_date between popm.effective_start_date and popm.effective_end_date and :p_batch_or_trx = 'T' and :p_type in ( 'PAYROLLS', 'ALL') and haou.name = nvl(:p_business_group, haou.name) union all --Q7 roi_line select cbagv.bank_account_id, cbagv.bank_account_name, cbagv.masked_account_num, cbbv.bank_name, cbbv.bank_branch_name branch_name, xep.name legal_entity, 'ROI_LINE' type1, 'RECEIPT' type2, null supplier_customer, c999iv.trx_date trx_date, to_date(null) maturity_date, c999iv.trx_number trx_number, null payment_method, c999iv.currency_code transaction_currency, 50 transaction_order, to_number(null) batch_id, null batch_name, null remittance_number, null batch_currency, null batch_bank_account, to_date(null) batch_date, c999iv.cleared_date cleared_date, c999iv.amount amount, decode(c999iv.currency_code, cbagv.currency_code, c999iv.amount, nvl(c999iv.acctd_amount, c999iv.amount)) account_amount, decode(c999iv.currency_code, cbagv.currency_code, c999iv.cleared_amount, nvl(c999iv.acctd_cleared_amount, c999iv.cleared_amount)) account_cleared_amount, null org_name, cbagv.currency_code bacurr, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid from ce_999_interface_v c999iv, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, xle_entity_profiles xep, gl_code_combinations gcc where cbagv.bank_branch_id = cbbv.branch_party_id and cbagv.bank_account_id = c999iv.bank_account_id and xep.legal_entity_id = cbagv.account_owner_org_id and gcc.code_combination_id = cbagv.asset_code_combination_id and c999iv.status = nvl(cbagv.recon_oi_cleared_status, '#') and c999iv.cleared_date >= nvl(:p_date_from, c999iv.cleared_date) and c999iv.cleared_date <= nvl(:p_date_to, c999iv.cleared_date) and :p_batch_or_trx = 'T' and :p_type in ('ROI_LINES', 'ALL') and c999iv.trx_type = 'CASH' union all select --Q8 roi_line cbagv.bank_account_id, cbagv.bank_account_name, cbagv.masked_account_num, cbbv.bank_name, cbbv.bank_branch_name branch_name, xep.name legal_entity, 'ROI_LINE' type1, 'PAYMENT' type2, null supplier_customer, c999iv.trx_date trx_date, to_date(null) maturity_date, c999iv.trx_number trx_number, null payment_method, c999iv.currency_code transaction_currency, 60 transaction_order, to_number(null) batch_id, null batch_name, null remittance_number, null batch_currency, null batch_bank_account, to_date(null) batch_date, c999iv.cleared_date cleared_date, c999iv.amount amount, decode(c999iv.currency_code, cbagv.currency_code, c999iv.amount, nvl(c999iv.acctd_amount, c999iv.amount)) account_amount, decode(c999iv.currency_code, cbagv.currency_code, c999iv.cleared_amount, nvl(c999iv.acctd_cleared_amount, c999iv.cleared_amount)) account_cleared_amount, null org_name, cbagv.currency_code bacurr, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid from ce_999_interface_v c999iv, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, xle_entity_profiles xep, gl_code_combinations gcc where cbagv.bank_branch_id = cbbv.branch_party_id and cbagv.bank_account_id = c999iv.bank_account_id and c999iv.status = nvl(cbagv.recon_oi_cleared_status, '#') and xep.legal_entity_id = cbagv.account_owner_org_id and gcc.code_combination_id = cbagv.asset_code_combination_id and c999iv.cleared_date >= nvl(:p_date_from, c999iv.cleared_date) and c999iv.cleared_date <= nvl(:p_date_to, c999iv.cleared_date) and :p_batch_or_trx = 'T' and :p_type in ('ROI_LINES','ALL') and c999iv.trx_type = 'PAYMENT' union all select --Q9 xtr_line cbagv.bank_account_id, cbagv.bank_account_name, cbagv.masked_account_num, cbbv.bank_name, cbbv.bank_branch_name branch_name, xep.name legal_entity, 'XTR_LINE' type1, 'RECEIPT' type2, null supplier_customer, c185rv.trx_date trx_date, to_date(null) maturity_date, c185rv.trx_number trx_number, null payment_method, c185rv.currency_code transaction_currency, 50 transaction_order, to_number(null) batch_id, null batch_name, null remittance_number, null batch_currency, null batch_bank_account, to_date(null) batch_date, c185rv.cleared_date cleared_date, c185rv.amount amount, c185rv.bank_account_amount account_amount, c185rv.amount_cleared account_cleared_amount, xep2.name org_name, cbagv.currency_code bacurr, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid from ce_185_reconciled_v c185rv, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, xle_entity_profiles xep, xle_entity_profiles xep2, gl_code_combinations gcc where cbagv.bank_branch_id = cbbv.branch_party_id and cbagv.bank_account_id = c185rv.bank_account_id and xep.legal_entity_id = cbagv.account_owner_org_id and xep2.legal_entity_id = c185rv.legal_entity_id and gcc.code_combination_id = cbagv.asset_code_combination_id and c185rv.cleared_date >= nvl(:p_date_from, c185rv.cleared_date) and c185rv.cleared_date <= nvl(:p_date_to, c185rv.cleared_date) and :p_batch_or_trx = 'T' and :p_type in ( 'XTR_LINES', 'ALL') and c185rv.trx_type = 'CASH' and xep2.name = nvl(:p_legal_entity,xep2.name) union all select --Q10 xtr_line cbagv.bank_account_id, cbagv.bank_account_name, cbagv.masked_account_num, cbbv.bank_name bank_name, cbbv.bank_branch_name branch_name, xep.name legal_entity, 'XTR_LINE' type2, 'PAYMENT' type2, null supplier_customer, c185rv.trx_date trx_date, to_date(null) maturity_date, c185rv.trx_number trx_number, null payment_method, c185rv.currency_code transaction_currency, 60 transaction_order, to_number(null) batch_id, null batch_name, null remittance_number, null batch_currency, null batch_bank_account, to_date(null) batch_date, c185rv.cleared_date cleared_date, c185rv.amount amount, c185rv.bank_account_amount account_amount, c185rv.amount_cleared account_cleared_amount, xep2.name org_name, cbagv.currency_code bacurr, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid from ce_185_reconciled_v c185rv, ce_bank_accts_gt_v cbagv, ce_bank_branches_v cbbv, xle_entity_profiles xep, xle_entity_profiles xep2, gl_code_combinations gcc where cbagv.bank_branch_id = cbbv.branch_party_id and cbagv.bank_account_id = c185rv.bank_account_id and xep.legal_entity_id = cbagv.account_owner_org_id and xep2.legal_entity_id = c185rv.legal_entity_id and gcc.code_combination_id = cbagv.asset_code_combination_id and c185rv.cleared_date >= nvl(:p_date_from, c185rv.cleared_date) and c185rv.cleared_date <= nvl(:p_date_to, c185rv.cleared_date) and :p_batch_or_trx = 'T' and :p_type in ( 'XTR_LINES', 'ALL') and c185rv.trx_type = 'PAYMENT' and xep2.name = nvl(:p_legal_entity,xep2.name) union all --Q11 cashflow receipt select cbagv.bank_account_id, cbagv.bank_account_name, cbagv.masked_account_num, hp_bank.party_name bank_name, hp_branch.party_name branch_name, cspg.name legal_entity, 'CASHFLOW' type1, 'RECEIPT' type2, null supplier_customer, cc.cashflow_date trx_date, to_date(null) maturity_date, nvl(cc.bank_trxn_number, cc.cashflow_id) trx_number, null payment_method, cc.cashflow_currency_code transaction_currency, 70 transaction_order, to_number(null) batch_id, null batch_name, null remittance_number, null batch_currency, null batch_bank_account, to_date(null) batch_date, cc.cleared_date cleared_date, cc.cashflow_amount amount, decode(cc.cashflow_currency_code, cbagv.currency_code, cc.cashflow_amount, nvl(cc.base_amount, cc.cashflow_amount)) account_amount, ccah.cleared_amount account_cleared_amount, xep2.name org_name, cbagv.currency_code bacurr, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid from ce_bank_accts_gt_v cbagv, ce_cashflows cc, ce_cashflow_acct_h ccah, hz_parties hp_bank, hz_parties hp_branch, ce_security_profiles_gt cspg, xle_entity_profiles xep2, gl_code_combinations gcc where cbagv.bank_branch_id = hp_branch.party_id and cbagv.bank_id = hp_bank.party_id and cbagv.account_owner_org_id = cspg.organization_id and cspg.organization_type = 'LEGAL_ENTITY' and cbagv.bank_account_id = cc.cashflow_bank_account_id and cbagv.account_owner_org_id = cc.cashflow_legal_entity_id and xep2.legal_entity_id = cc.cashflow_legal_entity_id and gcc.code_combination_id = cbagv.asset_code_combination_id and cc.cashflow_status_code in ('CLEARED','RECONCILED') and cc.cleared_date >= nvl(:p_date_from, cc.cleared_date) and cc.cleared_date <= nvl(:p_date_to, cc.cleared_date) and cc.cashflow_direction = 'RECEIPT' and ccah.cashflow_id = cc.cashflow_id and ccah.current_record_flag = 'Y' and ccah.event_type in ('CE_BAT_CLEARED','CE_STMT_RECORDED') and :p_batch_or_trx = 'T' and :p_type in ('CASHFLOWS', 'ALL') and xep2.name = nvl(:p_legal_entity,xep2.name) union all --Q12 cashflow payments select cbagv.bank_account_id, cbagv.bank_account_name, cbagv.masked_account_num, hp_bank.party_name bank_name, hp_branch.party_name branch_name, cspg.name legal_entity, 'CASHFLOW' type1, 'PAYMENT' type2, null supplier_customer, cc.cashflow_date trx_date, to_date(null) maturity_date, nvl(cc.bank_trxn_number, cc.cashflow_id) trx_number, null payment_method, cc.cashflow_currency_code transaction_currency, 80 transaction_order, to_number(null) batch_id, null batch_name, null remittance_number, null batch_currency, null batch_bank_account, to_date(null) batch_date, cc.cleared_date cleared_date, ccah.cleared_amount account_cleared_amount, cc.cashflow_amount amount, decode(cc.cashflow_currency_code, cbagv.currency_code, cc.cashflow_amount, nvl(cc.base_amount, cc.cashflow_amount)) account_amount, xep2.name org_name, cbagv.currency_code bacurr, gcc.code_combination_id asset_ccid, gcc.chart_of_accounts_id coaid from ce_bank_accts_gt_v cbagv, ce_cashflows cc, ce_cashflow_acct_h ccah, hz_parties hp_bank, hz_parties hp_branch, ce_security_profiles_gt cspg, xle_entity_profiles xep2, gl_code_combinations gcc where cbagv.bank_branch_id = hp_branch.party_id and cbagv.bank_id = hp_bank.party_id and cbagv.account_owner_org_id = cspg.organization_id and cspg.organization_type = 'LEGAL_ENTITY' and cbagv.bank_account_id = cc.cashflow_bank_account_id and cbagv.account_owner_org_id = cc.cashflow_legal_entity_id and xep2.legal_entity_id = cc.cashflow_legal_entity_id and gcc.code_combination_id = cbagv.asset_code_combination_id and cc.cashflow_status_code in ('CLEARED','RECONCILED') and cc.cleared_date >= nvl(:p_date_from, cc.cleared_date) and cc.cleared_date <= nvl(:p_date_to, cc.cleared_date) and cc.cashflow_direction = 'PAYMENT' and ccah.cashflow_id = cc.cashflow_id and ccah.current_record_flag = 'Y' and ccah.event_type IN ('CE_BAT_CLEARED','CE_STMT_RECORDED') and :p_batch_or_trx = 'T' and :p_type IN ('CASHFLOWS', 'ALL') and xep2.name = nvl(:p_legal_entity,xep2.name) ) -- -- Main Query Starts Here -- select q.legal_entity, q.bank_account_name, q.bank_account_num, q.bacurr bank_account_currency, q.bank_name, q.branch_name, case q.transaction_order when 10 then 'Receipts' when 30 then 'Payments' when 40 then 'Payroll Payments' when 50 then 'Open Interface Receipts' when 60 then 'Open Interface Payments' when 70 then 'Cashflow Receipts' when 80 then 'Cashflow Payments' else 'Other' end cleared_transaction_type, q.supplier_customer agent, q.trx_date "Remit/Payment Date", q.maturity_date, q.payment_method, q.trx_number "Receipt/Payment Number", q.batch_id, q.batch_name, q.batch_date, nvl(q.batch_bank_account,'Batch Bank Not Specified') batch_bank_account, nvl(q.batch_currency,'Batch Currency Not Specified') batch_currency, q.transaction_currency, q.amount, q.account_amount, q.cleared_date, q.account_cleared_amount, case when q.type2 = 'PAYMENT' then -1 * q.account_cleared_amount else q.account_cleared_amount end net_account_cleared_amount, case when q.type1 not in ('PAYROLL','XTR_LINE','CASHFLOW') then q.org_name end operating_unit, case when q.type1 in ('PAYROLL') then q.org_name end payroll_business_group, case when q.type1 in ('XTR_LINE','CASHFLOW') then q.org_name end treasury_legal_entity, -- -- GL Cash Account Details fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', q.coaid, NULL, q.asset_ccid, 'GL_BALANCING', 'Y', 'VALUE') gl_company_code, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', q.coaid, NULL, q.asset_ccid, 'GL_BALANCING', 'Y', 'DESCRIPTION') gl_company_desc, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', q.coaid, NULL, q.asset_ccid, 'GL_ACCOUNT', 'Y', 'VALUE') gl_account_code, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', q.coaid, NULL, q.asset_ccid, 'GL_ACCOUNT', 'Y', 'DESCRIPTION') gl_account_desc, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', q.coaid, NULL, q.asset_ccid, 'FA_COST_CTR', 'Y', 'VALUE') gl_cost_center_code, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', q.coaid, NULL, q.asset_ccid, 'FA_COST_CTR', 'Y', 'DESCRIPTION') gl_cost_center_desc, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', q.coaid, NULL, q.asset_ccid, 'ALL', 'Y', 'VALUE') gl_cash_account, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_bal_seg', 'SQLGL', 'GL#', q.coaid, NULL, q.asset_ccid, 'ALL', 'Y', 'DESCRIPTION') gl_cash_account_desc, -- pivot labels q.bank_name || ' - ' || q.bank_account_num || ' - ' || q.bank_account_name || ' (' || q.bacurr || ')' bank_account_pivot_label, q.org_name organization_pivot_label, case when to_char(q.batch_id) || q.batch_name is null then 'Unbatched Transactions' else 'Batched Transactions' end batched_unbatched_flag, case when to_char(q.batch_id) || q.batch_name is null then 'Unbatched Transactions' else to_char(q.batch_date,'YYYY/MM/DD') || ': ' || q.batch_name || ' (' || q.batch_id || ')' end batch_pivot_label, q.transaction_order from q_cleared_transactions q where 1=1 order by q.legal_entity, q.bank_name, q.bank_account_num, q.transaction_order, q.trx_date Y #,##0.00;[Red]-#,##0.00 CE_CEXCLEAR_XMLP_PKG AR CE تقرير حركات المقاصة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Imported from BI Publisher Description: الحركات - المدفوعات/المقبوضات المصفاة Application: إدارة النقدية Source: تقرير حركات المقاصة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG D CE Ausgezifferte Transaktionen- Nicht unterstützt: Reserviert für zukünftige Verwendung Imported from BI Publisher Description: Transaktionen - Ausgezifferte Zahlungsausgänge/-eingänge Application: Cash Management Source: Ausgezifferte Transaktionen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG E CE Informe de Transacciones Compensadas: No Admitido, Reservado para Uso Futuro Imported from BI Publisher Description: Transacciones - Pagos/Cobros Conciliados Application: Cash Management Source: Informe de Transacciones Compensadas (XML): No Admitido, Reservado para Uso Futuro Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG F CE Etat des mouvements apurés- Non pris en charge : réservé pour une utilisation future Imported from BI Publisher Description: Mouvements - Règlements/encaissements apurés Application: Cash Management Source: Etat des mouvements apurés (XML) - Non pris en charge : réservé pour une utilisation future Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG I CE Rapporto Transazioni liquidate- non supportato: riservato per usi futuri Imported from BI Publisher Description: Transazioni: pagamenti/incassi liquidati Application: Cash Management Source: Rapporto Transazioni liquidate (XML) - non supportato: riservato per usi futuri Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG JA CE 決済取引レポート- 未サポート: 将来の使用のために予約 Imported from BI Publisher Description: 取引 - 決済済支払/入金 Application: Cash Management Source: 決済取引レポート(XML) - 未サポート: 将来の使用のために予約 Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG KO CE 정산된 거래 보고서- 지원되지 않음: 추후 사용을 위해 예약됨 Imported from BI Publisher Description: 거래 - 정산된 지급/수금 Application: Cash Management Source: 정산된 거래 보고서(XML) - 지원되지 않음: 추후 사용을 위해 예약됨 Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG PTB CE Relatório de Transações Compensadas- Não Suportado: Reservado para Uso Futuro Imported from BI Publisher Description: Transações - Pagamentos/Recebimentos Compensados Application: Cash Management Source: Relatório de Transações Compensadas (XML) - Não Suportado: Reservado para Uso Futuro Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG RU CE Отчет о перерассчитанных транзакциях- не поддерживается: зарезервировано для будущего использования Imported from BI Publisher Description: Транзакции - перерассчитанные платежи/поступления Application: Движение денежных средств Source: Отчет о перерассчитанных транзакциях (XML) - не поддерживается: зарезервировано для будущего использования Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG S CE Rapport över reglerade transaktioner- stöds inte: Reserverad för framtida bruk Imported from BI Publisher Description: Transaktioner - reglerade ut-/inbetalningar Application: Cash Management Source: Rapport över reglerade transaktioner (XML) - stöds inte: Reserverad för framtida bruk Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG TR CE Takas Edilen İşlemler Raporu- Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Imported from BI Publisher Description: İşlemler - Takas Edilen Ödemeler/Alınan Ödemeler Application: Nakit Yönetimi Source: Takas Edilen İşlemler Raporu (XML) - Desteklenmez: Gelecekte Kullanım İçin Ayrılmıştır Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG US CE Cleared Transactions Application: Cash Management Description: Transactions - Cleared Payment/Receipt Transactions Provides equivalent functionality to the following standard Oracle Forms/Reports - Cleared Transactions Report Applicable Templates: Pivot: Cleared Transactions Summary Pivot: Cleared Batches Summary Source: Cleared Transactions Report (CEXCLEAR) DB package: CE_CEXCLEAR_XMLP_PKG (required to initialize security) ZHS CE 已结事务处理报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 事务处理 - 已结付款/收款 Application: 现金管理系统 Source: 已结事务处理报表 (XML) - 不支持：已保留供将来使用 Short Name: CEXCLEAR_XML DB package: CE_CEXCLEAR_XMLP_PKG Enginatics R12 only 1=1 :c_amount_width :c_bank_account_name :c_bank_account_num :c_bank_branch_name :c_bank_currency_code :c_bank_name :c_batch_amount :c_batch_bank_account_amount :c_batch_cleared_amount :c_company_name_header :c_receipt_translation :c_the_end :c_transaction_type :p_bank_account :p_bank_branch :p_batch_or_trx :p_bg_org_id :p_business_group :p_conc_request_id :p_date_from :p_date_to :p_debug_mode :p_legal_entity :p_legal_entity_id :p_operating_unit :p_order_by :p_org_id :p_sql_trace :p_type 1 -100 :p_batch_or_trx LOV Oracle CE_BATCH_OR_TRX Y select lookup_code id, meaning value, null description from ce_lookups where lookup_type='BATCH_OR_TRX' order by value,description T Y AR حركة/مجموعة حركة/مجموعة D Transaktion/Stapel Transaktion/Stapel E Transacción/Lote Transacción/Lote F Mouvement/lot Mouvement/lot I Transazione/batch Transazione/batch JA 取引/バッチ 取引/バッチ KO 거래/배치 거래/배치 PTB Transação/Lote Transação/Lote RU Транзакция/пакет Транзакция/пакет S Transaktion/bunt Transaktion/bunt TR İşlem/Grup İşlem/İşlem Grubu US Transaction/Batch Transaction/Batch ZHS 事务处理/批 事务处理/批 2 10 1=1 q.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 Bank US Bank Name Bank 3 20 1=1 q.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 AR فرع البنك فرع البنك D Zweigstelle Zweigstelle E Sucursal Bancaria Sucursal Bancaria F Succursale bancaire Agence bancaire I Filiale banca Filiale banca JA 銀行支店 銀行支店 KO 은행 지점 은행 지점 PTB Agência Bancária Agência Bancária RU Филиал банка Филиал банка S Bankkontor Bankkontor TR Banka Şubesi Banka Şubesi US Bank Branch Bank Branch ZHS 分行 分行 4 30 1=1 q.bank_account_name = :p_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 Bank Account Name US Bank Account Name Bank Account Name 5 40 1=1 q.bank_account_num = :p_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 AR رقم حساب البنك رقم حساب البنك D Kontonummer Kontonummer E Número de Cuenta Bancaria Número de Cuenta Bancaria F Numéro de compte bancaire Numéro de compte bancaire I Numero conto bancario Numero conto bancario JA 銀行口座番号 銀行口座番号 KO 은행 계정 번호 은행 계좌 번호 PTB Número da Conta Bancária Número da Conta Bancária RU № банковского счета № банковского счета S Bankkontonummer Bankkontonummer TR Banka Hesap Numarası Banka Hesap Numarası US Bank Account Number Bank Account Num ZHS 银行帐号 银行帐号 6 50 :p_type LOV Oracle CE_TRAN_ORG_TYPE Y select lookup_code id, meaning value, description description from ce_lookups where lookup_type='TRAN_ORG_TYPE' order by value,description ALL Y AR نوع الحركة نوع الحركة D Transaktionsart Transaktionsart E Tipo de Transacción Tipo de Transacción F Type de transaction Type de mouvement I Tipo transazione Tipo di transazione JA 取引タイプ 取引タイプ KO 거래 유형 거래 유형 PTB Tipo de Transação Tipo de transação RU Тип транзакции Тип транзакции S Transaktionstyp Transaktionstyp TR İşlem Tipi İşlem tipi US Transaction Type Transaction type ZHS 事务处理类型 事务处理类型 7 60 :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) AR الكيان القانوني للخزانة 2 الكيان القانوني للخزانة D Treasury: Mandant 2 Treasury: Mandant E Entidad Legal de Tesorería 2 Entidad Legal de Tesorería F Trésorerie Entité légale Entité juridique Treasury I Persona giuridica Treasury 2 Persona giuridica Treasury JA 財務管理法的エンティティ 2 財務管理法的エンティティ KO Treasury 법인 2 Treasury 법인 PTB Pessoa Jurídica do Treasury 2 Pessoa Jurídica do Treasury RU Казначейство: юридическое лицо 2 Казначейство: юридическое лицо S Finansförvaltning: Juridisk enhet 2 Finansförvaltning: Juridisk enhet TR Hazine Yönetimi Tüzel Kişiliği 2 Hazine Yönetimi Tüzel Kişiliği US Treasury Legal Entity Treasury Legal Entity ZHS Oracle Treasury - 法人主体 2 Oracle Treasury - 法人主体 8 70 :p_business_group LOV CE Business Groups CA011D4BA5BE62B6E0530100007FF184 Y select clbovv.name value, null description from ce_le_bg_ou_vs_v clbovv where clbovv.organization_type='BUSINESS_GROUP' order by clbovv.name AR مجموعة أعمال كشف الرواتب مجموعة أعمال كشف الرواتب D Lohn und Gehalt: Unternehmensgruppe Lohn und Gehalt: Unternehmensgruppe E Grupo de Trabajo de Nóminas Grupo de Trabajo de Nóminas F Groupe d'affaires Paie Entité professionnelle Payroll I Business group cicli paghe Business group cicli paghe JA 給与ビジネス・グループ 給与ビジネス・グループ KO Payroll 업무 그룹 Payroll 업무 그룹 PTB Grupo Funcional da Folha de Pagamento Grupo Funcional da Folha de Pagamento RU ЗРП: бизнес-группа ЗРП: бизнес-группа S Verksamhetsgrupp för lönegrupp Verksamhetsgrupp för lönegrupp TR Bordro İş Grubu Bordro İş Grubu US Payroll Business Group Payroll Business Group ZHS Oracle Payroll - 业务组 Oracle Payroll - 业务组 9 80 :p_operating_unit LOV CE Operating Units CA012435B5946734E0530100007FFFA2 Y select clbovv.name value, null description from ce_le_bg_ou_vs_v clbovv where clbovv.organization_type='OPERATING_UNIT' order by clbovv.name AR وحدة تشغيل حساب المدفوعات/المقبوضات وحدة تشغيل حساب المدفوعات/المقبوضات D KR/DE Betriebseinheit KR/DE Betriebseinheit E Unidad Operativa de AP/AR Unidad Operativa de AP/AR F Unité opérationnelle AP/AR Unité opérationnelle AP/AR I Unità operativa AP/AR Unità operativa AP/AR JA AP/AR営業単位 AP/AR営業単位 KO AP/AR 운영 단위 AP/AR 운영 단위 PTB Unidade Operacional AP/AR Unidade Operacional AP/AR RU КР/ДБ: операционная единица КР/ДБ: операционная единица S Lev.resk./kundresk.: Operativ enhet Lev.resk./kundresk.: Operativ enhet TR AP/AR Faaliyet Birimi AP/AR Faaliyet Birimi US AP/AR Operating Unit AP/AR Operating Unit ZHS AP/AR 业务实体 AP/AR 业务实体 10 90 :p_date_from Date AR تاريخ المقاصة من تاريخ المقاصة من D Von Auszifferungsdatum Von Auszifferungsdatum E De Fecha de Conciliación De Fecha de Conciliación F Date d'effacement de Date d'apurement - Du I Data liquidazione - Da Data liquidazione - Da JA 決済日 自 決済日 自 KO 정산 일자: 부터 정산 일자: 부터 PTB Data da Compensação - De Data da Compensação - De RU Дата перерасчета с Дата перерасчета с S Från regleringsdatum Från regleringsdatum TR İlk Takas Tarihi İlk Takas Tarihi US Cleared Date From Cleared Date From ZHS 结清日期自 结清日期自 11 100 :p_date_to Date last_day(:$flex$.cleared_date_from) AR تاريخ المقاصة إلى تاريخ المقاصة إلى D Bis Auszifferungsdatum Bis Auszifferungsdatum E A Fecha de Conciliación A Fecha de Conciliación F Date d'apurement - Au Date d'apurement - Au I Data liquidazione - A Data liquidazione - A JA 決済日 至 決済日 至 KO 정산 일자: 까지 정산 일자: 까지 PTB Data da Compensação - Até Data da Compensação - Até RU Дата перерасчета по Дата перерасчета по S Till regleringsdatum Till regleringsdatum TR Son Takas Tarihi Son Takas Tarihi US Cleared Date To Cleared Date To ZHS 结清日期至 结清日期至 :$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$.cleared_date_from Cleared Date From Y Cleared Date To Pivot: Cleared Batches Summary Pivot: Cleared Batches Summary by Batched/Unbatched Transactions, Bank Account, Organization, Trx Type, Batch Currency with drilldown to Batch details SYSADMIN 16 ACCOUNT_AMOUNT SUM 17 ACCOUNT_CLEARED_AMOUNT SUM 15 AMOUNT SUM 5 BANK_ACCOUNT_CURRENCY 3 BANK_ACCOUNT_NAME 4 4 BANK_ACCOUNT_NUM 30 BANK_ACCOUNT_PIVOT_LABEL 6 BANK_NAME 3 1 BATCHED_UNBATCHED_FLAG 1 12 BATCH_BANK_ACCOUNT 13 BATCH_CURRENCY 11 BATCH_DATE 6 9 BATCH_ID 10 BATCH_NAME 7 32 BATCH_PIVOT_LABEL 7 BRANCH_NAME 8 CLEARED_TRANSACTION_TYPE 24 GL_ACCOUNT_CODE 25 GL_ACCOUNT_DESC 28 GL_CASH_ACCOUNT 29 GL_CASH_ACCOUNT_DESC 22 GL_COMPANY_CODE 23 GL_COMPANY_DESC 26 GL_COST_CENTER_CODE 27 GL_COST_CENTER_DESC 2 LEGAL_ENTITY 2 18 NET_ACCOUNT_CLEARED_AMOUNT SUM 19 OPERATING_UNIT 31 ORGANIZATION_PIVOT_LABEL 20 PAYROLL_BUSINESS_GROUP 14 TRANSACTION_CURRENCY 33 TRANSACTION_ORDER 5 21 TREASURY_LEGAL_ENTITY ACCOUNT_AMOUNT VALUE 2 SUM ACCOUNT_CLEARED_AMOUNT VALUE 3 SUM AMOUNT VALUE 1 SUM BANK_ACCOUNT_CURRENCY FILTER 7 BANK_ACCOUNT_NAME FILTER 6 BANK_ACCOUNT_NUM FILTER 5 BANK_ACCOUNT_PIVOT_LABEL ROW 2 BANK_NAME FILTER 3 BATCHED_UNBATCHED_FLAG ROW 1 BATCH_BANK_ACCOUNT FILTER 8 BATCH_CURRENCY ROW 5 BRANCH_NAME FILTER 4 CLEARED_TRANSACTION_TYPE ROW 4 GL_COMPANY_DESC FILTER 2 LEGAL_ENTITY FILTER 1 NET_ACCOUNT_CLEARED_AMOUNT VALUE 4 SUM ORGANIZATION_PIVOT_LABEL ROW 3 S Site Pivot: Cleared Transactions Summary Pivot: Cleared Transactions by Bank Account, Organization, Trx Type and Trx Currency with drill down to transactions SYSADMIN 18 ACCOUNT_AMOUNT 20 ACCOUNT_CLEARED_AMOUNT 8 AGENT 17 AMOUNT 4 BANK_ACCOUNT_CURRENCY 2 BANK_ACCOUNT_NAME 3 3 BANK_ACCOUNT_NUM 33 BANK_ACCOUNT_PIVOT_LABEL 5 BANK_NAME 2 15 BATCH_DATE 13 BATCH_ID 14 BATCH_NAME 6 BRANCH_NAME 19 CLEARED_DATE 7 CLEARED_TRANSACTION_TYPE 27 GL_ACCOUNT_CODE 28 GL_ACCOUNT_DESC 31 GL_CASH_ACCOUNT 32 GL_CASH_ACCOUNT_DESC 25 GL_COMPANY_CODE 26 GL_COMPANY_DESC 29 GL_COST_CENTER_CODE 30 GL_COST_CENTER_DESC 1 LEGAL_ENTITY 1 10 MATURITY_DATE 21 NET_ACCOUNT_CLEARED_AMOUNT 22 OPERATING_UNIT 34 ORGANIZATION_PIVOT_LABEL 11 PAYMENT_METHOD 23 PAYROLL_BUSINESS_GROUP 12 Receipt/Payment Number 9 Remit/Payment Date 5 16 TRANSACTION_CURRENCY 35 TRANSACTION_ORDER 4 24 TREASURY_LEGAL_ENTITY ACCOUNT_AMOUNT VALUE 2 SUM ACCOUNT_CLEARED_AMOUNT VALUE 3 SUM AMOUNT VALUE 1 SUM BANK_ACCOUNT_CURRENCY FILTER 7 BANK_ACCOUNT_NAME FILTER 6 BANK_ACCOUNT_NUM FILTER 5 BANK_ACCOUNT_PIVOT_LABEL ROW 1 BANK_NAME FILTER 3 BRANCH_NAME FILTER 4 CLEARED_TRANSACTION_TYPE ROW 3 GL_COMPANY_DESC FILTER 2 LEGAL_ENTITY FILTER 1 NET_ACCOUNT_CLEARED_AMOUNT VALUE 4 SUM ORGANIZATION_PIVOT_LABEL ROW 2 TRANSACTION_CURRENCY ROW 4 S Site SYSADMIN Pivot: Cleared Batches Summary DEVELOPER Pivot: Cleared Batches Summary Pivot: Cleared Transactions Summary