Search Results ahl_unit_deferrals_b




Overview
Explore in AI Chat

Overview

AHL_UNIT_DEFERRALS_B is a base table in the AHL schema, the product schema for Oracle Complex Maintenance, Repair and Overhaul (CMRO), a module within Oracle E-Business Suite Release 12.1.1 and 12.2.2. The table stores the deferral and Maintenance Requirement (MR) initialization information associated with a unit effectivity. In aerospace and defense MRO scenarios, a unit — an aircraft, engine, or repairable assembly — carries a unit effectivity record that governs the applicability of maintenance program requirements. A deferral allows an operator to postpone an otherwise due maintenance action, or to suppress MR initialization for that effectivity, under documented approval and eligibility rules. This table therefore sits at the transactional core of deferred maintenance tracking and MEL/CDL (Minimum Equipment List / Configuration Deviation List) processing.

Based on the foreign key structure, the data warehouse classification heuristic suggests this is a satellite-leaning object: its primary key is a surrogate UNIT_DEFERRAL_ID, while its descriptive and transactional attributes (deferral type, approval status, due-date handling flags, reason codes, and extensible ATTRIBUTE1–ATTRIBUTE15 columns) surround the UNIT_EFFECTIVITY_ID business reference. This classification is a modeling suggestion only; in the operational EBS schema, the table behaves as a transactional base table with a companion translation table.

Key Information Stored

The table contains 35 documented columns. The most significant are:

Common Use Cases and Queries

Typical operational and reporting scenarios include listing all active deferrals for a unit effectivity, validating approvals, and auditing due-date impacts.

  • Retrieve non-cancelled deferrals for an effectivity:

SELECT d.unit_deferral_id, d.unit_deferral_type, d.set_due_date, d.approval_status_code
FROM ahl_unit_deferrals_b d
WHERE d.unit_effectivity_id = :p_effectivity_id
AND NVL(d.cancel_flag,'N') = 'N';

  • Join to translations to obtain the descriptive deferral name:

SELECT d.unit_deferral_id, t.deferral_name
FROM ahl_unit_deferrals_b d, ahl_unit_deferrals_tl t
WHERE d.unit_deferral_id = t.unit_deferral_id
AND t.language = USERENV('LANG');

  • Identify deferrals suppressing MR initialization (SKIP_MR_FLAG = 'Y') for compliance reporting.
  • Reconcile deferrals against ATA chapter sequences using ATA_SEQUENCE_ID for MEL/CDL analysis.

Related Objects

  • AHL_UNIT_EFFECTIVITIES_B — parent effectivity; joined on UNIT_EFFECTIVITY_ID.
  • AHL_UNIT_DEFERRALS_TL — translation table; joined on UNIT_DEFERRAL_ID and referencing this table.
  • AHL_UNIT_THRESHOLDS — threshold definitions per deferral; joined on UNIT_DEFERRAL_ID.
  • AHL_MEL_CDL_ATA_SEQUENCES — ATA sequence reference; joined on ATA_SEQUENCE_ID.
  • FND_SECURITY_GROUPS — security group reference via SECURITY_GROUP_ID.