Results for “base_price”

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

Overview

The APPS.PMIFV_ITEM_PRICE_V view belongs to the Process Manufacturing Intelligence (PMI) product family, which is flagged as Obsolete in Oracle EBS 12.1.1 and 12.2.2. It is a read-only view (declared WITH READ ONLY) that consolidates item pricing information into a single, denormalized result set. The view presents pricing data broken down along five dimensions: quantity, warehouse, grade, customer, and pricelist. Its purpose is to supply flattened pricing detail for reporting, analytical querying, and integration scenarios, removing the need for callers to manually join the five underlying pricing and master tables.

Because PMI is obsolete, the view is retained only for backward compatibility with existing custom reports, extracts, and interfaces. New development in 12.1.1 or 12.2.2 should not depend on it; Oracle's strategic replacement is Oracle Advanced Pricing. The user's search term pricesort_name maps directly to the PRICESORT_NAME column, which is sourced from the pricemaster record and identifies the sort sequence of the pricelist.

Underlying Base Objects

The view is defined over the following documented base objects, all referenced in the APPS schema as synonyms:

• OP_PRCE_ITM (alias PRICEITEM) — the item-level pricing record, supplying price ID, item ID, warehouse code, grade, base price, price UOM, and WHO columns.
• OP_PRCE_BRK (alias PRICEBREAK) — the price break detail, supplying quantity and value breakpoints, break factors, and breakpoint prices.
• OP_PRCE_MST (alias PRICEMASTER) — the pricelist master, supplying pricelist code, description, sort name, comments, and currency.
• IC_ITEM_MST (alias ITEM) — the inventory item master, supplying item number, description, and units of measure.
• IC_WHSE_MST (alias WAREHOUSE) — the warehouse master, supplying warehouse name. Joined with an outer (+) operator.
• SY_ORGN_MST — queried in a subquery to enforce organization-level security.
• PMI_SECURITY_PKG — the package invoked as PMI_SECURITY_PKG.SHOW_RECORD within the security predicate.

Joins are made on PRICELIST_ID, PRICE_ID, ITEM_ID, and WHSE_CODE. The organization security filter permits records where the warehouse organization is null or belongs to an organization for which SHOW_RECORD returns 'TRUE'.

Key Columns

• PRICESORT_NAME — the pricelist sort name from the pricing master; the column matched by the user's search.
• PRICELIST_ID / PRICELIST_CODE / PRICELIST_DESC1 — pricelist identifiers and descriptive attributes.
• PRICE_ID / PRICE_CLASS / PRICE_TYPE / BREAK_TYPE — the pricing record identity and classification.
• ITEM_ID / ITEM_NUMBER / ITEM_DESCRIPTION / ITEM_UOM / ITEM_UOM2 — item identity and units of measure.
• QC_GRADE — the quality grade associated with the item price.
• WAREHOUSE_CODE / WAREHOUSE_DESC — warehouse context for the price.
• BASE_PRICE / PRICE_UOM / FRIEGHT_BILL_MTHD — base price, pricing UOM, and freight billing method.
• QTY_BREAKPOINT / VALUE_BREAKPOINT / BREAKPOINT_FACTOR / BREAKPOINT_PRICE / BREAKTYPE_ID — price break detail.
• CURRENCY_CODE / COMMENTS — pricing master attributes.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE — WHO audit columns.

Common Use Cases and Queries

A typical reporting scenario retrieves all price breaks for a given item across warehouses, filtering by pricelist sort name:

• Item price lookup by pricelist sort: SELECT item_number, warehouse_code, pricelist_code, pricesort_name, qty_breakpoint, breakpoint_price FROM apps.pmifv_item_price_v WHERE pricesort_name = :sort_name;
• Warehouse price comparison: group base price by warehouse for a specific item.
• Price break extraction: select quantity and value breakpoints for interface loaders feeding downstream pricing systems.
• Security-aware extracts: rely on the built-in PMI_SECURITY_PKG predicate rather than re-implementing organization filtering.

Consumers should treat results as read-only and note the obsolete product status when planning migration to Advanced Pricing.