DBA Data[Home] [Help]

APPS.OE_ORDER_WF_UTIL dependencies on WF_ACTIVITIES_VL

Line 3834: wf_activities_vl act

3830: CURSOR c_eligible_activity IS
3831: select pa.activity_name
3832: from wf_item_activity_statuses s,
3833: wf_process_activities pa, wf_lookups l,
3834: wf_activities_vl act
3835: where s.activity_status = l.lookup_code
3836: and l.lookup_type = l_wfeng_status
3837: and s.process_activity = pa.instance_id
3838: and pa.activity_item_type = act.item_type

Line 3842: from wf_activities_vl act2

3838: and pa.activity_item_type = act.item_type
3839: and pa.activity_name = act.name
3840: and pa.process_name <> l_root
3841: and act.version = (select max(version)
3842: from wf_activities_vl act2
3843: where act.item_type = act2.item_type
3844: and act.name = act2.name)
3845: and upper(s.activity_status) = l_eng_notified
3846: and s.item_type = l_oenh