All AP Tables in Oracle Apps .ap base tables in oracle apps r12

All AP Tables in Oracle Apps .Detail description of Payables Tables in Oracle apps

 

ap base tables in oracle apps r12

AP_INVOICES_ALL

 

THIS TABLE STORE ALL INFORMATION BETWEEN Invoice Headers Workbench information

 

AP_INVOICE_LINES_ALL

 

THIS TABLE STORE ALL INVOICE LINES INFORMATION  SAME LIKE INVOICE WORKBENCH

 

AP_INVOICE_DISTRIBUTIONS_ALL

 

THIS TABLE STORE ALL INVOICE DISTRIBUTIONS INFORMATION (ALL GL ACCOUNT INFORMATION )

 

AP_SUPPLIERS

 

 

TO GET ALL THE SUPPLIER INFORMATION FOR THE INVOICE WE NEED TO GO AP_SUPPLIERS . This is supplier master table

 

AP_SUPPLIER_SITES_ALL

 

TO GET ALL THE SUPPLIER SITE INFORMATION FOR THE INVOICE WE NEED TO GO AP_SUPPLIER_SITES_ALL. In this table we will get suppllier sites and thier addresses.

 

AP_PAYMENT_SCHEDULES_ALL

 

THIS TABLE STORE INFORMATION OF THE INVOICE PAYMENT SCHEDULE TAB SAME LIKE INVOICE WORKBENCH. This table store all information about due dates of the payments

like on which dates we need to make the payments . This table also store information about discounts also.

 

AP_PAYMENT_HISTORY_ALL

 

It also stores the maturity history for future dated payments.

The table contains a row for each future dated payment, once the future dated payment matures, i.e. becomes negotiable.

Any time a payment is cleared or uncleared, a row is inserted into this table for the payment.

 

AP_BATCHES_ALL

 

if you are entering the payables invoices in batches , then in this table you will get information about this batch details.

 

 

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 ABPUT INVOICES HOLDS.

 

ce_bank_accounts 

 

This table store internal bank accounts information

 

ce_banks_v

 

This table store only bank and branch informations

 

select * from apps.ce_bank_acct_uses_all

 

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

 

Sql Query of Payables Tables in Oracle apps

 

SELECT A1.INVOICE_NUM,A1.INVOICE_CURRENCY_CODE,A1.PAYMENT_CURRENCY_CODE,A1.INVOICE_AMOUNT,

A2.LINE_NUMBER,A3.DISTRIBUTION_LINE_NUMBER,

A1.AMOUNT_PAID,CHECK_NUMBER,

ACA.AMOUNT CHECK_AMOUNT,

A4.AMOUNT AMOUNT_PAID,

PV.VENDOR_NAME,

ASS.VENDOR_SITE_CODE,

CE.BANK_ACCOUNT_NAME,

ACA.BANK_ACCOUNT_NAME

 FROM APPS.AP_INVOICES_ALL A1 ,

  APPS.AP_INVOICE_LINES_ALL A2 ,

  APPS.AP_INVOICE_DISTRIBUTIONS_ALL A3,

   APPS.AP_INVOICE_PAYMENTS_ALL A4,

   APPS.AP_CHECKS_ALL ACA,

   APPS.AP_SUPPLIERS PV,

   APPS.AP_SUPPLIER_SITES_ALL ASS

  -- APPS.CE_BANK_ACCOUNTS C

 WHERE A1.INVOICE_ID=A2.INVOICE_ID

AND  A2.INVOICE_ID=A3.INVOICE_ID

 AND A3.INVOICE_ID=A4.INVOICE_ID

 AND A4.CHECK_ID=ACA.CHECK_ID

 AND A1.VENDOR_ID=PV.VENDOR_ID

 AND PV.VENDOR_ID=ASS.VENDOR_ID

 AND A1.VENDOR_SITE_ID=ASS.VENDOR_SITE_ID

 AND ACA.BANK_ACCOUNT_ID=CE.BANK_ACCOUNT_ID