APPS.POS_MERGE_SUPPLIER_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 178: DELETE FROM pos_supplier_mappings a

174: fnd_file.put_line(fnd_file.log,
175: 'Inside POS_MERGE_SUPPLIER_PKG.Buss_Class_Merge l_to_vendor_id: ' ||
176: l_to_vendor_id);
177:
178: DELETE FROM pos_supplier_mappings a
179: WHERE a.party_id = p_to_fk_id
180: AND a.vendor_id <> l_to_vendor_id
181: AND EXISTS (SELECT 1
182: FROM pos_supplier_mappings b

Line 182: FROM pos_supplier_mappings b

178: DELETE FROM pos_supplier_mappings a
179: WHERE a.party_id = p_to_fk_id
180: AND a.vendor_id <> l_to_vendor_id
181: AND EXISTS (SELECT 1
182: FROM pos_supplier_mappings b
183: WHERE b.party_id = p_to_fk_id
184: AND vendor_id = l_to_vendor_id);
185:
186: UPDATE pos_supplier_mappings

Line 186: UPDATE pos_supplier_mappings

182: FROM pos_supplier_mappings b
183: WHERE b.party_id = p_to_fk_id
184: AND vendor_id = l_to_vendor_id);
185:
186: UPDATE pos_supplier_mappings
187: SET vendor_id = l_to_vendor_id,
188: last_updated_by = fnd_global.user_id,
189: last_update_date = SYSDATE,
190: last_update_login = fnd_global.login_id

Line 192: FROM pos_supplier_mappings

188: last_updated_by = fnd_global.user_id,
189: last_update_date = SYSDATE,
190: last_update_login = fnd_global.login_id
191: WHERE mapping_id IN (SELECT mapping_id
192: FROM pos_supplier_mappings
193: WHERE party_id = p_to_fk_id);
194:
195: fnd_file.put_line(fnd_file.log, 'Rowcount1: ' || SQL%ROWCOUNT);
196:

Line 340: FROM pos_supplier_mappings

336:
337: -- Get the mapping_id using the following SQLL
338: SELECT mapping_id
339: INTO l_mapping_id
340: FROM pos_supplier_mappings
341: WHERE vendor_id = p_vendor_prodsrv_rec.vendor_id
342: AND party_id = p_party_id;
343:
344: pos_product_service_utl_pkg.initialize(x_status => l_status,

Line 589: DELETE FROM pos_supplier_mappings a

585: last_update_login = hz_utility_pub.last_update_login
586: WHERE vendor_id = l_from_vendor_id
587: AND classification_id = p_from_id;
588:
589: DELETE FROM pos_supplier_mappings a
590: WHERE a.party_id = p_to_fk_id
591: AND a.vendor_id <> l_to_vendor_id
592: AND EXISTS (SELECT 1
593: FROM pos_supplier_mappings b

Line 593: FROM pos_supplier_mappings b

589: DELETE FROM pos_supplier_mappings a
590: WHERE a.party_id = p_to_fk_id
591: AND a.vendor_id <> l_to_vendor_id
592: AND EXISTS (SELECT 1
593: FROM pos_supplier_mappings b
594: WHERE b.party_id = p_to_fk_id
595: AND vendor_id = l_to_vendor_id);
596:
597: UPDATE pos_supplier_mappings

Line 597: UPDATE pos_supplier_mappings

593: FROM pos_supplier_mappings b
594: WHERE b.party_id = p_to_fk_id
595: AND vendor_id = l_to_vendor_id);
596:
597: UPDATE pos_supplier_mappings
598: SET vendor_id = l_to_vendor_id,
599: last_updated_by = fnd_global.user_id,
600: last_update_date = SYSDATE,
601: last_update_login = fnd_global.login_id

Line 603: FROM pos_supplier_mappings

599: last_updated_by = fnd_global.user_id,
600: last_update_date = SYSDATE,
601: last_update_login = fnd_global.login_id
602: WHERE mapping_id IN (SELECT mapping_id
603: FROM pos_supplier_mappings
604: WHERE party_id = p_to_fk_id);
605:
606: /* Get the details for the from party id */
607: