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: ENG.ENG_RELATIONSHIP_CHANGES

Object Details

Object Name:	ENG_RELATIONSHIP_CHANGES
Object Type:	TABLE
Owner:	ENG
FND Design Data:	ENG.ENG_RELATIONSHIP_CHANGES
Subobject Name:
Status:	VALID

Stores related entity information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ENG_RELATIONSHIP_CHANGES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RELATIONSHIP_CHANGES_SEQ_ID
ENG_RELATIONSHIP_CHANGES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHANGE_ID ENTITY_ID
ENG_RELATIONSHIP_CHANGES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RELATIONSHIP_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
RELATIONSHIP_CHANGES_SEQ_ID	NUMBER		Yes	Internal Id of the related entity table
CHANGE_ID	NUMBER		Yes	Internal id of the change order
ENTITY_ID	NUMBER		Yes	Internal Id of the entity
ENTITY_NAME	VARCHAR2	(40)		Name of the entity
ACTION	VARCHAR2	(40)		Action type
FROM_ENTITY_NAME	VARCHAR2	(40)		From entity name
FROM_PK1_VALUE	VARCHAR2	(100)		Primary Key1 of the from entity
FROM_PK2_VALUE	VARCHAR2	(100)		Primary Key2 of the from entity
FROM_PK3_VALUE	VARCHAR2	(100)		Primary Key3 of the from entity if any
FROM_PK4_VALUE	VARCHAR2	(100)		Primary Key4 of the from entity if any
FROM_PK5_VALUE	VARCHAR2	(100)		Primary Key5 of the from entity if any
TO_ENTITY_NAME	VARCHAR2	(100)		The related entity name
TO_PK1_VALUE	VARCHAR2	(240)		Primary key1 of the related entity
TO_PK2_VALUE	VARCHAR2	(240)		Primary key2 of the related entity if any
TO_PK3_VALUE	VARCHAR2	(240)		Primary key3 of the related entity if any
TO_PK4_VALUE	VARCHAR2	(240)		Primary key4 of the related entity if any
TO_PK5_VALUE	VARCHAR2	(240)		Primary key5 of the related entity if any
TO_CURRENT_VALUE	VARCHAR2	(100)		Current revision of the related entity
RELATIONSHIP_CODE	VARCHAR2	(100)		Relationship code of the entity
CREATED_BY	NUMBER		Yes	Standard WHO columns
CREATION_DATE	DATE		Yes	Standard WHO columns
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO columns
LAST_UPDATE_LOGIN	NUMBER			Standard WHO columns
ASSOCIATION_ID	NUMBER		Yes

Query Text

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


SELECT RELATIONSHIP_CHANGES_SEQ_ID
,      CHANGE_ID
,      ENTITY_ID
,      ENTITY_NAME
,      ACTION
,      FROM_ENTITY_NAME
,      FROM_PK1_VALUE
,      FROM_PK2_VALUE
,      FROM_PK3_VALUE
,      FROM_PK4_VALUE
,      FROM_PK5_VALUE
,      TO_ENTITY_NAME
,      TO_PK1_VALUE
,      TO_PK2_VALUE
,      TO_PK3_VALUE
,      TO_PK4_VALUE
,      TO_PK5_VALUE
,      TO_CURRENT_VALUE
,      RELATIONSHIP_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ASSOCIATION_ID
FROM ENG.ENG_RELATIONSHIP_CHANGES;

Dependencies

[top of page]

ENG.ENG_RELATIONSHIP_CHANGES does not reference any database object

ENG.ENG_RELATIONSHIP_CHANGES is referenced by following:

APPS: ENG_RELATIONSHIP_CHANGES