APPS.MSC_NET_RES_INST_AVAILABILITY dependencies on MSC_TRADING_PARTNERS

Line 43: ,msc_trading_partners tp

39: --v_stmt := 10;
40: select TRUNC(MIN(calendar_date))
41: into v_start_date
42: from msc_calendar_dates cal
43: ,msc_trading_partners tp
44: where tp.sr_tp_id = arg_organization_id
45: and tp.sr_instance_id = arg_sr_instance_id
46: and tp.partner_type = 3
47: and cal.calendar_code = tp.calendar_code

Line 72: ,msc_trading_partners tp

68: --v_stmt := 20;
69: select TRUNC(MAX(calendar_date))
70: into v_cutoff_date
71: from msc_calendar_dates cal
72: ,msc_trading_partners tp
73: where tp.sr_tp_id = arg_organization_id
74: and tp.sr_instance_id = arg_sr_instance_id
75: and tp.partner_type = 3
76: and cal.calendar_code = tp.calendar_code

Line 279: msc_trading_partners param

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
283: AND dates.sr_instance_id = arg_sr_instance_id

Line 436: msc_trading_partners param

432: msc_shift_times shifts,
433: msc_resource_shifts res_shifts,
434: msc_department_resources dept_res1,
435: msc_dept_res_instances dept_ins,
436: msc_trading_partners param
437: WHERE dates.calendar_code = param.calendar_code
438: AND dates.exception_set_id = param.calendar_exception_set_id
439: AND dates.sr_instance_id = param.sr_instance_id
440: AND dates.sr_instance_id = arg_sr_instance_id

Line 552: msc_trading_partners param

548: arg_refresh_number
549: FROM msc_calendar_dates dates,
550: msc_department_resources dept_res1,
551: msc_dept_res_instances dept_ins,
552: msc_trading_partners param
553: WHERE dates.calendar_code = param.calendar_code
554: AND dates.exception_set_id = param.calendar_exception_set_id
555: AND dates.sr_instance_id = param.sr_instance_id
556: AND dates.sr_instance_id = arg_sr_instance_id

Line 834: FROM msc_trading_partners org,

830: NVL(dept_res.capacity_units,1), --**
831: dept_res.disable_date --, --**
832: --org.calendar_code, --**
833: -- org.calendar_exception_set_id --**
834: FROM msc_trading_partners org,
835: msc_department_resources dept_res,
836: msc_dept_res_instances dept_ins
837: WHERE dept_res.owning_department_id = dept_res.department_id
838: AND dept_res.plan_id = -1

Line 874: FROM msc_trading_partners org,

870: NVL(dept_res.capacity_units,1), --**
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