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

TABLE: EAM.EAM_ASSET_TEXT

Object Details
Object Name: EAM_ASSET_TEXT
Object Type: TABLE
Owner: EAM
FND Design Data: TableEAM.EAM_ASSET_TEXT
Subobject Name:
Status: VALID


This table stores instance_id of all valid eAM asset defined in csi_item_instances. A text (intermedia) index will be created on the column 'TEXT' with the help of a concurrent program and the same is used in Asset text search page


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_ASSET_TEXT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
INSTANCE_ID NUMBER

Instance Id of the Asset defined in csi_item_instances
TEXT VARCHAR2 (1)
Column (dummy) for creating the text (intermedia) index
CREATED_BY NUMBER

Keeps track of which user created each row
CREATION_DATE DATE

Stores the date on which each row was created
LAST_UPDATED_BY NUMBER

Keeps track of who last updated each row
LAST_UPDATE_DATE DATE

Stores the date on which each row was last updated
LAST_UPDATE_LOGIN NUMBER

Provides access to information about the operating system login of the user who last updated each row
Query Text

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


SELECT INSTANCE_ID
,      TEXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM EAM.EAM_ASSET_TEXT;

Dependencies

[top of page]

EAM.EAM_ASSET_TEXT does not reference any database object

EAM.EAM_ASSET_TEXT is referenced by following:

SchemaAPPS
SynonymEAM_ASSET_TEXT