DBA Data[Home] [Help]

APPS.OE_INV_IFACE_CONC dependencies on WF_ITEM_ACTIVITY_STATUSES

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