DBA Data[Home] [Help]

APPS.MRP_REPORT_INV_TURNS dependencies on BOM_CALENDAR_DATES

Line 344: bom_calendar_dates cal,

340: + NVL(cst.tl_material_overhead, 0)
341: + NVL(cst.tl_outside_processing, 0))), 0)
342: / 1000
343: FROM cst_item_costs cst,
344: bom_calendar_dates cal,
345: mrp_recommendations rec
346: WHERE cst.inventory_item_id = rec.inventory_item_id
347: AND cst.organization_id = rec.organization_id
348: AND ( cst.cost_type_id = arg_cost_type

Line 479: FROM bom_calendar_dates cal,

475: (SELECT query.number8 +
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

Line 563: FROM bom_calendar_dates cal,

559: SELECT NVL(SUM(cst.item_cost
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