DBA Data[Home] [Help]

APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on BOM_SHIFT_TIMES

Line 521: FROM bom_shift_times shifts,

517: shifts.to_time) - shifts.from_time) *
518: (dept_res.capacity_units/3600) *
519: NVL(dept_res.utilization, 1.0) *
520: NVL(dept_res.efficiency, 1.0) ))
521: FROM bom_shift_times shifts,
522: bom_resource_shifts res_shifts,
523: bom_department_resources dept_res,
524: mtl_parameters param,
525: bom_calendar_dates cal,

Line 646: FROM bom_shift_times shifts,

642: -1 * SUM((DECODE(LEAST(shifts.to_time, shifts.from_time),
643: shifts.to_time, shifts.to_time + 24*3600,
644: shifts.to_time) - shifts.from_time) *
645: dept_res.capacity_units / 3600)
646: FROM bom_shift_times shifts,
647: bom_resource_changes brc,
648: bom_department_resources dept_res,
649: mrp_plan_organizations_v orgs,
650: mtl_parameters param,