SELECT
hou.name operating_unit,
xep.name legal_entity,
cebb.bank_name,
cebb.bank_number,
cebb.bank_branch_name,
cebb.bank_branch_number,
cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, OTHER.
cbv.address_line1, — Branch details – Branch Address details below
length(cbv.address_line1) address_line1_length,
cbv.address_line2,
cbv.address_line3,
cbv.address_line4,
cbv.city, — Branch City
cbv.state, — Branch State
cbv.zip,
cbv.country,
ceba.bank_account_name,
ceba.bank_account_num,
cebb.eft_swift_code,
ceba.iban_number,
ceba.currency_code,
ceba.check_digits,
glcc1.concatenated_segments asset_code_combination,
glcc2.concatenated_segments cash_clearing_code_combination,
glcc3.concatenated_segments bank_charges_code_combination,
cebau.ap_use_enable_flag ap_use_flag,
cebau.ar_use_enable_flag ar_use_flag,
cebau.xtr_use_enable_flag treasury_use_flag,
cebau.pay_use_enable_flag payroll_use_flag,
ceba.zero_amount_allowed,
ceba.multi_currency_allowed_flag,
ac.doc_category_code
FROM
apps.cefv_bank_branches cebb,
apps.ce_bank_accounts ceba,
apps.ce_bank_acct_uses_all cebau,
apps.ce_banks_v cbv,
apps.hr_operating_units hou,
apps.xle_entity_profiles xep,
apps.gl_code_combinations_kfv glcc1,
apps.gl_code_combinations_kfv glcc2,
apps.gl_code_combinations_kfv glcc3,
apps.ap_checks_all ac
WHERE
1 = 1
AND cebb.bank_branch_id = ceba.bank_branch_id
AND ceba.bank_account_id = cebau.bank_account_id
AND ceba.bank_id = cbv.bank_party_id
AND cebau.org_id = hou.organization_id
AND ceba.account_owner_org_id = xep.legal_entity_id
AND ceba.asset_code_combination_id = glcc1.code_combination_id(+)
AND ceba.cash_clearing_ccid = glcc2.code_combination_id(+)
AND ceba.bank_charges_ccid = glcc3.code_combination_id(+)
AND ac.ce_bank_acct_use_id(+) = cebau.bank_acct_use_id
ORDER BY
1
Recommended Posts
