Search Results ahl_mr_effectivity_dtls




Overview
Explore in AI Chat

Overview

The AHL_MR_EFFECTIVITY_DTLS table is a core data object within the Oracle E-Business Suite module for Complex Maintenance, Repair, and Overhaul (AHL). It functions as a detail table that stores granular, item instance-level specifications for a maintenance requirement's effectivity. Its primary role is to define precisely which physical units or configurations a specific maintenance task applies to, based on criteria such as serial numbers, manufacturer details, and geographical location. This table is essential for ensuring maintenance plans are accurately targeted and executed on the correct assets within the CMRO framework.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the documented foreign key relationships and description indicate the table holds critical identifiers and attributes. The primary key, MR_EFFECTIVITY_DETAIL_ID, uniquely identifies each detail record. The MR_EFFECTIVITY_ID column links the detail to its parent definition in the AHL_MR_EFFECTIVITIES table. Key descriptive columns include MANUFACTURER_ID, which references the MTL_MANUFACTURERS table to specify the asset's maker, and COUNTRY_CODE, which references FND_TERRITORIES to potentially define a geographical constraint for the effectivity. Other typical columns in such a structure would include serial number ranges, lot numbers, or specific item instance identifiers to pinpoint the applicable assets.

Common Use Cases and Queries

This table is central to queries that determine the exact scope of a maintenance requirement. A common use case is generating a work order for a specific asset; the system queries this table to verify if the asset's serial number, manufacturer, and location match any effectivity details tied to an active maintenance requirement. For reporting, analysts join this table to asset and maintenance header tables to list all assets subject to a particular maintenance task. A typical SQL pattern involves filtering on the parent MR_EFFECTIVITY_ID and joining to manufacturer and territory tables for descriptive information:

  • SELECT amed.*, mm.manufacturer_name, ft.territory_short_name FROM ahl_mr_effectivity_dtls amed, mtl_manufacturers mm, fnd_territories ft WHERE amed.mr_effectivity_id = :p_mr_effectivity_id AND amed.manufacturer_id = mm.manufacturer_id(+) AND amed.country_code = ft.territory_code(+);

Related Objects

The table maintains defined relationships with several key EBS objects, primarily through foreign key constraints. The central relationship is with the AHL_MR_EFFECTIVITIES table via the MR_EFFECTIVITY_ID column, linking details to their parent effectivity rule. For descriptive data, it references the inventory master table MTL_MANUFACTURERS via the MANUFACTURER_ID column and the foundational FND_TERRITORIES table via the COUNTRY_CODE column. As a detail table, it is likely referenced by various CMRO transactional and reporting interfaces to resolve asset-specific maintenance applicability.