Search Results pricing_group_sequence

Overview

QP_PRICING_ATTR_GET_V is an Advanced Pricing (QP) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. According to the ETRM metadata, it is documented as a "View of Benefit or Get Products for a Modifier" and is consumed by the Modifiers Form. Its purpose is to present the qualifying and benefit product attribute rules attached to a price list line, joining each pricing attribute record to its parent list line so the modifier form can retrieve and display the complete rule context in a single query.

The name reflects its function: "GET" refers to the get/benefit side of a modifier, and "PRICING_ATTR" refers to the pricing attribute conditions that drive the modifier. The view is a reporting and form-support construct rather than a stored table, so it is read-only and exposes no DML. It is relevant to the user's search term "benefit_price_list_line_id" because the underlying list line key (LIST_LINE_ID) is the identifier that links an attribute back to the benefit price list line on which the modifier is defined.

Underlying Base Objects

The view is defined over three documented base objects: QP_LIST_LINES, QP_PRICING_ATTRIBUTES, and QP_RLTD_MODIFIERS, all referenced through APPS synonyms. QP_LIST_LINES supplies the list line header context — the benefit line on which the modifier hangs. QP_PRICING_ATTRIBUTES supplies the attribute-level rule rows, including the comparison operator, attribute context, and value ranges. QP_RLTD_MODIFIERS provides the linkage between modifiers and their related lines, tying the get and benefit sides together.

In the view SQL, columns prefixed QL come from QP_LIST_LINES, and columns prefixed QPA come from QP_PRICING_ATTRIBUTES. The join is established through the pricing attribute's LIST_LINE_ID, which corresponds to the benefit price list line identifier the user searched for. The view carries QL.ROWID as ROW_ID, giving the form a handle to the underlying list line for downstream processing.

Key Columns

PRICING_ATTRIBUTE_ID / LIST_LINE_ID — primary identifiers linking the attribute rule to the benefit list line (the "benefit_price_list_line_id" concept).
COMPARISON_OPERATOR_CODE — the operator (=, >=, BETWEEN, etc.) applied to the pricing attribute value.
PRODUCT_ATTRIBUTE / PRODUCT_ATTR_VALUE / PRODUCT_UOM_CODE — the get-side product qualification data.
PRICING_ATTRIBUTE / PRICING_ATTR_VALUE_FROM / PRICING_ATTR_VALUE_TO — the pricing attribute and numeric range evaluated for the modifier.
PRODUCT_ATTRIBUTE_CONTEXT / PRICING_ATTRIBUTE_CONTEXT / CONTEXT — the descriptive flexfield context governing attribute meanings.
EXCLUDER_FLAG — indicates whether the attribute acts as an exclusion.
ATTRIBUTE_GROUPING_NO — groups attributes logically within a modifier.
LIST_LINE_NO, LIST_HEADER_ID, LIST_LINE_TYPE_CODE — list line identity, number, and type from QP_LIST_LINES.
ARITHMETIC_OPERATOR, OPERAND, PRORATION_TYPE_CODE, BENEFIT_LIMIT — benefit-side modifier behavior, including accrual and proration controls.
ATTRIBUTE1–ATTRIBUTE15 — DFF segments inherited from the list line.
Creation/audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, REQUEST_ID, PROGRAM_ID for concurrent program traceability.

Common Use Cases and Queries

The view supports modifier troubleshooting, pricing rule audits, and reconciliation reporting. A typical query groups attributes by their owning benefit line:

List all pricing attributes for a specific benefit line: SELECT pricing_attribute, comparison_operator_code, pricing_attr_value_from, pricing_attr_value_to FROM qp_pricing_attr_get_v WHERE list_line_id = :p_benefit_line_id;
Find modifiers where a product attribute is used as a get qualifier: SELECT list_line_id, product_attribute, product_attr_value FROM qp_pricing_attr_get_v WHERE product_attribute = :p_attr;
Audit benefit limits and proration by line: SELECT list_line_no, arithmetic_operator, operand, benefit_limit, proration_type_code FROM qp_pricing_attr_get_v WHERE list_header_id = :p_header_id ORDER BY list_line_no;

Because the view joins QP_LIST_LINES, QP_PRICING_ATTRIBUTES, and QP_RLTD_MODIFIERS, it is best used for read-only reporting. Any correction to modifier logic should be performed through the Advanced Pricing Modifiers Form or the corresponding base tables under controlled DML, not through the view itself.

Lookup Type: PRICING_GROUP_SEQUENCE 12.1.1
product: QP - Advanced Pricing , meaning: Pricing Group Sequence , description: Pricing Buckets for combining discounts ,
Lookup Type: PRICING_GROUP_SEQUENCE 12.2.2
product: QP - Advanced Pricing , meaning: Pricing Group Sequence , description: Pricing Buckets for combining discounts ,
View: QP_PRICING_ATTR_GET_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PRICING_ATTR_GET_V, object_name:QP_PRICING_ATTR_GET_V, status:VALID, product: QP - Advanced Pricing , description: View of Benefit or Get Products for a Modifier. Used by Modifiers Form. , implementation_dba_data: APPS.QP_PRICING_ATTR_GET_V ,
View: QP_PRICING_ATTR_GET_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PRICING_ATTR_GET_V, object_name:QP_PRICING_ATTR_GET_V, status:VALID, product: QP - Advanced Pricing , description: View of Benefit or Get Products for a Modifier. Used by Modifiers Form. , implementation_dba_data: APPS.QP_PRICING_ATTR_GET_V ,
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: QP_PREQ_RLTD_LINES_TMP 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_RLTD_LINES_TMP, object_name:QP_PREQ_RLTD_LINES_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_RLTD_LINES_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_RLTD_LINES_TMP ,
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: QP_PREQ_RLTD_LINES_TMP 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PREQ_RLTD_LINES_TMP, object_name:QP_PREQ_RLTD_LINES_TMP, status:VALID, product: QP - Advanced Pricing , description: Based on QP_PREQ_RLTD_LINES_TMP_T. This view has the information pertaining to the current pricing engine call. , implementation_dba_data: APPS.QP_PREQ_RLTD_LINES_TMP ,
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_LDETS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LDETS_V, object_name:QP_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: This view is for OM to get the post-pricing adjustment/modifier details. , implementation_dba_data: APPS.QP_LDETS_V ,
View: QP_LDETS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_LDETS_V, object_name:QP_LDETS_V, status:VALID, product: QP - Advanced Pricing , description: This view is for OM to get the post-pricing adjustment/modifier details. , implementation_dba_data: APPS.QP_LDETS_V ,
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: 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.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_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.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: 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_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_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_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_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_PRICING_ATTR_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PRICING_ATTR_V, object_name:QP_PRICING_ATTR_V, status:VALID, product: QP - Advanced Pricing , description: View of additonal qualification items for modifiers. Used by Modifiers Form (for Additional buy products block). , implementation_dba_data: APPS.QP_PRICING_ATTR_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_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.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_PRICING_ATTR_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QP_PRICING_ATTR_V, object_name:QP_PRICING_ATTR_V, status:VALID, product: QP - Advanced Pricing , description: View of additonal qualification items for modifiers. Used by Modifiers Form (for Additional buy products block). , implementation_dba_data: APPS.QP_PRICING_ATTR_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_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_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_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_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_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 ,