PAYMENT TABLES IN ORACLE APPS R12

 9 Important Payment Tables in Oracle apps r12

 1. AP_CHECKS_ALL
 2.AP_INVOICE_PAYMENTS_ALL
 3.AP_HOLDS_ALL
 4.ce_bank_accounts
 5.ce_banks_v
 6.IBY_PAYMENTS_ALL
 7. IBY_DOCS_PAYABLE_ALL
 8.CE_PAYMENT_DOCUMENTS
 9.IBY_TRXN_DOCUMENTS

AP_CHECKS_ALL

 

THIS TABLE STORE ALL THE INFORMATION ABOUT PAYMENTS, Here you will get all the payment information ,Check Number , Banks Detail Vendor etc.

 

AP_INVOICE_PAYMENTS_ALL

 

 IF YOU WANT TO SEE ONE CHECK IS DONE AGAINST WHICH PAYABLES INVOICES THEN YOU CAN CHECK FROM THIS TABLE. Here you can see invoices paid against check.

 

AP_HOLDS_ALL

THIS TABLE STORE INFORMATION ABOUT INVOICES HOLDS.

 ce_bank_accounts 

 This table store internal bank accounts information

ce_banks_v

 This table store only bank and branch information's

 

select * from apps.ce_bank_acct_uses_all

This table store information's about bank account and operating units. It Means this bank accounts is using with which operating units and for which modules like (AP & AR)