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;

Bank tables in oracle apps r12

Bank tables in oracle apps r12

Here we are going to discuss about Oracle Banks tables. 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.  Bank tables in oracle apps r12 stores all about Bank , Branch information's as well as Bank Accounts too. Here below is the complete list of the Bank tables in oracle apps r12.

2 Types of Banks in Oracle apps

1. Internal Bank

2.External Bank

 

Internal Bank:-

 

Internal Bank are the Oracle our Internal Banks or Business Unit /Organization Internals Banks which they uses to Pay Customer Invoice's and to do the receiving of the Customer Payments.

 

3 Important Tables of Internal Banks

 

1.CE_BANK_ACCOUNTS

2.CE_BANK_ACCT_USES_ALL

3.CE_BANKS_V

 

External Banks :-

 

External Banks are those Banks , Which is related to Our or Organization/ Business unit Customers and Suppliers. Both Customer and Suppliers are external Entities so Oracle has stored these Banking Information's in different tables as compared to the Internal Banks.

 

3 Important External Bank Tables

`1.iby_external_payers_all
 2.iby_pmt_instr_uses_all
 3. iby_ext_bank_accounts

Few Important SQL Query for Banks in oracle apps

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;