DBA Data[Home] [Help]

APPS.MSC_ATP_FUNC dependencies on MSC_TRADING_PARTNER_SITES

Line 223: FROM msc_trading_partner_sites

219: IF (p_organization_id IS NOT NULL) THEN
220:
221: SELECT sr_tp_site_id
222: INTO l_location_id
223: FROM msc_trading_partner_sites
224: WHERE sr_tp_id = p_organization_id
225: AND sr_instance_id = p_instance_id
226: AND partner_type = 3;
227:

Line 629: FROM msc_trading_partner_sites

625: BEGIN
626:
627: SELECT TP_SITE_CODE
628: INTO l_supplier_site_name
629: FROM msc_trading_partner_sites
630: WHERE PARTNER_SITE_ID = p_supplier_site_id;
631:
632: return l_supplier_site_name;
633: EXCEPTION WHEN NO_DATA_FOUND THEN