Search Results ahl_prog_type_subtypes_v




Overview
Explore in AI Chat

Overview

The view APPS.AHL_PROG_TYPE_SUBTYPES_V is a denormalized, lookup-resolved reporting view within the Oracle E-Business Suite (EBS) Complex Maintenance, Repair and Overhaul (AHL / eAM-MRO) product family. It exposes the relationship between program types and program subtypes as defined for Maintenance Repair (MR) program configuration, resolving the internal code values into their user-facing meanings and descriptions. The view is owned by the APPS schema and holds VALID status in both EBS 12.1.1 and 12.2.2.

In operational terms, the underlying entity AHL_PROG_TYPE_SUBTYPES stores the association between a program type lookup code and a program subtype lookup code, together with descriptive flexfield attributes. Rather than requiring report authors, integrations, or BI Publisher data models to perform multiple joins against FND_LOOKUP_VALUES_VL, this view pre-joins the lookups so that the translatable MEANING and DESCRIPTION columns are surfaced directly. This makes it convenient for reporting, concurrent-program extracts, and integration payloads that must present human-readable program type and subtype labels.

Underlying Base Objects

Per the documented ETRM metadata, AHL_PROG_TYPE_SUBTYPES_V is defined over three referenced objects:

The view therefore inherits the row-filtering behavior of an inner-join lookup resolution: a subtype relationship row will only appear if valid lookup values exist in both lookup types. The two FND_LOOKUP_VALUES_VL references are the same underlying view, used twice with distinct aliases for the type and subtype lookups respectively.

Key Columns

  • PROG_TYPE_SUBTYPE_ID — Primary identifier for the type/subtype relationship row; the principal key for joining back to the base table.
  • OBJECT_VERSION_NUMBER — Optimistic locking / concurrency column inherited from the base table.
  • PROGRAM_TYPE_CODE and PROGRAM_SUBTYPE_CODE — Internal lookup codes for the program type and subtype associations.
  • PROGRAM_TYPE and PROGRAM_TYPE_DESCRIPTION — The resolved lookup MEANING and DESCRIPTION for the program type (from alias PT).
  • PROGRAM_SUBTYPE and PROGRAM_SUBTYPE_DESCRIPTION — The resolved lookup MEANING and DESCRIPTION for the program subtype (from alias ST).
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield context and segment columns carried through from the base table for extensibility.

Common Use Cases and Queries

Typical uses include reporting on configured maintenance program type/subtype pairings, driving LOV-style selection lists in custom forms or OAF pages, and supplying readable labels in integration extracts. Because meanings are translatable, the view returns language-appropriate values for the session.

To list all resolved type/subtype relationships:

  • SELECT PROG_TYPE_SUBTYPE_ID, PROGRAM_TYPE, PROGRAM_SUBTYPE, PROGRAM_TYPE_DESCRIPTION, PROGRAM_SUBTYPE_DESCRIPTION FROM APPS.AHL_PROG_TYPE_SUBTYPES_V;

To filter for a specific program type or to inspect flexfield data:

  • SELECT PROGRAM_TYPE_CODE, PROGRAM_SUBTYPE_CODE, ATTRIBUTE_CATEGORY, ATTRIBUTE1 FROM APPS.AHL_PROG_TYPE_SUBTYPES_V WHERE PROGRAM_TYPE_CODE = :p_type;

Because the view performs the lookup joins internally, callers avoid writing the two FND_LOOKUP_VALUES_VL joins themselves and can rely on the view for consistent, translated presentation of program type and subtype data.