VIEW: ENG.ENG_CHANGE_ROUTE_ASSOCS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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