FND_FOREIGN_KEYS (Foreign keys)
Documentation | Oracle EBS Data Dictionary |
Name | FND_FOREIGN_KEYS |
Title | Foreign keys |
Module | EBS Data Dictionary Diagram |
Foreign keys registered with Oracle Application Object Library.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | APPLICATION_ID | NUMBER(15, 0) | FND_TABLES (Tables) | Application identifier. | ||||
Application identifier. References: FND_TABLES (Tables) |
||||||||
2 | TABLE_ID | NUMBER(15, 0) | FND_TABLES (Tables) | Table identifier. | ||||
Table identifier. References: FND_TABLES (Tables) |
||||||||
3 | FOREIGN_KEY_ID | NUMBER(15, 0) | Foreign key identifier. | |||||
Foreign key identifier. |
||||||||
4 | FOREIGN_KEY_NAME | VARCHAR2(30 BYTE) | Foreign key name. | |||||
Foreign key name. |
||||||||
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 | PRIMARY_KEY_APPLICATION_ID | NUMBER(15, 0) | Primary key application identifier. | |||||
Primary key application identifier. |
||||||||
11 | PRIMARY_KEY_TABLE_ID | NUMBER(15, 0) | Primary key table identifier. | |||||
Primary key table identifier. |
||||||||
12 | PRIMARY_KEY_ID | NUMBER(15, 0) | Primary key identifier. | |||||
Primary key identifier. |
||||||||
13 | CASCADE_BEHAVIOR | VARCHAR2(1 BYTE) | Cascade behavior. | |||||
Cascade behavior. |
||||||||
14 | FOREIGN_KEY_RELATION | VARCHAR2(1 BYTE) | Foreign key relation. | |||||
Foreign key relation. |
||||||||
15 | DESCRIPTION | VARCHAR2(240 BYTE) | Description. | |||||
Description. |
||||||||
16 | CONDITION | VARCHAR2(2000 BYTE) | Condition statement for conditional foreign keys (arc relationships). | |||||
Condition statement for conditional foreign keys (arc relationships). |
||||||||
17 | ENABLED_FLAG | VARCHAR2(1 BYTE) | Determines whether this key will be created as an enabled or disabled constraint. | |||||
Determines whether this key will be created as an enabled or disabled constraint. |
||||||||
18 | ZD_EDITION_NAME | VARCHAR2(30 BYTE) | Default: 'ORA$BASE' | |||||
Default:
'ORA$BASE' |
||||||||
19 | ZD_SYNC | VARCHAR2(30 BYTE) | Default: 'SYNCED' | |||||
Default:
'SYNCED' |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
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_FOREIGN_KEY_COLUMNS (Foreign key columns) | FND_FOREIGN_KEYS (Foreign keys) | FND_FOREIGN_KEY_COLUMNS.FOREIGN_KEY_ID = FND_FOREIGN_KEYS.FOREIGN_KEY_ID FND_FOREIGN_KEY_COLUMNS.TABLE_ID = FND_FOREIGN_KEYS.TABLE_ID FND_FOREIGN_KEY_COLUMNS.APPLICATION_ID = FND_FOREIGN_KEYS.APPLICATION_ID |
fk_FND_FOREIGN_KEY_COLUMNS_FND_FOREIGN_KEYS | |
FND_FOREIGN_KEY_COLUMNS.FOREIGN_KEY_ID = FND_FOREIGN_KEYS.FOREIGN_KEY_ID Name: fk_FND_FOREIGN_KEY_COLUMNS_FND_FOREIGN_KEYSFND_FOREIGN_KEY_COLUMNS.TABLE_ID = FND_FOREIGN_KEYS.TABLE_ID FND_FOREIGN_KEY_COLUMNS.APPLICATION_ID = FND_FOREIGN_KEYS.APPLICATION_ID |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
FND_FOREIGN_KEYS_U1 | APPLICATION_ID, ZD_EDITION_NAME, FOREIGN_KEY_ID, TABLE_ID | ||
FND_FOREIGN_KEYS_U2 | FOREIGN_KEY_NAME, ZD_EDITION_NAME, TABLE_ID, APPLICATION_ID |
Uses
Name |
---|
FND_FOREIGN_KEYS (Foreign keys)
|
Used by
Name |
---|
FND_FOREIGN_KEYS (Foreign keys)
|
FND_FOREIGN_KEYS#
|
Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17