ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 1EADD355513F41BDE0636AFB09059B36 select cbb.bank_name, cbb.bank_number, cbb.bank_name_alt, cbb.short_bank_name, cbb.bank_start_date, cbb.bank_end_date, cbb.bank_institution_type, cbb.bank_country, cbb.bank_branch_name, cbb.branch_number, cbb.bank_branch_name_alt, cbb.bank_branch_type, -- Branch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, OTHER. cbb.start_date bank_branch_start_date, cbb.end_date bank_branch_end_date, cbb.eft_swift_code, xxen_util.meaning(cbb.internal_use,'YES_NO',0) branch_internal_use, xxen_util.meaning(cbb.supplier_use,'YES_NO',0) branch_supplier_use, xxen_util.meaning(customer_use,'YES_NO',0) branch_customer_use, cbb.bank_party_id, cbb.branch_party_id, --Branch Address details below cbb.address_line1, cbb.address_line2, cbb.address_line3, cbb.address_line4, cbb.city, cbb.state, cbb.zip, cbb.country, cbb.description, cbb.eft_user_number, cbb.edi_id_number from (select (select 'Y' from ce_bank_accounts cba where cbbv.branch_party_id = cba.bank_branch_id and rownum <= 1 ) internal_use, (select 'Y' from iby_ext_bank_accounts ieba, iby_pmt_instr_uses_all ipiua, iby_external_payees_all iepa, ap_suppliers asu where cbbv.branch_party_id = ieba.branch_id and ieba.ext_bank_account_id = ipiua.instrument_id and ipiua.ext_pmt_party_id = iepa.ext_payee_id and iepa.payee_party_id = asu.party_id and ipiua.payment_function = 'PAYABLES_DISB' and ipiua.instrument_type = 'BANKACCOUNT' and sysdate between ipiua.start_date and nvl(ipiua.end_date,sysdate) and iepa.payment_function = 'PAYABLES_DISB' and rownum <= 1 ) supplier_use, (select 'Y' from iby_ext_bank_accounts ieba, iby_pmt_instr_uses_all ipiua, iby_external_payers_all iepa where cbbv.branch_party_id = ieba.branch_id and ieba.ext_bank_account_id = ipiua.instrument_id and ipiua.ext_pmt_party_id = iepa.ext_payer_id and ipiua.payment_function = 'CUSTOMER_PAYMENT' and ipiua.instrument_type = 'BANKACCOUNT' and sysdate between ipiua.start_date and nvl(ipiua.end_date,sysdate) and iepa.payment_function = 'CUSTOMER_PAYMENT' and (iepa.cust_account_id is not null or iepa.acct_site_use_id is not null ) and rownum <= 1 ) customer_use, cbbv.*, cbv.start_date bank_start_date, cbv.end_date bank_end_date, ftv.territory_short_name bank_country from ce_bank_branches_v cbbv, ce_banks_v cbv, fnd_territories_vl ftv where cbbv.bank_party_id=cbv.bank_party_id and ftv.territory_code=cbbv.bank_home_country ) cbb where 1=1 Y US CE Bank Branches This Report is the repository of all bank branches covering both internal and external bank accounts and will list the bank branches along with an indication of usage: -Internal -Supplier -Customer Enginatics 1=1 1 10 1=1 cbb.bank_name=:p_bank_name LOV custom Y select distinct cbbv.bank_name value, null description from ce_bank_branches_v cbbv order by cbbv.bank_name US Bank Name 2 20 1=1 cbb.bank_branch_name=:p_bank_branch_name LOV custom Y select cbbv.bank_branch_name value, cbbv.bank_name description from ce_bank_branches_v cbbv where :$flex$.Bank_name is null or xxen_util.contains(:$flex$.Bank_name,cbbv.bank_name)='Y' order by cbbv.bank_branch_name, cbbv.bank_name US Bank Branch Name 3 30 1=1 cbb.internal_use is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Internal Usage 4 40 1=1 cbb.supplier_use is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Supplier Usage 5 50 1=1 cbb.customer_use is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show Customer Usage :$flex$.Bank_name Bank Name Bank Branch Name