Oracle Apps Base Tables and Interface Tables

Oracle Apps Base Tables and Interface Tables

INVENTORY BASE TABLES           INVENTORY INTERFACE TABLES
================================================================== 
MTL_SYSTEM_ITEMS_B                MTL_SYSTEM_ITEMS_INTERFACE        
MTL_ITEM_CATEGORIES              MTL_ITEM_CATEGORIES_INTERFACE
MTL_ITEM_LOCATIONS                MTL_ITEM_REVISION_INTERFACE            
MTL_ITEM_REVISIONS_B             MTL_INTERFACE_ERRORS
MTL_PARAMETERS
MTL_ITEM_SUB_INVENTORIES
MTL_ONHAND_QUANTITIES
MTL_CATEGORY_SETS_B
CST_ITEM_COSTS
CST_COST_TYPES
MTL_MATERIAL_TRANSACTIONS
MTL_TRANSACTION_TYPES
MTL_SECONDARY_INVENTORIES
MTL_SERIAL_NUMBERS
MTL_LOT_NUMBERS
MTL_TRANSACTION_ACCOUNTS




PO REQ BASE TABLES                             PO REQ INTERFACE TABLES
==================================================================
PO_REQUISITION_HEADERS_ALL       PO_REQUISITIONS_INTERFACE_ALL
PO_REQUISITION_LINES_ALL              PO_REQ_DIST_INTERFACE_ALL
PO_REQ_DISTRIBUTIONS_ALL



PO BASE TABLES                                   PO INTERFACE TABLES
==================================================================
PO_HEADERS_ALL                                 PO_HEADERS_INTERFACE
PO_LINES_ALL                                        PO_LINES_INTERFACE
PO_LINE_LOCATIONS_ALL                  PO_DISTRIBUTIONS_INTERFACE
PO_DISTRIBUTIONS_ALL                     PO_INTERFACE_ERRORS           
PO_RELEASES_ALL
PO_AGENTS
PO_ACTION_HISTORY

PO_VENDORS
PO_VENDOR_SITES_ALL
PO_VENDOR_CONTACTS





RCV_SHIPMENT_HEADERS                RCV_HEADERS_INTERFACE
RCV_SHIPMENT_LINES                       RCV_TRANSACTIONS_INTERFACE
RCV_TRANSACTIONS


PAYBLES BASE TABLES                        PAYBLES INTERFACE TABLES                         
=======================================================
AP_INVOICES_ALL                                 AP_INVOICES_INTERFACE                
AP_INVOICE_LINES_ALL                      AP_INVOICE_LINES_INTERFACE
AP_INVOICE_DISTRIBUTIONS_ALL
AP_INVOICE_PAYMENTS_ALL            AP_INTERFECE_REJECTIONS

AP_PAYMENT_DISTRIBUTIONS_ALL     AP_SUPPLIERS_INT
AP_PAYMENT_HISTORY_ALL                  AP_SUPPLIER_SITES_INT
AP_PAYMENT_SCHEDULES_ALL            AP_SUP_SITE_CONTACT_INT

AP_AE_HEADERS_ALL
AP_AE_LINES_ALL
AP_BATCHES_ALL
AP_TERMS
AP_LOOKUP_CODES
AP_ACCOUNTING_EVENTS_ALL
AP_BANK_ACCOUNTS_ALL
AP_BANK_BRANCHES
AP_CHECKS_ALL
AP_HOLDS_AL
AP_CARD_CODES
AP_EXPENSE_REPORTS_ALL
AP_EXPENSE_REPORT_HEADERS_ALL
AP_EXPENSE_REPORT_LINES_ALL







OM BASE TABLES                                    OM INTERFACE TABLES
=======================================================

OE_ORDER_HEADERS_ALL                  OE_HEADERS_IFACE_ALL
OE_ORDER_LINES_ALL                         OE_LINES_IFACE_ALL
OE_ORDER_HOLDS_ALL                       OE_ACTIONS_IFACE_ALL
OE_ORDER_SOURCES
OE_TRANSACTION_TYPES_TL/ALL
OE_PAYMENT_TYPES_TL


WSH_DELIVERY_DETAILS
WSH_NEW_DELIVERIES
WSH_DELIVERY_ASSIGNMENTS

OE_ORDER_HOLDS

RA_SALESREPS
OE_TRANSACTION_TYPES_TL
AR_CUSTOMERS
RA_TERMS

QP_LIST_HEADERS
QP_LIST_LINES
QP_PRICING_ATTRIBUTES

OE_ORDER_HEADERS_ALL oe_order_pub.process_order
OE_ORDER_LINES_ALL
OE_SALES_CREDITS




GL BASE TABLES                              GL INTERFACE TABLES
=======================================================                          
GL_JE_HEADERS                               GL_INTERFACE
GL_JE_LINES                                      GL_INTERFACE_HISTORY
GL_JE_CATEGORIES                         GL_DAILY_RATES_INTERFACE 
GL_JE_SOURCES                                GL_BUDGET_INTERFACE
GL_SETS_OF_BOOKS                         GL_IEA_INTERFACE
GL_DAILY_RATES
GL_CODE_COMBINATIONS
GL_BALANCES
GL_PERIODS
GL_PERIOD_SETS
GL_CURRENCIES
GL_HISTORICAL_RATES
GL_LOOKUPS  

Oracle Apps  :  Link between GL to Subledger Account
=======================================================                        
GL_JE_BATCHES (je_batch_id)                        => GL_JE_HEADERS (je_batch_id)

GL_JE_HEADERS (je_header_id)                      => GL_JE_LINES (je_header_id)

GL_JE_LINES (je_header_id,  je_line_num)       => GL_IMPORT_REFERENCES (je_header_id, je_line_num)

GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id)        => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id)

XLA_AE_LINES (application_id, ae_header_id)                   => XLA_AE_HEADERS (application_id, ae_header_id)

XLA_AE_HEADERS (application_id, event_id)                     => XLA_EVENTS (application_id, event_id) 

XLA_EVENTS (application_id, entity_id)                        => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id)
 


HZ_PARTIES                                      HZ_PARTY_INERFACE     
HZ_CUST_ACCOUNTS                    HZ_PARTY_INTERFACE_ERRORS
HZ_CUST_ACCT_SITES_ALL         RA_CONTACT_PHONES_INT_ALL
HZ_CUST_SITE_USES_ALL            RA_CUSTOMER_PROFILES_INT_ALL       
HZ_PARTY_SITES                             RA_INTERFACE_DISTRIBUTIONS_ALL
HZ_LOCATIONS                                RA_INTERFACE_ERRORS_ALL
HZ_PARTY_SITE_USES                    RA_INTERFACE_LINES_ALL
HZ_CUSTOMER_PROFILES            RA_INTERFACE_SALESCREDITS_ALL
HZ_ORGANIZATION_PROFILES    AR_PAYMENTS_INTERFACE_ALL
HZ_PERSON_PROFILES                  AR_TAX_INTERFACE 
RA_CUSTOMER_TRX                              RCV_HEADERS_INTERFACE
RA_CUSTOMER_TRX_PARTIAL_V       RCV_TRANSACTIONS_INTERFACE
RA_CUSTOMER_TRX_LINES_ALL
RA_CUSTOMERS
AR_PAYMENT_SCHEDULES_ALL
RA_CUST_TRX_LINE_GL_DIST_ALL
RA_CUST_TRX_TYPES_ALL
RA_BATCH_SOURCES_ALL
AR_VAT_TAX_ALL
RA_TERMS
AR_PERIODS
AR_PERIOD_TYPES