APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_DEPARTMENT_RESOURCES

Line 1205: msc_department_resources dept_res

1201: dept_res.disable_date, --**
1202: org.calendar_code, --**
1203: org.calendar_exception_set_id --**
1204: FROM msc_trading_partners org,
1205: msc_department_resources dept_res
1206: WHERE dept_res.owning_department_id = dept_res.department_id
1207: AND dept_res.plan_id = -1
1208: AND dept_res.resource_id <> -1
1209: AND dept_res.aggregate_resource_flag <> 1 -- if it's not aggregate

Line 1232: msc_department_resources dept_res

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
1236: AND chg.refresh_number = arg_refresh_number

Line 1422: msc_department_resources dept

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
1426: and res.department_id = chg.department_id

Line 1571: from msc_net_resource_avail res, msc_department_resources line

1567: if arg_refresh_flag = 2 then
1568: v_stmt := 110;
1569: delete from msc_net_resource_avail
1570: where rowid in (select res.rowid
1571: from msc_net_resource_avail res, msc_department_resources line
1572: where res.organization_id = line.organization_id
1573: and res.sr_instance_id = line.sr_instance_id
1574: and res.department_id = line.department_id
1575: and res.resource_id = -1

Line 1584: on msc_department_resources (line_flag, plan_id, sr_instance_id,

1580: and line.sr_instance_id = arg_sr_instance_id ) ;
1581: end if;
1582:
1583: /* 2201418 - Added hints to improve performance. Also defined a new index
1584: on msc_department_resources (line_flag, plan_id, sr_instance_id,
1585: organization_id) */
1586:
1587: INSERT into MSC_net_resource_avail(
1588: transaction_id,

Line 1636: msc_department_resources line,

1632: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1633: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1634: ,arg_refresh_number
1635: FROM msc_calendar_dates dates,
1636: msc_department_resources line,
1637: msc_trading_partners org
1638: WHERE line.organization_id = arg_organization_id
1639: AND line.sr_instance_id = arg_sr_instance_id
1640: AND line.line_flag = 1

Line 1704: msc_department_resources line,

1700: ,FND_GLOBAL.CONC_PROGRAM_ID /*PROGRAM_ID */
1701: ,SYSDATE /* PROGRAM_UPDATE_DATE */
1702: ,arg_refresh_number
1703: FROM
1704: msc_department_resources line,
1705: msc_trading_partners org
1706: WHERE line.organization_id = arg_organization_id
1707: AND line.sr_instance_id = arg_sr_instance_id
1708: AND line.line_flag = 1