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

VIEW: ENG.ENG_CHANGE_ROUTE_ASSOCS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROUTE_ASSOCIATION_ID NUMBER
Yes
ROUTE_PEOPLE_ID NUMBER
Yes
ASSOC_OBJECT_NAME VARCHAR2 (30)
ASSOC_OBJ_PK1_VALUE VARCHAR2 (100)
ASSOC_OBJ_PK2_VALUE VARCHAR2 (100)
ASSOC_OBJ_PK3_VALUE VARCHAR2 (100)
ASSOC_OBJ_PK4_VALUE VARCHAR2 (100)
ASSOC_OBJ_PK5_VALUE VARCHAR2 (100)
ADHOC_ASSOC_FLAG VARCHAR2 (1) Yes
OBJECT_NAME VARCHAR2 (30) Yes
OBJECT_ID1 NUMBER

OBJECT_ID2 NUMBER

OBJECT_ID3 NUMBER

OBJECT_ID4 NUMBER

OBJECT_ID5 NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (50)
Query Text

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


SELECT ROUTE_ASSOCIATION_ID
,      ROUTE_PEOPLE_ID
,      ASSOC_OBJECT_NAME
,      ASSOC_OBJ_PK1_VALUE
,      ASSOC_OBJ_PK2_VALUE
,      ASSOC_OBJ_PK3_VALUE
,      ASSOC_OBJ_PK4_VALUE
,      ASSOC_OBJ_PK5_VALUE
,      ADHOC_ASSOC_FLAG
,      OBJECT_NAME
,      OBJECT_ID1
,      OBJECT_ID2
,      OBJECT_ID3
,      OBJECT_ID4
,      OBJECT_ID5
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      ORIGINAL_SYSTEM_REFERENCE
FROM ENG.ENG_CHANGE_ROUTE_ASSOCS#;

Dependencies

[top of page]

ENG.ENG_CHANGE_ROUTE_ASSOCS# references the following:

SchemaENG
TableENG_CHANGE_ROUTE_ASSOCS
ENG.ENG_CHANGE_ROUTE_ASSOCS# is referenced by following:

SchemaAPPS
SynonymENG_CHANGE_ROUTE_ASSOCS