Fusion Internal Bank Account Query (ce_bank_accounts)

SELECT

    hou.name                "OPERATING UNIT",

    cbbv.bank_name,

    cbbv.bank_branch_name,

    cba.bank_account_name,

    hp.party_name           "LEGAL ENTITY",

    cbau.ar_use_enable_flag "RECEIVABLES_ACCOUNT_USE",

    cbau.ap_use_enable_flag "PAYABLES_ACCOUNT_USE",

    cba.bank_account_num    "ACCOUNT_NUMBER",

    cba.bank_account_type   "ACCOUNT TYPE",

    cba.iban_number,

    cba.currency_code,

    cba.multi_currency_allowed_flag,

    cba.description

FROM

    ce_bank_accounts      cba,

    ce_bank_acct_uses_all cbau,

    ce_gl_accounts_ccid   cgac,

    ce_bank_branches_v    cbbv,

    hr_operating_units    hou,

    hz_parties            hp

WHERE

        cbbv.bank_party_id = cba.bank_id

    AND cbbv.branch_party_id = cba.bank_branch_id

    AND cba.bank_account_id = cbau.bank_account_id

    AND cgac.bank_acct_use_id = cbau.bank_acct_use_id

    AND cbau.org_id = hou.organization_id

    AND hp.party_id = cba.account_owner_party_id

    AND cba.bank_account_num IN ( :p_bank_account_num )   ----Parameters

https://docs.oracle.com/en/cloud/saas/financials/24b/oedmf/cebankaccounts-4387.html