APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_COMPANIES

Line 167: msc_companies c,

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

Line 168: msc_companies c1,

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,
171: msc_trading_partner_maps m2,
172: msc_trading_partners t,

Line 210: msc_companies pk:

206: msc_company_sites pk:
207: COMPANY_ID
208: COMPANY_SITE_ID
209:
210: msc_companies pk:
211: COMPANY_ID
212:
213: msc_trading_partners pk:
214: PARTNER_ID

Line 404: msc_companies c,

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

Line 405: msc_companies c1,

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,
408: msc_trading_partner_maps m2,
409: msc_trading_partners t,

Line 445: msc_companies pk:

441: msc_company_sites pk:
442: COMPANY_ID
443: COMPANY_SITE_ID
444:
445: msc_companies pk:
446: COMPANY_ID
447:
448: msc_trading_partners pk:
449: PARTNER_ID

Line 1417: msc_companies c

1413: select c.company_id
1414: into l_customer_id
1415: from msc_trading_partner_maps m,
1416: msc_company_relationships r,
1417: msc_companies c
1418: where m.tp_key = p_source_customer_id and
1419: m.map_type = 1 and
1420: m.company_key = r.relationship_id and
1421: r.relationship_type = 1 and