FND_TABLES (Tables)

Documentation	Oracle EBS Data Dictionary
Name	FND_TABLES
Title	Tables
Module	EBS Data Dictionary Diagram

Tables registered in applications.

Columns

		Name	Data type	Attributes	References	Description
	1	APPLICATION_ID	NUMBER(15, 0)		FND_APPLICATION (Applications)	Application identifier.
Application identifier. References: FND_APPLICATION (Applications)
	2	TABLE_ID	NUMBER(15, 0)			Table identifier.
Table identifier.
	3	TABLE_NAME	VARCHAR2(30 BYTE)			Table name.
Table name.
	4	USER_TABLE_NAME	VARCHAR2(80 BYTE)			Table title.
Table title.
	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)			Flag to indicate if this table is automatically sized during an install.
Flag to indicate if this table is automatically sized during an install.
	11	TABLE_TYPE	VARCHAR2(1 BYTE)			Type of the table (seed data, transaction data, interim).
Type of the table (seed data, transaction data, interim).
	12	INITIAL_EXTENT	NUMBER(15, 0)			Initial extent storage parameter.
Initial extent storage parameter.
	13	NEXT_EXTENT	NUMBER(15, 0)			Next extent storage parameter.
Next extent storage parameter.
	14	MIN_EXTENTS	NUMBER(15, 0)			Minimum extents storage parameter.
Minimum extents storage parameter.
	15	MAX_EXTENTS	NUMBER(15, 0)			Maximum extents storage parameter.
Maximum extents storage parameter.
	16	PCT_INCREASE	NUMBER(15, 0)			Percent increase storage parameter.
Percent increase storage parameter.
	17	INI_TRANS	NUMBER(15, 0)			Initial transactions storage parameter.
Initial transactions storage parameter.
	18	MAX_TRANS	NUMBER(15, 0)			Maximum transactions storage parameter.
Maximum transactions storage parameter.
	19	PCT_FREE	NUMBER(15, 0)			Percent free storage parameter.
Percent free storage parameter.
	20	PCT_USED	NUMBER(15, 0)			Percent used storage parameter.
Percent used storage parameter.
	21	DESCRIPTION	VARCHAR2(240 BYTE)			Description.
Description.
	22	HOSTED_SUPPORT_STYLE	VARCHAR2(30 BYTE)	Default: 'LOCAL'		validated by HOSTED_SUPPORT_STYLE lookup type.Default value is 'LOCAL'.
validated by HOSTED_SUPPORT_STYLE lookup type.Default value is 'LOCAL'. Default: 'LOCAL'
	23	IREP_COMMENTS	VARCHAR2(4000 BYTE)			Comments from CASE.
Comments from CASE.
	24	IREP_ANNOTATIONS	VARCHAR2(4000 BYTE)			Annotations from CASE.
Annotations from CASE.
	25	ZD_EDITION_NAME	VARCHAR2(30 BYTE)	Default: 'ORA$BASE'
Default: 'ORA$BASE'
	26	ZD_SYNC	VARCHAR2(30 BYTE)	Default: 'SYNCED'
Default: 'SYNCED'

Relations

Foreign table	Primary table	Join	Title / Name / Description
FND_TABLES (Tables)	FND_APPLICATION (Applications)	FND_TABLES.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID	FK_FND_TABLES
FND_TABLES.APPLICATION_ID = FND_APPLICATION.APPLICATION_ID Name: FK_FND_TABLES
FND_COLUMNS (Columns)	FND_TABLES (Tables)	FND_COLUMNS.TABLE_ID = FND_TABLES.TABLE_ID FND_COLUMNS.APPLICATION_ID = FND_TABLES.APPLICATION_ID	fk_FND_COLUMNS_FND_TABLES
FND_COLUMNS.TABLE_ID = FND_TABLES.TABLE_ID FND_COLUMNS.APPLICATION_ID = FND_TABLES.APPLICATION_ID Name: fk_FND_COLUMNS_FND_TABLES
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 FND_FOREIGN_KEYS.APPLICATION_ID = FND_TABLES.APPLICATION_ID Name: fk_FND_FOREIGN_KEYS_FND_TABLES
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_PRIMARY_KEYS (Primary keys)	FND_TABLES (Tables)	FND_PRIMARY_KEYS.TABLE_ID = FND_TABLES.TABLE_ID FND_PRIMARY_KEYS.APPLICATION_ID = FND_TABLES.APPLICATION_ID	fk_FND_PRIMARY_KEYS
FND_PRIMARY_KEYS.TABLE_ID = FND_TABLES.TABLE_ID FND_PRIMARY_KEYS.APPLICATION_ID = FND_TABLES.APPLICATION_ID Name: fk_FND_PRIMARY_KEYS

Unique keys

	Key name	Columns	Description
	FND_TABLES_U1	APPLICATION_ID, ZD_EDITION_NAME, TABLE_ID
	FND_TABLES_U2	APPLICATION_ID, ZD_EDITION_NAME, TABLE_NAME
	FND_TABLES_U3	APPLICATION_ID, ZD_EDITION_NAME, USER_TABLE_NAME

Uses

Name
FND_TABLES (Tables)
FND_APPLICATION (Applications)

Used by

Name
FND_TABLES (Tables)
FND_TABLES#
FND_COLUMNS (Columns)
FND_FOREIGN_KEYS (Foreign keys)
FND_INDEXES (Indexes)
FND_PRIMARY_KEYS (Primary keys)

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