APPS.POS_SUP_PROF_MRG_GRP dependencies on PO_VENDOR_SITES_ALL

Line 247: FROM po_vendor_sites_all

243: -- select count of active sites (besides the site being merged)
244:
245: SELECT count(*)
246: INTO l_num_active_sites
247: FROM po_vendor_sites_all
248: WHERE vendor_id = p_dup_vendor_id
249: AND vendor_site_id <> p_dup_vendor_site_id
250: AND nvl(inactive_date, sysdate+1) > sysdate;
251: