APPS.ETRM_SEARCH SQL Statements

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

Line: 57

                     , b_prior_selected => TRUE);

Line: 69

    select release_name
    from fnd_product_groups
    order by release_name;

Line: 90

  select app.application_id
  ,      app.application_short_name || ' - '|| tl.application_name product_name
  from APPLSYS.FND_APPLICATION_TL tl
  ,    APPLSYS.FND_APPLICATION    app
  where app.application_id = tl.application_id
  order by app.application_short_name;

Line: 128

    select table_name
    ,      description
    from   fnd_tables
    where application_id = n_appid
    and   table_id = n_tabid;

Line: 136

    select view_name
    ,      description
    from   fnd_views
    where application_id = n_appid
    and   view_id = n_tabid;

Line: 144

  select app_id, obj_id, obj_type, count(*) hits
  from fnd_etrm_search_tmp
  group by  app_id, obj_id, obj_type
  order by count(*) desc;

Line: 177

     'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
     select application_id, table_id, ''COL''
     from   fnd_columns c1
     where catsearch(c1.description, :search, null) > 0';

Line: 185

     'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
     select application_id, table_id, ''TAB''
     from   fnd_tables c1
     where catsearch(c1.description, :search, null) > 0';

Line: 193

     'insert into fnd_etrm_search_tmp (app_id, obj_id, obj_type)
     select application_id, view_id, ''VW''
     from   fnd_views c1
     where catsearch(c1.description, :search, null) > 0';

Line: 253

    select file_id
    ,      application
    ,      title
    from   fnd_help_documents
    where catsearch(title, c_search, null) > 0
    order by application, title;

Line: 280

select file_data
,      file_name
,      file_content_type
from fnd_lobs
where file_id = n_file_id;

Line: 327

    select object_name
    ,      object_type
    ,      owner
    ,      object_id
    from dba_objects
    where upper(object_name) = c_search
    order by object_id;

Line: 338

    select app.application_id
    ,      tl.application_name product_name
    from APPLSYS.FND_APPLICATION_TL tl
    ,    APPLSYS.FND_APPLICATION    app
    where app.application_id = tl.application_id
    and upper(c_search) = decode(app.application_short_name
                                    , 'SQLAP', 'AP'
                                    , 'SQLGL', 'GL'
                                    , app.application_short_name)
    and tl.language =  userenv('LANG');