Search Results primary_unit_of_measure




Overview
Explore in AI Chat

Overview

The APPS.ICX_MTL_DEMAND_ITEM_SUM_V view is a consolidated item availability aggregation view delivered within the Oracle iProcurement (ICX) module of Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description is "Item Availability View," reflecting its purpose of presenting summarized on-hand, demand, reservation, and net available quantities per inventory item, so that procurement and requisitioning users can assess whether requested items are available before committing to a purchase. The view is a reporting and integration convenience object: it abstracts the row-level detail held in ICX_MTL_DEMAND_SUMMARY_V and rolls it up to one row per inventory item, exposing the primary unit of measure alongside aggregated quantities. Because iProcurement availability checks and related inquiry screens operate against summarized figures rather than raw transaction detail, this view provides the aggregation layer that downstream UI and API calls consume. It should be treated as a read-only reporting object, not a transactional table, and it carries Oracle proprietary/confidential status consistent with standard EBS dictionary objects. The view is marked VALID in the APPS schema and is dependent on the underlying summary view and several supporting packages.

Underlying Base Objects

The documented base objects referenced by ICX_MTL_DEMAND_ITEM_SUM_V are ICX_MTL_DEMAND_SUMMARY_V (view), HR_GENERAL (package), HR_SECURITY (package), and INV_DECIMALS_PUB (package). The primary data source is ICX_MTL_DEMAND_SUMMARY_V, over which the aggregation is performed. HR_GENERAL and HR_SECURITY are the standard EBS security packages used to enforce organization and responsibility-level access, ensuring that only inventory organizations the user is authorized to see contribute to the summarized quantities. INV_DECIMALS_PUB governs unit-of-measure rounding and decimal precision, so that aggregated quantities align with the inventory item's defined precision. The view text performs a GROUP BY on INVENTORY_ITEM_ID, ITEM, DESCRIPTION, and PRIMARY_UNIT_OF_MEASURE, with SUM and NVL applied to each numeric quantity column, replacing nulls with zero before aggregation.

Key Columns

  • INVENTORY_ITEM_ID — Numeric primary key of the inventory item; the principal grouping and join key.
  • ITEM — Concatenated item segment value (the user-facing item number).
  • DESCRIPTION — Item description captured in the grouping.
  • PRIMARY_UNIT_OF_MEASURE — The item's primary UOM; the column most frequently searched in this context, used to express and filter all aggregated quantities.
  • ONHAND_QUANTITY — Summed on-hand quantity across authorized organizations.
  • DEMAND_QUANTITY — Total outstanding demand for the item.
  • HARD_RESERVATION_QUANTITY — Quantity reserved against firm demand.
  • SUPPLY_RESERVATION_QUANTITY — Quantity reserved against supply.
  • TRANSACTABLE_QUANTITY — Quantity available for transaction.
  • NET_AVAILABLE_QUANTITY — Net of on-hand, demand, and reservations; the key availability indicator.

Common Use Cases and Queries

A typical scenario is an availability inquiry filtered by UOM to identify items measured in a specific unit. Sample statement:

SELECT inventory_item_id, item, description, primary_unit_of_measure, net_available_quantity FROM apps.icx_mtl_demand_item_sum_v WHERE primary_unit_of_measure = :p_uom AND net_available_quantity > 0 ORDER BY item;

Alternatively, join to MTL_SYSTEM_ITEMS_B on INVENTORY_ITEM_ID to enrich the result with planning attributes, or filter on NET_AVAILABLE_QUANTITY to list only items with positive availability. The view is suited to requisition validation, sourcing analysis, and inventory dashboards, but should not be used for real-time transaction processing.