FND Design Data [Home] [Help]

Table: FND_PRIMARY_KEY_COLUMNS

Product: FND - Application Object Library
Description: Primary and unique key columns registered with Oracle Application Object Library
Implementation/DBA Data: TableAPPLSYS.FND_PRIMARY_KEY_COLUMNS
Primary Key: FND_PRIMARY_KEY_COLUMNS_PK
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_ID
  3. ColumnPRIMARY_KEY_ID
  4. ColumnPRIMARY_KEY_SEQUENCE
Primary Key: FND_PRIMARY_KEY_COLUMNS_UK1
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_ID
  3. ColumnPRIMARY_KEY_ID
  4. ColumnCOLUMN_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
FND_PRIMARY_KEY_COLUMNS FK Joins to TableFND_PRIMARY_KEYS FND_PRIMARY_KEY_COLUMNS.APPLICATION_ID
FND_PRIMARY_KEY_COLUMNS.TABLE_ID
FND_PRIMARY_KEY_COLUMNS.PRIMARY_KEY_ID
FND_PRIMARY_KEY_COLUMNS FK Joins to TableFND_COLUMNS FND_PRIMARY_KEY_COLUMNS.APPLICATION_ID
FND_PRIMARY_KEY_COLUMNS.TABLE_ID
FND_PRIMARY_KEY_COLUMNS.COLUMN_ID