FND Design Data [Home] [Help]

Table: EAM_FAILURE_COMBINATIONS

Product: EAM - Enterprise Asset Management
Description: Stores the unique Failure/Cause/Resolution Code Combinations
Implementation/DBA Data: TableEAM.EAM_FAILURE_COMBINATIONS
Primary Key: EAM_FAILURE_COMBINATIONS_PK
  1. ColumnCOMBINATION_ID
Primary Key: EAM_FAILURE_COMBINATIONS_UK
  1. ColumnCAUSE_CODE
  2. ColumnSET_ID
  3. ColumnRESOLUTION_CODE
  4. ColumnFAILURE_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
EAM_FAILURE_COMBINATIONS FK Joins to Table% EAM_FAILURE_COMBINATIONS.SET_ID
EAM_FAILURE_COMBINATIONS FK Joins to Table% EAM_FAILURE_COMBINATIONS.FAILURE_CODE
EAM_FAILURE_COMBINATIONS FK Joins to TableEAM_CAUSE_CODES EAM_FAILURE_COMBINATIONS.CAUSE_CODE
EAM_FAILURE_COMBINATIONS FK Joins to TableEAM_RESOLUTION_CODES EAM_FAILURE_COMBINATIONS.RESOLUTION_CODE