Search Results prod_value

Overview

PMI_REP_TOP_10_PROD_INGRD_V is a reporting view owned by the APPS schema within the Process Manufacturing Intelligence (PMI) product family of Oracle E-Business Suite. It is a VALID database object in both 12.1.1 and 12.2.2 and exists specifically to support PMI Production Reports. The view consolidates production summary data into a period-aware, organization-aware, and item-aware result set that reports produced quantities and values alongside consumed ingredient quantities and values. Its principal role is to supply the reporting layer with a flattened structure so that downstream reports — notably "top 10" style ranking reports for production and ingredient consumption — can be built without embedding complex joins against the base summary and calendar tables.

The view also enforces organization-level row security at query time. This makes it suitable for multi-organization deployments where a report must display only data the requesting user is authorized to see. From an integration standpoint, the view behaves as a read-only, denormalized data source, exposing fiscal calendar identifiers and item identifiers directly for direct consumption by BI Publisher, Oracle Reports, and ad hoc SQL.

Underlying Base Objects

The view joins four documented base objects and references a fifth for security:

• PMI_PROD_SUM (SYNONYM) — the primary fact source supplying company, organization, item, UOM, yield quantity/value, and usage quantity/value.
• PMI_GL_TIME_V (VIEW) — the GL time calendar view that resolves fiscal year, quarter, and period identifiers together with period start and end dates.
• GL_PLCY_MST (SYNONYM) — the fiscal policy master, joined on company code and set of books name to align the correct accounting calendar.
• IC_ITEM_MST (SYNONYM) — the item master, providing the canonical ITEM_ID.
• PMI_SECURITY_PKG (PACKAGE) — invoked in the WHERE clause through PMI_SECURITY_PKG.SHOW_RECORD(PSUM.ORGN_CODE) to filter rows according to organization security.

The joins align production summary rows to the fiscal calendar using a BETWEEN condition on GL_PERIOD_START_DATE against the period start and end dates, ensuring each production record is attributed to exactly one fiscal period.

Key Columns

• COMPANY_ID (PSUM.CO_CODE) — the company code, also the fiscal policy join key.
• ORGANIZATION_ID (PSUM.ORGN_CODE) — the inventory organization, subject to security filtering.
• YEAR_ID / QUARTER_ID / PERIOD_ID — fiscal calendar identifiers from PMI_GL_TIME_V.
• ITEM_ID (ITEMMST.ITEM_ID) — the item produced or consumed.
• UOM (PSUM.CONVERTIBLE_UOM) — the unit of measure for reported quantities.
• QTY_PRODUCED (PSUM.WHSE_YIELD_QTY) — quantity yielded at the warehouse.
• PROD_VALUE (PSUM.WHSE_YIELD_VALUE) — the production value. This is the column most commonly referenced when users search for "prod_value"; it represents the monetary value of production yield for the period.
• QTY_CONSUMED (PSUM.WHSE_USAGE_QTY * -1) — usage quantity negated so consumption appears as a positive figure.
• INGD_VALUE (PSUM.WHSE_USAGE_VALUE * -1) — ingredient consumption value, likewise negated.

Common Use Cases and Queries

The view supports period-over-period production value analysis, top-10 ranking of items by production value, and yield-versus-consumption comparisons. A representative query retrieving the highest production values for a fiscal period is:

SELECT ORGANIZATION_ID, ITEM_ID, UOM, QTY_PRODUCED, PROD_VALUE, QTY_CONSUMED, INGD_VALUE FROM APPS.PMI_REP_TOP_10_PROD_INGRD_V WHERE PERIOD_ID = :period_id AND YEAR_ID = :year_id ORDER BY PROD_VALUE DESC;

A further common pattern aggregates by organization for a quarter:

SELECT ORGANIZATION_ID, SUM(PROD_VALUE) TOTAL_PROD_VALUE, SUM(INGD_VALUE) TOTAL_INGD_VALUE FROM APPS.PMI_REP_TOP_10_PROD_INGRD_V WHERE YEAR_ID = :year_id AND QUARTER_ID = :quarter_id GROUP BY ORGANIZATION_ID;

Because security filtering is applied inside the view, callers do not need to append organization predicates; results automatically reflect the accessing user's authorized organizations.