APPS.POS_SUP_PROF_MRG_GRP dependencies on POS_SUP_PRODUCTS_SERVICES

Line 169: DELETE pos_sup_products_services t1

165: IF (l_num_active_sites = 0) THEN
166: -- delete classifications of the merged-from vendor that
167: -- the merged-to vendor also has
168:
169: DELETE pos_sup_products_services t1
170: WHERE vendor_id = p_old_vendor_id
171: AND exists
172: (SELECT 1 FROM pos_sup_products_services t2
173: WHERE (t1.segment1 = t2.segment1 OR t1.segment1 IS NULL AND t2.segment1 IS NULL)

Line 172: (SELECT 1 FROM pos_sup_products_services t2

168:
169: DELETE pos_sup_products_services t1
170: WHERE vendor_id = p_old_vendor_id
171: AND exists
172: (SELECT 1 FROM pos_sup_products_services t2
173: WHERE (t1.segment1 = t2.segment1 OR t1.segment1 IS NULL AND t2.segment1 IS NULL)
174: AND (t1.segment2 = t2.segment2 OR t1.segment2 IS NULL AND t2.segment2 IS NULL)
175: AND (t1.segment3 = t2.segment3 OR t1.segment3 IS NULL AND t2.segment3 IS NULL)
176: AND (t1.segment4 = t2.segment4 OR t1.segment4 IS NULL AND t2.segment4 IS NULL)

Line 196: UPDATE pos_sup_products_services

192: AND (t1.segment20 = t2.segment20 OR t1.segment20 IS NULL AND t2.segment20 IS NULL)
193: AND t2.vendor_id = p_new_vendor_id);
194:
195: -- transfer classifications of the merged-from vendor to the merged-to vendor
196: UPDATE pos_sup_products_services
197: SET vendor_id = p_new_vendor_id,
198: last_update_date = SYSDATE,
199: last_updated_by = FND_GLOBAL.user_id,
200: last_update_login = FND_GLOBAL.login_id