FND_INDEXES (Indexes)

Documentation	Oracle EBS Data Dictionary
Name	FND_INDEXES
Title	Indexes
Module	EBS Data Dictionary Diagram

Unique and non-unique indexes registered with Oracle Application Object Library.

Columns

		Name	Data type	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	INDEX_ID	NUMBER(15, 0)			Index identifier.
Index identifier.
	4	INDEX_NAME	VARCHAR2(30 BYTE)			Index name.
Index 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	AUTO_SIZE	VARCHAR2(1 BYTE)			Is this index automatically sized during an install?
Is this index automatically sized during an install?
	11	INI_TRANS	NUMBER(15, 0)			Initial number of transactions.
Initial number of transactions.
	12	MAX_TRANS	NUMBER(15, 0)			Maximum number of transactions.
Maximum number of transactions.
	13	INITIAL_EXTENT	NUMBER(15, 0)			Initial extent.
Initial extent.
	14	NEXT_EXTENT	NUMBER(15, 0)			Next extent.
Next extent.
	15	MIN_EXTENTS	NUMBER(15, 0)			Minimum extent.
Minimum extent.
	16	MAX_EXTENTS	NUMBER(15, 0)			Maximum extent.
Maximum extent.
	17	PCT_FREE	NUMBER(15, 0)			Percent of free space.
Percent of free space.
	18	PCT_INCREASE	NUMBER(15, 0)			Percent of free space to increase.
Percent of free space to increase.
	19	UNIQUENESS	VARCHAR2(1 BYTE)			Uniqueness.
Uniqueness.
	20	DESCRIPTION	VARCHAR2(240 BYTE)			Description.
Description.
	21	ZD_EDITION_NAME	VARCHAR2(30 BYTE)	Default: 'ORA$BASE'
Default: 'ORA$BASE'
	22	ZD_SYNC	VARCHAR2(30 BYTE)	Default: 'SYNCED'
Default: 'SYNCED'

Relations

Foreign table	Primary table	Join	Title / Name / Description
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 FND_INDEXES.APPLICATION_ID = FND_TABLES.APPLICATION_ID Name: fk_FND_INDEXES_FND_TABLES
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_INDEXES_U1	APPLICATION_ID, ZD_EDITION_NAME, INDEX_ID, TABLE_ID
	FND_INDEXES_U2	INDEX_NAME, ZD_EDITION_NAME, TABLE_ID, APPLICATION_ID

Uses

Name
FND_INDEXES (Indexes)
FND_TABLES (Tables)

Used by

Name
FND_INDEXES (Indexes)
FND_INDEXES#
FND_INDEX_COLUMNS (Index columns)

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