FND Design Data [Home] [Help]

Table: FND_TABLES

Product: FND - Application Object Library
Description: Tables registered in applications
Implementation/DBA Data: TableAPPLSYS.FND_TABLES
Primary Key: FND_TABLES_PK
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_ID
Primary Key: FND_TABLES_UK1
  1. ColumnAPPLICATION_ID
  2. ColumnUSER_TABLE_NAME
Primary Key: FND_TABLES_UK2
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
FND_TABLES FK Joins to TableFND_APPLICATION FND_TABLES.APPLICATION_ID
TableAD_MERGE_ACTION_TABLES FK Joins to FND_TABLES AD_MERGE_ACTION_TABLES.TABLE_APPLICATION_ID
AD_MERGE_ACTION_TABLES.TABLE_ID
TableALR_ALERTS FK Joins to FND_TABLES ALR_ALERTS.TABLE_APPLICATION_ID
ALR_ALERTS.TABLE_ID
TableFND_AUDIT_TABLES FK Joins to FND_TABLES FND_AUDIT_TABLES.TABLE_APP_ID
FND_AUDIT_TABLES.TABLE_ID
TableFND_BUILDING_BLOCK_OBJECTS FK Joins to FND_TABLES FND_BUILDING_BLOCK_OBJECTS.OBJECT_APPLICATION_ID
FND_BUILDING_BLOCK_OBJECTS.OBJECT_ID
TableFND_COLUMNS FK Joins to FND_TABLES FND_COLUMNS.APPLICATION_ID
FND_COLUMNS.TABLE_ID
TableFND_DESCRIPTIVE_FLEXS FK Joins to FND_TABLES FND_DESCRIPTIVE_FLEXS.TABLE_APPLICATION_ID
FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME
TableFND_FOREIGN_KEYS FK Joins to FND_TABLES FND_FOREIGN_KEYS.APPLICATION_ID
FND_FOREIGN_KEYS.TABLE_ID
TableFND_ID_FLEXS FK Joins to FND_TABLES FND_ID_FLEXS.TABLE_APPLICATION_ID
FND_ID_FLEXS.APPLICATION_TABLE_NAME
TableFND_INDEXES FK Joins to FND_TABLES FND_INDEXES.APPLICATION_ID
FND_INDEXES.TABLE_ID
TableFND_PRIMARY_KEYS FK Joins to FND_TABLES FND_PRIMARY_KEYS.APPLICATION_ID
FND_PRIMARY_KEYS.TABLE_ID
TableSO_OBJECTS FK Joins to FND_TABLES SO_OBJECTS.TABLE_APPLICATION_ID
SO_OBJECTS.TABLE_NAME