FND_INDEX_COLUMNS (Index columns)

Index columns registered with Oracle Application Object Library.

Columns

		Name	Data type	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 FND_INDEX_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_INDEX_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID Name: fk_FND_INDEX_COLUMNS_FND_COLUMNS
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 FND_INDEX_COLUMNS.INDEX_ID = FND_INDEXES.INDEX_ID FND_INDEX_COLUMNS.APPLICATION_ID = FND_INDEXES.APPLICATION_ID Name: fk_FND_INDEX_COLUMNS_FND_INDEXES

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)
FND_COLUMNS (Columns)
FND_INDEXES (Indexes)

Used by

Name
FND_INDEX_COLUMNS (Index columns)
FND_INDEX_COLUMNS#

Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17