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

TABLE: XDP.XDP_OE_ORDER_LINE_DETS

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


XDP_OE_ORDER_LINE_DETAILS contains all order line parameter values for an order generated by Oracle SFM- Order Entry interface.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XDP_OE_ORDER_LINE_DETS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnORDER_NUMBER
ColumnORDER_VERSION
ColumnLINE_NUMBER
ColumnPARAMETER_NAME
Columns
Name Datatype Length Mandatory Comments
ORDER_NUMBER VARCHAR2 (40) Yes External identifier for an order
ORDER_VERSION VARCHAR2 (40)
Order version
LINE_NUMBER NUMBER
Yes Order line number
PARAMETER_NAME VARCHAR2 (40) Yes Order parameter name
PARAMETER_VALUE VARCHAR2 (4000)
Parameter value
PARAMETER_REF_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 ORDER_NUMBER
,      ORDER_VERSION
,      LINE_NUMBER
,      PARAMETER_NAME
,      PARAMETER_VALUE
,      PARAMETER_REF_VALUE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XDP.XDP_OE_ORDER_LINE_DETS;

Dependencies

[top of page]

XDP.XDP_OE_ORDER_LINE_DETS does not reference any database object

XDP.XDP_OE_ORDER_LINE_DETS is referenced by following:

SchemaXDP
ViewXDP_OE_ORDER_LINE_DETS#