APPS.OE_HOLDS_PVT dependencies on WF_ITEMS

Line 373: wf_items wi

369: wf_process_activities wpa_to,
370: wf_activities wa,
371: wf_item_activity_statuses wias_from,
372: wf_activity_transitions wat,
373: wf_items wi
374: WHERE wpa_to.instance_id= wias_to.process_activity
375: AND wat.to_process_activity = wpa_to.instance_id
376: AND wat.result_code = 'ON_HOLD'
377: AND wias_from.process_activity = wat.from_process_activity