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: WIP.WIP_SCHED_RELATIONSHIPS

Object Details

Object Name:	WIP_SCHED_RELATIONSHIPS
Object Type:	TABLE
Owner:	WIP
FND Design Data:	WIP.WIP_SCHED_RELATIONSHIPS
Subobject Name:
Status:	VALID

WIP_SCHED_RELATIONSHIPS table stores scheduling relationships between work orders. It captures the parent child relationship and dependency relationship between work orders. It is designed to be flexible to be able to capture other relationships in the future.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WIP_SCHED_RELATIONSHIPS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SCHED_RELATIONSHIP_ID
WIP_SCHED_RELATIONSHIPS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_OBJECT_ID PARENT_OBJECT_TYPE_ID RELATIONSHIP_TYPE
WIP_SCHED_RELATIONSHIPS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHILD_OBJECT_ID CHILD_OBJECT_TYPE_ID RELATIONSHIP_TYPE
WIP_SCHED_RELATIONSHIPS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TOP_LEVEL_OBJECT_ID TOP_LEVEL_OBJECT_TYPE_ID

Columns

Name	Datatype	Mandatory	Comments
SCHED_RELATIONSHIP_ID	NUMBER	Yes	Schedule Relationship Identification
PARENT_OBJECT_ID	NUMBER	Yes	The parent object identification
PARENT_OBJECT_TYPE_ID	NUMBER	Yes	The parent object type identification
CHILD_OBJECT_ID	NUMBER	Yes	The child object identification
CHILD_OBJECT_TYPE_ID	NUMBER	Yes	The child object type identification
RELATIONSHIP_TYPE	NUMBER	Yes	The type of relationship between parent object and child object
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
TOP_LEVEL_OBJECT_ID	NUMBER		The object identification of the root node in the tree structure. Mainly used for performance reasons.
TOP_LEVEL_OBJECT_TYPE_ID	NUMBER		The object type identification of the root node in the tree structure.
RELATIONSHIP_STATUS	NUMBER	Yes	Used to indicate the validity of the relationship (whether the relationship violates the structure definition).

Query Text

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


SELECT SCHED_RELATIONSHIP_ID
,      PARENT_OBJECT_ID
,      PARENT_OBJECT_TYPE_ID
,      CHILD_OBJECT_ID
,      CHILD_OBJECT_TYPE_ID
,      RELATIONSHIP_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TOP_LEVEL_OBJECT_ID
,      TOP_LEVEL_OBJECT_TYPE_ID
,      RELATIONSHIP_STATUS
FROM WIP.WIP_SCHED_RELATIONSHIPS;

Dependencies

[top of page]

WIP.WIP_SCHED_RELATIONSHIPS does not reference any database object

WIP.WIP_SCHED_RELATIONSHIPS is referenced by following:

WIP: WIP_SCHED_RELATIONSHIPS#