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:	ONT.OE_ORDER_HEADERS_ALL

Primary Key: OE_ORDER_HEADERS_PK

1. HEADER_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OE_ORDER_HEADERS_ALL		OE_ORDER_SOURCES	OE_ORDER_HEADERS_ALL.ORDER_SOURCE_ID
OE_ORDER_HEADERS_ALL		RA_SALESREPS_ALL	OE_ORDER_HEADERS_ALL.SALESREP_ID
OE_ORDER_HEADERS_ALL		OE_ORDER_SOURCES	OE_ORDER_HEADERS_ALL.SOURCE_DOCUMENT_TYPE_ID
OE_ORDER_HEADERS_ALL		OE_TRANSACTION_TYPES_ALL	OE_ORDER_HEADERS_ALL.ORDER_TYPE_ID
OE_ORDER_HEADERS_ALL		OE_AGREEMENTS_B	OE_ORDER_HEADERS_ALL.AGREEMENT_ID
OE_ORDER_HEADERS_ALL		HR_ALL_ORGANIZATION_UNITS	OE_ORDER_HEADERS_ALL.SHIP_FROM_ORG_ID
OE_ORDER_HEADERS_ALL		HR_ALL_ORGANIZATION_UNITS	OE_ORDER_HEADERS_ALL.SOLD_FROM_ORG_ID
OE_ORDER_HEADERS_ALL		HZ_CUST_SITE_USES_ALL	OE_ORDER_HEADERS_ALL.END_CUSTOMER_SITE_USE_ID
OE_ORDER_HEADERS_ALL		HZ_CUST_ACCOUNT_ROLES	OE_ORDER_HEADERS_ALL.END_CUSTOMER_CONTACT_ID
OE_ORDER_HEADERS_ALL		HZ_CUST_ACCOUNTS	OE_ORDER_HEADERS_ALL.END_CUSTOMER_ID
OE_ORDER_HEADERS_ALL		RA_RULES	OE_ORDER_HEADERS_ALL.ACCOUNTING_RULE_ID
OE_ORDER_HEADERS_ALL		FND_APPLICATION	OE_ORDER_HEADERS_ALL.PROGRAM_APPLICATION_ID
OE_ORDER_HEADERS_ALL		QP_LIST_HEADERS_B	OE_ORDER_HEADERS_ALL.PRICE_LIST_ID
OE_ORDER_HEADERS_ALL		RA_RULES	OE_ORDER_HEADERS_ALL.INVOICING_RULE_ID
OE_ORDER_HEADERS_ALL		RA_RULES	OE_ORDER_HEADERS_ALL.ACCOUNTING_RULE_ID
OE_ORDER_HEADERS_ALL		RA_TERMS_B	OE_ORDER_HEADERS_ALL.PAYMENT_TERM_ID
AHL_OSP_ORDERS_B		OE_ORDER_HEADERS_ALL	AHL_OSP_ORDERS_B.OE_HEADER_ID
AMS_EVENT_REGISTRATIONS		OE_ORDER_HEADERS_ALL	AMS_EVENT_REGISTRATIONS.ORDER_HEADER_ID
JAI_OM_LC_MATCHINGS		OE_ORDER_HEADERS_ALL	JAI_OM_LC_MATCHINGS.ORDER_HEADER_ID
JAI_OM_OE_BOND_TRXS		OE_ORDER_HEADERS_ALL	JAI_OM_OE_BOND_TRXS.ORDER_HEADER_ID
JAI_OM_OE_GEN_TAXINV_T		OE_ORDER_HEADERS_ALL	JAI_OM_OE_GEN_TAXINV_T.SOURCE_HEADER_ID
JAI_OM_OE_GEN_TAXINV_T		OE_ORDER_HEADERS_ALL	JAI_OM_OE_GEN_TAXINV_T.ORDER_HEADER_ID
JAI_OM_OE_RMA_LINES		OE_ORDER_HEADERS_ALL	JAI_OM_OE_RMA_LINES.RMA_HEADER_ID
JAI_OM_OE_SO_LINES		OE_ORDER_HEADERS_ALL	JAI_OM_OE_SO_LINES.HEADER_ID
JAI_OM_WSH_LINES_ALL		OE_ORDER_HEADERS_ALL	JAI_OM_WSH_LINES_ALL.ORDER_HEADER_ID
OE_DROP_SHIP_SOURCES		OE_ORDER_HEADERS_ALL	OE_DROP_SHIP_SOURCES.HEADER_ID
OE_HEADERS_IFACE_ALL		OE_ORDER_HEADERS_ALL	OE_HEADERS_IFACE_ALL.HEADER_ID
OE_HEADER_ACKS		OE_ORDER_HEADERS_ALL	OE_HEADER_ACKS.HEADER_ID
OE_HOLD_SOURCES_ALL		OE_ORDER_HEADERS_ALL	OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID
OE_LINE_ACKS		OE_ORDER_HEADERS_ALL	OE_LINE_ACKS.HEADER_ID
OE_ORDER_HOLDS_ALL		OE_ORDER_HEADERS_ALL	OE_ORDER_HOLDS_ALL.HEADER_ID
OE_ORDER_LINES_ALL		OE_ORDER_HEADERS_ALL	OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID
OE_ORDER_LINES_ALL		OE_ORDER_HEADERS_ALL	OE_ORDER_LINES_ALL.REFERENCE_HEADER_ID
OE_ORDER_LINES_ALL		OE_ORDER_HEADERS_ALL	OE_ORDER_LINES_ALL.HEADER_ID
OE_ORDER_PRICE_ATTRIBS		OE_ORDER_HEADERS_ALL	OE_ORDER_PRICE_ATTRIBS.HEADER_ID
OE_PRICE_ADJUSTMENTS		OE_ORDER_HEADERS_ALL	OE_PRICE_ADJUSTMENTS.HEADER_ID
OE_SALES_CREDITS		OE_ORDER_HEADERS_ALL	OE_SALES_CREDITS.HEADER_ID
OE_SETS		OE_ORDER_HEADERS_ALL	OE_SETS.HEADER_ID
OZF_CLAIMS_ALL		OE_ORDER_HEADERS_ALL	OZF_CLAIMS_ALL.PAYMENT_REFERENCE_ID
PV_PG_ENRL_REQUESTS		OE_ORDER_HEADERS_ALL	PV_PG_ENRL_REQUESTS.ORDER_HEADER_ID