APPS.MSC_NET_RES_INST_AVAILABILITY dependencies on MSC_RESOURCE_CHANGES

Line 278: msc_resource_changes reschanges,

274: changes.shift_num,
275: reschanges.capacity_change
276: from msc_shift_dates dates,
277: msc_res_instance_changes changes,
278: msc_resource_changes reschanges,
279: msc_trading_partners param
280: WHERE dates.calendar_code = param.calendar_code
281: AND dates.exception_set_id = param.calendar_exception_set_id
282: AND dates.sr_instance_id = param.sr_instance_id

Line 468: FROM msc_resource_changes changes

464: AND dept_ins.plan_id = -1
465: AND nvl(dept_ins.serial_number,-1) = nvl(arg_serial_num, -1)
466: AND NOT EXISTS
467: (SELECT NULL
468: FROM msc_resource_changes changes
469: WHERE changes.sr_instance_id = dept_res1.sr_instance_id
470: AND changes.department_id = dept_res1.department_id
471: AND changes.resource_id = dept_res1.resource_id
472: AND changes.simulation_set = arg_simulation_set

Line 875: msc_resource_changes chg,

871: dept_res.disable_date --, --**
872: --org.calendar_code, --**
873: -- org.calendar_exception_set_id --**
874: FROM msc_trading_partners org,
875: msc_resource_changes chg,
876: msc_department_resources dept_res,
877: msc_res_instance_changes res_ins
878: WHERE chg.department_id = dept_res.department_id
879: AND chg.resource_id = dept_res.resource_id

Line 1076: msc_resource_changes chg,

1072:
1073: delete from msc_net_res_inst_avail
1074: where rowid in (select res.rowid
1075: from msc_net_res_inst_avail res,
1076: msc_resource_changes chg,
1077: msc_department_resources dept
1078: where res.organization_id = arg_organization_id
1079: and res.sr_instance_id = arg_sr_instance_id
1080: and res.plan_id = -1