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.MSC_RESOURCE_AVAILABILITY dependencies on MSC_RESOURCE_CHANGES

Line 310: msc_resource_changes changes

306: dates.shift_date,
307: changes.shift_num,
308: changes.capacity_change
309: from msc_shift_dates dates,
310: msc_resource_changes changes
311: WHERE dates.calendar_code = v_calendar_code
312: AND dates.sr_instance_id = arg_sr_instance_id
313: AND dates.exception_set_id = v_calendar_exception_set_id
314: AND dates.seq_num is not null

Line 500: From MSC_RESOURCE_CHANGES

496: msc_resource_shifts res_shifts,
497: (select distinct department_id, resource_id,
498: sr_instance_id, simulation_set,
499: from_date, shift_num,action_type
500: From MSC_RESOURCE_CHANGES
501: where action_type = DELETE_WORKDAY ) changes --7705958
502: WHERE dates.calendar_code = v_calendar_code
503: AND dates.sr_instance_id = arg_sr_instance_id
504: AND dates.exception_set_id = v_calendar_exception_set_id

Line 531: FROM msc_resource_changes changes

527:
528: AND ( arg_simulation_set is null
529: OR NOT EXISTS
530: (SELECT NULL
531: FROM msc_resource_changes changes
532: WHERE changes.department_id = arg_department_id
533: AND changes.resource_id = arg_resource_id
534: AND changes.sr_instance_id = arg_sr_instance_id
535: AND changes.shift_num = dates.shift_num

Line 548: from MSC_RESOURCE_CHANGES changes,

544: SET capacity_units= 0
545: WHERE ROWID IN
546: ( select /*+ ordered index (nra MSC_NET_RESOURCE_AVAIL_U2 )*/
547: /* nra.ROWID
548: from MSC_RESOURCE_CHANGES changes,
549: MSC_NET_RESOURCE_AVAIL nra
550: WHERE changes.department_id = arg_department_id
551: AND changes.resource_id = arg_resource_id
552: AND changes.sr_instance_id = arg_sr_instance_id

Line 1164: FROM msc_resource_changes changes

1160: ,v_current_application
1161: ,v_current_conc_program
1162: ,MSC_CL_COLLECTION.v_current_date
1163: ,arg_refresh_number
1164: FROM msc_resource_changes changes
1165: WHERE changes.department_id = arg_department_id
1166: AND changes.resource_id = arg_resource_id
1167: AND changes.action_type = ADD_WORKDAY
1168: AND changes.simulation_set= arg_simulation_set

Line 1243: msc_resource_changes chg,

1239: dept_res.disable_date, --**
1240: org.calendar_code, --**
1241: org.calendar_exception_set_id --**
1242: FROM msc_trading_partners org,
1243: msc_resource_changes chg,
1244: msc_department_resources dept_res
1245: WHERE chg.department_id = dept_res.department_id
1246: AND chg.resource_id = dept_res.resource_id
1247: AND chg.sr_instance_id = dept_res.sr_instance_id

Line 1433: msc_resource_changes chg,

1429: v_stmt := 100;
1430: delete from msc_net_resource_avail
1431: where rowid in (select res.rowid
1432: from msc_net_resource_avail res,
1433: msc_resource_changes chg,
1434: msc_department_resources dept
1435: where res.organization_id = arg_organization_id
1436: and res.sr_instance_id = arg_sr_instance_id
1437: and res.plan_id = -1