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
- QTY_ONHAND / QTY_ONHAND_IN_UOM2 — on-hand quantity in the primary unit of measure and the secondary UOM, sourced from LOCT_ONHAND and LOCT_ONHAND2.
- WAREHOUSE_CODE — the warehouse in which the on-hand balance resides.
- LOT_ID / ITEM_ID — foreign keys identifying the lot master record and the inventory item.
- LOCATION — the locator or storage location within the warehouse.
- LOT_NUMBER / SUBLOT_NUMBER — the lot and sublot identifiers; VENDOR_LOT_NUMBER exposes the supplier's own lot reference via VENDOR_LOT_NO, which is often the search key users query for traceability.
- LOT_STATUS / QC_HOLD_REASON_CODE — the lot's status and, where applicable, the QC hold reason code (QCHOLD_RES_CODE).
- QC_GRADE, LOT_EXPIRE_DATE, LOT_CREATION_DATE — quality grade and key lifecycle dates for the lot.
- LAST_UPDATED_BY / CREATED_BY / LAST_UPDATE_DATE / CREATION_DATE — the WHO and audit date columns carried from the inventory record.
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.
-
Qty and availability info for Items in Inv at the present time by warehouse, loc, lot and item.
APPS.PMIBV_CURRENTINVENTORY_V·↳ IC_LOCT_INV·↳ IC_LOTS_MST·Explore PMI module →
-
Qty and availability info for Items in Inv at the present time by warehouse, loc, lot and item.
APPS.PMIBV_CURRENTINVENTORY_V·↳ IC_LOCT_INV·↳ IC_LOTS_MST·Explore PMI module →
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
SYNONYM: APPS.IC_LOCT_INV 12.2.2
-
SYNONYM: APPS.IC_LOCT_INV 12.1.1
-
SYNONYM: APPS.IC_LOTS_MST 12.1.1
-
SYNONYM: APPS.IC_LOTS_MST 12.2.2
-
eTRM - PMI Tables and Views 12.1.1
-
eTRM - PMI Tables and Views 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PMI Tables and Views 12.1.1
-
eTRM - PMI Tables and Views 12.2.2