APPS.QA_SPECS_PKG SQL Statements

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

Line: 27

                SELECT 1
                FROM   mtl_item_categories mic
                WHERE  mic.inventory_item_id = p_item_id AND
                       mic.organization_id = p_organization_id AND
                       mic.category_id = p_spec_cat_id AND
                       mic.category_set_id = p_spec_cat_set_id;

Line: 53

                SELECT 1
                FROM   mtl_item_categories mic
                WHERE  mic.inventory_item_id = p_item_id AND
                       mic.organization_id = p_organization_id AND
                       mic.category_set_id = p_spec_cat_set_id;

Line: 135

        SELECT spec_name INTO l_spec_name
        FROM   qa_specs
        WHERE  spec_id = p_spec_id AND rownum <= 1;