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_RHX_RESOURCE_AVAILABILITY dependencies on BOM_DEPARTMENT_RESOURCES

Line 235: bom_department_resources dept_res1,

231: var_gt_user_id
232: FROM bom_shift_dates dates,
233: bom_shift_times shifts,
234: bom_resource_shifts res_shifts,
235: bom_department_resources dept_res1,
236: mtl_parameters param
237: WHERE dates.calendar_code = param.calendar_code
238: AND dates.exception_set_id = param.calendar_exception_set_id
239: AND dates.shift_num = shifts.shift_num

Line 289: bom_department_resources dept_res1,

285: var_gt_user_id,
286: sysdate,
287: var_gt_user_id
288: FROM bom_calendar_dates dates,
289: bom_department_resources dept_res1,
290: mtl_parameters param
291: WHERE dates.calendar_code = param.calendar_code
292: AND dates.exception_set_id = param.calendar_exception_set_id
293: AND dates.calendar_date <= arg_cutoff_date

Line 680: from bom_department_resources dept_res,

676: cursor dept_res is
677: select dept_res.department_id,
678: dept_res.resource_id,
679: NVL(dept_res.available_24_hours_flag, 2)
680: from bom_department_resources dept_res,
681: bom_departments dept
682: where dept_res.department_id = dept.department_id
683: AND dept_res.share_from_dept_id is null
684: AND dept.organization_id = arg_organization_id;