APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_TRADING_PARTNER_SITES

Line 174: msc_trading_partner_sites mtps, --- PO_SHIP_DATE

170: msc_trading_partner_maps m1,
171: msc_trading_partner_maps m2,
172: msc_trading_partners t,
173: msc_trading_partners t1,
174: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
175: msc_company_relationships r,
176: msc_plan_buckets mpb,
177: msc_full_pegging mfp,
178: msc_supplies sup,

Line 411: msc_trading_partner_sites mtps, --- PO_SHIP_DATE

407: msc_trading_partner_maps m1,
408: msc_trading_partner_maps m2,
409: msc_trading_partners t,
410: msc_trading_partners t1,
411: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
412: msc_company_relationships r,
413: msc_plan_buckets mpb,
414: fnd_lookup_values flv
415: where

Line 681: FROM msc_trading_partner_sites

677:
678: IF p_source_customer_site_id IS NOT NULL THEN
679: SELECT location
680: INTO l_cust_site
681: FROM msc_trading_partner_sites
682: WHERE partner_id = p_source_customer_id
683: AND partner_site_id = p_source_customer_site_id
684: AND tp_site_code = 'SHIP_TO';
685: l_log_message := l_log_message || get_message('MSC','MSC_X_PUB_CUST_SITE',l_language_code) || ': ' || l_cust_site || fnd_global.local_chr(10);