VIEW: APPS.CN_CW_SETUP_TASKS_ALL_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_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 ,st.org_id FROM cn_cw_setup_tasks_all_b st, cn_cw_setup_tasks_all_tl st_tl WHERE st.setup_task_code=st_tl.setup_task_code and st_tl.language=userenv('LANG') and st.org_id = st_tl.org_id

View Text - HTML Formatted

SELECT ST.SETUP_TASK_CODE
, ST.WORKBENCH_ITEM_CODE
, ST.SETUP_TASK_SEQUENCE
, ST.SETUP_TASK_STATUS
, 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
, ST.ORG_ID
FROM CN_CW_SETUP_TASKS_ALL_B ST
, CN_CW_SETUP_TASKS_ALL_TL ST_TL
WHERE ST.SETUP_TASK_CODE=ST_TL.SETUP_TASK_CODE
AND ST_TL.LANGUAGE=USERENV('LANG')
AND ST.ORG_ID = ST_TL.ORG_ID