SELECT cba.bank_account_name
,cba.bank_account_id
,cba.bank_account_name_alt
,cba.bank_account_num
,cba.multi_currency_allowed_flag
,cba.zero_amount_allowed
,cba.account_classification
,cbb.bank_name
,cba.bank_id
,cbb.bank_number
,cbb.bank_branch_type
,cbb.bank_branch_name
,cba.bank_branch_id
,cbb.bank_branch_number
,cbb.eft_swift_code
,cbb.description bank_description
,cba.currency_code
,cbb.address_line1
,cbb.address_line2
,cbb.city
,cbb.county
,cbb.state
,cbb.zip_code
,cbb.country
,hou.name
,gcf.concatenated_segments
,cba.ap_use_allowed_flag
,cba.ar_use_allowed_flag
,cba.xtr_use_allowed_flag
,cba.pay_use_allowed_flag
FROM ce_bank_accounts cba
,ce_bank_acct_uses_all bau
,cefv_bank_branches cbb
,hr_operating_units hou
,gl_code_combinations_kfv gcf
WHERE cba.bank_account_id = bau.bank_account_id
AND cba.bank_branch_id = cbb.bank_branch_id
AND hou.organization_id = bau.org_id
AND cba.asset_code_combination_id = gcf.code_combination_id
AND (
cba.end_date IS NULL OR cba.end_date > TRUNC(SYSDATE)
)
AND hou.name = 'XX Operating Unit'
ORDER BY cba.bank_account_num
