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.

[Home] [Help]

View: ENG_CHANGE_ROUTE_PEOPLE_VL

Product:	ENG - Engineering
Description:
Implementation/DBA Data:	APPS.ENG_CHANGE_ROUTE_PEOPLE_VL

View Text

SELECT ECRP.ROWID ROW_ID
, ECRP.ROUTE_PEOPLE_ID
, ECRP.STEP_ID
, ECRP.ASSIGNEE_ID
, ECRP.ASSIGNEE_TYPE_CODE
, ECRP.ADHOC_PEOPLE_FLAG
, ECRPTL.RESPONSE_DESCRIPTION
, ECRP.WF_NOTIFICATION_ID
, ECRP.RESPONSE_CODE
, ECRP.RESPONSE_DATE
, ECRP.CREATION_DATE
, ECRP.CREATED_BY
, ECRP.LAST_UPDATE_DATE
, ECRP.LAST_UPDATED_BY
, ECRP.LAST_UPDATE_LOGIN
, ECRP.REQUEST_ID
, ECRP.PROGRAM_ID
, ECRP.PROGRAM_APPLICATION_ID
, ECRP.PROGRAM_UPDATE_DATE
, ECRP.ORIGINAL_SYSTEM_REFERENCE
, ECRP.ORIGINAL_ASSIGNEE_ID
, ECRP.ORIGINAL_ASSIGNEE_TYPE_CODE
, ECRP.RESPONSE_CONDITION_CODE
, ECRP.PARENT_ROUTE_PEOPLE_ID
FROM ENG_CHANGE_ROUTE_PEOPLE ECRP
, ENG_CHANGE_ROUTE_PEOPLE_TL ECRPTL
WHERE ECRP.ROUTE_PEOPLE_ID = ECRPTL.ROUTE_PEOPLE_ID
AND ECRPTL.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ROUTE_PEOPLE_ID
STEP_ID
ASSIGNEE_ID
ASSIGNEE_TYPE_CODE
ADHOC_PEOPLE_FLAG
RESPONSE_DESCRIPTION
WF_NOTIFICATION_ID
RESPONSE_CODE
RESPONSE_DATE
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
ORIGINAL_ASSIGNEE_ID
ORIGINAL_ASSIGNEE_TYPE_CODE
RESPONSE_CONDITION_CODE
PARENT_ROUTE_PEOPLE_ID