APPS.BIS_GNRL_SEARCH_ENGINE_PVT SQL Statements

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

Line: 81

 l_sql := ' select score(10), score(20), score(30), ' ||
          ' obj_id, obj_name, obj_description ' ||
          ' from  ' || v_eul || 'eul_objs ' ||
          ' where contains (obj_name, ' || l_wordlist || ', 10) > 0 ' ||
          '    or contains (obj_description, ' || l_wordlist || ', 20) > 0 ' ||
          '    or contains (obj_type, ' || l_wordlist || ', 30) > 0 ' ||
          ' order by score(10) DESC ,score(20) DESC ,score(30) DESC';

Line: 164

  SELECT owner
  FROM ALL_INDEXES
  WHERE index_name like p_index;