DBA Data[Home] [Help]

APPS.MSC_NET_RES_INST_AVAILABILITY dependencies on MSC_SHIFT_DATES

Line 276: from msc_shift_dates dates,

272: changes.to_time),
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

Line 431: FROM msc_shift_dates dates,

427: var_gt_application,
428: var_gt_conc_program,
429: sysdate,
430: arg_refresh_number
431: FROM msc_shift_dates dates,
432: msc_shift_times shifts,
433: msc_resource_shifts res_shifts,
434: msc_department_resources dept_res1,
435: msc_dept_res_instances dept_ins,