APPS.MSC_NET_RES_INST_AVAILABILITY dependencies on MSC_RES_INSTANCE_CHANGES

Line 277: msc_res_instance_changes changes,

273: dates.shift_date,
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

Line 789: FROM msc_res_instance_changes changes

785: var_gt_application,
786: var_gt_conc_program,
787: sysdate,
788: arg_refresh_number
789: FROM msc_res_instance_changes changes
790: WHERE changes.sr_instance_id = arg_sr_instance_id
791: AND changes.department_id = arg_department_id
792: AND changes.resource_id = arg_resource_id
793: and changes.res_instance_id = arg_instance_id

Line 855: AND exists (select * from msc_res_instance_changes chg

851: AND dept_res.resource_id = dept_ins.resource_id
852: /*
853: adding the following condition that the collection for the resource
854: instances for only there is any resource instance change */
855: AND exists (select * from msc_res_instance_changes chg
856: where dept_ins.department_id = chg.department_id
857: and dept_ins.resource_id = chg.resource_id
858: and dept_ins.sr_instance_id = chg.sr_instance_id
859: and dept_ins.res_instance_id = chg.res_instance_id

Line 877: msc_res_instance_changes res_ins

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
880: AND chg.sr_instance_id = dept_res.sr_instance_id
881: AND chg.refresh_number = arg_refresh_number