APPS.MSC_SCE_PUB_SUPPLY_COMMIT_PKG dependencies on MSC_TRADING_PARTNER_SITES

Line 183: msc_trading_partner_sites mtps, --- PO_SHIP_DATE

179: msc_trading_partner_maps m1,
180: msc_trading_partner_maps m2,
181: msc_trading_partners t,
182: msc_trading_partners t1,
183: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
184: msc_company_relationships r,
185: msc_plan_buckets mpb,
186: msc_full_pegging mfp,
187: msc_supplies sup,

Line 420: msc_trading_partner_sites mtps, --- PO_SHIP_DATE

416: msc_trading_partner_maps m1,
417: msc_trading_partner_maps m2,
418: msc_trading_partners t,
419: msc_trading_partners t1,
420: msc_trading_partner_sites mtps, --- PO_SHIP_DATE
421: msc_company_relationships r,
422: msc_plan_buckets mpb,
423: fnd_lookup_values flv
424: where

Line 708: FROM msc_trading_partner_sites

704:
705: IF p_source_customer_site_id IS NOT NULL THEN
706: SELECT location
707: INTO l_cust_site
708: FROM msc_trading_partner_sites
709: WHERE partner_id = p_source_customer_id
710: AND partner_site_id = p_source_customer_site_id
711: AND tp_site_code = 'SHIP_TO';
712: 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);