Search Results ahl_mel_cdl_ata_sequences_pk

Overview

The AHL_MEL_CDL_ATA_SEQUENCES table is a core configuration object within the Oracle E-Business Suite (EBS) Complex Maintenance Repair and Overhaul (AHL) module. It stores the association between Minimum Equipment List / Configuration Deviation List (MEL/CDL) headers and the ATA (Air Transport Association) codes—referred to here as System Sequences—that apply to them. In aerospace and defense maintenance operations, MEL/CDL records define permitted deferrals and deviations from an aircraft's certified configuration; this table provides the granular mapping that binds each deferral definition to one or more ATA chapter references and, optionally, a repair category.

Functionally, the table acts as the junction between a MEL/CDL header definition and the specific system sequences against which deferrals are tracked, dispatched, and resolved. From a Data Vault modeling perspective, the mined foreign-key structure classifies this object as hub-leaning, since it carries a surrogate primary key that is widely referenced by dependent transactional tables such as unit deferrals, maintenance-order procedures, and MEL/CDL relationships. This classification is a heuristic suggestion derived from the FK topology rather than a documented architectural designation.

Key Information Stored

The table contains 29 documented columns in the 12.2.2 physical schema. The most operationally significant are:

• MEL_CDL_ATA_SEQUENCE_ID — the surrogate primary key (AHL_MEL_CDL_ATA_SEQUENCES_PK) and the value most commonly searched by developers and integrators. It uniquely identifies each ATA sequence assignment.
• MEL_CDL_HEADER_ID — foreign key to AHL_MEL_CDL_HEADERS, identifying the parent MEL/CDL definition.
• ATA_CODE — the ATA chapter/system sequence code associated with the MEL/CDL. Together with MEL_CDL_HEADER_ID, this forms the business-key candidate AHL_MEL_CDL_ATA_SEQUENCES_U2.
• REPAIR_CATEGORY_ID — foreign key to AHL_REPAIR_CATEGORIES, linking the sequence to a repair classification.
• INSTALLED_NUMBER and DISPATCH_NUMBER — operational identifiers used in deferral and dispatch tracking.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant / organization-level data security.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the AHL framework for concurrent update control.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard EBS descriptive flexfield columns enabling customer-specific extension without schema modification.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard "Who" audit columns maintained by EBS.

A second unique index, AHL_MEL_CDL_ATA_SEQUENCES_U1, mirrors the primary key column, reinforcing uniqueness of MEL_CDL_ATA_SEQUENCE_ID.

Common Use Cases and Queries

Typical scenarios include retrieving all ATA sequences for a given MEL/CDL header, validating deferral eligibility against ATA codes, and reconciling unit deferrals to their originating sequence definitions. A representative query joining to the header is:

• SELECT s.mel_cdl_ata_sequence_id, s.ata_code, s.repair_category_id FROM ahl_mel_cdl_ata_sequences s WHERE s.mel_cdl_header_id = :header_id;
• Joining to AHL_UNIT_DEFERRALS_B on ATA_SEQUENCE_ID to report active deferrals per ATA sequence.
• Joining to AHL_MEL_CDL_RELATIONSHIPS to trace predecessor/successor sequence relationships via ATA_SEQUENCE_ID and RELATED_ATA_SEQUENCE_ID.
• Reporting by REPAIR_CATEGORY_ID to aggregate deferrals across maintenance categories.

Because the table is an intersection of MEL/CDL and ATA data, it is frequently used in custom OAF pages, concurrent programs, and BI Publisher reports supporting airworthiness and dispatch tracking.

Related Objects

The most significant related objects, per the documented FK relationships, are:

• AHL_MEL_CDL_HEADERS — parent header; joined on MEL_CDL_HEADER_ID.
• AHL_REPAIR_CATEGORIES — joined on REPAIR_CATEGORY_ID.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for row-level security.
• AHL_MEL_CDL_MO_PROCEDURES — references this table via ATA_SEQUENCE_ID.
• AHL_MEL_CDL_RELATIONSHIPS — references this table twice, via ATA_SEQUENCE_ID and RELATED_ATA_SEQUENCE_ID.
• AHL_UNIT_DEFERRALS_B — references this table via ATA_SEQUENCE_ID, tying operational deferrals to sequence definitions.

These dependencies confirm the table's role as a hub object within the MEL/CDL deferral model, central to both configuration and transactional maintenance workflows in the AHL module.