DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on WIP_EAM_PERIOD_BALANCES

Line 248: FROM WIP_EAM_PERIOD_BALANCES

244: --Find the total estimated cost of workorder
245: BEGIN
246: SELECT NVL((SUM(system_estimated_mat_cost) + SUM(system_estimated_lab_cost) + SUM(system_estimated_eqp_cost)),0)
247: INTO l_cost_estimate
248: FROM WIP_EAM_PERIOD_BALANCES
249: WHERE wip_entity_id = p_eam_wo_rec.wip_entity_id;
250: EXCEPTION
251: WHEN NO_DATA_FOUND THEN
252: l_cost_estimate := 0;

Line 11915: FROM WIP_EAM_PERIOD_BALANCES

11911: --Find the total estimated cost of workorder
11912: BEGIN
11913: SELECT NVL((SUM(system_estimated_mat_cost) + SUM(system_estimated_lab_cost) + SUM(system_estimated_eqp_cost)),0)
11914: INTO l_cost_estimate
11915: FROM WIP_EAM_PERIOD_BALANCES
11916: WHERE wip_entity_id = l_eam_wo_comp_rec.wip_entity_id;
11917: EXCEPTION
11918: WHEN NO_DATA_FOUND THEN
11919: l_cost_estimate := 0;