FND Design Data [Home] [Help]

View: WF_RUNNABLE_PROCESSES_V

Product: FND - Application Object Library
Description: All runnable processes
Implementation/DBA Data: ViewAPPS.WF_RUNNABLE_PROCESSES_V
View Text

SELECT WFA_ACT.ITEM_TYPE ITEM_TYPE
, WFA_ACT.NAME PROCESS_NAME
, WFA_ACT.DISPLAY_NAME DISPLAY_NAME
FROM WF_ACTIVITIES_VL WFA_ACT
WHERE WFA_ACT.RUNNABLE_FLAG = 'Y'
AND WFA_ACT.TYPE = 'PROCESS'
AND SYSDATE BETWEEN WFA_ACT.BEGIN_DATE
AND NVL(WFA_ACT.END_DATE
, SYSDATE)

Columns

Name
ITEM_TYPE
PROCESS_NAME
DISPLAY_NAME