FND Design Data

Table: OE_ORDER_HEADERS_ALL

Product: ONT - Order Management
Description: OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
Implementation/DBA Data: TableONT.OE_ORDER_HEADERS_ALL
Primary Key: OE_ORDER_HEADERS_PK
  1. ColumnHEADER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
OE_ORDER_HEADERS_ALL FK Joins to TableOE_ORDER_SOURCES OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID
OE_ORDER_HEADERS_ALL FK Joins to TableRA_SALESREPS_ALL OE_ORDER_HEADERS_ALL.SALESREP_ID
OE_ORDER_HEADERS_ALL FK Joins to TableOE_ORDER_SOURCES OE_ORDER_HEADERS_ALL.SOURCE_DOCUMENT_TYPE_ID
OE_ORDER_HEADERS_ALL FK Joins to TableOE_TRANSACTION_TYPES_ALL OE_ORDER_HEADERS_ALL.ORDER_TYPE_ID
OE_ORDER_HEADERS_ALL FK Joins to TableOE_AGREEMENTS_B OE_ORDER_HEADERS_ALL.AGREEMENT_ID
OE_ORDER_HEADERS_ALL FK Joins to TableHR_ALL_ORGANIZATION_UNITS OE_ORDER_HEADERS_ALL.SHIP_FROM_ORG_ID
OE_ORDER_HEADERS_ALL FK Joins to TableHR_ALL_ORGANIZATION_UNITS OE_ORDER_HEADERS_ALL.SOLD_FROM_ORG_ID
OE_ORDER_HEADERS_ALL FK Joins to TableHZ_CUST_SITE_USES_ALL OE_ORDER_HEADERS_ALL.END_CUSTOMER_SITE_USE_ID
OE_ORDER_HEADERS_ALL FK Joins to TableHZ_CUST_ACCOUNT_ROLES OE_ORDER_HEADERS_ALL.END_CUSTOMER_CONTACT_ID
OE_ORDER_HEADERS_ALL FK Joins to TableHZ_CUST_ACCOUNTS OE_ORDER_HEADERS_ALL.END_CUSTOMER_ID
OE_ORDER_HEADERS_ALL FK Joins to TableRA_RULES OE_ORDER_HEADERS_ALL.ACCOUNTING_RULE_ID
OE_ORDER_HEADERS_ALL FK Joins to TableFND_APPLICATION OE_ORDER_HEADERS_ALL.PROGRAM_APPLICATION_ID
OE_ORDER_HEADERS_ALL FK Joins to TableQP_LIST_HEADERS_B OE_ORDER_HEADERS_ALL.PRICE_LIST_ID
OE_ORDER_HEADERS_ALL FK Joins to TableRA_RULES OE_ORDER_HEADERS_ALL.INVOICING_RULE_ID
OE_ORDER_HEADERS_ALL FK Joins to TableRA_RULES OE_ORDER_HEADERS_ALL.ACCOUNTING_RULE_ID
OE_ORDER_HEADERS_ALL FK Joins to TableRA_TERMS_B OE_ORDER_HEADERS_ALL.PAYMENT_TERM_ID
TableAHL_OSP_ORDERS_B FK Joins to OE_ORDER_HEADERS_ALL AHL_OSP_ORDERS_B.OE_HEADER_ID
TableAMS_EVENT_REGISTRATIONS FK Joins to OE_ORDER_HEADERS_ALL AMS_EVENT_REGISTRATIONS.ORDER_HEADER_ID
TableJAI_OM_LC_MATCHINGS FK Joins to OE_ORDER_HEADERS_ALL JAI_OM_LC_MATCHINGS.ORDER_HEADER_ID
TableJAI_OM_OE_BOND_TRXS FK Joins to OE_ORDER_HEADERS_ALL JAI_OM_OE_BOND_TRXS.ORDER_HEADER_ID
TableJAI_OM_OE_GEN_TAXINV_T FK Joins to OE_ORDER_HEADERS_ALL JAI_OM_OE_GEN_TAXINV_T.SOURCE_HEADER_ID
TableJAI_OM_OE_GEN_TAXINV_T FK Joins to OE_ORDER_HEADERS_ALL JAI_OM_OE_GEN_TAXINV_T.ORDER_HEADER_ID
TableJAI_OM_OE_RMA_LINES FK Joins to OE_ORDER_HEADERS_ALL JAI_OM_OE_RMA_LINES.RMA_HEADER_ID
TableJAI_OM_OE_SO_LINES FK Joins to OE_ORDER_HEADERS_ALL JAI_OM_OE_SO_LINES.HEADER_ID
TableJAI_OM_WSH_LINES_ALL FK Joins to OE_ORDER_HEADERS_ALL JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID
TableOE_DROP_SHIP_SOURCES FK Joins to OE_ORDER_HEADERS_ALL OE_DROP_SHIP_SOURCES.HEADER_ID
TableOE_HEADERS_IFACE_ALL FK Joins to OE_ORDER_HEADERS_ALL OE_HEADERS_IFACE_ALL.HEADER_ID
TableOE_HEADER_ACKS FK Joins to OE_ORDER_HEADERS_ALL OE_HEADER_ACKS.HEADER_ID
TableOE_HOLD_SOURCES_ALL FK Joins to OE_ORDER_HEADERS_ALL OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID
TableOE_LINE_ACKS FK Joins to OE_ORDER_HEADERS_ALL OE_LINE_ACKS.HEADER_ID
TableOE_ORDER_HOLDS_ALL FK Joins to OE_ORDER_HEADERS_ALL OE_ORDER_HOLDS_ALL.HEADER_ID
TableOE_ORDER_LINES_ALL FK Joins to OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID
TableOE_ORDER_LINES_ALL FK Joins to OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL.REFERENCE_HEADER_ID
TableOE_ORDER_LINES_ALL FK Joins to OE_ORDER_HEADERS_ALL OE_ORDER_LINES_ALL.HEADER_ID
TableOE_ORDER_PRICE_ATTRIBS FK Joins to OE_ORDER_HEADERS_ALL OE_ORDER_PRICE_ATTRIBS.HEADER_ID
TableOE_PRICE_ADJUSTMENTS FK Joins to OE_ORDER_HEADERS_ALL OE_PRICE_ADJUSTMENTS.HEADER_ID
TableOE_SALES_CREDITS FK Joins to OE_ORDER_HEADERS_ALL OE_SALES_CREDITS.HEADER_ID
TableOE_SETS FK Joins to OE_ORDER_HEADERS_ALL OE_SETS.HEADER_ID
TableOZF_CLAIMS_ALL FK Joins to OE_ORDER_HEADERS_ALL OZF_CLAIMS_ALL.PAYMENT_REFERENCE_ID
TablePV_PG_ENRL_REQUESTS FK Joins to OE_ORDER_HEADERS_ALL PV_PG_ENRL_REQUESTS.ORDER_HEADER_ID



Copyright © 2001, 2014, Oracle Oracle Proprietary, Confidential Information Legal Notices