Friday, May 8, 2020

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

No comments:

Post a Comment

Types of animations

Animation is a diverse and creative field with a variety of styles that artists and filmmakers use to bring their visions to life. Here are ...