APPS TABLES WITH LINKS
資料來源: 這裡
常用模組的 table, 含 join 欄位
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)