{"id":896,"date":"2014-03-21T08:45:53","date_gmt":"2014-03-21T00:45:53","guid":{"rendered":"http:\/\/j178.mtgbb.com\/?p=896"},"modified":"2014-03-21T08:45:53","modified_gmt":"2014-03-21T00:45:53","slug":"apps-tables-with-links","status":"publish","type":"post","link":"https:\/\/j178.mtgbb.com\/?p=896","title":{"rendered":"APPS TABLES WITH LINKS"},"content":{"rendered":"

\u8cc7\u6599\u4f86\u6e90: \u9019\u88e1<\/a><\/p>\n

\u5e38\u7528\u6a21\u7d44\u7684 table, \u542b join \u6b04\u4f4d<\/p>\n

<\/p>\n

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE ‘AP_E%ALL’ AND OWNER=’AP’<\/p>\n

PAYABLES INTERFACE TABLES
\n==========================
\nAP_INVOICES_INTERFACE
\nAP_INVOICE_LINES_INTERFACE
\nAP_SUPPLIERS_INT
\nAP_SUPPLIER_SITES_INT
\nAP_SUP_SITE_CONTACT_INT<\/p>\n

PAYABLES BASE TABLES
\n======================
\nAP_INVOICES_ALL
\nAP_INVOICE_LINES_ALL
\nAP_INVOICE_DISTRIBUTIONS_ALL
\nAP_INVOICE_PAYMENTS_ALL
\nAP_PAYMENT_SCHEDULES_ALL
\nAP_PAYMENT_HISTORY_ALL
\nAP_PAYMENT_DISTRIBUTIONS_ALL
\nAP_AE_HEADERS_ALL
\nAP_AE_LINES_ALL
\nAP_BATCHES_ALL
\nAP_TERMS
\nAP_LOOKUP_CODES
\nAP_ACCOUNTING_EVENTS_ALL
\nAP_BANK_ACCOUNTS_ALL
\nAP_BANK_ACCOUNT_USES_ALL
\nAP_CHECKS_ALL
\nAP_HOLDS_ALL
\nAP_CARD_CODES
\nAP_CARDS_ALL
\nAP_CARD_CODES_ALL
\nAP_CARD_CODE_SETS_ALL
\nAP_EXPENSE_REPORTS_ALL
\nAP_EXPENSE_REPORT_HEADERS_ALL
\nAP_EXPENSE_REPORT_LINES_ALL
\nAP_EXP_REPORT_DISTS_ALL<\/p>\n

====================================================================================<\/p>\n

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE ‘PO_%E_ALL’ AND OWNER=’PO’<\/p>\n

PO INTERFACE TABLES
\n====================<\/p>\n

PO_HEADERS_INTERFACE
\nPO_LINES_INTERFACE
\nPO_LINE_LOCATIONS_INTERFACE
\nPO_DISTRIBUTIONS_INTERFACE<\/p>\n

PO REQ INTERFACE TABLES
\n=======================<\/p>\n

PO_REQUISITIONS_INTERFACE_ALL
\nPO_REQ_DIST_INTERFACE_ALL<\/p>\n

PO BASE TABLES
\n=================<\/p>\n

PO_HEADERS_ALL
\nPO_LINES_ALL
\nPO_LINE_LOCATIONS_ALL
\nPO_DISTRIBUTIONS_ALL
\nPO_RELEASES_ALL
\nPO_AGENTS
\nPO_ACTION_HISTORY<\/p>\n

AP_SUPPLIERS
\nAP_SUPPLIER_SITES_ALL
\nAP_SUPPLIER_CONTACTS<\/p>\n

PO REQ BASE TABLES
\n=======================
\nPO_REQUISITION_HEADERS_ALL
\nPO_REQUISITION_LINES_ALL
\nPO_REQ_DISTRIBUTIONS_ALL<\/p>\n

RECEIPTS BASE TABLES
\n====================<\/p>\n

RCV_SHIPMENT_HEADERS
\nRCV_SHIPMENT_LINES
\nRCV_TRANSACTIONS<\/p>\n

=======================================================================================<\/p>\n

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE ‘FND_A%L’ –AND OWNER=’ONT’<\/p>\n

OM INTERFACE TABLES
\n====================<\/p>\n

OE_HEADERS_IFACE_ALL
\nOE_LINES_IFACE_ALL
\nOE_ACTIONS_IFACE_ALL<\/p>\n

OM BASE TABLES
\n====================<\/p>\n

OE_ORDER_HEADERS_ALL
\nOE_ORDER_LINES_ALL
\nOE_ORDER_HOLDS_ALL
\nOE_ORDER_SOURCES
\nOE_TRANSACTION_TYPES_TL\/ALL
\nOE_PAYMENT_TYPES_TL<\/p>\n

WSH_DELIVERY_DETAILS
\nWSH_NEW_DELIVERIES
\nWSH_DELIVERY_ASSIGNMENTS
\nOE_ORDER_HOLDS
\nQP_LIST_HEADERS
\nRA_SALESREPS
\nOE_TRANSACTION_TYPES_TL
\nAR_CUSTOMERS
\nRA_TERMS<\/p>\n

====================================================================================<\/p>\n

SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME LIKE ‘FND_PRO%S’ AND OWNER=’APPS’<\/p>\n

OTHER BASE TABLES
\n===================<\/p>\n

FND_USER
\nFND_APPLICATION_VL
\nFND_RESPONSIBILITY_VL
\nFND_CONCURRENT_PROGRAMS
\nFND_EXECUTABLES
\nFND_CONCURRENT_PROCESSES
\nFND_CONCURRENT_REQUESTS
\nFND_DATA_GROUPS
\nFND_SEGMENT_ATTRIBUTE_TYPES
\nFND_SEGMENT_ATTRIBUTE_VALUES
\nFND_TABLES
\nFND_TABLESPACES
\nFND_FORM
\nFND_PROFILE_OPTIONS
\nFND_PROFILE_OPTION_VALUES
\nFND_PRODUCT_INSTALLATIONS
\nFND_PRODUCT_GROUPS
\nFND_PRODUCT_DEPENDENCIES
\nORG_ORGANIZATION_DEFINITIONS
\nPER_ALL_PEOPLE_F(ENAME)
\nHR_LOCATIONS(BILL_TO,SHIP_TO)<\/p>\n","protected":false},"excerpt":{"rendered":"

\u8cc7\u6599\u4f86\u6e90: \u9019\u88e1 \u5e38\u7528\u6a21\u7d44\u7684 table, \u542b join \u6b04\u4f4d<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[57],"class_list":["post-896","post","type-post","status-publish","format-standard","hentry","category-oracle-erp","tag-oracle-erp"],"_links":{"self":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/896","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=896"}],"version-history":[{"count":0,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=\/wp\/v2\/posts\/896\/revisions"}],"wp:attachment":[{"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=896"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=896"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/j178.mtgbb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=896"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}