Results for “warehouse_name”

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

Overview

The view APPS.PMIFV_INV_SUMMARY_V is an Oracle E-Business Suite database object owned by the APPS schema and associated with the Process Manufacturing Intelligence (PMI) product family, which is marked obsolete in the ETRM documentation. It consolidates inventory balance information by item, warehouse, and quality-control grade. In the Version 12.1.1 and 12.2.2 environments, the view surfaces on-hand, in-transit, on-order, shipping, production, purchase, and committed-sales quantities for each item/warehouse/grade combination, joined to item master attributes and organization details.

The object is a read-only VIEW. Its defining SQL includes the WITH READ ONLY clause, meaning no DML is permitted against it. Because PMI is obsolete, the view is retained largely for backward compatibility with legacy reports, extract programs, and historical customizations that reference it. The user search term "qc_grade_desc" maps directly to the QC_GRADE_DESC column exposed by this view, which is sourced from the GMD_GRADES_VL view.

Underlying Base Objects

The view is defined over the following documented base objects:

• IC_SUMM_INV (SYNONYM) — the inventory summary table, providing the core quantity columns and the ONHAND/INTRANSIT/COMMITTED measures.
• IC_ITEM_MST (SYNONYM) — item master, supplying ITEM_NO, ITEM_DESC1, alternate items, units of measure, and planning class.
• IC_WHSE_MST (SYNONYM) — warehouse master, supplying WHSE_NAME and the organization code used for security filtering.
• GMD_GRADES_VL (VIEW) — the translated grades view, supplying QC_GRADE_DESC, the description of the quality grade.
• SY_ORGN_MST (SYNONYM) — organization master, supplying ORGN_CODE and CO_CODE.
• PMI_SECURITY_PKG (PACKAGE) — invoked in the WHERE clause via PMI_SECURITY_PKG.SHOW_RECORD to restrict rows to organizations the current user is authorized to see.

All joins are outer joins (marked with (+)) on the item, warehouse, grade, and organization keys, so summary rows are preserved even when an item or grade master record is missing. Record-level security is enforced through the SY_ORGN_MST subquery calling PMI_SECURITY_PKG.SHOW_RECORD.

Key Columns

• ITEM_ID, ITEM_NO, ITEM_DESC1 — item identifiers and description.
• WHSE_CODE, WAREHOUSE_NAME — warehouse identifiers.
• ORGN_CODE, CO_CODE — organization and company codes.
• QC_GRADE, QC_GRADE_DESC — quality grade code and its described value from GMD_GRADES_VL.
• ONHAND_QTY, ONHAND_QTY2 — primary and secondary on-hand quantities.
• ONHAND_PRODUCTION_QTY, ONHAND_ORDER_QTY, ONHAND_SHIP_QTY — on-hand production, order, and shipping quantities.
• ONPURCH_QTY, PRODUCTION_PENDING_QTY, INTRANSIT_QTY — purchase, pending production, and in-transit quantities.
• COMMITTED_SALES_QTY, COMMITTED_PRODUCTION_QTY — committed sales and production quantities.
• ITEM_UOM, ITEM_UOM2, PLANNING_CLASS, ALTERNATE_ITEMA, ALTERNATE_ITEMB — item-level attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY — audit columns.

Common Use Cases and Queries

The view is typically used for grade-level inventory reporting, reconciliation of PMI inventory extracts, and legacy integrations. To retrieve grade descriptions for items held in a specific warehouse:

SELECT item_no, whse_code, qc_grade, qc_grade_desc,
       onhand_qty, onhand_qty2, intransit_qty
  FROM apps.pmifv_inv_summary_v
 WHERE whse_code = :p_whse
   AND onhand_qty > 0;

To aggregate on-hand balances by grade description across the organization:

SELECT qc_grade_desc,
       SUM(onhand_qty) AS total_onhand
  FROM apps.pmifv_inv_summary_v
 GROUP BY qc_grade_desc
 ORDER BY total_onhand DESC;

Because the view is obsolete and read-only, integration designs should migrate to current Process Manufacturing inventory reporting objects. Nonetheless, for existing 12.1.1 and 12.2.2 instances, PMIFV_INV_SUMMARY_V remains the documented reference for item/warehouse/grade inventory balances.