View: PER_RI_SETUP_TASKS_VL

Product:	PER - Human Resources
Description:	MLS View based on PER_RI_SETUP_TASKS table
Implementation/DBA Data:	APPS.PER_RI_SETUP_TASKS_VL

View Text

SELECT ST.SETUP_TASK_CODE
, ST.WORKBENCH_ITEM_CODE
, ST.SETUP_TASK_SEQUENCE
, ST.SETUP_TASK_STATUS
, ST.SETUP_TASK_CREATION_DATE
, ST.SETUP_TASK_LAST_MODIFIED_DATE
, ST.SETUP_TASK_TYPE
, ST.SETUP_TASK_ACTION
, ST_TL.SETUP_TASK_NAME
, ST_TL.SETUP_TASK_DESCRIPTION
, ST.OBJECT_VERSION_NUMBER
, ST.LAST_UPDATE_DATE
, ST.LAST_UPDATED_BY
, ST.LAST_UPDATE_LOGIN
, ST.CREATED_BY
, ST.CREATION_DATE
FROM PER_RI_SETUP_TASKS ST
, PER_RI_SETUP_TASKS_TL ST_TL
WHERE ST.SETUP_TASK_CODE=ST_TL.SETUP_TASK_CODE
AND ST_TL.LANGUAGE=USERENV('LANG')

Columns