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

TABLE: EAM.EAM_ASSET_STATUS_HISTORY

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


This table stores history of assets being shutdown. It stores the asset information, the date when the shutdown started, the date when the shutdown ended, and the information of the work order which caused the shutdown.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
EAM_ASSET_STATUS_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSET_STATUS_ID
EAM_ASSET_STATUS_HISTORY_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAINTENANCE_OBJECT_ID
ColumnMAINTENANCE_OBJECT_TYPE
ColumnSTART_DATE
ColumnEND_DATE
EAM_ASSET_STATUS_HISTORY_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
ASSET_STATUS_ID NUMBER
Yes Asset status identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
ASSET_GROUP_ID NUMBER
Yes Asset group identifier
ASSET_NUMBER VARCHAR2 (30) Yes Asset number identifier
START_DATE DATE
Yes Shutdown start date
END_DATE DATE
Yes Shutdown end date
WIP_ENTITY_ID NUMBER

Work order identifier
OPERATION_SEQ_NUM NUMBER

Operation identifier
DESCRIPTION VARCHAR2 (240)
Shutdown description
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Column
MAINTENANCE_OBJECT_TYPE NUMBER

Object Type
MAINTENANCE_OBJECT_ID NUMBER

Object ID
ENABLE_FLAG VARCHAR2 (1)
Enable Flag
Query Text

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


SELECT ASSET_STATUS_ID
,      ORGANIZATION_ID
,      ASSET_GROUP_ID
,      ASSET_NUMBER
,      START_DATE
,      END_DATE
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MAINTENANCE_OBJECT_TYPE
,      MAINTENANCE_OBJECT_ID
,      ENABLE_FLAG
FROM EAM.EAM_ASSET_STATUS_HISTORY;

Dependencies

[top of page]

EAM.EAM_ASSET_STATUS_HISTORY does not reference any database object

EAM.EAM_ASSET_STATUS_HISTORY is referenced by following:

SchemaEAM
ViewEAM_ASSET_STATUS_HISTORY#