Search Results parent_mc_id

Overview

The APPS.AHL_UC_HEADER_PATHS_V view is a dictionary-reported Oracle E-Business Suite database object owned by the APPS schema. It is classified as an internal view with FND Design Data reference AHL.AHL_UC_HEADER_PATHS_V and is reported as VALID in ETRM 12.2.2 metadata (also applicable to the 12.1.1 code line). The object belongs to the Oracle Enterprise Asset Management / Asset Lifecycle (AHL) product family, specifically the unit configuration (UC) and model configuration (MC) sub-areas. Its purpose is to resolve and present the hierarchical paths that exist between unit configuration headers and a parent structure, exposing both the child side (unit configuration header, model configuration header, revision, version) and the parent side of each relationship. The view therefore provides a denormalized, query-friendly projection of an otherwise multi-table graph traversal. Because Oracle marks this object as Oracle Internal Use Only, it is not a supported integration interface; customers should treat it as a reference and avoid building production dependencies on it. In the context of the search term "mc_revision", the view is notable because it directly exposes a named column MC_REVISION, allowing the model configuration revision identifier to be carried through hierarchy navigation without a manual join back to AHL_MC_HEADERS_B.

Underlying Base Objects

The view is defined over four APPS synonyms, each resolving to the underlying AHL and CSI base tables:

• AHL_MC_HEADERS_B — model configuration header base table, the source of the MC header, revision, and version attributes.
• AHL_MC_RELATIONSHIPS — the relationship table that defines parent/child links between model configuration records, supplying relationship and position keys.
• AHL_UNIT_CONFIG_HEADERS — unit configuration header table, supplying the UC header, instance, and name attributes.
• CSI_II_RELATIONSHIPS — the CSI instance-item relationship table, used to correlate installed base instance identifiers with the configuration graph.

The view is referenced by two PL/SQL packages, AHL_FMP_PVT and AHL_MC_PATH_POSITION_PVT, confirming its role as an internal dependency for configuration path and position resolution logic rather than as a public reporting interface.

Key Columns

The projection returns both child and parent attribute sets. The principal columns are:

• UC_HEADER_ID, NAME, CSI_INSTANCE_ID — identify the unit configuration header and its associated CSI instance.
• MC_HEADER_ID, MC_REVISION, MC_ID, MC_VERSION_NUMBER — identify the model configuration of the current node, including the revision string central to the search term.
• RELATIONSHIP_ID, POSITION_KEY — the link and ordinal position of the node within its parent.
• PARENT_UC_HEADER_ID, PARENT_INSTANCE_ID, PARENT_MC_HEADER_ID, PARENT_MC_ID, PARENT_VERSION_NUMBER, PARENT_RELATIONSHIP_ID, PARENT_POSITION_KEY — the corresponding attributes for the parent node.

Common Use Cases and Queries

Typical uses include reconstructing configuration hierarchies, locating parents of a given unit configuration, and auditing model configuration revisions across a structure. A minimal query is:

SELECT UC_HEADER_ID, NAME, MC_HEADER_ID, MC_REVISION,
       MC_VERSION_NUMBER, PARENT_UC_HEADER_ID, PARENT_MC_HEADER_ID,
       PARENT_POSITION_KEY
FROM   APPS.AHL_UC_HEADER_PATHS_V;

To filter by revision, add a predicate such as WHERE MC_REVISION = :revision. Because the object is unsupported and internal, such queries should be restricted to diagnostics, data investigation, or read-only reconciliation, and never embedded in delivered or upgrade-sensitive customizations.