FND Design Data [Home] [Help]

View: AMW_WF_PROCESSES_V

Product: AMW - Internal Controls Manager (Obsolete)
Description: View to display the Workflow processes and their item types
Implementation/DBA Data: Not implemented in this database
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

Name
DISPLAY_NAME
NAME
ITEM_TYPE