Results for “frieght_bill_mthd”

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

Overview

PMIBV_ITEM_PRICE_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Process Manufacturing Intelligence (PMI) product family, which Oracle has designated as obsolete. The view presents pricing information for a given item broken down across multiple qualifiers: quantity (price breaks), warehouse, quality grade, customer, and price list. Its purpose is to expose price list line and price break detail in a flattened, reporting-friendly form so that downstream inquiries, Discoverer worksheets, and integration extracts can retrieve tiered pricing without navigating the parent/child structure of the price list tables directly.

The view is defined over two Process Manufacturing pricing tables and joins them on PRICE_ID. Because the definition terminates with "WITH READ ONLY", it cannot be used as the target of DML; it is strictly a query object. The view carries both regular price header attributes (from the price item line) and price break attributes (from the break line), which is why a single item with several quantity or value tiers returns one row per break.

Underlying Base Objects

The view is defined over two synonyms that resolve to the following base tables:

• OP_PRCE_ITM — the price item (price list line) table, aliased PRICEITEM. It supplies item-level and price-list-level attributes such as ITEM_ID, PRICELIST_ID, PRICE_TYPE, PRICE_CLASS, base price, and unit of measure.
• OP_PRCE_BRK — the price break table, aliased PRICEBREAK. It supplies the tiered breakpoints and the resulting breakpoint price for each price line.

The join condition is PRICEITEM.PRICE_ID = PRICEBREAK.PRICE_ID. Both sides are filtered with DELETE_MARK = 0, meaning only active (soft-delete flag cleared) price items and price breaks are returned. The view is therefore effectively an inner join: a price item with no non-deleted breaks produces no rows.

Key Columns

• ITEM_ID — the inventory item identifier; the primary anchor for most queries.
• PRICELIST_ID — the price list header to which the price line belongs.
• PRICE_ID — the price item (price list line) identifier; the join key between the two base tables.
• PRICE_TYPE / PRICE_CLASS — classification of the pricing entry, used to distinguish price list types and pricing classes.
• BREAK_TYPE / BREAKTYPE_ID — distinguishes the nature of the break. The user's search term "break_type" maps to this column, which identifies whether the tier is a quantity break or a value break and how the breakpoint is interpreted.
• QTY_BREAKPOINT — the quantity at which the tier becomes effective.
• VALUE_BREAKPOINT — the monetary threshold at which the tier becomes effective.
• BREAKPOINT_FACTOR — the multiplier or modifier applied at the breakpoint.
• BREAKPOINT_PRICE — the resulting unit price applicable at that tier.
• BASE_PRICE — the base (list) price of the item on the price line.
• PRICE_UOM / PRICE_UM — the unit of measure in which the price is expressed.
• WAREHOUSE_CODE — the warehouse for which the price is valid; supports warehouse-specific pricing.
• QC_GRADE — the quality grade associated with the price line, enabling grade-based pricing in process manufacturing.
• FRTBILL_MTHD (FRIEGHT_BILL_MTHD) — the freight billing method associated with the price line.
• PRICEITEM_LINE_NO / PRICEBREAK_LINE_NO — line ordering within the price item and the break set.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard WHO audit columns.

Common Use Cases and Queries

Typical reporting scenarios include retrieving all price tiers for a given item, comparing quantity versus value breakpoint pricing for a price list, and extracting warehouse- or grade-specific price breaks for integration with order pricing or analytics. The following query lists every break tier for an item across all price lists:

• SELECT item_id, pricelist_id, price_id, break_type, qty_breakpoint, value_breakpoint, breakpoint_factor, breakpoint_price, price_uom, warehouse_code, qc_grade FROM apps.pmibv_item_price_v WHERE item_id = :p_item_id ORDER BY pricelist_id, priceitem_line_no, pricebreak_line_no;

To isolate quantity-based tiers within a single price list:

• SELECT item_id, price_id, qty_breakpoint, breakpoint_price FROM apps.pmibv_item_price_v WHERE pricelist_id = :p_pricelist_id AND qty_breakpoint IS NOT NULL ORDER BY item_id, qty_breakpoint;

Because the view is read-only and joins two soft-delete-filtered tables, it is well suited to ad-hoc inquiry and extraction, but not to maintenance. Note that the underlying PMI pricing model is documented as obsolete; where possible, current pricing inquiries should be sourced from the active Advanced Pricing (QP) tables that superseded this structure.