APPS.MRP_EPI dependencies on MRP_BIS_INV_DETAIL

Line 78: DELETE FROM mrp_bis_inv_detail

74: FETCH PLAN_BOUNDS_C INTO l_plan_start_date, l_plan_end_date;
75: CLOSE PLAN_BOUNDS_C;
76:
77: l_cursor := 'DELETE STATEMENTS';
78: DELETE FROM mrp_bis_inv_detail
79: WHERE compile_designator = p_designator;
80:
81: DELETE FROM mrp_bis_plan_profit
82: WHERE compile_designator = p_designator;

Line 89: INSERT INTO mrp_bis_inv_detail

85: WHERE compile_designator = p_designator;
86:
87: l_cursor := 'INSERT STATEMENTS';
88: -- Insert a row to store the beginning inventory values
89: INSERT INTO mrp_bis_inv_detail
90: (compile_designator,
91: owning_org_id,
92: organization_id,
93: schedule_designator,

Line 158: INSERT INTO mrp_bis_inv_detail

154:
155: commit work;
156: FOR plan_dates_rec IN plan_dates_c(l_plan_start_date, l_plan_end_date)
157: LOOP
158: INSERT INTO mrp_bis_inv_detail
159: (compile_designator,
160: owning_org_id,
161: organization_id,
162: schedule_designator,

Line 195: mrp_bis_inv_detail inv

191: sysdate,
192: 1
193: FROM mrp_schedule_dates dates,
194: mrp_system_items sys,
195: mrp_bis_inv_detail inv
196: WHERE dates.rate_end_date IS NULL
197: AND dates.schedule_date(+)
198: between plan_dates_rec.start_date and plan_dates_rec.end_date
199: AND dates.schedule_level(+) = 3

Line 236: mrp_bis_inv_detail inv

232: 1
233: FROM bom_calendar_dates cal,
234: mtl_parameters mtl,
235: mrp_schedule_dates dates,
236: mrp_bis_inv_detail inv
237: WHERE cal.calendar_date BETWEEN dates.schedule_date AND dates.rate_end_date
238: AND dates.rate_end_date is not null
239: AND cal.calendar_date
240: between plan_dates_rec.start_date and plan_dates_rec.end_date