eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on BOM_DEPARTMENT_RESOURCES

Line 523: bom_department_resources dept_res,

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,
526: mrp_form_query list
527: WHERE (shifts.calendar_code is NULL OR

Line 648: bom_department_resources dept_res,

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

Line 1459: bom_department_resources dept_res,

1455: v_resource_type_code,
1456: v_res_grp_name
1457: FROM mfg_lookups lkps,
1458: bom_resources res,
1459: bom_department_resources dept_res,
1460: bom_departments dept
1461: WHERE lkps.lookup_type(+) = 'BOM_RESOURCE_TYPE'
1462: AND lkps.lookup_code(+) = res.resource_type
1463: AND res.resource_id = p_res_id