Search Results qpbv_item_upgrades




Overview
Explore in AI Chat

Overview

QPBV_ITEM_UPGRADES is a read-only database view owned by the APPS schema within the Oracle Advanced Pricing (QP) module. It presents a filtered subset of pricing modifier data, specifically exposing records classified as Item Upgrade modifiers. In Oracle EBS Advanced Pricing, a modifier is a pricing adjustment or rule applied to items based on defined conditions. The Item Upgrade type represents a distinct modifier category where a related item relationship and upgrade logic are applied to a base item.

Because the view is queryable from the APPS schema and conforms to standard EBS view conventions, it is suitable for reporting, custom concurrent programs, and integration extracts that require visibility into item upgrade modifiers without traversing the full QP_LIST_LINES structure. Status for the 12.1.1 and 12.2.2 releases is documented as VALID, confirming that the object compiles and is available for querying in a supported environment.

Underlying Base Objects

QPBV_ITEM_UPGRADES is defined over a single documented base object: QP_LIST_LINES, referenced through the APPS synonym. QP_LIST_LINES is the core pricing entity that stores individual lines for pricing lists, modifiers, and qualifiers. The view applies a fixed filter, selecting only rows where LIST_LINE_TYPE_CODE equals 'IUE', the code designating Item Upgrade modifiers. All columns projected by the view are drawn directly from QP_LIST_LINES with no joins, aggregations, or derived expressions, so the view behaves as a restriction-only wrapper over its base table. This design means any write operations targeting the underlying modifier data must be directed at QP_LIST_LINES, while QPBV_ITEM_UPGRADES remains exclusively for read access.

Key Columns

The columns exposed reflect the standard pricing line attributes relevant to item upgrades:

Common Use Cases and Queries

A frequent scenario is locating item upgrade modifiers belonging to a specific incompatibility group, often after searching for incompatibility_grp_code:

  • SELECT list_header_id, list_line_id, inventory_item_id, related_item_id, incompatibility_grp_code FROM qpbv_item_upgrades WHERE incompatibility_grp_code = :p_group;
  • Identifying active upgrades for a given item and organization within an effective date window.
  • Extracting upgrade definitions for migration, validation, or reconciliation against configuration data.

Because the view enforces the 'IUE' filter, no additional line-type predicate is required. Queries should still apply date and organization constraints to limit result volume in large pricing implementations.