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