R12 SQL Bank Accounts Key Setup and Usage

 SELECT
 bb.bank_name                     "Bank Name",
 bb.bank_branch_type              "Bank Branch Type",
 bb.bank_branch_name              "Bank Branch Name",
 bb.bank_branch_number            "Bank Branch Number",
 cba.bank_account_name            "Bank Account Name",
 cba.bank_account_num             "Bank Account Number",
 cba.multi_currency_allowed_flag  "Multi Currency Flag",
 cba.zero_amount_allowed          "Zero Amount Flag",
 cba.account_classification       "Account Classification",
 bb.bank_name                     "Bank Name",
 bb.bank_branch_type              "Bank Branch Type",
 bb.bank_branch_name              "Bank Branch Name",
 bb.bank_branch_number            "Bank Branch Number",
 bb.eft_swift_code                "Swift Code",
 -- bb.description                   "Description",
 ou.name                          "Operating Unit",
 gcf.concatenated_segments        "GL Code Combination",
 bau.ar_use_enable_flag           "Enabled for AR",
 bau.ap_use_enable_flag           "Enabled for AP"
 FROM ce_bank_accounts          cba,
 ce_bank_acct_uses_all     bau,
 cefv_bank_branches        bb,
 HR_ALL_ORGANIZATION_UNITS ou,
 gl_code_combinations_kfv  gcf
 WHERE 1=1
 AND 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 sysdate between nvl(cba.start_date,sysdate-1) and nvl(cba.end_date,sysdate+1)
 ORDER BY BANK_NAME, BANK_BRANCH_NAME,cba.bank_account_num;

Leave a Reply