DBA Data[Home] [Help]

APPS.MRP_REPORT_INV_TURNS dependencies on MRP_SCHEDULE_DATES

Line 434: FROM mrp_schedule_dates dates,

430: UPDATE mrp_form_query query
431: SET number8 =
432: (SELECT NVL(SUM(dates.schedule_quantity * cst.item_cost), 0)
433: / 1000
434: FROM mrp_schedule_dates dates,
435: cst_item_costs cst,
436: mrp_system_items sys,
437: mrp_schedule_designators sched
438: WHERE cst.organization_id = sys.organization_id

Line 480: mrp_schedule_dates dates,

476: NVL(SUM(cst.item_cost
477: * dates.repetitive_daily_rate), 0)
478: / 1000
479: FROM bom_calendar_dates cal,
480: mrp_schedule_dates dates,
481: cst_item_costs cst,
482: mrp_system_items sys,
483: mrp_schedule_designators sched
484: WHERE cst.organization_id = sys.organization_id

Line 564: mrp_schedule_dates dates,

560: * NVL(dates.repetitive_daily_rate,
561: dates.schedule_quantity)), 0) / 1000
562: INTO past_due_master_schedule
563: FROM bom_calendar_dates cal,
564: mrp_schedule_dates dates,
565: cst_item_costs cst,
566: mrp_system_items sys,
567: mrp_schedule_designators sched
568: WHERE cst.organization_id = sys.organization_id