FND_FOREIGN_KEY_COLUMNS (Foreign key columns)

Foreign key columns registered with Oracle Application Object Library.

Columns

		Name	Data type	Attributes	References	Description
	1	APPLICATION_ID	NUMBER(15, 0)		FND_COLUMNS (Columns) FND_FOREIGN_KEYS (Foreign keys)	Application identifier.
Application identifier. References: FND_COLUMNS (Columns) ,FND_FOREIGN_KEYS (Foreign keys)
	2	TABLE_ID	NUMBER(15, 0)		FND_COLUMNS (Columns) FND_FOREIGN_KEYS (Foreign keys)	Table identifier.
Table identifier. References: FND_COLUMNS (Columns) ,FND_FOREIGN_KEYS (Foreign keys)
	3	FOREIGN_KEY_ID	NUMBER(15, 0)		FND_FOREIGN_KEYS (Foreign keys)	Foreign key identifier.
Foreign key identifier. References: FND_FOREIGN_KEYS (Foreign keys)
	4	FOREIGN_KEY_SEQUENCE	NUMBER(15, 0)			Sequence of the column in the foreign key.
Sequence of the column in the foreign 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	CASCADE_VALUE	VARCHAR2(80 BYTE)			Cascade value.
Cascade value.
	12	ZD_EDITION_NAME	VARCHAR2(30 BYTE)	Default: 'ORA$BASE'
Default: 'ORA$BASE'
	13	ZD_SYNC	VARCHAR2(30 BYTE)	Default: 'SYNCED'
Default: 'SYNCED'

Relations

Foreign table	Primary table	Join	Title / Name / Description
FND_FOREIGN_KEY_COLUMNS (Foreign key columns)	FND_COLUMNS (Columns)	FND_FOREIGN_KEY_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_FOREIGN_KEY_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID FND_FOREIGN_KEY_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID	fk_FND_FOREIGN_KEY_COLUMNS_FND_COLUMNS
FND_FOREIGN_KEY_COLUMNS.TABLE_ID = FND_COLUMNS.TABLE_ID FND_FOREIGN_KEY_COLUMNS.COLUMN_ID = FND_COLUMNS.COLUMN_ID FND_FOREIGN_KEY_COLUMNS.APPLICATION_ID = FND_COLUMNS.APPLICATION_ID Name: fk_FND_FOREIGN_KEY_COLUMNS_FND_COLUMNS
FND_FOREIGN_KEY_COLUMNS (Foreign key columns)	FND_FOREIGN_KEYS (Foreign keys)	FND_FOREIGN_KEY_COLUMNS.FOREIGN_KEY_ID = FND_FOREIGN_KEYS.FOREIGN_KEY_ID FND_FOREIGN_KEY_COLUMNS.TABLE_ID = FND_FOREIGN_KEYS.TABLE_ID FND_FOREIGN_KEY_COLUMNS.APPLICATION_ID = FND_FOREIGN_KEYS.APPLICATION_ID	fk_FND_FOREIGN_KEY_COLUMNS_FND_FOREIGN_KEYS
FND_FOREIGN_KEY_COLUMNS.FOREIGN_KEY_ID = FND_FOREIGN_KEYS.FOREIGN_KEY_ID FND_FOREIGN_KEY_COLUMNS.TABLE_ID = FND_FOREIGN_KEYS.TABLE_ID FND_FOREIGN_KEY_COLUMNS.APPLICATION_ID = FND_FOREIGN_KEYS.APPLICATION_ID Name: fk_FND_FOREIGN_KEY_COLUMNS_FND_FOREIGN_KEYS

Unique keys

	Key name	Columns	Description
	FND_FOREIGN_KEY_COLUMNS_U1	APPLICATION_ID, ZD_EDITION_NAME, FOREIGN_KEY_SEQUENCE, FOREIGN_KEY_ID, TABLE_ID
	FND_FOREIGN_KEY_COLUMNS_U2	APPLICATION_ID, ZD_EDITION_NAME, FOREIGN_KEY_ID, COLUMN_ID, TABLE_ID

Uses

Name
FND_FOREIGN_KEY_COLUMNS (Foreign key columns)
FND_COLUMNS (Columns)
FND_FOREIGN_KEYS (Foreign keys)

Used by

Name
FND_FOREIGN_KEY_COLUMNS (Foreign key columns)
FND_FOREIGN_KEY_COLUMNS#

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