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.

APPS.OE_ORDER_WF_UTIL dependencies on WF_ACTIVITIES

Line 3435: FROM wf_activities

3431:
3432: -- validate the p_process_name is ok
3433: SELECT NAME
3434: INTO l_valid_process
3435: FROM wf_activities
3436: WHERE item_type = p_item_type
3437: AND NAME = p_process_name
3438: AND runnable_flag = 'Y'
3439: AND end_date IS NULL;

Line 4986: wf_activities_vl act

4982: SELECT pa.activity_name
4983: FROM wf_item_activity_statuses s,
4984: wf_process_activities pa,
4985: wf_lookups l,
4986: wf_activities_vl act
4987: WHERE s.activity_status = l.lookup_code
4988: AND l.lookup_type = l_wfeng_status
4989: AND s.process_activity = pa.instance_id
4990: AND pa.activity_item_type = act.item_type

Line 4995: FROM wf_activities_vl act2

4991: AND pa.activity_name = act.NAME
4992: AND pa.process_name <> l_root
4993: AND act.VERSION =
4994: (SELECT MAX (VERSION)
4995: FROM wf_activities_vl act2
4996: WHERE act.item_type = act2.item_type
4997: AND act.NAME = act2.NAME)
4998: AND UPPER (s.activity_status) = l_eng_notified
4999: AND s.item_type = l_oenh