Results for “modifier_level_code”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
-
This code signifies whether a list line type ( like discount, surcharge ) is to be applied at the order, line or line group ( group of lines ) level on a sales order.
-
This code signifies whether a list line type ( like discount, surcharge ) is to be applied at the order, line or line group ( group of lines ) level on a sales order.
-
View: QPBV_ITEM_UPGRADES 12.2.2
This view gives information about Item Upgrades type of modifiers.
-
This view gives information about Term Substitutuions type of Modifiers.
APPS.QPBV_TERM_SUBSTITUTIONS·↳ QP_LIST_LINES·Explore QP module →
-
This view gives information about Term Substitutuions type of Modifiers.
APPS.QPBV_TERM_SUBSTITUTIONS·↳ QP_LIST_LINES·Explore QP module →
-
View: QPBV_ITEM_UPGRADES 12.1.1
This view gives information about Item Upgrades type of modifiers.
-
This view gives information about Term Substitutuions type of Modifiers.
APPS.QPFV_TERM_SUBSTITUTIONS·↳ QP_LIST_LINES·↳ QP_QP_FORM_PRICING_ATTR·Explore QP module →
-
This view gives information about Term Substitutuions type of Modifiers.
APPS.QPFV_TERM_SUBSTITUTIONS·↳ QP_LIST_LINES·↳ QP_QP_FORM_PRICING_ATTR·Explore QP module →
-
View: QPFV_ITEM_UPGRADES 12.1.1
This view gives information about Item Upgrades type of modifiers.
-
View: QPFV_ITEM_UPGRADES 12.2.2
This view gives information about Item Upgrades type of modifiers.
-
View: QPFV_COUPON_ISSUES 12.2.2
This view gives information about Coupon Issue type of modifier.
APPS.QPFV_COUPON_ISSUES·↳ MTL_UNITS_OF_MEASURE·↳ QP_LIST_LINES·↳ QP_RLTD_MODIFIERS·Explore QP module →
-
View: QPBV_COUPON_ISSUES 12.1.1
This view gives information about Coupon Issue type of modifier.
APPS.QPBV_COUPON_ISSUES·↳ QP_LIST_LINES·↳ QP_RLTD_MODIFIERS·Explore QP module →
-
View: QPBV_COUPON_ISSUES 12.2.2
This view gives information about Coupon Issue type of modifier.
APPS.QPBV_COUPON_ISSUES·↳ QP_LIST_LINES·↳ QP_RLTD_MODIFIERS·Explore QP module →
-
View: QP_PREQ_LINE_ATTRS_TMP 12.1.1
Based on QP_PREQ_LINE_ATTRS_TMP_T. This view has the information pertaining to the current pricing engine call.
APPS.QP_PREQ_LINE_ATTRS_TMP·↳ QP_PREQ_LINE_ATTRS_TMP_T·Explore QP module →
-
View: QP_PREQ_LINE_ATTRS_TMP 12.2.2
Based on QP_PREQ_LINE_ATTRS_TMP_T. This view has the information pertaining to the current pricing engine call.
APPS.QP_PREQ_LINE_ATTRS_TMP·↳ QP_PREQ_LINE_ATTRS_TMP_T·Explore QP module →
-
View: QPFV_COUPON_ISSUES 12.1.1
This view gives information about Coupon Issue type of modifier.
APPS.QPFV_COUPON_ISSUES·↳ MTL_UNITS_OF_MEASURE·↳ QP_LIST_LINES·↳ QP_RLTD_MODIFIERS·Explore QP module →
-
This table contains information on the pricing attributes that the attribute mapping functionality passed to the pricing engine. The pricing engine uses these attributes to qualify a line or an order for benefits.
-
View: QP_PRICING_ATTR_GET_V 12.1.1
View of Benefit or Get Products for a Modifier. Used by Modifiers Form.
APPS.QP_PRICING_ATTR_GET_V·↳ QP_LIST_LINES·↳ QP_PRICING_ATTRIBUTES·↳ QP_RLTD_MODIFIERS·Explore QP module →
-
QP_PRICING_PHASES stores all pricing phases.
-
QP_PRICING_PHASES stores all pricing phases.
-
View: QP_PRICING_ATTR_GET_V 12.2.2
View of Benefit or Get Products for a Modifier. Used by Modifiers Form.
APPS.QP_PRICING_ATTR_GET_V·↳ QP_LIST_LINES·↳ QP_PRICING_ATTRIBUTES·↳ QP_RLTD_MODIFIERS·Explore QP module →
-
View: QPBV_MODIFIER_LINES 12.2.2
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
APPS.QPBV_MODIFIER_LINES·↳ QP_LIST_LINES·↳ QP_RLTD_MODIFIERS·Explore QP module →
-
View: QPBV_MODIFIER_LINES 12.1.1
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
APPS.QPBV_MODIFIER_LINES·↳ QP_LIST_LINES·↳ QP_RLTD_MODIFIERS·Explore QP module →
-
This table contains information on the pricing attributes that the attribute mapping functionality passed to the pricing engine. The pricing engine uses these attributes to qualify a line or an order for benefits.
-
View: QP_LINES_SUMMARY_V 12.1.1
This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer.
APPS.QP_LINES_SUMMARY_V·↳ FND_USER_AP_PKG·↳ QP_LIST_HEADERS_TL·↳ QP_LIST_LINES·Explore QP module →
-
View: QP_LINES_SUMMARY_V 12.2.2
This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer.
APPS.QP_LINES_SUMMARY_V·↳ FND_USER_AP_PKG·↳ QP_LIST_HEADERS_TL·↳ QP_LIST_LINES·Explore QP module →
-
Permanent table for holding the pricing attributes.
-
Permanent table for holding the pricing attributes.
-
View: QPFV_MODIFIER_LINES 12.1.1
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
APPS.QPFV_MODIFIER_LINES·↳ MTL_UNITS_OF_MEASURE·↳ QP_LIST_LINES·↳ QP_QP_FORM_PRICING_ATTR·Explore QP module →
-
This table contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine eliminates.
-
View: QP_PREQ_LDETS_TMP 12.2.2
Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.
APPS.QP_PREQ_LDETS_TMP·↳ QP_PREQ_LDETS_TMP_T·Explore QP module →
-
View: QP_DEBUG_REQ_LDETS_V 12.2.2
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
APPS.QP_DEBUG_REQ_LDETS_V·↳ QP_DEBUG_REQ_LDETS·↳ QP_DEBUG_REQ_RLTD_LINES·Explore QP module →
-
View: QPFV_MODIFIER_LINES 12.2.2
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
APPS.QPFV_MODIFIER_LINES·↳ MTL_UNITS_OF_MEASURE·↳ QP_LIST_LINES·↳ QP_QP_FORM_PRICING_ATTR·Explore QP module →
-
View: QP_DEBUG_REQ_LDETS_V 12.1.1
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
APPS.QP_DEBUG_REQ_LDETS_V·↳ QP_DEBUG_REQ_LDETS·↳ QP_DEBUG_REQ_RLTD_LINES·Explore QP module →
-
View: QP_LDETS_V 12.2.2
This view is for OM to get the post-pricing adjustment/modifier details.
APPS.QP_LDETS_V·↳ QP_LIST_LINES·↳ QP_PREQ_LDETS_TMP_T·Explore QP module →
-
View: QP_MODIFIER_SUMMARY_V 12.2.2
Modifier Summary information for Modifier Lists. Used by the Modifiers form (for summary block).
APPS.QP_MODIFIER_SUMMARY_V·↳ QP_LIST_LINES·↳ QP_PRICE_LIST_LINE_UTIL·↳ QP_PRICING_ATTRIBUTES·Explore QP module →
-
This table contains information about the line details being priced. It has adjustment and discount details for lines, including adjustments and discounts that the pricing engine eliminates.
-
Permanent table for holding the details of the derivation of the base and adjusted prices.
-
View: QP_PREQ_LDETS_TMP 12.1.1
Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.
APPS.QP_PREQ_LDETS_TMP·↳ QP_PREQ_LDETS_TMP_T·Explore QP module →
-
View: QP_PRICING_ATTR_V 12.1.1
View of additonal qualification items for modifiers. Used by Modifiers Form (for Additional buy products block).
APPS.QP_PRICING_ATTR_V·↳ QP_LIST_LINES·↳ QP_PRICING_ATTRIBUTES·↳ QP_RLTD_MODIFIERS·Explore QP module →
-
View: QP_MODIFIER_SUMMARY_V 12.1.1
Modifier Summary information for Modifier Lists. Used by the Modifiers form (for summary block).
APPS.QP_MODIFIER_SUMMARY_V·↳ QP_LIST_LINES·↳ QP_PRICE_LIST_LINE_UTIL·↳ QP_PRICING_ATTRIBUTES·Explore QP module →
-
View: QP_LIST_ATTRIBUTES_V 12.2.2
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
APPS.QP_LIST_ATTRIBUTES_V·↳ QP_LIST_HEADERS_VL·↳ QP_LIST_LINES·↳ QP_PRICING_ATTRIBUTES·Explore QP module →
-
View: QP_LINE_LVL_QUAL_V 12.2.2
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
APPS.QP_LINE_LVL_QUAL_V·↳ QP_LIST_HEADERS_VL·↳ QP_LIST_LINES·↳ QP_QUALIFIERS·Explore QP module →
-
View: QP_LINE_LVL_QUAL_V 12.1.1
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
APPS.QP_LINE_LVL_QUAL_V·↳ QP_LIST_HEADERS_VL·↳ QP_LIST_LINES·↳ QP_QUALIFIERS·Explore QP module →