eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: EAM.EAM_WO_RELATIONSHIPS

Object Details

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

EAM work order Relationships table is used for holding four types of relations in EAM. They are - Scheduling Child, Costing Child, End to Start Dependency, and Follow up work order.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EAM_WO_RELATIONSHIPS_N4	NORMAL	UNIQUE	APPS_TS_TX_IDX	WO_RELATIONSHIP_ID
EAM_WO_RELATIONSHIPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_OBJECT_ID PARENT_OBJECT_TYPE_ID PARENT_RELATIONSHIP_TYPE
EAM_WO_RELATIONSHIPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHILD_OBJECT_ID CHILD_OBJECT_TYPE_ID PARENT_RELATIONSHIP_TYPE
EAM_WO_RELATIONSHIPS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TOP_LEVEL_OBJECT_ID TOP_LEVEL_OBJECT_TYPE_ID

Columns

Name	Datatype	Mandatory	Comments
WO_RELATIONSHIP_ID	NUMBER	Yes	Work order relationship identifier key
PARENT_OBJECT_ID	NUMBER	Yes	Object identifier of the parent in the relationship
PARENT_OBJECT_TYPE_ID	NUMBER	Yes	Object type of the parent in the relationship
CHILD_OBJECT_ID	NUMBER	Yes	Object identifier of the child in the relationship
CHILD_OBJECT_TYPE_ID	NUMBER	Yes	Object type of the child in the relationship
PARENT_RELATIONSHIP_TYPE	NUMBER	Yes	Type of relationship between the entities
RELATIONSHIP_STATUS	NUMBER		Status of relationship between work orders
CREATED_BY	NUMBER	Yes	Created By
CREATION_DATE	DATE	Yes	Creation date
LAST_UPDATED_BY	NUMBER	Yes	Last Updated By
LAST_UPDATE_DATE	DATE	Yes	Last Update Date
TOP_LEVEL_OBJECT_ID	NUMBER		Identifier of object at upper end of hierarchy
TOP_LEVEL_OBJECT_TYPE_ID	NUMBER		Type identifier of object at upper end of hierarchy

Query Text

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


SELECT WO_RELATIONSHIP_ID
,      PARENT_OBJECT_ID
,      PARENT_OBJECT_TYPE_ID
,      CHILD_OBJECT_ID
,      CHILD_OBJECT_TYPE_ID
,      PARENT_RELATIONSHIP_TYPE
,      RELATIONSHIP_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      TOP_LEVEL_OBJECT_ID
,      TOP_LEVEL_OBJECT_TYPE_ID
FROM EAM.EAM_WO_RELATIONSHIPS;

Dependencies

[top of page]

EAM.EAM_WO_RELATIONSHIPS does not reference any database object

EAM.EAM_WO_RELATIONSHIPS is referenced by following:

EAM: EAM_WO_RELATIONSHIPS#