Search Results build_in_wip_flag




Overview
Explore in AI Chat

Overview

APPS.AHL_MTL_ITEMS_NON_OU_V is a valid database view owned by the APPS schema and shipped as part of the AHL (Complex Maintenance Repair and Overhaul) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to expose inventory item definitions drawn from all inventory organizations without regard to Operating Unit (OU) boundaries. The view's description states explicitly that it retrieves items from all inventory organizations and that the item's organization need not reside in the same Operating Unit as the querying responsibility. This makes it a cross-OU read model rather than a transactional or secured data source.

Within EBS, this view is used for reporting, integration, and internal AHL processing where a maintenance or MRO workflow must resolve item attributes across the enterprise. Because item master and item organization data are normally subject to Operating Unit and organization security, the view provides a denormalized, read-only projection that bypasses OU scoping while still restricting results to EAM-enabled organizations.

Underlying Base Objects

The documented base objects for the 12.2.2 metadata are:

The join logic is driven from MTL_PARAMETERS: MP.MASTER_ORGANIZATION_ID = HOU.ORGANIZATION_ID and KFV.ORGANIZATION_ID = MP.ORGANIZATION_ID, with a filter of MP.EAM_ENABLED_FLAG = 'Y'. SELECT DISTINCT is applied, and the organization code is obtained through a subquery on MTL_PARAMETERS, while the description is obtained through a subquery on MTL_SYSTEM_ITEMS_KFV for the master organization. As synonyms are used in 12.2.2, the physical tables are typically MTL_SYSTEM_ITEMS_B/TL (via the KFV view), MTL_PARAMETERS, and HR_ORGANIZATION_UNITS.

Key Columns

Common Use Cases and Queries

Typical scenarios include enterprise-wide item reporting, cross-OU maintenance lookups, and validation of revision and quantity control settings for EAM-enabled organizations. Because results are not OU-restricted, the view suits centralized reporting but should not be used for transactional posting.

Listing EAM-enabled items with their revision control setting:

  • SELECT INVENTORY_ITEM_ID, CONCATENATED_SEGMENTS, ORGANIZATION_CODE, REVISION_QTY_CNTRL_CODE FROM APPS.AHL_MTL_ITEMS_NON_OU_V WHERE REVISION_QTY_CNTRL_CODE IS NOT NULL;
  • SELECT ORGANIZATION_CODE, COUNT(*) FROM APPS.AHL_MTL_ITEMS_NON_OU_V GROUP BY ORGANIZATION_CODE;
  • SELECT INVENTORY_ITEM_ID, DESCRIPTION, LOT_CONTROL_CODE, SERIAL_NBR_CNTRL_CODE FROM APPS.AHL_MTL_ITEMS_NON_OU_V WHERE ENABLED_FLAG = 'Y' AND MTL_TRANSACTIONS_ENABLED_FLAG = 'Y';

Note the DISTINCT and correlated subqueries can affect performance on large item masters; restrict by ORGANIZATION_CODE or ENABLED_FLAG where possible.