VIEW: APPS.AMW_WF_HIERARCHY_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)