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)