Search Results mtl_available_inventory_v




Overview
Explore in AI Chat

Overview

APPS.MTL_AVAILABLE_INVENTORY_V is a reporting view in the Oracle E-Business Suite Inventory (INV) module that exposes a curated snapshot of select available inventory. It surfaces locator-, lot-, and subinventory-level availability information together with transaction quantities that are relevant to the Inventory transaction processing workflow. The view is defined in the APPS schema and is documented as VALID in ETRM 12.2.2 (and available in the 12.1.1 code line).

Its primary role is to present the working contents of the available inventory temporary data — the staged set of rows produced while Inventory determines what is available for a given item, subinventory, and locator — in a readable, denormalized form. Because it joins temporary locator data to lot master attributes, locator key flexfield segments, and transaction reasons, it is commonly used in custom reports, concurrent programs, and integration extracts that need to display available quantity alongside lot, revision, and reason context. It is not a general ledger or costing view; it is a transactional availability view tied to the Inventory transaction engine.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over the following referenced base objects:

All joins from the driving temporary table to the lot, locator, and reason objects are outer joins, ensuring that availability rows are not lost when a matching lot, locator descriptor, or reason is absent. The query aggregates quantities with SUM grouped by locator, lot, subinventory, grade, reason, UOM, revision, ordering, and WMS rule attributes, and returns rows ordered by ORDER_BY.

Key Columns

Common Use Cases and Queries

Typical uses include displaying available stock during a transaction, feeding lot-controlled picking or put-away logic, and producing custom availability reports where dual-UOM quantities are required.

SELECT subinventory_code,
       locator_id,
       lot_number,
       trans_qty,
       trans_qty2,
       transaction_uom,
       secondary_uom
  FROM apps.mtl_available_inventory_v
 WHERE order_by IS NOT NULL;

Because TRANS_QTY2 reflects secondary quantities for dual-UOM items, reporting filters frequently isolate rows where TRANS_QTY2 > 0. Note that the view reads from a temporary table, so meaningful results depend on the inventory process having populated MTL_AVAILABLE_INVENTORY_TEMP; querying it outside that context may return only rows generated by the current session- or process-level transaction.