Search Results ahl_mc_config_relations




Overview
Explore in AI Chat

Overview

The AHL_MC_CONFIG_RELATIONS table is a core data object within the Oracle E-Business Suite module for Complex Maintenance, Repair, and Overhaul (AHL). It serves as a critical junction table that defines and stores hierarchical relationships between master configurations. Its primary role is to map sub-configurations to their parent master configurations, enabling the modeling of complex, multi-level equipment structures. This foundational data supports the configuration management capabilities essential for maintaining detailed service histories, managing assemblies, and executing maintenance operations on configurable assets within the EBS system.

Key Information Stored

The table stores the specific instances of relationships between master configuration headers. Its key columns, as defined by its primary and unique keys, are central to its function. The MC_CONFIG_RELATION_ID column serves as the unique system-generated identifier (primary key) for each relationship record. The RELATIONSHIP_ID column is a foreign key that references the AHL_MC_RELATIONSHIPS table, defining the type of relationship (e.g., parent-child, substitute) being instantiated. The MC_HEADER_ID column is a foreign key that references the AHL_MC_HEADERS_B table, identifying the specific child or sub-configuration header record being linked to a parent. Together, these columns create a precise mapping between a relationship definition and the actual configuration items it connects.

Common Use Cases and Queries

This table is primarily accessed to traverse and understand the hierarchical structure of a configurable item. A common reporting use case is to generate a complete bill-of-materials or configuration tree for a top-level master configuration. For troubleshooting or data validation, queries often join this table to the master configuration headers to verify relationship integrity. A typical SQL pattern to find all immediate sub-configurations for a given parent master configuration header ID would involve joining AHL_MC_CONFIG_RELATIONS (CR) to AHL_MC_HEADERS_B for the child details and filtering via the relationship definition.

SELECT cr.mc_header_id AS child_header_id,
       mch_b.CONFIGURATION_NAME AS child_config_name
FROM AHL_MC_CONFIG_RELATIONS cr,
     AHL_MC_HEADERS_B mch_b
WHERE cr.mc_header_id = mch_b.mc_header_id
  AND cr.relationship_id IN
      (SELECT relationship_id
       FROM AHL_MC_RELATIONSHIPS
       WHERE parent_mc_header_id = :p_parent_header_id);

Related Objects

The AHL_MC_CONFIG_RELATIONS table is centrally linked within the AHL configuration schema through well-defined foreign key relationships. It is a child table to both AHL_MC_RELATIONSHIPS and AHL_MC_HEADERS_B. Specifically, the RELATIONSHIP_ID column references AHL_MC_RELATIONSHIPS, which holds the definitional template for the relationship, including the parent configuration identifier. The MC_HEADER_ID column references AHL_MC_HEADERS_B, which stores the detailed header information for the child configuration item. This structure ensures that every record in AHL_MC_CONFIG_RELATIONS is a valid instance of a defined relationship type applied to a valid master configuration.