11i vs R12 Tables in Oracle Apps

Suppliers:

1.      AP_SUPPLIERS                                  - replaces PO_VENDORS

2.      AP_SUPPLIER_SITES_ALL            - replaces PO_VENDOR_SITES_ALL

Additional supplier related tables in IBY (Payments) and HZ (TCA):

1.      IBY_EXTERNAL_PAYEES_ALL                    - stores Payee(supplier) information.

2.      HZ_PARTIES                                                      - Party data for the suppliers.

3.      HZ_PARTY_SITES                                            - Party site data for the supplier sites.

Invoices:

1.      Additional table in R12:     AP_INVOICE_LINES_ALL

2.      Allocations -                         AP_CHRG_ALLOCATIONS_ALL is obsolete in R12

Taxes:

Functionality provided by E-Business Tax

1.      ZX_LINES                                            - Detailed Tax lines for the invoice (trx_id = invoice_id)

2.      ZX_LINES_SUMMARY                   - Summary tax lines for the invoice (trx_id = invoice_id)

3.      ZX_REC_NREC_DIST                      - Tax distributions for the invoice (trx_id = invoice_id)

4.      ZX_LINES_DET_FACTORS           - Tax determination factors for the invoice (trx_id = invoice_id)

Payments:

Functionality moved to central Payments (IBY)

1.      IBY_PAY_SERVICE_REQUESTS  - Payment Process Request information

Accounting:

Functionality moved to SubLedger Accounting (SLA)

2.      XLA_EVENTS                                     à replaces AP_ACOCUNTING_EVENTS_ALL 

3.      XLA_AE_HEADERS                         à replaces AP_AE_HEADERS_ALL

4.      XLA_AE_LINES                                 à replaces AP_AE_LINES_ALL

5.      XLA_DISTRIBUTION_LINKS

Bank Accounts:

Functionality moved to Cash Management.

1.      CE_BANK_ACCOUNTS                                  à replaces AP_BANK_ACCOUNTS_ALL

2.      CE_BANK_ACCT_USES_ALL                       à replaces AP_BANK_ACCOUNT_USES_ALL

3.      CE_PAYMENT_DOCUMENTS                      à AP_CHECK_STOCKS_ALL