FND_APPLICATION (Applications)
Documentation | Oracle EBS Data Dictionary |
Name | FND_APPLICATION |
Title | Applications |
Module | EBS Data Dictionary Diagram |
Applications registered with Oracle Application Object Library.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | APPLICATION_ID | NUMBER | Application identifier. | |||||
Application identifier. |
||||||||
2 | APPLICATION_SHORT_NAME | VARCHAR2(50 BYTE) | Application short name. | |||||
Application short name. |
||||||||
3 | LAST_UPDATE_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
4 | LAST_UPDATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
5 | CREATION_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
6 | CREATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
7 | LAST_UPDATE_LOGIN | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
8 | BASEPATH | VARCHAR2(20 BYTE) | The variable that stores the directory path of the TOP directory for the application. | |||||
The variable that stores the directory path of the TOP directory for the application. |
||||||||
9 | PRODUCT_CODE | VARCHAR2(50 BYTE) | Online help base application short name, if help content is shared with another application. | |||||
Online help base application short name, if help content is shared with another application. |
||||||||
10 | ZD_EDITION_NAME | VARCHAR2(30 BYTE) | Default: 'ORA$BASE' | |||||
Default:
'ORA$BASE' |
||||||||
11 | ZD_SYNC | VARCHAR2(30 BYTE) | Default: 'SYNCED' | |||||
Default:
'SYNCED' |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
FND_LOOKUP_TYPES (Lookup types) | FND_APPLICATION (Applications) | FND_LOOKUP_TYPES.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID | fk_FND_LOOKUP_TYPES_FND_APPLICATION | |
FND_LOOKUP_TYPES.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID Name: fk_FND_LOOKUP_TYPES_FND_APPLICATION |
||||
FND_TABLES (Tables) | FND_APPLICATION (Applications) | FND_TABLES.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID | FK_FND_TABLES | |
FND_TABLES.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID Name: FK_FND_TABLES |
||||
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 |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
FND_APPLICATION_PK | ZD_EDITION_NAME, APPLICATION_ID | ||
FND_APPLICATION_U3 | APPLICATION_SHORT_NAME, ZD_EDITION_NAME |
Used by
Name |
---|
FND_APPLICATION (Applications)
|
FND_APPLICATION#
|
Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17