FND_VIEWS

FND_VIEWS stores information about the registered views in your applications. Each row includes the name and description of the view and the view text. You need one row for each view in each application. Oracle Applications uses this information when installing and upgrading the database.

Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes Application identifier
VIEW_ID NUMBER (15) Yes View identifier
VIEW_NAME VARCHAR2 (30) Yes View name
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
DESCRIPTION VARCHAR2 (240)
Description
TEXT LONG (0)
Text of the view statement

Usage:


  cursor cur_views(c_name   in dba_objects.object_name%type := '%'
                 , n_appid  in number) is
  select v.view_id   id
  ,      v.view_name name
  from  fnd_views v
  where v.application_id = n_appid
  and   v.view_name like c_name ESCAPE '\'
  order by view_name;

  cursor cur_tables_and_views(c_name   in dba_objects.object_name%type := '%'
                            , n_appid  in number) is
  select t.table_id   id
  ,      t.table_name name
  ,      'TABLE'      o_type
  from applsys.fnd_tables t
  where t.application_id = n_appid
  and t.table_name like c_name ESCAPE '\'
  UNION
  select v.view_id   id
  ,      v.view_name name
  ,      'VIEW'      o_type
  from applsys.fnd_views v
  where v.application_id = n_appid
  and   v.view_name like c_name ESCAPE '\'
  order by 2;

CURSOR cur_view_dets(n_tabid in number
                   , n_appid in number)
   -- List view details
   IS select view_name
      ,      description
      ,      text
      from applsys.fnd_views
      where view_id = n_tabid
      and application_id = n_appid
      order by view_name;

  cursor cur_view(c_name  in dba_objects.object_name%type)
  is
    select decode(app.application_short_name, 'SQLAP', 'AP'
                                            , 'SQLGL', 'GL'
                                            , app.application_short_name) application_short_name
    from fnd_views t
    ,    fnd_application app
    where view_name = c_name
    and t.application_id = app.application_id;