Search Results ahl_mr_intervals




Overview
Explore in AI Chat

Overview

The AHL_MR_INTERVALS table is a core data object within the Oracle E-Business Suite (EBS) module for Complex Maintenance, Repair, and Overhaul (CMRO). It serves a critical function in asset lifecycle management by defining the frequency or schedule at which a specific maintenance requirement must be performed. This table is fundamental to establishing preventive maintenance programs, ensuring that inspections, repairs, and overhauls are executed at defined intervals based on time, usage, or other operational counters. Its data directly influences maintenance work order generation and scheduling within the application.

Key Information Stored

The table's primary purpose is to store interval definitions for maintenance requirements. Its key columns, as indicated by the metadata, include the primary key MR_INTERVAL_ID, which uniquely identifies each interval record. The MR_EFFECTIVITY_ID is a critical foreign key that links the interval to its parent maintenance requirement definition in the AHL_MR_EFFECTIVITIES table. The COUNTER_ID foreign key links to the CS_COUNTERS table, indicating the specific measurement (e.g., flight hours, cycles, calendar days) against which the interval is tracked. While the full column list is not detailed in the excerpt, typical interval-related data stored would include values specifying the interval length, tolerance windows, and applicable units of measure.

Common Use Cases and Queries

This table is central to queries that list or analyze maintenance schedules. Common use cases include generating reports of all preventive maintenance tasks due within a specific timeframe, validating interval data during maintenance program setup, and integrating schedule data with external planning systems. A typical SQL pattern involves joining AHL_MR_INTERVALS to AHL_MR_EFFECTIVITIES and AHL_MAINT_REQUESTS to retrieve the full maintenance task definition along with its scheduled frequency.

  • Sample Query: Retrieving basic interval information for a maintenance requirement.
SELECT mri.mr_interval_id, mri.counter_id, mre.mr_title
FROM ahl_mr_intervals mri,
     ahl_mr_effectivities mre
WHERE mri.mr_effectivity_id = mre.mr_effectivity_id
AND mre.mr_header_id = <MR_HEADER_ID>;

Related Objects

The metadata explicitly defines this table's integration within the CMRO schema. It is a primary entity referenced by several key objects. The primary key (MR_INTERVAL_ID) is referenced by the AHL_UNIT_EFFECTIVITIES_B table, which applies maintenance requirements and their intervals to specific asset units. Furthermore, AHL_MR_INTERVALS itself holds foreign key relationships to two essential tables: AHL_MR_EFFECTIVITIES, to get the requirement details, and CS_COUNTERS (from the Service Contracts module), to understand the counter type governing the interval. This network of relationships underscores its role as a linchpin between maintenance definitions, asset instances, and measurement systems.