APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_COMPANY_SITES

Line 165: msc_company_sites cs,

161: dem.sr_instance_id --Partner Instance Id
162: from
163: msc_demands dem,
164: msc_system_items item,
165: msc_company_sites cs,
166: msc_company_sites cs1,
167: msc_companies c,
168: msc_companies c1,
169: msc_trading_partner_maps m,

Line 166: msc_company_sites cs1,

162: from
163: msc_demands dem,
164: msc_system_items item,
165: msc_company_sites cs,
166: msc_company_sites cs1,
167: msc_companies c,
168: msc_companies c1,
169: msc_trading_partner_maps m,
170: msc_trading_partner_maps m1,

Line 206: msc_company_sites pk:

202: 3 - Site
203:
204: MAP_TYPE + TP_KEY is unique for MAP_TYPE = 2
205:
206: msc_company_sites pk:
207: COMPANY_ID
208: COMPANY_SITE_ID
209:
210: msc_companies pk:

Line 402: msc_company_sites cs,

398: fcst.sr_instance_id --Partner Instance Id
399: from
400: msc_constrained_forecast_v fcst,
401: msc_system_items item,
402: msc_company_sites cs,
403: msc_company_sites cs1,
404: msc_companies c,
405: msc_companies c1,
406: msc_trading_partner_maps m,

Line 403: msc_company_sites cs1,

399: from
400: msc_constrained_forecast_v fcst,
401: msc_system_items item,
402: msc_company_sites cs,
403: msc_company_sites cs1,
404: msc_companies c,
405: msc_companies c1,
406: msc_trading_partner_maps m,
407: msc_trading_partner_maps m1,

Line 441: msc_company_sites pk:

437: 3 - Site
438:
439: MAP_TYPE + TP_KEY is unique for MAP_TYPE = 2
440:
441: msc_company_sites pk:
442: COMPANY_ID
443: COMPANY_SITE_ID
444:
445: msc_companies pk:

Line 1441: msc_company_sites cs

1437: BEGIN
1438: select cs.company_site_id
1439: into l_customer_site_id
1440: from msc_trading_partner_maps m,
1441: msc_company_sites cs
1442: where m.tp_key = p_source_customer_site_id and
1443: m.map_type = 3 and
1444: cs.company_site_id = m.company_key;
1445: EXCEPTION

Line 1464: msc_company_sites cs,

1460: sd.plan_id = -1 and
1461: sd.publisher_id = 1 and
1462: sd.publisher_site_id IN (select cs.company_site_id
1463: from msc_plan_organizations o,
1464: msc_company_sites cs,
1465: msc_trading_partner_maps m,
1466: msc_trading_partners p
1467: where o.plan_id = p_plan_id and
1468: p.sr_tp_id = nvl(p_org_id, o.organization_id) and

Line 1507: msc_company_sites cs,

1503: sd.plan_id = -1 and
1504: sd.publisher_id = 1 and
1505: sd.publisher_site_id IN (select cs.company_site_id
1506: from msc_plan_organizations o,
1507: msc_company_sites cs,
1508: msc_trading_partner_maps m,
1509: msc_trading_partners p
1510: where o.plan_id = p_plan_id and
1511: p.sr_tp_id = nvl(p_org_id, o.organization_id) and