APPS.AHL_VENDORMERGE_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 77

        UPDATE ahl_osp_orders_b
           SET vendor_id = p_vendor_id,
               vendor_site_id = p_vendor_site_id,
               last_updated_by = FND_GLOBAL.user_id,
               last_update_date = SYSDATE
         WHERE vendor_id = p_dup_vendor_id
           AND vendor_site_id = p_dup_vendor_site_id;

Line: 86

        UPDATE ahl_vendor_customer_rels
           SET vendor_site_id = p_vendor_site_id,
               last_updated_by = FND_GLOBAL.user_id,
               last_update_date = SYSDATE
         WHERE vendor_site_id = p_dup_vendor_site_id;

Line: 93

        UPDATE ahl_supplier_documents
           SET supplier_id = p_vendor_id,
               last_updated_by = FND_GLOBAL.user_id,
               last_update_date = SYSDATE
         WHERE supplier_id = p_dup_vendor_id;