APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_COMPANIES

Line 176: msc_companies c,

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,
180: msc_trading_partner_maps m2,

Line 177: msc_companies c1,

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,
180: msc_trading_partner_maps m2,
181: msc_trading_partners t,

Line 219: msc_companies pk:

215: msc_company_sites pk:
216: COMPANY_ID
217: COMPANY_SITE_ID
218:
219: msc_companies pk:
220: COMPANY_ID
221:
222: msc_trading_partners pk:
223: PARTNER_ID

Line 413: msc_companies c,

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,
417: msc_trading_partner_maps m2,

Line 414: msc_companies c1,

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,
417: msc_trading_partner_maps m2,
418: msc_trading_partners t,

Line 454: msc_companies pk:

450: msc_company_sites pk:
451: COMPANY_ID
452: COMPANY_SITE_ID
453:
454: msc_companies pk:
455: COMPANY_ID
456:
457: msc_trading_partners pk:
458: PARTNER_ID

Line 1453: msc_companies c

1449: select c.company_id
1450: into l_customer_id
1451: from msc_trading_partner_maps m,
1452: msc_company_relationships r,
1453: msc_companies c
1454: where m.tp_key = p_source_customer_id and
1455: m.map_type = 1 and
1456: m.company_key = r.relationship_id and
1457: r.relationship_type = 1 and