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

TABLE: MSC.MSC_EAM_ACT_ASSOCIATIONS

Object Details
Object Name: MSC_EAM_ACT_ASSOCIATIONS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_EAM_ACT_ASSOCIATIONS
Subobject Name:
Status: VALID

This table Stores the association relationship between an EAM Activty
and the corresponding Asset/rebuildable item

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_EAM_ACT_ASSOCIATIONS_N1 NORMAL NONUNIQUE Tablespace ColumnSR_INSTANCE_ID
ColumnASSET_ACTIVITY_ID
ColumnORGANIZATION_ID
MSC_EAM_ACT_ASSOCIATIONS_N2 NORMAL NONUNIQUE Tablespace ColumnSR_INSTANCE_ID
ColumnASSET_REBUILD_ITEM_ID
ColumnORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
SR_INSTANCE_ID NUMBER
Yes Instance id
ASSET_ACTIVITY_ID NUMBER
Yes Inv Item Id of Activity item
ORGANIZATION_ID NUMBER
Yes Org Id
ACTIVITY VARCHAR2 (40)
Activity Name
ASSET_REBUILD_ITEM_ID NUMBER
Yes Inv Item Id of Asset Group or Rebuild Item
ACTIVITY_TYPE VARCHAR2 (40)
Activity Type
ASSET_REBUILD_GROUP VARCHAR2 (40) Yes Asset group/Rebuild Item
EAM_ITEM_TYPE NUMBER

EAM Item Type
REFRESH_NUMBER NUMBER
Yes ODS LOAD CYCLE ID
LAST_UPDATE_DATE DATE
Yes STANDARD WHO COLUMN
LAST_UPDATED_BY NUMBER
Yes STANDARD WHO COLUMN
CREATION_DATE DATE
Yes STANDARD WHO COLUMN
CREATED_BY NUMBER
Yes STANDARD WHO COLUMN
LAST_UPDATE_LOGIN NUMBER

STANDARD WHO COLUMN
Query Text

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


SELECT SR_INSTANCE_ID
,      ASSET_ACTIVITY_ID
,      ORGANIZATION_ID
,      ACTIVITY
,      ASSET_REBUILD_ITEM_ID
,      ACTIVITY_TYPE
,      ASSET_REBUILD_GROUP
,      EAM_ITEM_TYPE
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM MSC.MSC_EAM_ACT_ASSOCIATIONS;

Dependencies

[top of page]

MSC.MSC_EAM_ACT_ASSOCIATIONS does not reference any database object

MSC.MSC_EAM_ACT_ASSOCIATIONS is referenced by following:

SchemaMSC
ViewMSC_EAM_ACT_ASSOCIATIONS#