FND_PRIMARY_KEY_COLUMNS (Primary key columns)
| Documentation | Oracle EBS Data Dictionary |
| Name | FND_PRIMARY_KEY_COLUMNS |
| Title | Primary key columns |
| Module | EBS Data Dictionary Diagram |
Primary and unique key columns registered with Oracle Application Object Library.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | APPLICATION_ID | NUMBER(15, 0) | FND_COLUMNS
(Columns)
FND_PRIMARY_KEYS (Primary keys) |
Application identifier. | ||||
| Application identifier. References: FND_COLUMNS (Columns) ,FND_PRIMARY_KEYS (Primary keys) |
||||||||
| 2 | TABLE_ID | NUMBER(15, 0) | FND_COLUMNS
(Columns)
FND_PRIMARY_KEYS (Primary keys) |
Table identifier. | ||||
| Table identifier. References: FND_COLUMNS (Columns) ,FND_PRIMARY_KEYS (Primary keys) |
||||||||
| 3 | PRIMARY_KEY_ID | NUMBER(15, 0) | FND_PRIMARY_KEYS (Primary keys) | Primary key identifier. | ||||
| Primary key identifier. References: FND_PRIMARY_KEYS (Primary keys) |
||||||||
| 4 | PRIMARY_KEY_SEQUENCE | NUMBER(15, 0) | Sequence of the column in the primary key. | |||||
| Sequence of the column in the primary key. |
||||||||
| 5 | COLUMN_ID | NUMBER(15, 0) | FND_COLUMNS (Columns) | Column identifier. | ||||
| Column identifier. References: FND_COLUMNS (Columns) |
||||||||
| 6 | LAST_UPDATE_DATE | DATE | Standard Who column. | |||||
| Standard Who column. |
||||||||
| 7 | LAST_UPDATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
| Standard Who column. |
||||||||
| 8 | CREATION_DATE | DATE | Standard Who column. | |||||
| Standard Who column. |
||||||||
| 9 | CREATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
| Standard Who column. |
||||||||
| 10 | LAST_UPDATE_LOGIN | NUMBER(15, 0) | Standard Who column. | |||||
| Standard Who column. |
||||||||
| 11 | ZD_EDITION_NAME | VARCHAR2(30 BYTE) | Default: 'ORA$BASE' | |||||
|
Default:
'ORA$BASE' |
||||||||
| 12 | ZD_SYNC | VARCHAR2(30 BYTE) | Default: 'SYNCED' | |||||
|
Default:
'SYNCED' |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| FND_PRIMARY_KEY_COLUMNS (Primary key columns) | FND_COLUMNS (Columns) | FND_PRIMARY_KEY_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_PRIMARY_KEY_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID FND_PRIMARY_KEY_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID |
fk_FND_PRIMARY_KEY_COLUMNS_FND_COLUMNS | |
|
FND_PRIMARY_KEY_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID Name: fk_FND_PRIMARY_KEY_COLUMNS_FND_COLUMNSFND_PRIMARY_KEY_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID FND_PRIMARY_KEY_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID |
||||
| FND_PRIMARY_KEY_COLUMNS (Primary key columns) | FND_PRIMARY_KEYS (Primary keys) | FND_PRIMARY_KEY_COLUMNS.PRIMARY_KEY_ID = FND_PRIMARY_KEYS.PRIMARY_KEY_ID FND_PRIMARY_KEY_COLUMNS.APPLICATION_ID = FND_PRIMARY_KEYS.APPLICATION_ID FND_PRIMARY_KEY_COLUMNS.TABLE_ID = FND_PRIMARY_KEYS.TABLE_ID |
FK_FND_PRIMARY_KEY_COLUMNS_FND_PRIMARY_KEYS | |
|
FND_PRIMARY_KEY_COLUMNS.PRIMARY_KEY_ID = FND_PRIMARY_KEYS.PRIMARY_KEY_ID Name: FK_FND_PRIMARY_KEY_COLUMNS_FND_PRIMARY_KEYSFND_PRIMARY_KEY_COLUMNS.APPLICATION_ID = FND_PRIMARY_KEYS.APPLICATION_ID FND_PRIMARY_KEY_COLUMNS.TABLE_ID = FND_PRIMARY_KEYS.TABLE_ID |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| FND_PRIMARY_KEY_COLUMNS_U1 | APPLICATION_ID, ZD_EDITION_NAME, PRIMARY_KEY_SEQUENCE, PRIMARY_KEY_ID, TABLE_ID | ||
| FND_PRIMARY_KEY_COLUMNS_U2 | APPLICATION_ID, ZD_EDITION_NAME, COLUMN_ID, PRIMARY_KEY_ID, TABLE_ID |
Uses
| Name |
|---|
|
FND_PRIMARY_KEY_COLUMNS (Primary key columns)
|
Used by
| Name |
|---|
|
FND_PRIMARY_KEY_COLUMNS (Primary key columns)
|
|
FND_PRIMARY_KEY_COLUMNS#
|
Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17