Search Results ahl_yes_no_type




Overview
Explore in AI Chat

Overview

The view APPS.AHL_MR_HEADERS_V is a reporting and integration layer exposed by Oracle E-Business Suite for the Maintenance Management (Enterprise Asset Management) product family. It presents maintenance requirement headers — the top-level definition of a planned maintenance, service, or overhaul work specification — together with their translated descriptive text and a large set of decoded lookup meanings. The view is owned by the APPS schema and is intended to be consumed directly by reports, concurrent programs, OAF pages, and external integrations rather than queried at the base table level.

Its principal value is that it resolves raw code columns (status, category, service type, proposal type, UOM, and similar) into human-readable meanings by joining to the appropriate lookup and value-set sources in a single access path. This shelters reporting code from the underlying normalization of the AHL_MR_HEADERS_B / AHL_MR_HEADERS_TL pair and removes the need for report authors to write repeated lookup subqueries.

Underlying Base Objects

The view is defined over a join of the base table AHL_MR_HEADERS_B (aliased MR) and its translation table AHL_MR_HEADERS_TL (aliased MR_TL), which together hold the language-independent and language-dependent maintenance requirement header attributes. Additional documented base objects referenced in the view text are:

In the ETRM 12.2.2 metadata these appear as synonyms owned by APPS, with FND_LOOKUP_VALUES_VL itself being a view and FND_PROFILE a package. The precedence maintenance requirement (PMR) rows are also joined to expose the preceding header's title and revision.

Key Columns

The view exposes the full identity and descriptive set of the maintenance requirement header. Significant columns include:

Common Use Cases and Queries

Typical usage includes maintenance program listings, status dashboards, integration extracts that must map coded values to meanings, and ad-hoc lookups of yes/no flag behaviour. Because the view already supplies decoded meanings, queries are concise:

  • List active headers with their status and category meanings, filtered on EFFECTIVE_TO IS NULL OR EFFECTIVE_TO > SYSDATE.
  • Report on copy behaviour flags, for example SELECT MR_HEADER_ID, TITLE, COPY_INIT_ACCOMPLSMNTS, COPY_DEFERRALS FROM APPS.AHL_MR_HEADERS_V.
  • Join to MTL_SYSTEM_ITEMS_KFV or billing tables using BILLING_ITEM_ID and BILLING_ORG_ID.
  • Filter by SERVICE_TYPE_CODE or MR_STATUS_CODE for workload and scheduling reporting.

Always qualify the view as APPS.AHL_MR_HEADERS_V and restrict rows on indexed base columns where possible, since the view performs numerous correlated lookups that can affect performance on large data sets.