VIEW: APPS.AMW_WF_PROCESS_HIERARCHY_VL

Source

View Text - Preformatted

SELECT wpa.process_item_type, wpa.process_name, wpa.activity_item_type, wpa.activity_name, wa2_tl.display_name activity_display_name, wa2_tl.description activity_description, wpa.instance_id from wf_process_activities wpa, wf_activities wa1, wf_activities wa2, wf_activities_tl wa2_tl WHERE wpa.process_item_type=wa1.item_type and wpa.process_name=wa1.name and wpa.process_version=wa1.version and wa1.end_date is null and wpa.activity_item_type=wa2.item_type and wpa.activity_name=wa2.name and wa2.type='PROCESS' and wa2.end_date is null and wa2.name=wa2_tl.name and wa2.item_type=wa2_tl.item_type and wa2.version=wa2_tl.version and wa2_tl.language=userenv('LANG')

View Text - HTML Formatted

SELECT WPA.PROCESS_ITEM_TYPE
, WPA.PROCESS_NAME
, WPA.ACTIVITY_ITEM_TYPE
, WPA.ACTIVITY_NAME
, WA2_TL.DISPLAY_NAME ACTIVITY_DISPLAY_NAME
, WA2_TL.DESCRIPTION ACTIVITY_DESCRIPTION
, WPA.INSTANCE_ID
FROM WF_PROCESS_ACTIVITIES WPA
, WF_ACTIVITIES WA1
, WF_ACTIVITIES WA2
, WF_ACTIVITIES_TL WA2_TL
WHERE WPA.PROCESS_ITEM_TYPE=WA1.ITEM_TYPE
AND WPA.PROCESS_NAME=WA1.NAME
AND WPA.PROCESS_VERSION=WA1.VERSION
AND WA1.END_DATE IS NULL
AND WPA.ACTIVITY_ITEM_TYPE=WA2.ITEM_TYPE
AND WPA.ACTIVITY_NAME=WA2.NAME
AND WA2.TYPE='PROCESS'
AND WA2.END_DATE IS NULL
AND WA2.NAME=WA2_TL.NAME
AND WA2.ITEM_TYPE=WA2_TL.ITEM_TYPE
AND WA2.VERSION=WA2_TL.VERSION
AND WA2_TL.LANGUAGE=USERENV('LANG')