APPS.QA_VENDORMERGE_GRP SQL Statements

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

Line: 12

        PROCEDURE update_qa_results(
            p_from_vendor_id NUMBER,
            p_to_vendor_id NUMBER) IS

        BEGIN
            --
            -- Quality only stores vendor ID, not vendor site, nor party
            -- therefore updating vendor ID only.  This UPDATE statement
            -- is potentially long running.  The customer is advised to
            -- create a custom index on QA_RESULTS.VENDOR_ID to make it
            -- more performing if this operation is run frequently.
            --

            UPDATE qa_results
            SET    vendor_id = p_to_vendor_id
            WHERE  vendor_id = p_from_vendor_id;

Line: 29

        END update_qa_results;

Line: 78

        update_qa_results(
            p_from_vendor_id => p_dup_vendor_id,
            p_to_vendor_id => p_vendor_id);