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_LINES_ALL

Product:	ONT - Order Management
Description:	OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
Implementation/DBA Data:	ONT.OE_ORDER_LINES_ALL

Primary Key: OE_ORDER_LINES_PK

LINE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OE_ORDER_LINES_ALL	RA_SALESREPS_ALL	OE_ORDER_LINES_ALL.SALESREP_ID
OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL.SPLIT_FROM_LINE_ID
OE_ORDER_LINES_ALL	OE_SETS	OE_ORDER_LINES_ALL.SHIP_SET_ID
OE_ORDER_LINES_ALL	OE_ORDER_SOURCES	OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_TYPE_ID
OE_ORDER_LINES_ALL	OE_SETS	OE_ORDER_LINES_ALL.LINE_SET_ID
OE_ORDER_LINES_ALL	OE_TRANSACTION_TYPES_ALL	OE_ORDER_LINES_ALL.LINE_TYPE_ID
OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL.ATO_LINE_ID
OE_ORDER_LINES_ALL	BOM_COMPONENTS_B	OE_ORDER_LINES_ALL.COMPONENT_SEQUENCE_ID
OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL.LINK_TO_LINE_ID
OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL.TOP_MODEL_LINE_ID
OE_ORDER_LINES_ALL	OE_AGREEMENTS_B	OE_ORDER_LINES_ALL.AGREEMENT_ID
OE_ORDER_LINES_ALL	OE_ORDER_HEADERS_ALL	OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID
OE_ORDER_LINES_ALL	MTL_CUSTOMER_ITEMS	OE_ORDER_LINES_ALL.ORDERED_ITEM_ID
OE_ORDER_LINES_ALL	MTL_CROSS_REFERENCE_TYPES	OE_ORDER_LINES_ALL.ITEM_IDENTIFIER_TYPE
OE_ORDER_LINES_ALL	OE_ORDER_HEADERS_ALL	OE_ORDER_LINES_ALL.REFERENCE_HEADER_ID
OE_ORDER_LINES_ALL	QP_LIST_HEADERS_B	OE_ORDER_LINES_ALL.PRICE_LIST_ID
OE_ORDER_LINES_ALL	HR_ALL_ORGANIZATION_UNITS	OE_ORDER_LINES_ALL.SHIP_FROM_ORG_ID
OE_ORDER_LINES_ALL	HR_ALL_ORGANIZATION_UNITS	OE_ORDER_LINES_ALL.SOLD_FROM_ORG_ID
OE_ORDER_LINES_ALL	RA_CUSTOMER_TRX_LINES_ALL	OE_ORDER_LINES_ALL.REFERENCE_CUSTOMER_TRX_LINE_ID
OE_ORDER_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_LINES_ALL.END_CUSTOMER_CONTACT_ID
OE_ORDER_LINES_ALL	HZ_CUST_SITE_USES_ALL	OE_ORDER_LINES_ALL.END_CUSTOMER_SITE_USE_ID
OE_ORDER_LINES_ALL	HZ_CUST_ACCOUNTS	OE_ORDER_LINES_ALL.END_CUSTOMER_ID
OE_ORDER_LINES_ALL	FND_APPLICATION	OE_ORDER_LINES_ALL.PROGRAM_APPLICATION_ID
OE_ORDER_LINES_ALL	HZ_CUST_ACCOUNT_ROLES	OE_ORDER_LINES_ALL.INTMED_SHIP_TO_CONTACT_ID
OE_ORDER_LINES_ALL	IBE_MSITES_B	OE_ORDER_LINES_ALL.MINISITE_ID
OE_ORDER_LINES_ALL	OE_ORDER_HEADERS_ALL	OE_ORDER_LINES_ALL.HEADER_ID
OE_ORDER_LINES_ALL	OE_SETS	OE_ORDER_LINES_ALL.ARRIVAL_SET_ID
OE_ORDER_LINES_ALL	RA_TERMS_B	OE_ORDER_LINES_ALL.PAYMENT_TERM_ID
OE_ORDER_LINES_ALL	RA_RULES	OE_ORDER_LINES_ALL.INVOICING_RULE_ID
OE_ORDER_LINES_ALL	RA_RULES	OE_ORDER_LINES_ALL.ACCOUNTING_RULE_ID
AHL_OSP_ORDER_LINES	OE_ORDER_LINES_ALL	AHL_OSP_ORDER_LINES.OE_SHIP_LINE_ID
AHL_OSP_ORDER_LINES	OE_ORDER_LINES_ALL	AHL_OSP_ORDER_LINES.OE_RETURN_LINE_ID
AMS_EVENT_REGISTRATIONS	OE_ORDER_LINES_ALL	AMS_EVENT_REGISTRATIONS.ORDER_LINE_ID
AR_DEFERRED_LINES_ALL	OE_ORDER_LINES_ALL	AR_DEFERRED_LINES_ALL.PARENT_LINE_ID
CST_COGS_EVENTS	OE_ORDER_LINES_ALL	CST_COGS_EVENTS.COGS_OM_LINE_ID
CST_REVENUE_COGS_MATCH_LINES	OE_ORDER_LINES_ALL	CST_REVENUE_COGS_MATCH_LINES.COGS_OM_LINE_ID
CST_REVENUE_COGS_MATCH_LINES	OE_ORDER_LINES_ALL	CST_REVENUE_COGS_MATCH_LINES.REVENUE_OM_LINE_ID
CST_REVENUE_RECOGNITION_LINES	OE_ORDER_LINES_ALL	CST_REVENUE_RECOGNITION_LINES.REVENUE_OM_LINE_ID
CSD_REPAIRS	OE_ORDER_LINES_ALL	CSD_REPAIRS.ORDER_LINE_ID
CSI_ITEM_INSTANCES	OE_ORDER_LINES_ALL	CSI_ITEM_INSTANCES.IN_TRANSIT_ORDER_LINE_ID
CSP_REQUIREMENT_LINES	OE_ORDER_LINES_ALL	CSP_REQUIREMENT_LINES.ORDER_LINE_ID
CS_LINE_INST_DETAILS	OE_ORDER_LINES_ALL	CS_LINE_INST_DETAILS.ORDER_LINE_ID
CS_LINE_INST_DETAILS	OE_ORDER_LINES_ALL	CS_LINE_INST_DETAILS.NEW_CP_RMA_LINE_ID
CS_LINE_INST_DETAILS	OE_ORDER_LINES_ALL	CS_LINE_INST_DETAILS.INSTALLED_CP_RMA_LINE_ID
CSD_REPAIRS	OE_ORDER_LINES_ALL	CSD_REPAIRS.ORDER_LINE_ID
JAI_OM_LC_MATCHINGS	OE_ORDER_LINES_ALL	JAI_OM_LC_MATCHINGS.ORDER_LINE_ID
JAI_OM_OE_SO_LINES	OE_ORDER_LINES_ALL	JAI_OM_OE_SO_LINES.SPLIT_FROM_LINE_ID
JAI_OM_OE_SO_LINES	OE_ORDER_LINES_ALL	JAI_OM_OE_SO_LINES.SHIPMENT_SCHEDULE_LINE_ID
JAI_OM_REP_JAINEXFR_T	OE_ORDER_LINES_ALL	JAI_OM_REP_JAINEXFR_T.ORDER_LINE_ID
JAI_OM_WSH_LINES_ALL	OE_ORDER_LINES_ALL	JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID
JAI_PO_RMA_RTN_LINES	OE_ORDER_LINES_ALL	JAI_PO_RMA_RTN_LINES.RMA_LINE_ID
JMF_SHIKYU_REPLENISHMENTS	OE_ORDER_LINES_ALL	JMF_SHIKYU_REPLENISHMENTS.REPLENISHMENT_SO_LINE_ID
OE_DROP_SHIP_SOURCES	OE_ORDER_LINES_ALL	OE_DROP_SHIP_SOURCES.LINE_ID
OE_LINE_ACKS	OE_ORDER_LINES_ALL	OE_LINE_ACKS.TOP_MODEL_LINE_ID
OE_LINE_SETS	OE_ORDER_LINES_ALL	OE_LINE_SETS.LINE_ID
OE_LOT_SERIAL_NUMBERS	OE_ORDER_LINES_ALL	OE_LOT_SERIAL_NUMBERS.LINE_ID
OE_ORDER_HOLDS_ALL	OE_ORDER_LINES_ALL	OE_ORDER_HOLDS_ALL.LINE_ID
OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL.SPLIT_FROM_LINE_ID
OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL.ATO_LINE_ID
OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL.LINK_TO_LINE_ID
OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL.TOP_MODEL_LINE_ID
OE_ORDER_LINES_HISTORY	OE_ORDER_LINES_ALL	OE_ORDER_LINES_HISTORY.LINE_ID
OE_ORDER_PRICE_ATTRIBS	OE_ORDER_LINES_ALL	OE_ORDER_PRICE_ATTRIBS.LINE_ID
OE_PRICE_ADJUSTMENTS	OE_ORDER_LINES_ALL	OE_PRICE_ADJUSTMENTS.LINE_ID
OE_PRICE_ADJ_ASSOCS	OE_ORDER_LINES_ALL	OE_PRICE_ADJ_ASSOCS.LINE_ID
OE_SALES_CREDITS	OE_ORDER_LINES_ALL	OE_SALES_CREDITS.LINE_ID