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;