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 519: FROM msc_resource_changes changes

515:
516: AND ( arg_simulation_set is null
517: OR NOT EXISTS
518: (SELECT NULL
519: FROM msc_resource_changes changes
520: WHERE changes.department_id = arg_department_id
521: AND changes.resource_id = arg_resource_id
522: AND changes.sr_instance_id = arg_sr_instance_id
523: AND changes.shift_num = dates.shift_num

Line 536: from MSC_RESOURCE_CHANGES changes,

532: SET capacity_units= 0
533: WHERE ROWID IN
534: ( select /*+ ordered index (nra MSC_NET_RESOURCE_AVAIL_U2 )*/
535: nra.ROWID
536: from MSC_RESOURCE_CHANGES changes,
537: MSC_NET_RESOURCE_AVAIL nra
538: WHERE changes.department_id = arg_department_id
539: AND changes.resource_id = arg_resource_id
540: AND changes.sr_instance_id = arg_sr_instance_id

Line 1152: FROM msc_resource_changes changes

1148: ,v_current_application
1149: ,v_current_conc_program
1150: ,MSC_CL_COLLECTION.v_current_date
1151: ,arg_refresh_number
1152: FROM msc_resource_changes changes
1153: WHERE changes.department_id = arg_department_id
1154: AND changes.resource_id = arg_resource_id
1155: AND changes.action_type = ADD_WORKDAY
1156: AND changes.simulation_set= arg_simulation_set

Line 1231: msc_resource_changes chg,

1227: dept_res.disable_date, --**
1228: org.calendar_code, --**
1229: org.calendar_exception_set_id --**
1230: FROM msc_trading_partners org,
1231: msc_resource_changes chg,
1232: msc_department_resources dept_res
1233: WHERE chg.department_id = dept_res.department_id
1234: AND chg.resource_id = dept_res.resource_id
1235: AND chg.sr_instance_id = dept_res.sr_instance_id

Line 1421: msc_resource_changes chg,

1417: v_stmt := 100;
1418: delete from msc_net_resource_avail
1419: where rowid in (select res.rowid
1420: from msc_net_resource_avail res,
1421: msc_resource_changes chg,
1422: msc_department_resources dept
1423: where res.organization_id = arg_organization_id
1424: and res.sr_instance_id = arg_sr_instance_id
1425: and res.plan_id = -1