APPS.OE_INV_IFACE_CONC dependencies on WF_PROCESS_ACTIVITIES

Line 20: FROM wf_item_activity_statuses wias, wf_process_activities wpa

16:
17: -- Check for workflow status to be Inventory Interface Eligible
18: SELECT ACTIVITY_STATUS
19: INTO l_activity_status_code
20: FROM wf_item_activity_statuses wias, wf_process_activities wpa
21: WHERE wias.item_type = 'OEOL' AND
22: wias.item_key = to_char(p_line_id) AND
23: wias.process_activity = wpa.instance_id AND
24: wpa.activity_name = 'INVENTORY_INTERFACE_ELIGIBLE' AND

Line 113: From wf_item_activity_statuses wias, wf_process_activities wpa

109: --FOR UPDATE NOWAIT;
110:
111: CURSOR wf_item_inv IS -- /* Added for Bug 10213020 */
112: Select item_key
113: From wf_item_activity_statuses wias, wf_process_activities wpa
114: Where wias.item_type = 'OEOL'
115: And wias.process_activity = wpa.instance_id
116: And wpa.activity_name = 'INVENTORY_INTERFACE_ELIGIBLE'
117: And wias.activity_status = 'NOTIFIED';