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_RESOURCE_CHANGES

Line 148: bom_resource_changes changes,

144: dates.shift_date,
145: changes.shift_num,
146: changes.capacity_change
147: from bom_shift_dates dates,
148: bom_resource_changes changes,
149: mtl_parameters param
150: WHERE dates.calendar_code = param.calendar_code
151: AND dates.exception_set_id = param.calendar_exception_set_id
152: AND dates.seq_num is not null

Line 254: FROM bom_resource_changes changes

250: AND dept_res1.department_id = arg_department_id
251: AND param.organization_id = arg_organization_id
252: AND NOT EXISTS
253: (SELECT NULL
254: FROM bom_resource_changes changes
255: WHERE changes.department_id = dept_res1.department_id
256: AND changes.resource_id = dept_res1.resource_id
257: AND changes.shift_num = dates.shift_num
258: AND changes.from_date = dates.shift_date

Line 664: FROM bom_resource_changes changes

660: sysdate,
661: var_gt_user_id,
662: sysdate,
663: var_gt_user_id
664: FROM bom_resource_changes changes
665: WHERE changes.department_id = arg_department_id
666: AND changes.resource_id = arg_resource_id
667: AND changes.action_type = ADD_WORKDAY
668: AND changes.simulation_set= arg_simulation_set;