BASE TABLES IN ORACLE APPS

BASE TABLES IN ORACLE APPS

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   

  


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