eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_COMPANY_SITES

Line 174: msc_company_sites cs,

170: dem.sr_instance_id --Partner Instance Id
171: from
172: msc_demands dem,
173: msc_system_items item,
174: msc_company_sites cs,
175: msc_company_sites cs1,
176: msc_companies c,
177: msc_companies c1,
178: msc_trading_partner_maps m,

Line 175: msc_company_sites cs1,

171: from
172: msc_demands dem,
173: msc_system_items item,
174: msc_company_sites cs,
175: msc_company_sites cs1,
176: msc_companies c,
177: msc_companies c1,
178: msc_trading_partner_maps m,
179: msc_trading_partner_maps m1,

Line 215: msc_company_sites pk:

211: 3 - Site
212:
213: MAP_TYPE + TP_KEY is unique for MAP_TYPE = 2
214:
215: msc_company_sites pk:
216: COMPANY_ID
217: COMPANY_SITE_ID
218:
219: msc_companies pk:

Line 411: msc_company_sites cs,

407: fcst.sr_instance_id --Partner Instance Id
408: from
409: msc_constrained_forecast_v fcst,
410: msc_system_items item,
411: msc_company_sites cs,
412: msc_company_sites cs1,
413: msc_companies c,
414: msc_companies c1,
415: msc_trading_partner_maps m,

Line 412: msc_company_sites cs1,

408: from
409: msc_constrained_forecast_v fcst,
410: msc_system_items item,
411: msc_company_sites cs,
412: msc_company_sites cs1,
413: msc_companies c,
414: msc_companies c1,
415: msc_trading_partner_maps m,
416: msc_trading_partner_maps m1,

Line 450: msc_company_sites pk:

446: 3 - Site
447:
448: MAP_TYPE + TP_KEY is unique for MAP_TYPE = 2
449:
450: msc_company_sites pk:
451: COMPANY_ID
452: COMPANY_SITE_ID
453:
454: msc_companies pk:

Line 1477: msc_company_sites cs

1473: BEGIN
1474: select cs.company_site_id
1475: into l_customer_site_id
1476: from msc_trading_partner_maps m,
1477: msc_company_sites cs
1478: where m.tp_key = p_source_customer_site_id and
1479: m.map_type = 3 and
1480: cs.company_site_id = m.company_key;
1481: EXCEPTION

Line 1500: msc_company_sites cs,

1496: sd.plan_id = -1 and
1497: sd.publisher_id = 1 and
1498: sd.publisher_site_id IN (select cs.company_site_id
1499: from msc_plan_organizations o,
1500: msc_company_sites cs,
1501: msc_trading_partner_maps m,
1502: msc_trading_partners p
1503: where o.plan_id = p_plan_id and
1504: p.sr_tp_id = nvl(p_org_id, o.organization_id) and

Line 1543: msc_company_sites cs,

1539: sd.plan_id = -1 and
1540: sd.publisher_id = 1 and
1541: sd.publisher_site_id IN (select cs.company_site_id
1542: from msc_plan_organizations o,
1543: msc_company_sites cs,
1544: msc_trading_partner_maps m,
1545: msc_trading_partners p
1546: where o.plan_id = p_plan_id and
1547: p.sr_tp_id = nvl(p_org_id, o.organization_id) and