View: AMW_WF_HIERARCHY_V

Product:	AMW - Internal Controls Manager
Description:	This view returns the Details about Parent Child Process Hierarchy
Implementation/DBA Data:	APPS.AMW_WF_HIERARCHY_V

View Text

SELECT WPA.PROCESS_NAME
, WPA.PROCESS_ITEM_TYPE
, WPA.ACTIVITY_NAME
, WPA.ACTIVITY_ITEM_TYPE
FROM WF_PROCESS_ACTIVITIES WPA
, WF_ACTIVITIES WA
WHERE WPA.PROCESS_NAME = WA.NAME
AND WPA.PROCESS_VERSION = WA.VERSION
AND WPA.PROCESS_ITEM_TYPE = WA.ITEM_TYPE
AND WA.END_DATE IS NULL
AND WPA.PROCESS_ITEM_TYPE = 'AUDITMGR'
AND WPA.ACTIVITY_NAME NOT IN ('START'
, 'END')
AND EXISTS (SELECT 1
FROM WF_ACTIVITIES WA2
WHERE WPA.ACTIVITY_NAME = WA2.NAME
AND WPA.ACTIVITY_ITEM_TYPE = WA2.ITEM_TYPE
AND WA2.END_DATE IS NULL)

Columns