APPS.POS_SUP_PROF_MRG_GRP dependencies on PO_VENDOR_SITES_ALL

Line 269: FROM po_vendor_sites_all

265: -- select count of active sites (besides the site being merged)
266:
267: SELECT count(*)
268: INTO l_num_active_sites
269: FROM po_vendor_sites_all
270: WHERE vendor_id = p_dup_vendor_id
271: AND vendor_site_id <> p_dup_vendor_site_id
272: AND nvl(inactive_date, sysdate+1) > sysdate;
273: