VIEW: APPS.PER_RI_SETUP_TASKS_VL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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