Skip to content

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

VIEW: ENG.ENG_RELATIONSHIP_CHANGES#

Object Details
Object Name: ENG_RELATIONSHIP_CHANGES#
Object Type: VIEW
Owner: ENG
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RELATIONSHIP_CHANGES_SEQ_ID NUMBER
Yes
CHANGE_ID NUMBER
Yes
ENTITY_ID NUMBER
Yes
ENTITY_NAME VARCHAR2 (40)
ACTION VARCHAR2 (40)
FROM_ENTITY_NAME VARCHAR2 (40)
FROM_PK1_VALUE VARCHAR2 (100)
FROM_PK2_VALUE VARCHAR2 (100)
FROM_PK3_VALUE VARCHAR2 (100)
FROM_PK4_VALUE VARCHAR2 (100)
FROM_PK5_VALUE VARCHAR2 (100)
TO_ENTITY_NAME VARCHAR2 (100)
TO_PK1_VALUE VARCHAR2 (240)
TO_PK2_VALUE VARCHAR2 (240)
TO_PK3_VALUE VARCHAR2 (240)
TO_PK4_VALUE VARCHAR2 (240)
TO_PK5_VALUE VARCHAR2 (240)
TO_CURRENT_VALUE VARCHAR2 (100)
RELATIONSHIP_CODE VARCHAR2 (100)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

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# references the following:

SchemaENG
TableENG_RELATIONSHIP_CHANGES
ENG.ENG_RELATIONSHIP_CHANGES# is referenced by following:

SchemaAPPS
SynonymENG_RELATIONSHIP_CHANGES