Query to list Bank, Bank Branch, Bank Account information Operating Unit wise

Shailender Thallam
9 years ago
/**********************************************************************
 *PURPOSE: Query to list all Bank, Bank Branch, Bank Account information
 *         Operating Unit wise
 *AUTHOR: Shailender Thallam 
 ***********************************************************************/
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 ,
  bb.bank_name ,
  cba.bank_id,
  bb.bank_number,
  bb.bank_branch_type ,
  bb.bank_branch_name ,
  cba.bank_branch_id ,
  bb.bank_branch_number ,
  bb.eft_swift_code ,
  bb.description BANK_DESCRIPTION,
  cba.currency_code ,
  bb.address_line1,
  bb.city,
  bb.county,
  bb.state,
  bb.zip_code,
  bb.country,
  ou.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 apps.ce_bank_accounts cba,
  apps.ce_bank_acct_uses_all bau,
  apps.cefv_bank_branches bb,
  apps.hr_operating_units ou,
  apps.gl_code_combinations_kfv gcf
WHERE cba.bank_account_id         = bau.bank_account_id
AND cba.bank_branch_id            = bb.bank_branch_id
AND ou.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))
ORDER BY TO_NUMBER(cba.bank_account_num);
For Further Reading
