APPS.EAM_FAILURESETS_PVT dependencies on EAM_WORK_ORDER_DETAILS

Line 248: eam_work_order_details ewod

244: IF (p_mode = 'D') THEN
245: SELECT count(1)
246: INTO l_open_wo_exists
247: FROM wip_discrete_jobs wdj,
248: eam_work_order_details ewod
249: WHERE (wdj.asset_group_id = p_association_rec.inventory_item_id
250: OR
251: wdj.rebuild_item_id = p_association_rec.inventory_item_id)
252: AND wdj.status_type NOT IN (4,5,7,12,14,15)