DBA Data[Home] [Help]

APPS.OE_1024PC1_ORDER_HDRINVC dependencies on OE_AK_ORDER_HEADERS_V

Line 22: ,OE_AK_ORDER_HEADERS_V a

18: l_wf_activity_status_code varchar2(8) :='COMPLETE';
19: CURSOR C_VC IS
20: SELECT count(*)
21: FROM wf_item_activity_statuses w, wf_process_activities wpa
22: ,OE_AK_ORDER_HEADERS_V a
23: WHERE w.item_type = l_wf_item_type
24: AND w.process_activity = wpa.instance_id
25: AND wpa.activity_name = l_wf_activity_name
26: AND w.activity_status = l_wf_activity_status_code