Search Results ahl_mel_cdl_headers_u2

Overview

AHL.AHL_MEL_CDL_HEADERS is a transactional table in the Oracle E-Business Suite AHL (Complex Maintenance, Repair and Overhaul) schema that stores MEL (Minimum Equipment List) and CDL (Configuration Deviation List) header information associated with a Product Classification node. Each row represents a discrete MEL or CDL document defined against a node in the product classification hierarchy, capturing its type, status, revision, and internal version along with the standard administrative columns common to EBS transactional entities.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, reflecting its role as an actively maintained transactional object rather than reference data. It carries a single-column surrogate primary key, AHL_MEL_CDL_HEADERS_PK, defined on MEL_CDL_HEADER_ID. A Data Vault classification heuristic derived from the foreign key structure suggests a satellite-leaning profile: the table holds descriptive, versioned attributes about a MEL/CDL document and depends outward on parent entities rather than acting as a central hub or link. This classification should be treated as a modeling suggestion for integration or warehouse design, not as a physical constraint in the EBS schema.

Key Information Stored

The most significant columns in this table are:

• MEL_CDL_HEADER_ID — surrogate primary key and the unique identifier referenced by dependent child tables.
• PC_NODE_ID — the Product Classification node to which the MEL/CDL is associated; part of the business key.
• MEL_CDL_TYPE_CODE — distinguishes the record as a MEL or CDL, validated against the AHL_MEL_CDL_TYPE lookup type; part of the business key.
• VERSION_NUMBER — the internal version number of the MEL/CDL; part of the business key.
• STATUS_CODE — current status of the MEL/CDL, validated against the AHL_MEL_CDL_STATUS lookup type.
• REVISION — user-entered revision identifier for the document.
• REVISION_DATE and EXPIRED_DATE — the dates on which the MEL/CDL was revised and on which it expires, supporting effective-dated reporting.
• OBJECT_VERSION_NUMBER — locking sequence number used for optimistic concurrency control in the EBS framework.
• SECURITY_GROUP_ID — used in application hosting and multi-tenant isolation.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield columns for customer-specific extensions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — standard Who columns.

Two unique indexes define candidate business keys. AHL_MEL_CDL_HEADERS_U1 enforces uniqueness on MEL_CDL_HEADER_ID, while AHL_MEL_CDL_HEADERS_U2 enforces uniqueness on the composite of PC_NODE_ID, MEL_CDL_TYPE_CODE, and VERSION_NUMBER — the natural business key that guarantees only one document version of a given type exists per classification node.

Common Use Cases and Queries

The primary use case is retrieving the active or current MEL/CDL for a given product classification node, filtering on status and expiration. A typical query joins to the node table:

• Reporting the latest valid MEL/CDL per node: SELECT h.* FROM ahl_mel_cdl_headers h WHERE h.pc_node_id = :node_id AND h.status_code = 'ACTIVE' AND (h.expired_date IS NULL OR h.expired_date > SYSDATE);
• Version history for a document: filter on PC_NODE_ID and MEL_CDL_TYPE_CODE ordered by VERSION_NUMBER to trace revisions.
• Population of child line data by joining MEL_CDL_HEADER_ID to AHL_MEL_CDL_ATA_SEQUENCES.
• Flexfield-based reporting using ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 for customer-defined fields.
• Security-filtered extracts keyed on SECURITY_GROUP_ID in hosted deployments.

Related Objects

• AHL.AHL_PC_NODES_B — parent product classification node; joined via AHL_MEL_CDL_HEADERS.PC_NODE_ID = AHL_PC_NODES_B.PC_NODE_ID.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for hosted security group resolution.
• AHL.AHL_MEL_CDL_ATA_SEQUENCES — child table holding ATA sequence detail; joined via MEL_CDL_HEADER_ID.
• AHL_MEL_CDL_TYPE and AHL_MEL_CDL_STATUS — lookup types validating MEL_CDL_TYPE_CODE and STATUS_CODE.
• AHL MEL/CDL maintenance forms and concurrent programs that create, revise, and expire header records.