FND Design Data [Home] [Help]

Table: AHL_MEL_CDL_ATA_SEQUENCES

Product: AHL - Complex Maintenance Repair and Overhaul
Description: This table stores information about ATA codes (System Sequnces) associated to the MEL/CDL.
Implementation/DBA Data: TableAHL.AHL_MEL_CDL_ATA_SEQUENCES
Primary Key: AHL_MEL_CDL_ATA_SEQUENCES_PK
  1. ColumnMEL_CDL_ATA_SEQUENCE_ID
Primary Key: AHL_MEL_CDL_ATA_SEQUENCES_UK1
  1. ColumnMEL_CDL_HEADER_ID
  2. ColumnATA_CODE
Foreign Keys
Table
Foreign Table Foreign Key Column
AHL_MEL_CDL_ATA_SEQUENCES FK Joins to TableAHL_MEL_CDL_HEADERS AHL_MEL_CDL_ATA_SEQUENCES.MEL_CDL_HEADER_ID
AHL_MEL_CDL_ATA_SEQUENCES FK Joins to TableAHL_REPAIR_CATEGORIES AHL_MEL_CDL_ATA_SEQUENCES.REPAIR_CATEGORY_ID
TableAHL_MEL_CDL_MO_PROCEDURES FK Joins to AHL_MEL_CDL_ATA_SEQUENCES AHL_MEL_CDL_MO_PROCEDURES.ATA_SEQUENCE_ID
TableAHL_MEL_CDL_RELATIONSHIPS FK Joins to AHL_MEL_CDL_ATA_SEQUENCES AHL_MEL_CDL_RELATIONSHIPS.ATA_SEQUENCE_ID
TableAHL_MEL_CDL_RELATIONSHIPS FK Joins to AHL_MEL_CDL_ATA_SEQUENCES AHL_MEL_CDL_RELATIONSHIPS.RELATED_ATA_SEQUENCE_ID
TableAHL_UNIT_DEFERRALS_B FK Joins to AHL_MEL_CDL_ATA_SEQUENCES AHL_UNIT_DEFERRALS_B.ATA_SEQUENCE_ID