VIEW: APPS.PER_RI_SETUP_SUB_TASKS_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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