FND_VIEWS (Views)
Documentation | Oracle EBS Data Dictionary |
Name | FND_VIEWS |
Title | Views |
Module | EBS Data Dictionary Diagram |
Views registered with Oracle Application Object Library.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | APPLICATION_ID | NUMBER(15, 0) | FND_APPLICATION (Applications) | Application identifier. | ||||
Application identifier. References: FND_APPLICATION (Applications) |
||||||||
2 | VIEW_ID | NUMBER(15, 0) | View identifier. | |||||
View identifier. |
||||||||
3 | VIEW_NAME | VARCHAR2(30 BYTE) | View name. | |||||
View name. |
||||||||
4 | LAST_UPDATE_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
5 | LAST_UPDATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
6 | CREATION_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
7 | CREATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
8 | LAST_UPDATE_LOGIN | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
9 | DESCRIPTION | VARCHAR2(240 BYTE) | Description. | |||||
Description. |
||||||||
10 | IREP_COMMENTS | VARCHAR2(4000 BYTE) | Comments from CASE. | |||||
Comments from CASE. |
||||||||
11 | IREP_ANNOTATIONS | VARCHAR2(4000 BYTE) | Annotations from CASE. | |||||
Annotations from CASE. |
||||||||
12 | TEXT | CLOB | Text of the view statement. | |||||
Text of the view statement. |
||||||||
13 | ZD_EDITION_NAME | VARCHAR2(30 BYTE) | Default: 'ORA$BASE' | |||||
Default:
'ORA$BASE' |
||||||||
14 | ZD_SYNC | VARCHAR2(30 BYTE) | Default: 'SYNCED' | |||||
Default:
'SYNCED' |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
FND_VIEWS (Views) | FND_APPLICATION (Applications) | FND_VIEWS.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID | fk_FND_VIEWS_FND_APPLICATION | |
FND_VIEWS.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID Name: fk_FND_VIEWS_FND_APPLICATION |
||||
FND_VIEW_COLUMNS (View columns) | FND_VIEWS (Views) | FND_VIEW_COLUMNS.VIEW_ID = FND_VIEWS.VIEW_ID FND_VIEW_COLUMNS.APPLICATION_ID = FND_VIEWS.APPLICATION_ID |
fk_FND_VIEW_COLUMNS_FND_VIEWS | |
FND_VIEW_COLUMNS.VIEW_ID = FND_VIEWS.VIEW_ID Name: fk_FND_VIEW_COLUMNS_FND_VIEWSFND_VIEW_COLUMNS.APPLICATION_ID = FND_VIEWS.APPLICATION_ID |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
FND_VIEWS_U1 | APPLICATION_ID, ZD_EDITION_NAME, VIEW_ID | ||
FND_VIEWS_U2 | ZD_EDITION_NAME, VIEW_NAME, APPLICATION_ID |
Uses
Name |
---|
FND_VIEWS (Views)
|
Used by
Name |
---|
FND_VIEWS (Views)
|
FND_VIEWS#
|
Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17