APPS.OE_LINE_UTIL dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 17546: WF_ITEM_ACTIVITY_STATUSES WIAS

17542: l_ctr NUMBER;
17543:
17544: CURSOR ship_authorize IS
17545: SELECT 'Y' from
17546: WF_ITEM_ACTIVITY_STATUSES WIAS
17547: , WF_PROCESS_ACTIVITIES WPA
17548: where WIAS.item_type = 'OEOL'
17549: AND WIAS.item_key = to_char(p_x_line_rec.line_id)
17550: AND WIAS.activity_status = 'NOTIFIED'

Line 17829: from wf_item_activity_statuses s,

17825:
17826: IF nvl(p_x_line_rec.cancelled_flag,'N') = 'Y' THEN
17827: oe_debug_pub.add(' Line is cancelled, Close_Line WF act is ? ');
17828: select count(*) into l_close_act_complete
17829: from wf_item_activity_statuses s,
17830: wf_process_activities p
17831: where s.process_activity = p.instance_id
17832: and s.item_type = 'OEOL'
17833: and s.item_key = to_char(p_x_line_rec.line_id)

Line 22587: FROM wf_item_activity_statuses wias,

22583:
22584: BEGIN
22585: SELECT ACTIVITY_STATUS
22586: INTO l_activity_status_code
22587: FROM wf_item_activity_statuses wias,
22588: wf_process_activities wpa
22589: WHERE wias.item_type = 'OEOL'
22590: AND wias.item_key = to_char(p_link_to_line_id)
22591: AND wias.process_activity = wpa.instance_id