VIEW: APPS.ENG_WF_PROCESS_V

Source

View Text - Preformatted

SELECT wfa_act.name process_name ,wfa_act.display_name display_name FROM WF_ACTIVITIES_VL WFA_PROC, WF_PROCESS_ACTIVITIES WFPA, WF_ACTIVITIES_VL WFA_ACT WHERE WFA_PROC.NAME = 'ROOT' AND WFA_PROC.ITEM_TYPE = 'ECO_APP' AND WFA_PROC.ITEM_TYPE = WFPA.PROCESS_ITEM_TYPE AND WFA_PROC.NAME = WFPA.PROCESS_NAME AND WFA_PROC.END_DATE IS NULL AND WFPA.ACTIVITY_ITEM_TYPE = WFA_ACT.ITEM_TYPE AND WFPA.ACTIVITY_NAME = WFA_ACT.NAME AND WFA_PROC.VERSION = WFPA.PROCESS_VERSION AND WFA_ACT.END_DATE IS NULL

View Text - HTML Formatted

SELECT WFA_ACT.NAME PROCESS_NAME
, WFA_ACT.DISPLAY_NAME DISPLAY_NAME
FROM WF_ACTIVITIES_VL WFA_PROC
, WF_PROCESS_ACTIVITIES WFPA
, WF_ACTIVITIES_VL WFA_ACT
WHERE WFA_PROC.NAME = 'ROOT'
AND WFA_PROC.ITEM_TYPE = 'ECO_APP'
AND WFA_PROC.ITEM_TYPE = WFPA.PROCESS_ITEM_TYPE
AND WFA_PROC.NAME = WFPA.PROCESS_NAME
AND WFA_PROC.END_DATE IS NULL
AND WFPA.ACTIVITY_ITEM_TYPE = WFA_ACT.ITEM_TYPE
AND WFPA.ACTIVITY_NAME = WFA_ACT.NAME
AND WFA_PROC.VERSION = WFPA.PROCESS_VERSION
AND WFA_ACT.END_DATE IS NULL