Search Results product_precedence

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:

LIST_HEADER_ID / LIST_LINE_ID / LIST_LINE_NO — identifiers for the parent list header, the individual line, and the line sequence number.
INVENTORY_ITEM_ID / ORGANIZATION_ID — the base item and inventory organization to which the upgrade modifier applies.
RELATED_ITEM_ID / RELATIONSHIP_TYPE_ID — the upgraded-to item and the relationship classification connecting it to the base item.
INCOMPATIBILITY_GRP_CODE — the incompatibility group that governs whether the modifier can coexist with other pricing adjustments; it is the column most commonly targeted when investigating modifier conflict behavior.
MODIFIER_LEVEL_CODE / LIST_LINE_TYPE_CODE — the level at which the modifier operates and the constant line type ('IUE') enforced by the view.
PRICING_PHASE_ID / PRODUCT_PRECEDENCE / ESTIM_GL_VALUE — the pricing phase, precedence ranking, and estimated GL value.
START_DATE_ACTIVE / END_DATE_ACTIVE — the effective date range.
Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY.

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.

View: QPBV_ITEM_UPGRADES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_ITEM_UPGRADES, object_name:QPBV_ITEM_UPGRADES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Item Upgrades type of modifiers. , implementation_dba_data: APPS.QPBV_ITEM_UPGRADES ,
View: QPBV_TERM_SUBSTITUTIONS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_TERM_SUBSTITUTIONS, object_name:QPBV_TERM_SUBSTITUTIONS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Term Substitutuions type of Modifiers. , implementation_dba_data: APPS.QPBV_TERM_SUBSTITUTIONS ,
View: QPFV_TERM_SUBSTITUTIONS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_TERM_SUBSTITUTIONS, object_name:QPFV_TERM_SUBSTITUTIONS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Term Substitutuions type of Modifiers. , implementation_dba_data: APPS.QPFV_TERM_SUBSTITUTIONS ,
View: QPFV_ITEM_UPGRADES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_ITEM_UPGRADES, object_name:QPFV_ITEM_UPGRADES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Item Upgrades type of modifiers. , implementation_dba_data: APPS.QPFV_ITEM_UPGRADES ,
View: QPFV_ITEM_UPGRADES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_ITEM_UPGRADES, object_name:QPFV_ITEM_UPGRADES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Item Upgrades type of modifiers. , implementation_dba_data: APPS.QPFV_ITEM_UPGRADES ,
View: QPFV_TERM_SUBSTITUTIONS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_TERM_SUBSTITUTIONS, object_name:QPFV_TERM_SUBSTITUTIONS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Term Substitutuions type of Modifiers. , implementation_dba_data: APPS.QPFV_TERM_SUBSTITUTIONS ,
View: QPBV_ITEM_UPGRADES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_ITEM_UPGRADES, object_name:QPBV_ITEM_UPGRADES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Item Upgrades type of modifiers. , implementation_dba_data: APPS.QPBV_ITEM_UPGRADES ,
View: QPBV_TERM_SUBSTITUTIONS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_TERM_SUBSTITUTIONS, object_name:QPBV_TERM_SUBSTITUTIONS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Term Substitutuions type of Modifiers. , implementation_dba_data: APPS.QPBV_TERM_SUBSTITUTIONS ,
View: QPBV_PRICE_LIST_LINES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PRICE_LIST_LINES, object_name:QPBV_PRICE_LIST_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Price List lines. , implementation_dba_data: APPS.QPBV_PRICE_LIST_LINES ,
View: QPFV_PRICE_LIST_LINES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PRICE_LIST_LINES, object_name:QPFV_PRICE_LIST_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Price List lines. , implementation_dba_data: APPS.QPFV_PRICE_LIST_LINES ,
View: QPFV_PRICE_LIST_LINES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PRICE_LIST_LINES, object_name:QPFV_PRICE_LIST_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Price List lines. , implementation_dba_data: APPS.QPFV_PRICE_LIST_LINES ,
View: QPBV_COUPON_ISSUES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_COUPON_ISSUES, object_name:QPBV_COUPON_ISSUES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Coupon Issue type of modifier. , implementation_dba_data: APPS.QPBV_COUPON_ISSUES ,
View: QPBV_COUPON_ISSUES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_COUPON_ISSUES, object_name:QPBV_COUPON_ISSUES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Coupon Issue type of modifier. , implementation_dba_data: APPS.QPBV_COUPON_ISSUES ,
View: QPBV_PRICE_LIST_LINES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PRICE_LIST_LINES, object_name:QPBV_PRICE_LIST_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Price List lines. , implementation_dba_data: APPS.QPBV_PRICE_LIST_LINES ,
View: QPFV_COUPON_ISSUES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_COUPON_ISSUES, object_name:QPFV_COUPON_ISSUES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Coupon Issue type of modifier. , implementation_dba_data: APPS.QPFV_COUPON_ISSUES ,
View: QPFV_COUPON_ISSUES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_COUPON_ISSUES, object_name:QPFV_COUPON_ISSUES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Coupon Issue type of modifier. , implementation_dba_data: APPS.QPFV_COUPON_ISSUES ,
View: QPBV_MODIFIER_LINES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_MODIFIER_LINES, object_name:QPBV_MODIFIER_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f , implementation_dba_data: APPS.QPBV_MODIFIER_LINES ,
View: QPBV_MODIFIER_LINES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_MODIFIER_LINES, object_name:QPBV_MODIFIER_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f , implementation_dba_data: APPS.QPBV_MODIFIER_LINES ,
View: QP_PREQ_LDETS_TMP 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_LDETS_TMP, object_name:QP_PREQ_LDETS_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_LDETS_TMP ,
View: QP_DEBUG_REQ_LDETS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LDETS_V, object_name:QP_DEBUG_REQ_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine elimi , implementation_dba_data: APPS.QP_DEBUG_REQ_LDETS_V ,
View: QP_PREQ_LDETS_TMP 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_LDETS_TMP, object_name:QP_PREQ_LDETS_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_LDETS_TMP ,
View: QPFV_MODIFIER_LINES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_MODIFIER_LINES, object_name:QPFV_MODIFIER_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f , implementation_dba_data: APPS.QPFV_MODIFIER_LINES ,
View: QP_DEBUG_REQ_LDETS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_DEBUG_REQ_LDETS_V, object_name:QP_DEBUG_REQ_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine elimi , implementation_dba_data: APPS.QP_DEBUG_REQ_LDETS_V ,
View: QPFV_MODIFIER_LINES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_MODIFIER_LINES, object_name:QPFV_MODIFIER_LINES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional goods type of modifier summary lines. These are only 'header' line for a Price Break and 'Buy' line f , implementation_dba_data: APPS.QPFV_MODIFIER_LINES ,
View: QP_LINE_LVL_QUAL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LINE_LVL_QUAL_V, object_name:QP_LINE_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose lines are associated with pricing qual , implementation_dba_data: APPS.QP_LINE_LVL_QUAL_V ,
View: QP_LINE_LVL_QUAL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LINE_LVL_QUAL_V, object_name:QP_LINE_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose lines are associated with pricing qual , implementation_dba_data: APPS.QP_LINE_LVL_QUAL_V ,
View: QP_LIST_ATTRIBUTES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_ATTRIBUTES_V, object_name:QP_LIST_ATTRIBUTES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_PRICING_ATTRIBUTES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..), their lines and pricing attributes. All the columns , implementation_dba_data: APPS.QP_LIST_ATTRIBUTES_V ,
View: QP_LISTS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LISTS_V, object_name:QP_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables) and QP_LIST_LINES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines. All the columns of the underlying tables or views are incl , implementation_dba_data: APPS.QP_LISTS_V ,
View: QP_LISTS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LISTS_V, object_name:QP_LISTS_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables) and QP_LIST_LINES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines. All the columns of the underlying tables or views are incl , implementation_dba_data: APPS.QP_LISTS_V ,
View: QP_LIST_ATTRIBUTES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_ATTRIBUTES_V, object_name:QP_LIST_ATTRIBUTES_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_PRICING_ATTRIBUTES. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..), their lines and pricing attributes. All the columns , implementation_dba_data: APPS.QP_LIST_ATTRIBUTES_V ,
View: QP_LINES_SUMMARY_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LINES_SUMMARY_V, object_name:QP_LINES_SUMMARY_V, status:VALID, product: QP - Advanced Pricing , description: This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer. , implementation_dba_data: APPS.QP_LINES_SUMMARY_V ,
View: QP_LINES_SUMMARY_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LINES_SUMMARY_V, object_name:QP_LINES_SUMMARY_V, status:VALID, product: QP - Advanced Pricing , description: This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer. , implementation_dba_data: APPS.QP_LINES_SUMMARY_V ,
View: QP_HDR_LVL_QUAL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_HDR_LVL_QUAL_V, object_name:QP_HDR_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose headers are associate with pricing qual , implementation_dba_data: APPS.QP_HDR_LVL_QUAL_V ,
View: QP_HDR_LVL_QUAL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_HDR_LVL_QUAL_V, object_name:QP_HDR_LVL_QUAL_V, status:VALID, product: QP - Advanced Pricing , description: View that joins QP_LIST_HEADERS_VL (MLS View on Base Tables), QP_LIST_LINES and QP_QUALIFIERS. This view is used to retrieve all the list types (E.g Price Lists, Discounts etc..) and their lines whose headers are associate with pricing qual , implementation_dba_data: APPS.QP_HDR_LVL_QUAL_V ,
View: QP_PRICE_BREAKS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PRICE_BREAKS_V, object_name:QP_PRICE_BREAKS_V, status:VALID, product: QP - Advanced Pricing , description: Price or Modifier Break lines information. Used by Price List and Modifiers form. , implementation_dba_data: APPS.QP_PRICE_BREAKS_V ,
View: QP_PRICE_BREAKS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PRICE_BREAKS_V, object_name:QP_PRICE_BREAKS_V, status:VALID, product: QP - Advanced Pricing , description: Price or Modifier Break lines information. Used by Price List and Modifiers form. , implementation_dba_data: APPS.QP_PRICE_BREAKS_V ,
View: QP_LIST_LINES_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_LINES_V, object_name:QP_LIST_LINES_V, status:VALID, product: QP - Advanced Pricing , description: Price List Lines information - used for List Lines block in Price Lists form. , implementation_dba_data: APPS.QP_LIST_LINES_V ,
View: QP_LIST_LINES_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LIST_LINES_V, object_name:QP_LIST_LINES_V, status:VALID, product: QP - Advanced Pricing , description: Price List Lines information - used for List Lines block in Price Lists form. , implementation_dba_data: APPS.QP_LIST_LINES_V ,
View: QP_MODIFIER_SUMMARY_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_MODIFIER_SUMMARY_V, object_name:QP_MODIFIER_SUMMARY_V, status:VALID, product: QP - Advanced Pricing , description: Modifier Summary information for Modifier Lists. Used by the Modifiers form (for summary block). , implementation_dba_data: APPS.QP_MODIFIER_SUMMARY_V ,
View: QP_MODIFIER_SUMMARY_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_MODIFIER_SUMMARY_V, object_name:QP_MODIFIER_SUMMARY_V, status:VALID, product: QP - Advanced Pricing , description: Modifier Summary information for Modifier Lists. Used by the Modifiers form (for summary block). , implementation_dba_data: APPS.QP_MODIFIER_SUMMARY_V ,