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_RESOURCE_CHANGES

Line 583: bom_resource_changes brc,

579: (DECODE(LEAST(NVL(brc.from_time, 0), NVL(brc.to_time, 1)),
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

Line 618: FROM bom_resource_changes brc2

614: AND list.number3 is not null
615: AND list.query_id = g_item_list_id
616: AND not exists
617: (SELECT 'Exists'
618: FROM bom_resource_changes brc2
619: WHERE brc2.department_id = brc.department_id
620: AND brc2.resource_id = brc.resource_id
621: AND brc2.shift_num = brc.shift_num
622: AND brc2.action_type = DELETE_WORK_DAY

Line 647: bom_resource_changes brc,

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,
651: mrp_form_query list