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

TABLE: OE.SO_LINE_DETAIL_ATTRIBUTES

Object Details
Object Name: SO_LINE_DETAIL_ATTRIBUTES
Object Type: TABLE
Owner: OE
FND Design Data: TableOE.SO_LINE_DETAIL_ATTRIBUTES
Subobject Name:
Status: VALID


SO_LINE_DETAIL_ATTRIBUTES stores globalization information about
scheduling and fulfillment details in Oracle Order Entry/Shipping.
.
The table is a sibling of SO_LINE_DETAILS; for each row in
SO_LINE_DETAILS, there is at most one row in
SO_LINE_DETAIL_ATTRIBUTES.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SO_LINE_DETAIL_ATTRIBUTES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_DETAIL_ID
Columns
Name Datatype Length Mandatory Comments
LINE_DETAIL_ID NUMBER
Yes System-generated identifier
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Application of concurrent program that last updated the row
PROGRAM_ID NUMBER

Concurrent program that last updated the row
PROGRAM_UPDATE_DATE DATE

Last date updated by concurrent program
REQUEST_ID NUMBER

Concurrent request that last updated the row
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Globalization information
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Globalization information
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Globalization information
Query Text

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


SELECT LINE_DETAIL_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
FROM OE.SO_LINE_DETAIL_ATTRIBUTES;

Dependencies

[top of page]

OE.SO_LINE_DETAIL_ATTRIBUTES does not reference any database object

OE.SO_LINE_DETAIL_ATTRIBUTES is referenced by following:

SchemaAPPS
SynonymSO_LINE_DETAIL_ATTRIBUTES