Search Results ahl_mc_headers_vl




Overview
Explore in AI Chat

Overview

In Oracle E-Business Suite 12.1.1 and 12.2.2, APPS.AHL_MC_HEADERS_VL is a documented view belonging to the AHL - Complex Maintenance Repair and Overhaul product. It exposes Master Configuration header information, combining translation-independent attributes with translatable descriptive text. The "_VL" suffix denotes a "view language" construct — a standard Oracle EBS pattern used to join a base ("_B") table, which stores language-neutral data, with a translation ("_TL") table, which stores language-specific data. This design enables multilingual support without duplicating non-translatable columns across languages.

Master Configurations in AHL represent configured maintenance structures and assemblies used in complex MRO processes. Because reporting and integration layers frequently require a single flat source for header data that respects the user's session language, the view is the preferred access point rather than the individual base tables. The view status is VALID and it is owned by the APPS schema, consistent with EBS standards where public synonyms and grants expose such objects to custom code and concurrent programs.

Underlying Base Objects

The view is defined over two synonymed base objects:

  • AHL_MC_HEADERS_B (synonym) — the base table holding translation-independent header attributes such as identifiers, version, revision, status, audit columns, and descriptive flexfield (DFF) attributes.
  • AHL_MC_HEADERS_TL (synonym) — the translation table holding the translatable DESCRIPTION column.

The documented view text joins these on MCHB.MC_HEADER_ID = MCHTL.MC_HEADER_ID and filters translations with MCHTL.LANGUAGE = USERENV('LANG'). The USERENV('LANG') predicate ensures each session sees only the row for its current language, presenting a single logical record per master configuration header. Because the join filters to one language, callers receive exactly one description value per header according to session locale.

Key Columns

  • ROW_ID — the base-table ROWID of the underlying header record (from MCHB), useful for row identification.
  • MC_HEADER_ID — the primary identifier of the master configuration header; the join key between the base and translation tables.
  • OBJECT_VERSION_NUMBER — optimistic locking / concurrency control column used by the OAF/BC4J framework.
  • NAME — the (translation-independent) name of the master configuration header.
  • MC_ID — reference to the associated master configuration identifier.
  • VERSION_NUMBER, REVISION — versioning and revision control of the configuration header.
  • CONFIG_STATUS_CODE — status code reflecting the lifecycle state of the configuration.
  • SECURITY_GROUP_ID — the multi-org/security grouping identifier for data segregation.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard "Who" audit columns.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield columns for extensible attributes.
  • DESCRIPTION — the translatable description text from the TL table, returned in the session language.

Common Use Cases and Queries

Typical usage includes custom reports, concurrent programs, BI Publisher data sources, and integration extracts that need master configuration header data in the user's language without manually joining the B and TL tables.

Retrieve all master configuration headers for the current session language:

  • SELECT mc_header_id, name, version_number, revision, config_status_code, description FROM apps.ahl_mc_headers_vl;

Filter by name pattern and status:

  • SELECT mc_header_id, name, config_status_code, description FROM apps.ahl_mc_headers_vl WHERE name LIKE 'CFG%' AND config_status_code = 'ACTIVE' ORDER BY name;

Join to related detail tables using the header identifier:

  • SELECT h.name, h.description, d.* FROM apps.ahl_mc_headers_vl h, apps.ahl_mc_details d WHERE h.mc_header_id = d.mc_header_id;

Extract DFF attributes for integration:

  • SELECT mc_header_id, name, attribute_category, attribute1, attribute2 FROM apps.ahl_mc_headers_vl WHERE attribute_category IS NOT NULL;

Because the view embeds the USERENV('LANG') predicate, ensure the session language is set appropriately when the same data is expected across concurrent runs; otherwise description text may differ by environment.