VIEW: APPS.ENG_CHANGE_ROUTE_PEOPLE_VL

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')