Search Results inventory_class




Overview
Explore in AI Chat

Overview

APPS.PMIFV_LOT_RESOURCE_LIST_V is a Business Intelligence System (BIS) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its FND Design Data identifier is PMI.PMIFV_LOT_RESOURCE_LIST_V, and the object carries a VALID status. The view is part of the Process Manufacturing Intelligence (PMIFV) family of reporting objects and is designed to correlate manufactured lots with the resources consumed during their production.

As documented, the view "lists lots that shared a particular set of parameters, most importantly the resources used in the lots' manufacture." Its principal business purpose is quality investigation: by grouping lots according to the resources applied during manufacturing, analysts can identify defective lots caused by defective resources. This makes the view a targeted diagnostic instrument for root-cause analysis rather than a general-purpose lot inquiry.

Because the object is exposed through the APPS schema and includes a published query text, it is intended to be consumed directly by reports, ad hoc SQL, and downstream integrations that require a denormalized join of lot, item, organization, and vendor attributes alongside resource identifiers. It is not referenced by any database object, confirming that it is a leaf-level reporting view rather than a dependency of other database logic.

Underlying Base Objects

The view is defined over six documented base objects, each referenced as a synonym within the APPS schema:

  • GME_BATCH_STEP_RESOURCES — supplies the process manufacturing resource usage associated with batch steps, providing the RESOURCES column.
  • IC_ITEM_MST — the inventory item master, supplying item number, description, and inventory class attributes.
  • IC_LOTS_MST — the lot master, supplying lot number, sublot number, lot creation date, and quality control grade.
  • IC_TRAN_PND — the pending transaction table, used to link lot activity to organizational and transactional context.
  • PO_VEND_MST — the purchasing vendor master, supplying vendor number and vendor name.
  • SY_ORGN_MST — the organization master, supplying organization code and organization name.

These objects are joined to present a single denormalized row per item, lot, and resource combination, enabling resource-centric lot comparison without requiring the consumer to reconstruct the joins manually.

Key Columns

The view exposes sixteen columns spanning item, lot, organization, vendor, and resource dimensions:

Common Use Cases and Queries

The view supports defect investigations where a suspect resource or supplier must be traced across many lots. A typical query filters by inventory class and returns all lots sharing a resource:

SELECT LOT_NO, ITEM_NO, INVENTORY_CLASS, RESOURCES, QC_GRADE, VENDOR_NAME
FROM APPS.PMIFV_LOT_RESOURCE_LIST_V
WHERE INVENTORY_CLASS = :p_class
ORDER BY RESOURCES, LOT_CREATION_DATE;

A supplier-focused variant identifies all lots from a given vendor that used a specific resource, while a quality-focused variant selects lots with a low QC_GRADE and lists the resources involved. Because the view is not referenced by any database object, it can be queried without side effects and serves as a stable, read-only reporting surface for both ad hoc analysis and scheduled BI extracts.