View: AMW_WF_PROCESSES_V

Product:	AMW - Internal Controls Manager
Description:	View to display the Workflow processes and their item types
Implementation/DBA Data:	APPS.AMW_WF_PROCESSES_V

View Text

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

Columns