VIEW: APPS.AMW_WF_PROCESSES_V

Source

View Text - Preformatted

SELECT wa_tl.display_name, wa.name, wa.item_type from wf_activities wa, wf_activities_tl wa_tl WHERE wa.end_date is null and wa.name = wa_tl.name and wa.version = wa_tl.version and wa.item_type = wa_tl.item_type and wa.type = 'PROCESS' and wa_tl.language = USERENV('LANG')

View Text - HTML Formatted

SELECT WA_TL.DISPLAY_NAME
, WA.NAME
, WA.ITEM_TYPE
FROM WF_ACTIVITIES WA
, WF_ACTIVITIES_TL WA_TL
WHERE WA.END_DATE IS NULL
AND WA.NAME = WA_TL.NAME
AND WA.VERSION = WA_TL.VERSION
AND WA.ITEM_TYPE = WA_TL.ITEM_TYPE
AND WA.TYPE = 'PROCESS'
AND WA_TL.LANGUAGE = USERENV('LANG')