FND Design Data [Home] [Help]

Table: FND_FOREIGN_KEYS

Product: FND - Application Object Library
Description: Foreign keys registered with Oracle Application Object Library
Implementation/DBA Data: TableAPPLSYS.FND_FOREIGN_KEYS
Primary Key: FND_FOREIGN_KEYS_PK
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_ID
  3. ColumnFOREIGN_KEY_ID
Primary Key: FND_FOREIGN_KEYS_UK1
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_ID
  3. ColumnFOREIGN_KEY_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
FND_FOREIGN_KEYS FK Joins to TableFND_TABLES FND_FOREIGN_KEYS.APPLICATION_ID
FND_FOREIGN_KEYS.TABLE_ID
FND_FOREIGN_KEYS FK Joins to TableFND_PRIMARY_KEYS FND_FOREIGN_KEYS.PRIMARY_KEY_APPLICATION_ID
FND_FOREIGN_KEYS.PRIMARY_KEY_TABLE_ID
FND_FOREIGN_KEYS.PRIMARY_KEY_ID
TableFND_FOREIGN_KEY_COLUMNS FK Joins to FND_FOREIGN_KEYS FND_FOREIGN_KEY_COLUMNS.APPLICATION_ID
FND_FOREIGN_KEY_COLUMNS.TABLE_ID
FND_FOREIGN_KEY_COLUMNS.FOREIGN_KEY_ID