Search Results ahl_unit_alternates_v




Overview
Explore in AI Chat

Overview

APPS.AHL_UNIT_ALTERNATES_V is a reporting and integration view within the Oracle E-Business Suite AHL (Complex Maintenance Repair and Overhaul) product family. Its documented purpose is to retrieve alternate item instances available in Oracle Install Base for a given position (node) as defined by a Master Configuration. In other words, where a Master Configuration defines a set of valid items or positions, this view surfaces the serialized units in Install Base that can legitimately substitute or occupy that position, together with the ownership, location, and item attributes required for downstream decision-making.

The object is registered in ETRM as a VALID VIEW owned by the APPS schema and is available in both 12.1.1 and 12.2.2. It is commonly encountered in ETRM searches alongside po_vendors because one branch of its owner resolution logic queries the PO_VENDORS synonym to derive vendor numbers and vendor names for supplier-owned instances. This makes the view a convenient single source for both party-owned and vendor-owned unit information without requiring external joins.

Underlying Base Objects

The view is defined over a mixture of synonym-wrapped base tables, other views, packages, and lookups. The documented referenced objects include:

The view therefore sits at the intersection of Install Base (CSI), Master Configuration (AHL), inventory items (MTL), and supplier/party masters (PO/HZ).

Key Columns

Common Use Cases and Queries

Typical scenarios include identifying all valid replacement units for a configured position, verifying whether a supplier-owned unit may be substituted, and producing owner/status reports for MRO planning. A basic query to list alternates with owner resolution is:

  • SELECT csi_instance_number, item_number, owner_name, party_type, status FROM apps.ahl_unit_alternates_v WHERE inventory_item_id = :item_id;
  • SELECT csi_item_instance_id, owner_number, location_description FROM apps.ahl_unit_alternates_v WHERE party_type = 'VENDOR';
  • SELECT csi_instance_number, item_description, priority FROM apps.ahl_unit_alternates_v ORDER BY priority;

Because owner resolution depends on PARTY_SOURCE_TABLE, filtering by PARTY_TYPE is the reliable method for isolating vendor-supplied versus partner-supplied instances. As with most Install Base views, queries should be filtered by organization where possible to leverage MO_GLOBAL security processing.