Search Results warehouse_shipped_from




Overview
Explore in AI Chat

Overview

APPS.PMI_REP_GROSS_MARGIN_V is a reporting view in the Oracle E-Business Suite Process Manufacturing Intelligence (PMI) module. It exposes gross margin computations for sales transactions, aggregating revenue, discounts, cost of goods sold (COGS), and the resulting margin across defined periods. The view is built as a thin projection over the PMI reporting sales details view, PMI_REP_SALES_DETAILS_V, and is intended for use by reporting engines, dashboards, and analytical queries that require period-level margin visibility by operating unit, sales company, and sales organization.

The view resides in the APPS schema and is documented in ETRM metadata for release 12.2.2, with applicability to 12.1.1. Because it performs a cost lookup at query time, its results depend on inventory cost data available as of the period start date.

Underlying Base Objects

The view is defined over the following documented objects:

  • PMI_REP_SALES_DETAILS_V (VIEW) — the primary source, supplying sales line detail, quantities, prices, charges, and organizational dimensions.
  • PMI_COMMON_PKG (PACKAGE) — supplies the PMICO_GET_COST function invoked for each sales line to compute unit cost.
  • GMICUOM (PACKAGE) — used for unit-of-measure conversions within the PMI stack.
  • PMI_SALES_PKG (PACKAGE) — supporting sales processing logic.
  • HR_SECURITY (PACKAGE) and PMI_SECURITY_PKG (PACKAGE) — enforce organization and functional security, restricting rows based on the user's authorized operating units and sales organizations.

All objects are owned by APPS, and the view inherits the security model applied by the PMI reporting layer rather than filtering independently.

Key Columns

All monetary columns are expressed in base currency, so no on-the-fly currency conversion is required at the reporting layer.

Common Use Cases and Queries

Typical usage includes gross margin analysis by period, profitability by sales organization, and export of margin data into external BI platforms. A representative query aggregates margin by period and sales organization:

SELECT sales_organization, period_id, SUM(revenue) revenue, SUM(discount) discount, SUM(cogs) cogs, SUM(margin) margin FROM apps.pmi_rep_gross_margin_v WHERE operating_unit_id = :org_id AND period_id BETWEEN :from_period AND :to_period GROUP BY sales_organization, period_id;

Because COGS is derived through PMICO_GET_COST at runtime, queries filtering on item and warehouse perform the cost lookup per row, so predicate pushdown and indexed access on the underlying sales details improve responsiveness. Users should execute the view through APPS credentials so that PMI security packages apply the correct organization filters. The term "marg malavika" in the user's search does not correspond to any documented column or object; the relevant identifiers are the MARGIN column and the PMI_REP_GROSS_MARGIN_V view itself.