Search Results ahl_unit_deferrals_b_pk

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:

• UNIT_DEFERRAL_ID — surrogate primary key, enforced by AHL_UNIT_DEFERRALS_B_PK and uniquely indexed by AHL_UNIT_DEFERRALS_B_U1.
• UNIT_EFFECTIVITY_ID — the unit effectivity to which the deferral applies; joins to AHL_UNIT_EFFECTIVITIES_B. Together with UNIT_DEFERRAL_TYPE it forms the business-key candidate AHL_UNIT_DEFERRALS_B_U2.
• UNIT_DEFERRAL_TYPE — discriminates the deferral category (for example, a full deferral versus MR initialization suppression).
• USER_DEFERRAL_TYPE — the operator-facing or user-assigned deferral classification.
• SKIP_MR_FLAG — indicates whether maintenance requirement initialization is skipped for the effectivity.
• SET_DUE_DATE — the due date established for the deferred requirement.
• AFFECT_DUE_CALC_FLAG — controls whether the deferral participates in due-date calculation.
• DEFERRAL_EFFECTIVE_ON — the date the deferral takes effect.
• DEFER_REASON_CODE — coded justification for the deferral.
• APPROVAL_STATUS_CODE — workflow or approval state of the deferral request.
• CANCEL_FLAG — marks the deferral as cancelled without physical deletion.
• ATA_SEQUENCE_ID — links the deferral to an ATA chapter sequence via AHL_MEL_CDL_ATA_SEQUENCES.
• Standard EBS audit columns: OBJECT_VERSION_NUMBER, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and SECURITY_GROUP_ID.

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.