eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AMW_WF_PROCESS_HIERARCHY_VL

Product:	AMW - Internal Controls Manager (Obsolete)
Description:	View for workflow process hierarchy
Implementation/DBA Data:	Not implemented in this database

View Text

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

Columns

Name
PROCESS_ITEM_TYPE
PROCESS_NAME
ACTIVITY_ITEM_TYPE
ACTIVITY_NAME
ACTIVITY_DISPLAY_NAME
ACTIVITY_DESCRIPTION
INSTANCE_ID