APPS.POS_SUP_PROF_MRG_GRP dependencies on POS_SUP_PRODUCTS_SERVICES

Line 154: DELETE pos_sup_products_services t1

150: IF (l_num_active_sites = 0) THEN
151: -- delete classifications of the merged-from vendor that
152: -- the merged-to vendor also has
153:
154: DELETE pos_sup_products_services t1
155: WHERE vendor_id = p_old_vendor_id
156: AND exists
157: (SELECT 1 FROM pos_sup_products_services t2
158: WHERE (t1.segment1 = t2.segment1 OR t1.segment1 IS NULL AND t2.segment1 IS NULL)

Line 157: (SELECT 1 FROM pos_sup_products_services t2

153:
154: DELETE pos_sup_products_services t1
155: WHERE vendor_id = p_old_vendor_id
156: AND exists
157: (SELECT 1 FROM pos_sup_products_services t2
158: WHERE (t1.segment1 = t2.segment1 OR t1.segment1 IS NULL AND t2.segment1 IS NULL)
159: AND (t1.segment2 = t2.segment2 OR t1.segment2 IS NULL AND t2.segment2 IS NULL)
160: AND (t1.segment3 = t2.segment3 OR t1.segment3 IS NULL AND t2.segment3 IS NULL)
161: AND (t1.segment4 = t2.segment4 OR t1.segment4 IS NULL AND t2.segment4 IS NULL)

Line 181: UPDATE pos_sup_products_services

177: AND (t1.segment20 = t2.segment20 OR t1.segment20 IS NULL AND t2.segment20 IS NULL)
178: AND t2.vendor_id = p_new_vendor_id);
179:
180: -- transfer classifications of the merged-from vendor to the merged-to vendor
181: UPDATE pos_sup_products_services
182: SET vendor_id = p_new_vendor_id,
183: last_update_date = SYSDATE,
184: last_updated_by = FND_GLOBAL.user_id,
185: last_update_login = FND_GLOBAL.login_id