APPS.ETRM_RPT SQL Statements

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

Line: 15

    select application_id
    from fnd_application
    where application_short_name = c_app;

Line: 34

  select name
  from sys.obj$
  where obj# = n_object_id;

Line: 39

  select name
  from sys.con$
  where con# = n_object_id;

Line: 48

  select object_name
  ,      object_type
  ,      owner
  from dba_objects
  where object_id = n_object_id;

Line: 87

    select table_name
    from applsys.fnd_tables
    where application_id = n_appid
    and   table_id = n_tabid;

Line: 104

  select object_name
  ,      object_type
  ,      owner
  from dba_objects
  where object_id = n_object_id;

Line: 132

    select OWNER
    ,      OBJECT_NAME
    ,      SUBOBJECT_NAME
    ,      OBJECT_ID
    ,      DATA_OBJECT_ID
    ,      OBJECT_TYPE
    ,      CREATED
    ,      LAST_DDL_TIME
    ,      TIMESTAMP
    ,      STATUS
    ,      TEMPORARY
    ,      GENERATED
    ,      SECONDARY
    from dba_objects
    where object_name = c_name
    and   object_type = c_type
    and   owner       = owner;

Line: 152

    select a.application_short_name
    ,      a.application_id
    ,      t.table_id
    from fnd_tables t
    ,    fnd_application a
    where table_name = c_name
    and t.application_id = a.application_id
    order by a.application_short_name;

Line: 164

    select a.application_short_name
    ,      a.application_id
    ,      t.view_id
    from fnd_views t
    ,    fnd_application a
    where view_name = c_name
    and t.application_id = a.application_id
    order by a.application_short_name;

Line: 190

   IS select tab.table_name
      ,      tab.tablespace_name
      ,      tab.pct_free
      ,      tab.pct_used
      from dba_tables tab
      where table_name = c_name
      order by tab.table_name;

Line: 201

  is select comments
     from dba_tab_comments
     where owner = c_owner
     and table_name = c_name
     and (table_type = 'TABLE'
          OR table_type = 'VIEW');

Line: 211

  is select ind.index_name
     ,      ind.uniqueness
     ,      ind.tablespace_name
     ,      ind.pct_increase
     ,      ind.pct_free
     ,      ind.owner
     from dba_indexes ind
     where ind.table_name = cv_tab_name
     and   ind.table_owner = c_owner
     order by ind.uniqueness desc, ind.index_name;

Line: 225

  is select ic.column_name
     ,      ic.column_length
     from dba_ind_columns ic
     where ic.index_name = cv_index_name
     and   ic.index_owner = c_owner
     order by ic.column_position;

Line: 235

  is select uc.constraint_name
     from dba_constraints uc
     where uc.table_name = cv_table_name
     and uc.owner = c_owner
     and uc.constraint_type = 'P'
     order by uc.constraint_name;

Line: 245

  is select uc.constraint_name
     from dba_constraints uc
     where uc.table_name = cv_table_name
     and uc.constraint_type = 'U'
     and uc.owner = c_owner
     order by uc.constraint_name;

Line: 258

  is select cc.column_name
     from dba_cons_columns cc
     where cc.constraint_name = cv_cons_name
     and cc.owner = c_owner
     order by cc.position;

Line: 380

   IS select table_name
      ,      INITIAL_EXTENT
      ,      NEXT_EXTENT
      ,      MIN_EXTENTS
      ,      MAX_EXTENTS
      ,      PCT_INCREASE
      ,      INI_TRANS
      ,      MAX_TRANS
      ,      PCT_FREE
      ,      PCT_USED
      ,      description
      from applsys.fnd_tables
      where application_id = n_appid
      and   table_id = n_tabid
      order by table_name;

Line: 400

  is SELECT PRIMARY_KEY_ID
     ,      PRIMARY_KEY_NAME
     ,      PRIMARY_KEY_TYPE
     ,      ENABLED_FLAG
     FROM APPLSYS.FND_PRIMARY_KEYS
     where table_id = n_tabid
     and   application_id = n_appid
     order by primary_key_name;

Line: 412

  SELECT c.column_name
  from applsys.fnd_columns c
  ,    applsys.fnd_primary_key_columns k
  where k.table_id = c.table_id
  and   k.application_id = c.application_id
  and   k.column_id = c.column_id
  and   k.table_id = n_tabid
  and   k.application_id = n_appid
  and   k.primary_key_id = n_keyid
  order by primary_key_sequence;

Line: 428

  is SELECT PRIMARY_KEY_APPLICATION_ID
     ,      PRIMARY_KEY_TABLE_ID
     ,      PRIMARY_KEY_ID
     ,      foreign_key_id
     ,      foreign_key_name
     FROM APPLSYS.FND_FOREIGN_KEYS
     where table_id = n_tabid
     and   application_id = n_appid
     order by foreign_key_name;

Line: 441

  is SELECT PRIMARY_KEY_ID
     ,      table_id
     ,      application_id
     ,      foreign_key_id
     ,      foreign_key_name
     FROM APPLSYS.FND_FOREIGN_KEYS
     where primary_key_table_id = n_tabid
     and   primary_key_application_id = n_appid
     order by foreign_key_name;

