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: XDP_ORDER_LINE_ITEMS

Product:	XDP - Provisioning
Description:	Order Line Items
Implementation/DBA Data:	XDP.XDP_ORDER_LINE_ITEMS

Primary Key: XDP_ORDER_LINE_ITEMS_PK

LINE_ITEM_ID

Primary Key: XDP_ORDER_LINE_ITEMS_UK

ORDER_ID
LINE_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
XDP_ORDER_LINE_ITEMS	XDP_ORDER_BUNDLES	XDP_ORDER_LINE_ITEMS.ORDER_ID XDP_ORDER_LINE_ITEMS.BUNDLE_ID
XDP_ORDER_LINE_ITEMS	XDP_ORDER_HEADERS	XDP_ORDER_LINE_ITEMS.ORDER_ID
XDP_ORDER_LINE_ITEMS	XDP_WORKITEMS	XDP_ORDER_LINE_ITEMS.WORKITEM_ID
XDP_ORDER_LINE_ITEMS	MTL_SYSTEM_ITEMS_B	XDP_ORDER_LINE_ITEMS.INVENTORY_ITEM_ID XDP_ORDER_LINE_ITEMS.ORGANIZATION_ID
XDP_ORDER_LINE_ITEMS	CSI_ITEM_INSTANCES	XDP_ORDER_LINE_ITEMS.IB_SOURCE_ID
XDP_ORDER_LINE_ITEMS	CSI_T_TXN_LINE_DETAILS	XDP_ORDER_LINE_ITEMS.IB_SOURCE_ID
XDP_ORDER_LINE_ITEMS	HZ_CUST_SITE_USES_ALL	XDP_ORDER_LINE_ITEMS.SITE_USE_ID
XDP_FULFILL_WORKLIST	XDP_ORDER_LINE_ITEMS	XDP_FULFILL_WORKLIST.LINE_ITEM_ID
XDP_FULFILL_WORKLIST	XDP_ORDER_LINE_ITEMS	XDP_FULFILL_WORKLIST.ORDER_ID XDP_FULFILL_WORKLIST.LINE_NUMBER
XDP_LINE_RELATIONSHIPS	XDP_ORDER_LINE_ITEMS	XDP_LINE_RELATIONSHIPS.LINE_ITEM_ID
XDP_LINE_RELATIONSHIPS	XDP_ORDER_LINE_ITEMS	XDP_LINE_RELATIONSHIPS.RELATED_LINE_ITEM_ID
XDP_ORDER_LINEITEM_DETS	XDP_ORDER_LINE_ITEMS	XDP_ORDER_LINEITEM_DETS.LINE_ITEM_ID