Banking details R12

 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 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 & 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