View: ENG_WF_PROCESS_V

Product:	ENG - Engineering
Description:	Lists of all root proceses for 'ECO_APP' item type
Implementation/DBA Data:	APPS.ENG_WF_PROCESS_V

View Text

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

Columns