FND Design Data [Home] [Help]

Table: XDP_ORDER_LINE_ITEMS

Product: XDP - Provisioning
Description: Order Line Items
Implementation/DBA Data: TableXDP.XDP_ORDER_LINE_ITEMS
Primary Key: XDP_ORDER_LINE_ITEMS_PK
  1. ColumnLINE_ITEM_ID
Primary Key: XDP_ORDER_LINE_ITEMS_UK
  1. ColumnORDER_ID
  2. ColumnLINE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
XDP_ORDER_LINE_ITEMS FK Joins to TableXDP_ORDER_BUNDLES XDP_ORDER_LINE_ITEMS.ORDER_ID
XDP_ORDER_LINE_ITEMS.BUNDLE_ID
XDP_ORDER_LINE_ITEMS FK Joins to TableXDP_ORDER_HEADERS XDP_ORDER_LINE_ITEMS.ORDER_ID
XDP_ORDER_LINE_ITEMS FK Joins to TableXDP_WORKITEMS XDP_ORDER_LINE_ITEMS.WORKITEM_ID
XDP_ORDER_LINE_ITEMS FK Joins to TableMTL_SYSTEM_ITEMS_B XDP_ORDER_LINE_ITEMS.INVENTORY_ITEM_ID
XDP_ORDER_LINE_ITEMS.ORGANIZATION_ID
XDP_ORDER_LINE_ITEMS FK Joins to TableCSI_ITEM_INSTANCES XDP_ORDER_LINE_ITEMS.IB_SOURCE_ID
XDP_ORDER_LINE_ITEMS FK Joins to TableCSI_T_TXN_LINE_DETAILS XDP_ORDER_LINE_ITEMS.IB_SOURCE_ID
XDP_ORDER_LINE_ITEMS FK Joins to TableHZ_CUST_SITE_USES_ALL XDP_ORDER_LINE_ITEMS.SITE_USE_ID
TableXDP_FULFILL_WORKLIST FK Joins to XDP_ORDER_LINE_ITEMS XDP_FULFILL_WORKLIST.LINE_ITEM_ID
TableXDP_FULFILL_WORKLIST FK Joins to XDP_ORDER_LINE_ITEMS XDP_FULFILL_WORKLIST.ORDER_ID
XDP_FULFILL_WORKLIST.LINE_NUMBER
TableXDP_LINE_RELATIONSHIPS FK Joins to XDP_ORDER_LINE_ITEMS XDP_LINE_RELATIONSHIPS.LINE_ITEM_ID
TableXDP_LINE_RELATIONSHIPS FK Joins to XDP_ORDER_LINE_ITEMS XDP_LINE_RELATIONSHIPS.RELATED_LINE_ITEM_ID
TableXDP_ORDER_LINEITEM_DETS FK Joins to XDP_ORDER_LINE_ITEMS XDP_ORDER_LINEITEM_DETS.LINE_ITEM_ID