APPS BASE TABLES AND INTERFACE TABLES

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'AP_E%ALL' AND OWNER='AP'

PAYABLES INTERFACE TABLES
==========================
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
AP_SUPPLIERS_INT
AP_SUPPLIER_SITES_INT
AP_SUP_SITE_CONTACT_INT


PAYABLES BASE TABLES
======================
AP_INVOICES_ALL
AP_INVOICE_LINES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
AP_INVOICE_PAYMENTS_ALL
AP_PAYMENT_SCHEDULES_ALL
AP_PAYMENT_HISTORY_ALL
AP_PAYMENT_DISTRIBUTIONS_ALL
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_ACCOUNT_USES_ALL
AP_CHECKS_ALL
AP_HOLDS_ALL
AP_CARD_CODES
AP_CARDS_ALL
AP_CARD_CODES_ALL
AP_CARD_CODE_SETS_ALL
AP_EXPENSE_REPORTS_ALL
AP_EXPENSE_REPORT_HEADERS_ALL
AP_EXPENSE_REPORT_LINES_ALL
AP_EXP_REPORT_DISTS_ALL

====================================================================================

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'PO_%E_ALL' AND OWNER='PO'



PO INTERFACE TABLES
====================

PO_HEADERS_INTERFACE
PO_LINES_INTERFACE
PO_LINE_LOCATIONS_INTERFACE
PO_DISTRIBUTIONS_INTERFACE

PO REQ INTERFACE TABLES
=======================

PO_REQUISITIONS_INTERFACE_ALL
PO_REQ_DIST_INTERFACE_ALL

PO BASE TABLES
=================

PO_HEADERS_ALL 
PO_LINES_ALL 
PO_LINE_LOCATIONS_ALL 
PO_DISTRIBUTIONS_ALL 
PO_RELEASES_ALL
PO_AGENTS
PO_ACTION_HISTORY

AP_SUPPLIERS
AP_SUPPLIER_SITES_ALL
AP_SUPPLIER_CONTACTS

PO REQ BASE TABLES
=======================
PO_REQUISITION_HEADERS_ALL 
PO_REQUISITION_LINES_ALL 
PO_REQ_DISTRIBUTIONS_ALL 

RECEIPTS BASE TABLES
====================

RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES
RCV_TRANSACTIONS


=======================================================================================


SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'FND_A%L' --AND OWNER='ONT'


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

OE_HEADERS_IFACE_ALL
OE_LINES_IFACE_ALL
OE_ACTIONS_IFACE_ALL


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

OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OE_ORDER_HOLDS_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 
QP_LIST_HEADERS 
RA_SALESREPS 
OE_TRANSACTION_TYPES_TL 
AR_CUSTOMERS 
RA_TERMS 




====================================================================================


SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'FND_PRO%S' AND OWNER='APPS'

OTHER BASE TABLES
===================

FND_USER
FND_APPLICATION_VL
FND_RESPONSIBILITY_VL
FND_CONCURRENT_PROGRAMS
FND_EXECUTABLES
FND_CONCURRENT_PROCESSES
FND_CONCURRENT_REQUESTS
FND_DATA_GROUPS
FND_SEGMENT_ATTRIBUTE_TYPES
FND_SEGMENT_ATTRIBUTE_VALUES
FND_TABLES
FND_TABLESPACES
FND_FORM
FND_PROFILE_OPTIONS
FND_PROFILE_OPTION_VALUES
FND_PRODUCT_INSTALLATIONS
FND_PRODUCT_GROUPS
FND_PRODUCT_DEPENDENCIES
ORG_ORGANIZATION_DEFINITIONS
PER_ALL_PEOPLE_F(ENAME)
HR_LOCATIONS(BILL_TO,SHIP_TO)

============================================


SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'AR_P%L' AND OWNER='AR'


TCA(TRADING COMMUNITY ARCHITECTURE TABLES)
============================================


HZ_PARTIES 
HZ_PARTY_SITES 
HZ_CUST_ACCOUNTS
HZ_CUST_ACCT_SITES_ALL 
HZ_CUST_SITE_USES_ALL 
HZ_CUSTOMER_PROFILES
HZ_PARTY_RELATIONSHIPS 
HZ_CUST_PROFILE_CLASSES
HZ_LOCATIONS 
RA_TERMS 
RA_CUSTOMER_TRX_ALL 
RA_CUSTOMER_TRX_LINES_ALL 
RA_CUST_TRX_LINE_GL_DIST_ALL 
RA_CUST_TRX_TYPES_ALL
HZ_CONTACT_POINTS 
HZ_CUST_CONTACT_POINTS 
AR_CUSTOMERS 
AR_PAYMENT_SCHEDULES_ALL 
AR_ADJUSTMENTS_ALL 
AR_DISTRIBUTIONS_ALL 
AR_TRANSACTION_HISTORY_ALL
AR_CASH_RECEIPTS_ALL 
AR_DISTRIBUTION_SETS_ALL
AR_RECEIVABLES_TRX_ALL 
AR_PERIODS
AR_PERIOD_TYPES
AR_VAT_TAX_ALL

RCV_SHIPMENT_HEADERS
RCV_SHIPMENT_LINES
RCV_TRANSACTIONS

INTERFACE TABLES OF AR
=======================

HZ_PARTY_INTERFACE
HZ_PARTY_INTERFACE_ERRORS
RA_INTERFACE_LINES_ALL
RA_INTERFACE_ERRORS_ALL
RA_INTERFACE_DISTRIBUTIONS_ALL
RA_INTERFACE_SALESCREDITS_ALL
RA_CONTACT_PHONES_INT_ALL
RA_CUSTOMERS_INTERFACE_ALL
RA_CUSTOMER_BANKS_INT_ALL
AR_PAYMENTS_INTERFACE_ALL
AR_TAX_INTERFACE
RCV_HEADERS_INTERFACE
RCV_TRANSACTIONS_INTERFACE

==============================================


SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'GL_I%E' AND OWNER='GL'

GL BASE TABLES
===============

GL_JE_HEADERS
GL_JE_LINES
GL_JE_BATCHES
GL_JE_CATEGORIES
GL_JE_SOURCES
GL_LEDGERS
GL_SETS_OF_BOOKS
GL_DAILY_RATES
GL_CODE_COMBINATIONS
GL_BALANCES
GL_PERIODS
GL_PERIOD_SETS
GL_CURRENCIES
GL_HISTORICAL_RATES
GL_LOOKUPS


GL INTERFACE TABLES
====================

GL_INTERFACE
GL_INTERFACE_HISTORY
GL_DAILY_RATES_INTERFACE
GL_BUDGET_INTERFACE
GL_IEA_INTERFACE

=================================================================================



SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE 'MTL_I%E' AND OWNER='INV'


INVENTORY (INV) BASE TABLES
============================

MTL_SYSTEM_ITEMS_B
MTL_ITEM_CATEGORIES
MTL_ITEM_LOCATIONS
MTL_ITEM_REVISIONS_B
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


INV INTERFACE TABLES
=======================

MTL_SYSTEM_ITEMS_INTERFACE
MTL_ITEM_CATEGORIES_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE
MTL_INTERFACE_ERRORS
=========================================================================