APPS.MSC_RESOURCE_AVAILABILITY dependencies on MSC_TRADING_PARTNERS

Line 70: ,msc_trading_partners tp

66: v_stmt := 10;
67: select TRUNC(MIN(calendar_date))
68: into v_start_date
69: from msc_calendar_dates cal
70: ,msc_trading_partners tp
71: where tp.sr_tp_id = arg_organization_id
72: and tp.sr_instance_id = arg_sr_instance_id
73: and tp.partner_type = 3
74: and cal.calendar_code = tp.calendar_code

Line 99: ,msc_trading_partners tp

95: v_stmt := 20;
96: select TRUNC(MAX(calendar_date))
97: into v_cutoff_date
98: from msc_calendar_dates cal
99: ,msc_trading_partners tp
100: where tp.sr_tp_id = arg_organization_id
101: and tp.sr_instance_id = arg_sr_instance_id
102: and tp.partner_type = 3
103: and cal.calendar_code = tp.calendar_code

Line 1204: FROM msc_trading_partners org,

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

Line 1230: FROM msc_trading_partners org,

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

Line 1637: msc_trading_partners org

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
1641: AND line.plan_id = -1

Line 1705: msc_trading_partners org

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
1709: AND line.plan_id = -1

Line 1794: lv_where_clause := ' AND ORGANIZATION_ID IN ( SELECT SR_TP_ID FROM MSC_TRADING_PARTNERS WHERE '||

1790: MSC_CL_COLLECTION.v_instance_id := pINSTANCE_ID;
1791:
1792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' Start date : '|| lv_start_date);
1793:
1794: lv_where_clause := ' AND ORGANIZATION_ID IN ( SELECT SR_TP_ID FROM MSC_TRADING_PARTNERS WHERE '||
1795: ' SR_INSTANCE_ID = '||MSC_CL_COLLECTION.v_instance_id ||
1796: ' AND ORGANIZATION_TYPE =1 ) ';
1797:
1798: -- log_debug('before delete of MSC_NET_RESOURCE_AVAIL debug0 ');

Line 1883: MSC_TRADING_PARTNERS mtp

1879: CURSOR c1 IS
1880: SELECT tp.Organization_ID
1881: FROM MSC_PARAMETERS tp,
1882: MSC_INSTANCE_ORGS ins_org,
1883: MSC_TRADING_PARTNERS mtp
1884: WHERE tp.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1885: AND ins_org.SR_INSTANCE_ID=tp.SR_INSTANCE_ID
1886: AND ins_org.Organization_ID=tp.ORGANIZATION_ID
1887: AND ins_org.ENABLED_FLAG= MSC_UTIL.SYS_YES

Line 2256: msc_trading_partners mtp

2252:
2253: CURSOR c_org_list IS
2254: select organization_id
2255: from msc_instance_orgs mio,
2256: msc_trading_partners mtp
2257: where mio.sr_instance_id= MSC_CL_COLLECTION.v_instance_id and
2258: mio.enabled_flag= 1 and
2259: ((MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (mio.org_group = MSC_CL_COLLECTION.v_coll_prec.org_group_flag)) and
2260: mio.sr_instance_id=mtp.sr_instance_id and