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.

VIEW: APPS.WF_RUNNABLE_PROCESSES_V

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)