DBA Data[Home] [Help]

APPS.EAM_FAILURESETS_PVT dependencies on WIP_DISCRETE_JOBS

Line 247: FROM wip_discrete_jobs wdj,

243: l_open_wo_exists := 0;
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)