Bank Tables in Oracle apps r12

Bank Tables in Oracle apps r12 

 

Internal Banks and External Banks.

Internal banks are those banks, Which we create 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.

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 use to Pay Customer Invoice's and to do the receiving of the Customer Payments.

 

Important Tables of Internal Banks

 

select * from CE_BANK_ACCOUNTS 

select * from CE_BANK_ACCT_USES_ALL

select * from CE_BANKS_V

select * from CE_BANK_ACCT_USES_ALL;

select * from CE_BANK_BRANCHES_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 in different tables as compared to the Internal Banks.

 

Important External Bank Tables

1 Select * from iby_external_payers_all

2 Select * from iby_pmt_instr_uses_all

3 Select * from iby_ext_bank_accounts