DBA Data[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on WF_ACTIVITIES_VL

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