VIEW: ENG.ENG_CHANGE_ROUTE_PEOPLE#

Source

View Text - Preformatted

select ROUTE_PEOPLE_ID ROUTE_PEOPLE_ID, STEP_ID STEP_ID, ASSIGNEE_ID ASSIGNEE_ID, ASSIGNEE_TYPE_CODE ASSIGNEE_TYPE_CODE, ADHOC_PEOPLE_FLAG ADHOC_PEOPLE_FLAG, WF_NOTIFICATION_ID WF_NOTIFICATION_ID, RESPONSE_CODE RESPONSE_CODE, RESPONSE_DATE RESPONSE_DATE, 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, ORIGINAL_ASSIGNEE_ID ORIGINAL_ASSIGNEE_ID, ORIGINAL_ASSIGNEE_TYPE_CODE ORIGINAL_ASSIGNEE_TYPE_CODE, RESPONSE_CONDITION_CODE RESPONSE_CONDITION_CODE, PARENT_ROUTE_PEOPLE_ID PARENT_ROUTE_PEOPLE_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "ENG"."ENG_CHANGE_ROUTE_PEOPLE"

View Text - HTML Formatted

SELECT ROUTE_PEOPLE_ID ROUTE_PEOPLE_ID
, STEP_ID STEP_ID
, ASSIGNEE_ID ASSIGNEE_ID
, ASSIGNEE_TYPE_CODE ASSIGNEE_TYPE_CODE
, ADHOC_PEOPLE_FLAG ADHOC_PEOPLE_FLAG
, WF_NOTIFICATION_ID WF_NOTIFICATION_ID
, RESPONSE_CODE RESPONSE_CODE
, RESPONSE_DATE RESPONSE_DATE
, 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
, ORIGINAL_ASSIGNEE_ID ORIGINAL_ASSIGNEE_ID
, ORIGINAL_ASSIGNEE_TYPE_CODE ORIGINAL_ASSIGNEE_TYPE_CODE
, RESPONSE_CONDITION_CODE RESPONSE_CONDITION_CODE
, PARENT_ROUTE_PEOPLE_ID PARENT_ROUTE_PEOPLE_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "ENG"."ENG_CHANGE_ROUTE_PEOPLE"