FND_FOREIGN_KEYS (Foreign keys)

Documentation	Oracle EBS Data Dictionary
Name	FND_FOREIGN_KEYS
Title	Foreign keys
Module	EBS Data Dictionary Diagram

Foreign keys 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	FOREIGN_KEY_ID	NUMBER(15, 0)			Foreign key identifier.
Foreign key identifier.
	4	FOREIGN_KEY_NAME	VARCHAR2(30 BYTE)			Foreign key name.
Foreign key 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	PRIMARY_KEY_APPLICATION_ID	NUMBER(15, 0)			Primary key application identifier.
Primary key application identifier.
	11	PRIMARY_KEY_TABLE_ID	NUMBER(15, 0)			Primary key table identifier.
Primary key table identifier.
	12	PRIMARY_KEY_ID	NUMBER(15, 0)			Primary key identifier.
Primary key identifier.
	13	CASCADE_BEHAVIOR	VARCHAR2(1 BYTE)			Cascade behavior.
Cascade behavior.
	14	FOREIGN_KEY_RELATION	VARCHAR2(1 BYTE)			Foreign key relation.
Foreign key relation.
	15	DESCRIPTION	VARCHAR2(240 BYTE)			Description.
Description.
	16	CONDITION	VARCHAR2(2000 BYTE)			Condition statement for conditional foreign keys (arc relationships).
Condition statement for conditional foreign keys (arc relationships).
	17	ENABLED_FLAG	VARCHAR2(1 BYTE)			Determines whether this key will be created as an enabled or disabled constraint.
Determines whether this key will be created as an enabled or disabled constraint.
	18	ZD_EDITION_NAME	VARCHAR2(30 BYTE)	Default: 'ORA$BASE'
Default: 'ORA$BASE'
	19	ZD_SYNC	VARCHAR2(30 BYTE)	Default: 'SYNCED'
Default: 'SYNCED'

Relations

Foreign table	Primary table	Join	Title / Name / Description
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_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_KEYS_U1	APPLICATION_ID, ZD_EDITION_NAME, FOREIGN_KEY_ID, TABLE_ID
	FND_FOREIGN_KEYS_U2	FOREIGN_KEY_NAME, ZD_EDITION_NAME, TABLE_ID, APPLICATION_ID

Uses

Name
FND_FOREIGN_KEYS (Foreign keys)
FND_TABLES (Tables)

Used by

Name
FND_FOREIGN_KEYS (Foreign keys)
FND_FOREIGN_KEYS#
FND_FOREIGN_KEY_COLUMNS (Foreign key columns)

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