APPS.BIS_GNRL_SEARCH_ENGINE_PVT_OA SQL Statements

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

Line: 90

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

Line: 186

  dc_query := 'select distinct ' ||
              '        b.profile_option_value || ''_'' || c.language ' ||
              '  from ' ||
              '        fnd_profile_options a ' ||
              '       ,fnd_profile_option_values b' ||
              '       ,fnd_profile_options_tl c ' ||
              ' where ' ||
              '       a.profile_option_name = ''ICX_DEFAULT_EUL'' and ' ||
              '       a.profile_option_id = b.profile_option_id and ' ||
              '       a.profile_option_name = c.profile_option_name ';

Line: 207

  dc_query := 'select distinct count(*) ' ||
              '  from all_objects ' ||
              ' where owner = :e ' ||
              '   and object_name = ''' || get_eul_table_version || '_BAS''' ||
              '   and object_type = ''TABLE''';