DBA Data[Home] [Help]

APPS.EAM_COMPLETION dependencies on WIP_EAM_PERIOD_BALANCES

Line 1199: FROM WIP_EAM_PERIOD_BALANCES

1195: --Find the total estimated cost of workorder
1196: BEGIN
1197: SELECT NVL((SUM(system_estimated_mat_cost) + SUM(system_estimated_lab_cost) + SUM(system_estimated_eqp_cost)),0)
1198: INTO l_cost_estimate
1199: FROM WIP_EAM_PERIOD_BALANCES
1200: WHERE wip_entity_id =x_wip_entity_id;
1201: EXCEPTION
1202: WHEN NO_DATA_FOUND THEN
1203: l_cost_estimate := 0;