FND Design Data [Home] [Help]

Table: FND_PRIMARY_KEYS

Product: FND - Application Object Library
Description: Primary and unique keys registered with Oracle Application Object Library
Implementation/DBA Data: TableAPPLSYS.FND_PRIMARY_KEYS
Primary Key: FND_PRIMARY_KEYS_PK
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_ID
  3. ColumnPRIMARY_KEY_ID
Primary Key: FND_PRIMARY_KEYS_UK1
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_ID
  3. ColumnPRIMARY_KEY_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
FND_PRIMARY_KEYS FK Joins to TableFND_TABLES FND_PRIMARY_KEYS.APPLICATION_ID
FND_PRIMARY_KEYS.TABLE_ID
TableFND_FOREIGN_KEYS FK Joins to FND_PRIMARY_KEYS FND_FOREIGN_KEYS.PRIMARY_KEY_APPLICATION_ID
FND_FOREIGN_KEYS.PRIMARY_KEY_TABLE_ID
FND_FOREIGN_KEYS.PRIMARY_KEY_ID
TableFND_PRIMARY_KEY_COLUMNS FK Joins to FND_PRIMARY_KEYS FND_PRIMARY_KEY_COLUMNS.APPLICATION_ID
FND_PRIMARY_KEY_COLUMNS.TABLE_ID
FND_PRIMARY_KEY_COLUMNS.PRIMARY_KEY_ID