Line: 454

  SELECT c.column_name
  from applsys.fnd_columns c
  ,    applsys.fnd_foreign_key_columns k
  where k.table_id = c.table_id
  and   k.application_id = c.application_id
  and   k.column_id = c.column_id
  and   k.table_id = n_tabid
  and   k.application_id = n_appid
  and   k.foreign_key_id = n_keyid
  order by foreign_key_sequence;

Line: 622

  is select col.column_name
     ,      col.data_type
     ,      col.data_length
     ,      nvl(to_char(col.data_precision), '
') data_precision
     ,      nvl(decode(col.nullable, 'N', 'Y'), '
')  nullable
     from dba_tab_columns col
     where col.table_name = c_name
     and   col.owner = c_owner
     order by col.column_id;

Line: 636

  is select comments
     from dba_col_comments
     where owner = c_owner
     and table_name = c_tname
     and column_name = c_cname;

Line: 722

  is select d_obj# object_id
     ,      etrm_pnav.get_object_name(d_obj#, 'USER') owner
     ,      etrm_pnav.get_object_name(d_obj#, 'ITEM') item
     from sys.dependency$
     where p_obj# = n_object_id
     order by etrm_pnav.get_object_name(d_obj#);

Line: 730

  is select p_obj# object_id
     ,      etrm_pnav.get_object_name(p_obj#, 'USER') owner
     ,      etrm_pnav.get_object_name(p_obj#, 'ITEM') item
     from sys.dependency$
     where d_obj# = n_object_id
     order by etrm_pnav.get_object_name(p_obj#);

Line: 831

is select text
   from dba_source
   where name = c_name
   and   type = c_type
   and   owner = c_owner;

Line: 839

is select text
   from dba_views
   where view_name = c_name
   and   owner = c_owner;

Line: 854

      v_viewtext := replace(v_viewtext , 'SELECT ', 'SELECT ');

Line: 912

  select d.object_name
  ,      d.object_type
  ,      d.owner
  ,      a.application_id
  ,      t.table_id
  from dba_objects d
  ,    fnd_tables t
  ,    fnd_application a
  where a.application_short_name = c_owner
  and a.application_id = t.application_id
  and t.table_name = d.object_name
  and d.object_type = 'TABLE'
  UNION
  select d.object_name
  ,      d.object_type
  ,      d.owner
  ,      a.application_id
  ,      t.view_id       table_id
  from dba_objects d
  ,    fnd_views t
  ,    fnd_application a
  where a.application_short_name = c_owner
  and a.application_id = t.application_id
  and t.view_name = d.object_name
  and d.object_type = 'VIEW'
  order by 2, 1;

Line: 987

  select d.object_name
  ,      d.object_type
  ,      d.object_id
  ,      d.owner
  from dba_objects d
  ,    fnd_tables t
  ,    fnd_application a
  where a.application_short_name = c_owner
  and a.application_id = t.application_id
  and t.table_name = d.object_name
  and d.object_type = 'TABLE'
  UNION
  select d.object_name
  ,      d.object_type
  ,      d.object_id
  ,      d.owner
  from dba_objects d
  ,    fnd_views t
  ,    fnd_application a
  where a.application_short_name = c_owner
  and a.application_id = t.application_id
  and t.view_name = d.object_name
  and d.object_type = 'VIEW'
  order by 2, 1;

Line: 1013

  select etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
                             , etrm_pnav.get_object_name(d_obj#, 'TYPE')) owner
  ,      etrm_pnav.get_object_name(d_obj#, 'ITEM')  d_item
  ,      etrm_pnav.get_object_name(d_obj#, 'TYPE') d_item_type
  ,      etrm_pnav.get_object_name(d_obj#, 'USER') d_schema
  from sys.dependency$
  where p_obj# = n_object_id
  order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(d_obj#, 'ITEM')
  ,      etrm_pnav.get_object_name(d_obj#, 'TYPE'))
  ,      etrm_pnav.get_object_name(d_obj#, 'USER')
  ,      etrm_pnav.get_object_name(d_obj#, 'ITEM');

Line: 1027

  select etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
                             , etrm_pnav.get_object_name(p_obj#, 'TYPE')) owner
  ,      etrm_pnav.get_object_name(p_obj#, 'ITEM')  d_item
  ,      etrm_pnav.get_object_name(p_obj#, 'TYPE') d_item_type
  ,      etrm_pnav.get_object_name(p_obj#, 'USER') d_schema
  from sys.dependency$
  where d_obj# = n_object_id
  order by etrm_fndnav.get_owner(etrm_pnav.get_object_name(p_obj#, 'ITEM')
  ,      etrm_pnav.get_object_name(p_obj#, 'TYPE'))
  ,      etrm_pnav.get_object_name(p_obj#, 'USER')
  ,      etrm_pnav.get_object_name(p_obj#, 'ITEM');

Line: 1041

  select a.application_id
  ,      a.application_short_name
  ,      t.application_name
  ,      t.description
  from fnd_application a
  ,    fnd_application_tl t
  where a.application_id = t.application_id
  order by a.application_short_name;

Line: 1052

  select application_id
  from fnd_application
  order by application_id;