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

TABLE: XDP.XDP_ORDER_LINEITEM_DETS

Object Details
Object Name: XDP_ORDER_LINEITEM_DETS
Object Type: TABLE
Owner: XDP
FND Design Data: TableXDP.XDP_ORDER_LINEITEM_DETS
Subobject Name:
Status: VALID


XDP_ORDER_LINEITEM_DETS is used to hold all the parameters for each line item of an order sent from the upstream system (Customer Care, Order Entry).


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XDP_ORDER_LINEITEM_DETS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ITEM_ID
ColumnLINE_PARAMETER_NAME
Columns
Name Datatype Length Mandatory Comments
LINE_ITEM_ID NUMBER
Yes Unique identifier for line item
LINE_PARAMETER_NAME VARCHAR2 (40) Yes Line parameter name
PARAMETER_VALUE VARCHAR2 (4000)
Parameter value
PARAMETER_REFERENCE_VALUE VARCHAR2 (4000)
Parameter reference value
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT LINE_ITEM_ID
,      LINE_PARAMETER_NAME
,      PARAMETER_VALUE
,      PARAMETER_REFERENCE_VALUE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XDP.XDP_ORDER_LINEITEM_DETS;

Dependencies

[top of page]

XDP.XDP_ORDER_LINEITEM_DETS does not reference any database object

XDP.XDP_ORDER_LINEITEM_DETS is referenced by following:

SchemaXDP
ViewXDP_ORDER_LINEITEM_DETS#