Search Results revision_qty_cntrl_code




Overview
Explore in AI Chat

Overview

APPS.AHL_MTL_ITEMS_OU_V is an Oracle E-Business Suite view that presents item master attribute data filtered by operating unit. It is part of the Oracle Enterprise Asset Management / Asset Lifecycle (AHL) schema family, providing a joined, denormalized projection of item definitions across inventory organizations that belong to the currently selected operating unit. Rather than exposing raw MTL_SYSTEM_ITEMS_KFV records, the view restricts results to organizations defined in ORG_ORGANIZATION_DEFINITIONS whose operating unit matches the current MO_GLOBAL context (NVL(operating_unit, MO_GLOBAL.GET_CURRENT_ORG_ID()) = MO_GLOBAL.GET_CURRENT_ORG_ID()). This makes it a Multi-Org (MOAC) aware source for reports, extensions, and inbound/outbound integrations that must respect operating unit security without manually applying org filters. The column alias SERIAL_NBR_CNTRL_CODE is the point of interest for the searched term "serial_nbr_cntrl_code", mapping to the underlying SERIAL_NUMBER_CONTROL_CODE attribute of the item.

Underlying Base Objects

The view is defined over a three-way join of documented base objects:

  • MTL_SYSTEM_ITEMS_KFV (synonym) — the key flexfield-enabled item master view supplying all item attributes.
  • HR_ORGANIZATION_UNITS (view) — supplies the organization NAME, joined on ORGANIZATION_ID = HOU.ORGANIZATION_ID.
  • MTL_PARAMETERS (synonym) — supplies ORGANIZATION_CODE and EAM_ENABLED_FLAG, joined via HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID.
  • ORG_ORGANIZATION_DEFINITIONS (view) — used in the subquery to enforce operating unit security.
  • MO_GLOBAL (package) and HR_SECURITY / HR_GENERAL (packages) — provide the current operating unit context and organization security resolution.

The join is driven by the organization dimension, so only items associated with valid, OU-mapped inventory organizations are returned.

Key Columns

Common Use Cases and Queries

This view is commonly used to list serial-controlled items within the current operating unit, to validate item setup before inventory or EAM transactions, and to feed integration extracts.

Example — retrieve serial-controlled items for the current operating unit:

SELECT inventory_item_id, concatenated_segments, description, organization_name, serial_nbr_cntrl_code FROM apps.ahl_mtl_items_ou_v WHERE serial_nbr_cntrl_code > 0 ORDER BY organization_code, concatenated_segments;

Example — identify EAM-enabled serialized items:

SELECT inventory_item_id, serial_nbr_cntrl_code, eam_item_type, eam_enabled_flag FROM apps.ahl_mtl_items_ou_v WHERE service_item_flag = 'Y' AND serial_nbr_cntrl_code IN ('1','2','3','4','5');

Because the view resolves operating unit through MO_GLOBAL, integrations should initialize the org context (e.g., via FND_GLOBAL or MO_GLOBAL.SET_POLICY_CONTEXT) before querying to ensure correct OU-scoped results.