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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: XDP.XDP_ORDER_LINE_ITEMS

Object Details

Object Name:	XDP_ORDER_LINE_ITEMS
Object Type:	TABLE
Owner:	XDP
FND Design Data:	XDP.XDP_ORDER_LINE_ITEMS
Subobject Name:
Status:	VALID

XDP_ORDER_LINE_ITEMS is used to hold all the liine items for an order sent by the upstream system (Customer Care, Order Entry). In addition, Oracle SDPProvisioning generates virtual line items for each order line that is of a package type. In this case, the IS_VIRTUAL_LINE_FLAG will be set to 'Y' and the relationship between the virtual line and the original order line will be logged into the XDP_LINE_RELATIONSHIPS table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XDP_ORDER_LINE_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ITEM_ID
XDP_ORDER_LINE_ITEMS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORDER_ID LINE_NUMBER
XDP_ORDER_LINE_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STARTING_NUMBER ENDING_NUMBER
XDP_ORDER_LINE_ITEMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ITEM_ID	NUMBER		Yes	Unique internal identifier generated by the system
ORDER_ID	NUMBER		Yes	Unique identifier for the order
LINE_NUMBER	NUMBER		Yes	Line Number in Upstream Application
LINE_ITEM_NAME	VARCHAR2	(40)	Yes	Line Item Name
PROVISIONING_REQUIRED_FLAG	VARCHAR2	(1)	Yes	Indicate if fulfillment is required for this line item
STATUS_CODE	VARCHAR2	(40)	Yes	Status code of the line item
STATE	VARCHAR2	(40)		Not Used
IS_PACKAGE_FLAG	VARCHAR2	(1)	Yes	Indicator to determine if the line item is part of an order that belongs to a package
IS_VIRTUAL_LINE_FLAG	VARCHAR2	(1)	Yes	Indicator to determine if line item is virtual
LINE_SEQUENCE	NUMBER		Yes	Sequence number for the line item
BUNDLE_SEQUENCE	NUMBER			Bundle sequence number for bundled orders
SEQ_IN_PACKAGE	NUMBER			Sequence of line item if part of a package
SERVICE_ID	NUMBER			Not Used
PACKAGE_ID	NUMBER			Not Used
WORKITEM_ID	NUMBER			Workitem identifier
IS_OA_ADDED_FLAG	VARCHAR2	(1)		Order Analyzer Indicator used to determine customizations for audit trails
PRIORITY	NUMBER			Priority
LINE_ITEM_ACTION_CODE	VARCHAR2	(30)		Line Item Action code
VERSION	VARCHAR2	(20)		service version
BUNDLE_ID	NUMBER			Bundle identifier
PROVISIONING_DATE	DATE			Fulfillment process date for the order
DUE_DATE	DATE			Internal date for the completion of the provisioing process
CUSTOMER_REQUIRED_DATE	DATE			Customer required date for the completion of the order
COMPLETION_DATE	DATE			Actual completion date
CANCEL_PROVISIONING_DATE	DATE			Fulfillment cancellation date
CANCELED_BY	VARCHAR2	(40)		Identification of user cancelling the process
HOLD_PROVISIONING_DATE	DATE			Fulfillment process hold date
HELD_BY	VARCHAR2	(40)		User identification for holding fulfillment process
RESUME_PROVISIONING_DATE	DATE			Resume fulfillment process date
RESUMED_BY	VARCHAR2	(40)		Identification of user issuing resume command
ERROR_REF_ID	NUMBER			Error reference identification
WF_ITEM_TYPE	VARCHAR2	(8)		Workflow item type
WF_ITEM_KEY	VARCHAR2	(240)		Workflow item key
JEOPARDY_ENABLED_FLAG	VARCHAR2	(1)		Jeopardy flag
STARTING_NUMBER	NUMBER			Starting number
ENDING_NUMBER	NUMBER			Ending number
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
LINE_SOURCE	VARCHAR2	(30)		Source for line (e.g. Table Name) in Upstream Application
INVENTORY_ITEM_ID	NUMBER			Inventory Item Identifier
ORGANIZATION_ID	NUMBER			Organization Identifier for Item Definition
IB_SOURCE	VARCHAR2	(240)	Yes	Indicates source for IB information. 'CSI' = Item Instance, 'TXN' = Transaction Details, 'NONE'=No IB
IB_SOURCE_ID	NUMBER			If IB_SOURCE = 'CSI', this column will hold ID foran Item Instance. If IB_SOURCE = 'TXN', this column will hold ID for a Transaction Line
SITE_USE_ID	NUMBER	(15)		Indicates the site to which the order line adheres (e.g. Install To Site)
ACTUAL_PROVISIONING_DATE	DATE			Actual Fulfillment Date
ATTRIBUTE_CATEGORY	VARCHAR2	(240)		Attribute Category
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexvfeld
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexvfeld

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT LINE_ITEM_ID
,      ORDER_ID
,      LINE_NUMBER
,      LINE_ITEM_NAME
,      PROVISIONING_REQUIRED_FLAG
,      STATUS_CODE
,      STATE
,      IS_PACKAGE_FLAG
,      IS_VIRTUAL_LINE_FLAG
,      LINE_SEQUENCE
,      BUNDLE_SEQUENCE
,      SEQ_IN_PACKAGE
,      SERVICE_ID
,      PACKAGE_ID
,      WORKITEM_ID
,      IS_OA_ADDED_FLAG
,      PRIORITY
,      LINE_ITEM_ACTION_CODE
,      VERSION
,      BUNDLE_ID
,      PROVISIONING_DATE
,      DUE_DATE
,      CUSTOMER_REQUIRED_DATE
,      COMPLETION_DATE
,      CANCEL_PROVISIONING_DATE
,      CANCELED_BY
,      HOLD_PROVISIONING_DATE
,      HELD_BY
,      RESUME_PROVISIONING_DATE
,      RESUMED_BY
,      ERROR_REF_ID
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      JEOPARDY_ENABLED_FLAG
,      STARTING_NUMBER
,      ENDING_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      LINE_SOURCE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      IB_SOURCE
,      IB_SOURCE_ID
,      SITE_USE_ID
,      ACTUAL_PROVISIONING_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM XDP.XDP_ORDER_LINE_ITEMS;

Dependencies

[top of page]

XDP.XDP_ORDER_LINE_ITEMS does not reference any database object

XDP.XDP_ORDER_LINE_ITEMS is referenced by following:

APPS: XDP_ORDER_LINE_ITEMS