FND Design Data [Home] [Help]

Table: AHL_UNIT_DEFERRALS_B

Product: AHL - Complex Maintenance Repair and Overhaul
Description: This table holds the deferral and MR initialization information for a unit effectivity.
Implementation/DBA Data: TableAHL.AHL_UNIT_DEFERRALS_B
Primary Key: AHL_UNIT_DEFERRALS_B_PK
  1. ColumnUNIT_DEFERRAL_ID
Primary Key: AHL_UNIT_DEFERRALS_B_UK
  1. ColumnUNIT_EFFECTIVITY_ID
  2. ColumnUNIT_DEFERRAL_TYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
AHL_UNIT_DEFERRALS_B FK Joins to TableAHL_UNIT_EFFECTIVITIES_B AHL_UNIT_DEFERRALS_B.UNIT_EFFECTIVITY_ID
AHL_UNIT_DEFERRALS_B FK Joins to TableAHL_MEL_CDL_ATA_SEQUENCES AHL_UNIT_DEFERRALS_B.ATA_SEQUENCE_ID
TableAHL_UNIT_DEFERRALS_TL FK Joins to AHL_UNIT_DEFERRALS_B AHL_UNIT_DEFERRALS_TL.UNIT_DEFERRAL_ID
TableAHL_UNIT_THRESHOLDS FK Joins to AHL_UNIT_DEFERRALS_B AHL_UNIT_THRESHOLDS.UNIT_DEFERRAL_ID