eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

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

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