Search Results sales_organization




Overview
Explore in AI Chat

Overview

PMI_REP_SALES_DETAILS_V is a reporting view owned by the APPS schema within the Process Manufacturing Intelligence (PMI) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is documented in ETRM as the "PMI Sales Details Report view" and carries a VALID status. The view consolidates order-line level sales activity into a period-oriented, currency-normalized result set suitable for analytical reporting, dashboards, and downstream integration extracts.

The definition is an aggregate query layered over an inline view. The inner query joins order headers and details to item masters, warehouse masters, sales organizations, operating units, and the GL time dimension, then converts quantities to the item's primary unit of measure and monetary amounts to the ledger base currency. The outer query groups by item, warehouse shipped from, sales company, sales organization, operating unit, and the GL period hierarchy (period, quarter, year), applying SUM aggregation to ORDER_QUANTITY, EXTENDED_PRICE_BASE_CURRENCY, and CHARGES_BASE_CURRENCY. All monetary and quantity exposure is therefore at the summarized grain rather than the raw transaction grain.

Underlying Base Objects

ETRM documents the referenced base objects as GL_PLCY_MST, GL_SETS_OF_BOOKS, GMICUOM (package), HR_OPERATING_UNITS, HR_SECURITY (package), IC_ITEM_MST_B, IC_WHSE_MST, MTL_SYSTEM_ITEMS_B, OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, OE_SYSTEM_PARAMETERS_ALL, OP_ORDR_DTL, OP_ORDR_HDR, PMI_COMMON_PKG, PMI_GL_TIME_V, PMI_SALES_PKG, PMI_SECURITY_PKG, and SY_ORGN_MST. Most are exposed to APPS as synonyms.

The core transactional sources are the process manufacturing order tables OP_ORDR_HDR and OP_ORDR_DTL, with the OE_ORDER_* objects providing associated order and system-parameter context. Item and warehouse attributes come from IC_ITEM_MST_B, IC_WHSE_MST, and MTL_SYSTEM_ITEMS_B. Organizational and ledger context is supplied by SY_ORGN_MST, HR_OPERATING_UNITS, GL_PLCY_MST, and GL_SETS_OF_BOOKS, while PMI_GL_TIME_V supplies the GL calendar used to bucket shipments into periods. The GMICUOM package performs UOM conversion via I2UOM_CV, PMI_SALES_PKG computes charges through PMISA_GET_CHARGE, and HR_SECURITY, PMI_SECURITY_PKG, and PMI_COMMON_PKG apply access and common logic.

Key Columns

  • ITEM_ID — Inventory item identifier of the sold item, joined from the order detail.
  • ORDER_QUANTITY — Aggregated shipped quantity, converted from ORDER_UM1 via GMICUOM.I2UOM_CV to the item master unit of measure. This is the column most often targeted by users searching for order_quantity.
  • WAREHOUSE_SHIPPED_FROM — Ship-from warehouse code from the order detail's FROM_WHSE.
  • EXTENDED_PRICE_BASE_CURRENCY — Extended price normalized to the base currency, using the exchange rate and multiply/divide indicator when billing and base currencies differ.
  • CHARGES_BASE_CURRENCY — Charges in base currency, derived through PMI_SALES_PKG.PMISA_GET_CHARGE.
  • SALES_COMPANY and SALES_ORGANIZATION — Company code and organization code attributes for the selling entity.
  • PERIOD_START_DATE, YEAR_ID, QUARTER_ID, PERIOD_ID — GL calendar dimensions used to slice results by accounting period.
  • OPERATING_UNIT_ID — Operating unit identifier supporting multi-org reporting.

Common Use Cases and Queries

Typical uses include period-over-period sales analysis, quantity shipped by item and warehouse, base-currency revenue reporting, and feed queries for PMI dashboards. Because results are pre-aggregated and multi-org aware, filters on OPERATING_UNIT_ID and the calendar columns are standard.

Sample query for order quantity by item and period:

  • SELECT ITEM_ID, PERIOD_ID, SUM(ORDER_QUANTITY) FROM APPS.PMI_REP_SALES_DETAILS_V GROUP BY ITEM_ID, PERIOD_ID;
  • SELECT YEAR_ID, QUARTER_ID, SALES_ORGANIZATION, SUM(EXTENDED_PRICE_BASE_CURRENCY) FROM APPS.PMI_REP_SALES_DETAILS_V GROUP BY YEAR_ID, QUARTER_ID, SALES_ORGANIZATION;
  • SELECT ITEM_ID, WAREHOUSE_SHIPPED_FROM, ORDER_QUANTITY FROM APPS.PMI_REP_SALES_DETAILS_V WHERE OPERATING_UNIT_ID = :p_org_id AND PERIOD_START_DATE >= :p_start;