APPS.MSC_X_RECEIVE_CAPACITY_PKG dependencies on MSC_TRADING_PARTNER_SITES

Line 491: msc_trading_partner_sites tps

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
494: tps.partner_site_id = p_supplier_site_id AND
495: tp.partner_id = tps.partner_id AND

Line 688: msc_trading_partner_sites tps

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
691: tp.partner_id = tps.partner_id AND
692: map1.company_key = s.company_site_id AND

Line 746: msc_trading_partner_sites tps

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
749: tps.partner_site_id = l_aps_supplier_site_id AND
750: tp.partner_id = tps.partner_id AND

Line 1807: l_supplier_site_name msc_trading_partner_sites.tp_site_code%type;

1803: l_nextid Number;
1804: l_user_id Number := fnd_global.user_id;
1805: l_refresh_number Number;
1806: l_supplier_name msc_trading_partners.partner_name%type;
1807: l_supplier_site_name msc_trading_partner_sites.tp_site_code%type;
1808: l_desc msc_designators.description%type;
1809: BEGIN
1810:
1811:

Line 1827: from msc_trading_partner_sites

1823: and partner_type = 1;
1824:
1825: select tp_site_code
1826: into l_supplier_site_name
1827: from msc_trading_partner_sites
1828: where partner_id = p_supplier_id
1829: and partner_site_id = p_supplier_site_id;
1830:
1831: exception