Search Results ahl_mel_cdl_ata_sequences_u2

Overview

The table AHL.AHL_MEL_CDL_ATA_SEQUENCES is a core configuration object within the Oracle EBS Complex Maintenance, Repair, and Overhaul (CMRO) / Advanced Maintenance application, owned by the AHL schema. It stores the association between MEL/CDL (Minimum Equipment List / Configuration Deviation List) records and ATA (Air Transport Association) system sequence codes. Each row represents a single ATA code tied to a specific MEL/CDL header, along with the operational limits governing that sequence — how many items may be installed and how many are required for dispatch. This makes the table the authoritative source for ATA-level dispatch and deferral rules embedded in maintenance programs. In Oracle EBS 12.1.1 and 12.2.2, the object is documented as VALID and resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, while its unique indexes are held in APPS_TS_TX_IDX. Given its role as a persistent entity keyed by a surrogate identifier and referenced by dependent transactional tables, the mined Data Vault classification is hub-leaning — a reasonable modeling suggestion is to treat it as a hub with associated satellites for its descriptive attributes.

Key Information Stored

The primary key of the table is MEL_CDL_ATA_SEQUENCE_ID (NUMBER), a surrogate identifier generated for each row. Two documented unique indexes serve as business-key candidates: AHL_MEL_CDL_ATA_SEQUENCES_U1 enforces uniqueness on MEL_CDL_ATA_SEQUENCE_ID, while AHL_MEL_CDL_ATA_SEQUENCES_U2 enforces uniqueness on the pairing of MEL_CDL_HEADER_ID and ATA_CODE, confirming that an ATA code may appear only once per MEL/CDL header.

• MEL_CDL_HEADER_ID — the MEL/CDL header to which the ATA sequence is associated; a foreign key to AHL_MEL_CDL_HEADERS.
• ATA_CODE — the ATA system sequence code (VARCHAR2(30)), sourced from the AHL_ATA_CODE lookup type.
• REPAIR_CATEGORY_ID — the repair category assigned to the sequence; a foreign key to AHL_REPAIR_CATEGORIES.
• INSTALLED_NUMBER — the maximum number of items permitted to be installed at that ATA sequence.
• DISPATCH_NUMBER — the number of items required to be installed at the sequence before flight dispatch.
• OBJECT_VERSION_NUMBER — the locking sequence number used for optimistic concurrency control.
• SECURITY_GROUP_ID — used in application hosting / multi-tenant data segregation; references FND_SECURITY_GROUPS.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield structure and attribute columns for customer-specific extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Who audit columns.

Common Use Cases and Queries

Typical uses include generating MEL/CDL reports that enumerate ATA codes with their dispatch and installed limits, validating deferral configurations, and tracing which procedures, relationships, or unit deferrals depend on a given ATA sequence.

• Listing ATA sequences for a MEL/CDL header:

  SELECT ata_code, installed_number, dispatch_number
  FROM   ahl.ahl_mel_cdl_ata_sequences
  WHERE  mel_cdl_header_id = :p_header_id
  ORDER  BY ata_code;

• Joining to the header for reporting:

  SELECT h.header_name, a.ata_code, a.installed_number, a.dispatch_number
  FROM   ahl.ahl_mel_cdl_ata_sequences a, ahl.ahl_mel_cdl_headers h
  WHERE  a.mel_cdl_header_id = h.mel_cdl_header_id;

• Identifying dependent procedures and relationships via ATA_SEQUENCE_ID in AHL_MEL_CDL_MO_PROCEDURES, AHL_MEL_CDL_RELATIONSHIPS, and AHL_UNIT_DEFERRALS_B.
• Auditing rows modified within a date range using the Who columns.

Related Objects

• AHL.AHL_MEL_CDL_HEADERS — parent entity; joined via MEL_CDL_HEADER_ID.
• AHL.AHL_REPAIR_CATEGORIES — repair category reference via REPAIR_CATEGORY_ID.
• FND_SECURITY_GROUPS — hosting security reference via SECURITY_GROUP_ID.
• AHL.AHL_MEL_CDL_MO_PROCEDURES — references this table through ATA_SEQUENCE_ID.
• AHL.AHL_MEL_CDL_RELATIONSHIPS — references ATA_SEQUENCE_ID and RELATED_ATA_SEQUENCE_ID.
• AHL.AHL_UNIT_DEFERRALS_B — references ATA_SEQUENCE_ID for unit-level deferrals.