[Home] [Help] [Dependency Information]

TABLE: EAM.EAM_SUPPRESSION_RELATIONS

Object Details

Object Name:	EAM_SUPPRESSION_RELATIONS
Object Type:	TABLE
Owner:	EAM
FND Design Data:	EAM.EAM_SUPPRESSION_RELATIONS
Subobject Name:
Status:	VALID

This table stores preventive maintenance suppression rules and suppression templates. The parent activity suppresses the child activity. When tmpl_flag='Y', the row is a suppression template, and the parent_association_id and child_association_id refer to activity association templates in the mtl_eam_asset_activities table. When tmpl_flag='N' or is null, the row is a suppression rule, and the parent_association_id and child_association_id refer to asset activity associations in the mtl_eam_asset_activities table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_SUPPRESSION_RELATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARENT_ASSOCIATION_ID CHILD_ASSOCIATION_ID

Columns

Query Text

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

SELECT PARENT_ASSOCIATION_ID
,      CHILD_ASSOCIATION_ID
,      DAY_TOLERANCE
,      RUNTIME_TOLERANCE
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      TMPL_FLAG
FROM EAM.EAM_SUPPRESSION_RELATIONS;

Dependencies

[top of page]

EAM.EAM_SUPPRESSION_RELATIONS does not reference any database object

EAM.EAM_SUPPRESSION_RELATIONS is referenced by following:

EAM

EAM_SUPPRESSION_RELATIONS#