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 621: FROM msc_trading_partner_sites

617: BEGIN
618:
619: SELECT TP_SITE_CODE
620: INTO l_supplier_site_name
621: FROM msc_trading_partner_sites
622: WHERE PARTNER_SITE_ID = p_supplier_site_id;
623:
624: return l_supplier_site_name;
625: EXCEPTION WHEN NO_DATA_FOUND THEN