Internal bank account query in r12

Internal bank account query in r12

In this post , We will discuss about Internal bank account query in r12 . In Oracle apps , we stores two types of Banks . Internal Banks and External Banks. Internal banks are those banks , Which we creates in the Oracle applications to do the payments for suppliers and receive the payment from the customers.  Internal bank account query in r12 stores all about Bank , Branch information's as well as Bank Accounts too. Here below is the complete sql query of Internal bank account query in r12.

Bank tables in oracle apps r12

CE_BANK_ACCOUNTS

CE_BANK_ACCT_USES_ALL

CE_BANKS_V

Internal bank account query in r12

select b.BANK_NAME
from CE_BANK_ACCOUNTS A ,CE_BANKS_V B
WHERE a.bank_account_id IN (SELECT b.bank_account_id
                             FROM CE_BANK_ACCT_USES_ALL b
                             WHERE 1=1
                            --and b.org_id = mo_global.GET_CURRENT_ORG_ID
                             AND (NVL(AP_USE_ENABLE_FLAG,'N' ) = 'Y' OR NVL(AR_USE_ENABLE_FLAG,'N' ) = 'Y' ))
                             and B.BANK_PARTY_ID =A.BANK_ID
 ORDER BY a.bank_account_name;