Product: | ENG - Engineering |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ENG_CHANGE_ROUTE_PEOPLE_VL |
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')