DBA Data[Home] [Help]

APPS.MSC_X_RECEIVE_CAPACITY_PKG dependencies on MSC_COMPANY_SITES

Line 489: msc_company_sites s,

485: SELECT distinct s.company_site_id
486: INTO l_map_supplier_site_id
487: FROM msc_trading_partner_maps map1,
488: msc_companies c,
489: msc_company_sites s,
490: msc_trading_partners tp,
491: msc_trading_partner_sites tps
492: WHERE map1.map_type = 3 AND
493: map1.tp_key = tps.partner_site_id AND

Line 686: msc_company_sites s,

682: SELECT distinct tps.partner_site_id
683: INTO l_aps_supplier_site_id
684: FROM msc_trading_partner_maps map1,
685: msc_companies c,
686: msc_company_sites s,
687: msc_trading_partners tp,
688: msc_trading_partner_sites tps
689: WHERE map1.map_type = 3 AND
690: map1.tp_key = tps.partner_site_id AND

Line 744: msc_company_sites s,

740: SELECT distinct s.company_site_id
741: INTO l_map_supplier_site_id
742: FROM msc_trading_partner_maps map1,
743: msc_companies c,
744: msc_company_sites s,
745: msc_trading_partners tp,
746: msc_trading_partner_sites tps
747: WHERE map1.map_type = 3 AND
748: map1.tp_key = tps.partner_site_id AND