DBA Data[Home] [Help]

APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on MRP_PLAN_ORGANIZATIONS_V

Line 584: mrp_plan_organizations_v orgs,

580: NVL(brc.to_time, 1), 24 * 3600 + NVL(brc.to_time, 1),
581: NVL(brc.to_time, 1)) - NVL(brc.from_TIME, 0)))/3600
582: FROM bom_calendar_dates dates,
583: bom_resource_changes brc,
584: mrp_plan_organizations_v orgs,
585: mtl_parameters param,
586: mrp_form_query list
587: WHERE dates.exception_set_id = param.calendar_exception_set_id
588: AND dates.calendar_code = param.calendar_code

Line 649: mrp_plan_organizations_v orgs,

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,
651: mrp_form_query list
652: WHERE shifts.calendar_code = param.calendar_code
653: AND shifts.shift_num = brc.shift_num