FND_INDEX_COLUMNS (Index columns)
Documentation | Oracle EBS Data Dictionary |
Name | FND_INDEX_COLUMNS |
Title | Index columns |
Module | EBS Data Dictionary Diagram |
Index 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_INDEXES (Indexes) |
Application identifier. | ||||
Application identifier. References: FND_COLUMNS (Columns) ,FND_INDEXES (Indexes) |
||||||||
2 | TABLE_ID | NUMBER(15, 0) | FND_COLUMNS
(Columns)
FND_INDEXES (Indexes) |
Table identifier. | ||||
Table identifier. References: FND_COLUMNS (Columns) ,FND_INDEXES (Indexes) |
||||||||
3 | INDEX_ID | NUMBER(15, 0) | FND_INDEXES (Indexes) | Index identifier. | ||||
Index identifier. References: FND_INDEXES (Indexes) |
||||||||
4 | COLUMN_SEQUENCE | NUMBER(15, 0) | The position of the column in the index. | |||||
The position of the column in the index. |
||||||||
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_INDEX_COLUMNS (Index columns) | FND_COLUMNS (Columns) | FND_INDEX_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID FND_INDEX_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_INDEX_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID |
fk_FND_INDEX_COLUMNS_FND_COLUMNS | |
FND_INDEX_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID Name: fk_FND_INDEX_COLUMNS_FND_COLUMNSFND_INDEX_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_INDEX_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID |
||||
FND_INDEX_COLUMNS (Index columns) | FND_INDEXES (Indexes) | FND_INDEX_COLUMNS.TABLE_ID = FND_INDEXES.TABLE_ID FND_INDEX_COLUMNS.INDEX_ID = FND_INDEXES.INDEX_ID FND_INDEX_COLUMNS.APPLICATION_ID = FND_INDEXES.APPLICATION_ID |
fk_FND_INDEX_COLUMNS_FND_INDEXES | |
FND_INDEX_COLUMNS.TABLE_ID = FND_INDEXES.TABLE_ID Name: fk_FND_INDEX_COLUMNS_FND_INDEXESFND_INDEX_COLUMNS.INDEX_ID = FND_INDEXES.INDEX_ID FND_INDEX_COLUMNS.APPLICATION_ID = FND_INDEXES.APPLICATION_ID |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
FND_INDEX_COLUMNS_U1 | ZD_EDITION_NAME, APPLICATION_ID, COLUMN_SEQUENCE, INDEX_ID, TABLE_ID | ||
FND_INDEX_COLUMNS_U2 | APPLICATION_ID, ZD_EDITION_NAME, INDEX_ID, COLUMN_ID, TABLE_ID |
Uses
Name |
---|
FND_INDEX_COLUMNS (Index columns)
|
Used by
Name |
---|
FND_INDEX_COLUMNS (Index columns)
|
FND_INDEX_COLUMNS#
|
Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17