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