FND Design Data [Home] [Help]

Table: AHL_OPERATION_PHASES

Product: AHL - Complex Maintenance Repair and Overhaul
Description: This table stores the significant phases in an Operation.
Implementation/DBA Data: TableAHL.AHL_OPERATION_PHASES
Primary Key: AHL_OPERATION_PHASES_PK
  1. ColumnOPERATION_PHASE_ID
Primary Key: AHL_OPERATION_PHASES_UK1
  1. ColumnOPERATION_ID
  2. ColumnPHASE_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
AHL_OPERATION_PHASES FK Joins to TableAHL_OPERATIONS_B AHL_OPERATION_PHASES.OPERATION_ID
TableAHL_OPERATION_PHASES_H FK Joins to AHL_OPERATION_PHASES AHL_OPERATION_PHASES_H.OPERATION_PHASE_ID