APPS.MRP_EPI dependencies on MRP_SCHEDULE_DATES

Line 193: FROM mrp_schedule_dates dates,

189: sysdate,
190: 1,
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(+)

Line 235: mrp_schedule_dates dates,

231: sysdate,
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

Line 460: FROM mrp_schedule_dates dates,

456: mrp_item_cost(dates.inventory_item_id,
457: dates.organization_id)), 0)
458: / 1000
459: INTO revenue, cost
460: FROM mrp_schedule_dates dates,
461: mrp_system_items sys
462: WHERE dates.organization_id = sys.organization_id
463: AND dates.inventory_item_id = sys.inventory_item_id
464: AND dates.schedule_level = 3

Line 484: mrp_schedule_dates dates,

480: dates.organization_id)), 0)
481: / 1000
482: INTO revenue, cost
483: FROM bom_calendar_dates cal,
484: mrp_schedule_dates dates,
485: mrp_system_items sys,
486: mtl_parameters param
487: WHERE dates.organization_id = sys.organization_id
488: AND dates.inventory_item_id = sys.inventory_item_id

Line 1289: FROM mrp_schedule_dates

1285: p_item_id IN NUMBER, p_date IN DATE) RETURN NUMBER IS
1286:
1287: CURSOR MDS_C IS
1288: SELECT SUM(NVL(schedule_quantity,0))
1289: FROM mrp_schedule_dates
1290: WHERE schedule_designator = p_designator
1291: AND schedule_level = 3
1292: AND organization_id = p_org_id
1293: AND inventory_item_id = p_item_id