Results for “pmibv_currentinventory_v”

16 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PMIBV_CURRENTINVENTORY_V is an APPS-owned database view in Oracle EBS 12.1.1 and 12.2.2, delivered under the Process Manufacturing Intelligence (PMI) product family. As reflected in its ETRM record, PMI is now marked Obsolete, meaning the view is retained for backward compatibility and for any custom reports or integrations that have not yet been migrated to supported alternatives. The view presents a consolidated, read-only snapshot of current item inventory, combining on-hand quantity and availability information broken down by warehouse, locator, lot, and item. It is defined as a WITH READ ONLY view, so it can be queried safely from reports, ad hoc SQL, and integration extracts without risk of mutating base data.

Underlying Base Objects

The view is defined over two documented base objects, both referenced in APPS through synonyms:

  • IC_LOCT_INV — the locator-level inventory table that holds on-hand quantities, warehouse code, location, lot status, QC hold information, and audit (WHO) columns for a given item/lot/location.
  • IC_LOTS_MST — the lot master table, which stores lot-level attributes such as lot number, sublot number, QC grade, expiration date, creation date, and the vendor lot number.

The two objects are joined with outer joins keyed on LOT_ID and ITEM_ID, so lots defined in IC_LOTS_MST appear even when no corresponding inventory row exists in IC_LOCT_INV. A filter suppresses rows where DELETE_MARK equals zero or is null, which effectively retains soft-deleted inventory records per the predicate as written.

Key Columns

Common Use Cases and Queries

Because the view exposes both on-hand quantities and lot attributes in a single flat structure, it is commonly used for inventory reconciliation, lot traceability, expiry monitoring, and QC hold reporting. A typical traceability query locating inventory by supplier lot is:

  • SELECT lot_number, vendor_lot_number, sublot_number, item_id, warehouse_code, location, qty_onhand, lot_status, lot_expire_date FROM apps.pmibv_currentinventory_v WHERE vendor_lot_number = :vendor_lot;

Availability and hold reporting follow similar patterns, for example filtering on LOT_STATUS or QC_HOLD_REASON_CODE to list lots blocked from use, or aggregating QTY_ONHAND by WAREHOUSE_CODE and ITEM_ID for stock balance summaries. Expiry-driven reporting can select lots where LOT_EXPIRE_DATE falls within a threshold window.

Given the Obsolete status of the PMI module, new development should validate results against supported Oracle Inventory and Process Manufacturing lot tables, but PMIBV_CURRENTINVENTORY_V remains a convenient read-only source for current, lot-level stock visibility in existing 12.1.1 and 12.2.2 environments.