FND_TABLES (Tables)
Documentation | Oracle EBS Data Dictionary |
Name | FND_TABLES |
Title | Tables |
Module | EBS Data Dictionary Diagram |
Tables registered in applications.
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 | TABLE_ID | NUMBER(15, 0) | Table identifier. | |||||
Table identifier. |
||||||||
3 | TABLE_NAME | VARCHAR2(30 BYTE) | Table name. | |||||
Table name. |
||||||||
4 | USER_TABLE_NAME | VARCHAR2(80 BYTE) | Table title. | |||||
Table title. |
||||||||
5 | LAST_UPDATE_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
6 | LAST_UPDATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
7 | CREATION_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
8 | CREATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
9 | LAST_UPDATE_LOGIN | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
10 | AUTO_SIZE | VARCHAR2(1 BYTE) | Flag to indicate if this table is automatically sized during an install. | |||||
Flag to indicate if this table is automatically sized during an install. |
||||||||
11 | TABLE_TYPE | VARCHAR2(1 BYTE) | Type of the table (seed data, transaction data, interim). | |||||
Type of the table (seed data, transaction data, interim). |
||||||||
12 | INITIAL_EXTENT | NUMBER(15, 0) | Initial extent storage parameter. | |||||
Initial extent storage parameter. |
||||||||
13 | NEXT_EXTENT | NUMBER(15, 0) | Next extent storage parameter. | |||||
Next extent storage parameter. |
||||||||
14 | MIN_EXTENTS | NUMBER(15, 0) | Minimum extents storage parameter. | |||||
Minimum extents storage parameter. |
||||||||
15 | MAX_EXTENTS | NUMBER(15, 0) | Maximum extents storage parameter. | |||||
Maximum extents storage parameter. |
||||||||
16 | PCT_INCREASE | NUMBER(15, 0) | Percent increase storage parameter. | |||||
Percent increase storage parameter. |
||||||||
17 | INI_TRANS | NUMBER(15, 0) | Initial transactions storage parameter. | |||||
Initial transactions storage parameter. |
||||||||
18 | MAX_TRANS | NUMBER(15, 0) | Maximum transactions storage parameter. | |||||
Maximum transactions storage parameter. |
||||||||
19 | PCT_FREE | NUMBER(15, 0) | Percent free storage parameter. | |||||
Percent free storage parameter. |
||||||||
20 | PCT_USED | NUMBER(15, 0) | Percent used storage parameter. | |||||
Percent used storage parameter. |
||||||||
21 | DESCRIPTION | VARCHAR2(240 BYTE) | Description. | |||||
Description. |
||||||||
22 | HOSTED_SUPPORT_STYLE | VARCHAR2(30 BYTE) | Default: 'LOCAL' | validated by HOSTED_SUPPORT_STYLE lookup type.Default value is 'LOCAL'. | ||||
validated by HOSTED_SUPPORT_STYLE lookup type.Default value is 'LOCAL'. Default: 'LOCAL' |
||||||||
23 | IREP_COMMENTS | VARCHAR2(4000 BYTE) | Comments from CASE. | |||||
Comments from CASE. |
||||||||
24 | IREP_ANNOTATIONS | VARCHAR2(4000 BYTE) | Annotations from CASE. | |||||
Annotations from CASE. |
||||||||
25 | ZD_EDITION_NAME | VARCHAR2(30 BYTE) | Default: 'ORA$BASE' | |||||
Default:
'ORA$BASE' |
||||||||
26 | ZD_SYNC | VARCHAR2(30 BYTE) | Default: 'SYNCED' | |||||
Default:
'SYNCED' |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
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_COLUMNS (Columns) | FND_TABLES (Tables) | FND_COLUMNS.TABLE_ID = FND_TABLES.TABLE_ID FND_COLUMNS.APPLICATION_ID = FND_TABLES.APPLICATION_ID |
fk_FND_COLUMNS_FND_TABLES | |
FND_COLUMNS.TABLE_ID = FND_TABLES.TABLE_ID Name: fk_FND_COLUMNS_FND_TABLESFND_COLUMNS.APPLICATION_ID = FND_TABLES.APPLICATION_ID |
||||
FND_FOREIGN_KEYS (Foreign keys) | FND_TABLES (Tables) | FND_FOREIGN_KEYS.TABLE_ID = FND_TABLES.TABLE_ID FND_FOREIGN_KEYS.APPLICATION_ID = FND_TABLES.APPLICATION_ID |
fk_FND_FOREIGN_KEYS_FND_TABLES | |
FND_FOREIGN_KEYS.TABLE_ID = FND_TABLES.TABLE_ID Name: fk_FND_FOREIGN_KEYS_FND_TABLESFND_FOREIGN_KEYS.APPLICATION_ID = FND_TABLES.APPLICATION_ID |
||||
FND_INDEXES (Indexes) | FND_TABLES (Tables) | FND_INDEXES.TABLE_ID = FND_TABLES.TABLE_ID FND_INDEXES.APPLICATION_ID = FND_TABLES.APPLICATION_ID |
fk_FND_INDEXES_FND_TABLES | |
FND_INDEXES.TABLE_ID = FND_TABLES.TABLE_ID Name: fk_FND_INDEXES_FND_TABLESFND_INDEXES.APPLICATION_ID = FND_TABLES.APPLICATION_ID |
||||
FND_PRIMARY_KEYS (Primary keys) | FND_TABLES (Tables) | FND_PRIMARY_KEYS.TABLE_ID = FND_TABLES.TABLE_ID FND_PRIMARY_KEYS.APPLICATION_ID = FND_TABLES.APPLICATION_ID |
fk_FND_PRIMARY_KEYS | |
FND_PRIMARY_KEYS.TABLE_ID = FND_TABLES.TABLE_ID Name: fk_FND_PRIMARY_KEYSFND_PRIMARY_KEYS.APPLICATION_ID = FND_TABLES.APPLICATION_ID |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
FND_TABLES_U1 | APPLICATION_ID, ZD_EDITION_NAME, TABLE_ID | ||
FND_TABLES_U2 | APPLICATION_ID, ZD_EDITION_NAME, TABLE_NAME | ||
FND_TABLES_U3 | APPLICATION_ID, ZD_EDITION_NAME, USER_TABLE_NAME |
Uses
Name |
---|
FND_TABLES (Tables)
|
Used by
Name |
---|
FND_TABLES (Tables)
|
FND_TABLES#
|
Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17