Results for “sr_item_pk”

50+ results




Overview
Explore in AI Chat

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

Overview

MSD_SR_ITEM_LIST_PRICE_V is a source view owned by the APPS schema in Oracle E-Business Suite, defined within the MSD (Demand Planning) product family. Its documented purpose is to expose Item List Price information—specifically the Base Unit of Measure, List Price, and Average Discount—for items maintained in an Oracle Applications instance. As a "source view," it functions as a standardized extraction interface through which Demand Planning and related downstream processes retrieve item pricing attributes from the transactional EBS database. The view is registered as VALID and is intended for deployment against an Oracle Applications instance from which pricing data must be collected.

Although the description references Oracle Applications 11i, the object remains present and valid under EBS 12.1.1 and 12.2.2, where it continues to serve as a compatibility layer for price-list sourcing. Because it is a view rather than a table, it introduces no independent storage and reflects the current state of the underlying item master at query time.

Underlying Base Objects

The documented ETRM 12.2.2 metadata identifies two referenced base objects:

  • MSD_SR_UTIL (PACKAGE) — A PL/SQL utility package supplying the MASTER_ORGANIZATION() function, which returns the master organization identifier used to filter item records.
  • MTL_SYSTEM_ITEMS_KFV (SYNONYM) — The key flexfield view over the item master, exposing concatenated item segments alongside item attributes and pricing columns.

The documented view text confirms this relationship:

SELECT CONCATENATED_SEGMENTS, INVENTORY_ITEM_ID, LIST_PRICE_PER_UNIT, NULL, PRIMARY_UOM_CODE, BOM_ITEM_TYPE, ATO_FORECAST_CONTROL FROM MTL_SYSTEM_ITEMS_KFV WHERE ORGANIZATION_ID = MSD_SR_UTIL.MASTER_ORGANIZATION()

Two points are significant. First, the filter restricts output to the master organization, ensuring a single authoritative item record per inventory item. Second, the NULL literal in the fourth position indicates that average discount is not sourced from the item master itself and is therefore not populated.

Key Columns

The documented column list maps to the view text as follows:

  • ITEM — Derived from CONCATENATED_SEGMENTS; the concatenated flexfield representation of the item identifier.
  • SR_ITEM_PK — Derived from INVENTORY_ITEM_ID; the internal primary key of the inventory item.
  • LIST_PRICE — Derived from LIST_PRICE_PER_UNIT; the item's list price per unit, the column most directly associated with the searched term "list_price_per_unit".
  • AVG_DISCOUNT — Returned as NULL; average discount is not supplied by this view in its documented form.
  • BASE_UOM — Derived from PRIMARY_UOM_CODE; the primary unit of measure for the item.
  • ITEM_TYPE_ID — Derived from BOM_ITEM_TYPE; the item's BOM type classification.
  • FORECAST_TYPE_ID — Derived from ATO_FORECAST_CONTROL; the forecast control setting for configured items.

Common Use Cases and Queries

Typical scenarios include extracting price lists for demand planning loads, reconciling master-organization pricing across instances, and feeding pricing baselines into forecasting models. A representative query is:

SELECT ITEM, SR_ITEM_PK, LIST_PRICE, BASE_UOM FROM APPS.MSD_SR_ITEM_LIST_PRICE_V WHERE LIST_PRICE IS NOT NULL;

Because the view enforces master-organization filtering internally, no additional organization predicate is required. Analysts searching for "list_price_per_unit" should note that the underlying item master column carries that name, while the view exposes it as LIST_PRICE. Any reliance on AVG_DISCOUNT requires an alternative source, as the view returns NULL for that column.