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: PER_RI_SETUP_SUB_TASKS_VL

Product:	PER - Human Resources
Description:	MLS view based on PER_RI_SETUP_SUB_TASKS table
Implementation/DBA Data:	APPS.PER_RI_SETUP_SUB_TASKS_VL

View Text

SELECT SST.SETUP_SUB_TASK_CODE
, SST.SETUP_TASK_CODE
, SST.SETUP_SUB_TASK_SEQUENCE
, SST.SETUP_SUB_TASK_STATUS
, SST.SETUP_SUB_TASK_TYPE
, SST.SETUP_SUB_TASK_DATA_PUMP_LINK
, SST.SETUP_SUB_TASK_ACTION
, SST.SETUP_SUB_TASK_CREATION_DATE
, SST.SETUP_SUB_TASK_LAST_MOD_DATE
, SST_TL.SETUP_SUB_TASK_NAME
, SST_TL.SETUP_SUB_TASK_DESCRIPTION
, SST.OBJECT_VERSION_NUMBER
, SST.LAST_UPDATE_DATE
, SST.LAST_UPDATED_BY
, SST.LAST_UPDATE_LOGIN
, SST.CREATED_BY
, SST.CREATION_DATE
, SST.LEGISLATION_CODE
FROM PER_RI_SETUP_SUB_TASKS SST
, PER_RI_SETUP_SUB_TASKS_TL SST_TL
WHERE SST.SETUP_SUB_TASK_CODE=SST_TL.SETUP_SUB_TASK_CODE
AND SST_TL.LANGUAGE=USERENV('LANG')

Columns

Name
SETUP_SUB_TASK_CODE
SETUP_TASK_CODE
SETUP_SUB_TASK_SEQUENCE
SETUP_SUB_TASK_STATUS
SETUP_SUB_TASK_TYPE
SETUP_SUB_TASK_DATA_PUMP_LINK
SETUP_SUB_TASK_ACTION
SETUP_SUB_TASK_CREATION_DATE
SETUP_TASK_LAST_MOD_DATE
SETUP_SUB_TASK_NAME
SETUP_SUB_TASK_DESCRIPTION
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
LEGISLATION_CODE