APPS.MRP_EPI dependencies on MRP_BIS_RES_SUMMARY

Line 84: DELETE FROM mrp_bis_res_summary

80:
81: DELETE FROM mrp_bis_plan_profit
82: WHERE compile_designator = p_designator;
83:
84: DELETE FROM mrp_bis_res_summary
85: WHERE compile_designator = p_designator;
86:
87: l_cursor := 'INSERT STATEMENTS';
88: -- Insert a row to store the beginning inventory values

Line 1507: -- Insert summary records into mrp_bis_res_summary

1503: AND req.compile_designator = p_designator
1504: AND req.organization_id = p_org_id;
1505:
1506: -- ------------------------------------------------
1507: -- Insert summary records into mrp_bis_res_summary
1508: -- ------------------------------------------------
1509: INSERT INTO mrp_bis_res_summary
1510: (organization_id,
1511: compile_designator,

Line 1509: INSERT INTO mrp_bis_res_summary

1505:
1506: -- ------------------------------------------------
1507: -- Insert summary records into mrp_bis_res_summary
1508: -- ------------------------------------------------
1509: INSERT INTO mrp_bis_res_summary
1510: (organization_id,
1511: compile_designator,
1512: department_id,
1513: resource_id,

Line 1547: UPDATE mrp_bis_res_summary

1543: -- If available hours is zero, then
1544: -- utilization already shows as zero
1545: -- -----------------------------------
1546: /***
1547: UPDATE mrp_bis_res_summary
1548: SET utilization = required_hours/available_hours
1549: WHERE available_hours <> 0;
1550: ***/
1551: