Search Results arithmetic_operator




Overview
Explore in AI Chat

Overview

QP_DEBUG_REQ_RLTD_LINES_V is a diagnostic view owned by the APPS schema within the Oracle E-Business Suite Advanced Pricing (QP) module. It is defined over the pricing debug request tables and exposes the relationship structure between line details captured during a pricing engine debug run. The view is part of the pricing debugger infrastructure, a facility used to trace how the Oracle Advanced Pricing engine resolves lists, formulas, qualifiers, and related line calculations during request processing. Because the debug tables persist intermediate pricing resolution steps, this view provides a normalized projection of those steps suitable for reporting and troubleshooting.

The view is a UNION of two queries against the same pair of base objects, combining rows where the debug line detail index matches either the primary line detail index or the related line detail index. This dual projection ensures that both sides of a pricing relationship are represented in a single result set, which is valuable when analyzing how an adjustment or list line is linked to other lines in the same request.

Underlying Base Objects

The view is defined over two documented base objects, both synonyms in the APPS schema:

  • QP_DEBUG_REQ_RLTD_LINES — stores the relationship records between line detail entries within a debug request, including the line detail index and related line detail index along with the relationship type code.
  • QP_DEBUG_REQ_LDETS — stores the line detail attributes, including list header, list type, list line identifiers, line type, operand calculation code, and operand value.

The join is performed on REQUEST_ID and on LINE_DETAIL_INDEX (first branch) or RELATED_LINE_DETAIL_INDEX (second branch), with the two branches combined by UNION. Columns selected from QP_DEBUG_REQ_RLTD_LINES include REQUEST_ID, REQUEST_TYPE_CODE, LINE_INDEX, LINE_DETAIL_INDEX, and RELATIONSHIP_TYPE_CODE. Columns selected from QP_DEBUG_REQ_LDETS are aliased into the view, notably CREATED_FROM_LIST_HEADER_ID as LIST_HEADER_ID, CREATED_FROM_LIST_TYPE_CODE as LIST_TYPE_CODE, CREATED_FROM_LIST_LINE_ID as LIST_LINE_ID, CREATED_FROM_LIST_LINE_TYPE as LIST_LINE_TYPE_CODE, OPERAND_CALCULATION_CODE as ARITHMETIC_OPERATOR, and OPERAND_VALUE.

Key Columns

  • REQUEST_ID — Identifier of the debug request; the primary correlation key across the underlying tables.
  • REQUEST_TYPE_CODE — Classifies the debug request type.
  • LINE_INDEX — Index of the parent line within the request.
  • LINE_DETAIL_INDEX — The line detail index, taken from either the primary or related index depending on the UNION branch.
  • RELATIONSHIP_TYPE_CODE — Describes the nature of the relationship between the line detail and its related line detail.
  • LIST_HEADER_ID — The pricing list header from which the line was created or resolved.
  • LIST_TYPE_CODE — The type of the pricing list (for example, price list, discount list, or promotion). This is a frequently queried attribute when filtering debug output by list category.
  • LIST_LINE_ID — The specific list line identifier associated with the detail.
  • LIST_LINE_TYPE_CODE — Classification of the list line.
  • ARITHMETIC_OPERATOR — The operand calculation code, indicating the arithmetic applied to the operand value.
  • OPERAND_VALUE — The numeric operand used in the calculation.

Common Use Cases and Queries

This view is used primarily by technical consultants and support analysts diagnosing pricing behavior. Typical scenarios include tracing which list lines contributed to a calculated price, identifying the relationship type between line details, and examining the arithmetic operator and operand values applied. A common filter is by LIST_TYPE_CODE to isolate a particular category of pricing list.

SELECT request_id,
       line_index,
       line_detail_index,
       relationship_type_code,
       list_header_id,
       list_type_code,
       list_line_id,
       arithmetic_operator,
       operand_value
  FROM apps.qp_debug_req_rltd_lines_v
 WHERE request_id = :p_request_id
   AND list_type_code = :p_list_type_code
 ORDER BY line_index, line_detail_index;

Because the view frequently returns multiple rows per line detail due to the UNION, queries should be ordered and, where necessary, de-duplicated to present a readable diagnostic trail. The view is read-only and intended for query and reporting purposes only; no DML should be issued against it or its underlying debug tables outside the standard pricing debugger processes.

  • Lookup Type: ARITHMETIC_OPERATOR 12.1.1

    product: QP - Advanced Pricing ,  meaning: Arithmetic Operator ,  description: Types of calculation methods like percentage discount, amount discount or a new price for a list line type ( like discount or surcharge ). , 

  • Lookup Type: ARITHMETIC_OPERATOR 12.2.2

    product: QP - Advanced Pricing ,  meaning: Arithmetic Operator ,  description: Types of calculation methods like percentage discount, amount discount or a new price for a list line type ( like discount or surcharge ). , 

  • View: QP_DEBUG_REQ_RLTD_LINES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_DEBUG_REQ_RLTD_LINES_V,  object_name:QP_DEBUG_REQ_RLTD_LINES_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 related lines. ,  implementation_dba_data: APPS.QP_DEBUG_REQ_RLTD_LINES_V , 

  • View: QP_DEBUG_REQ_RLTD_LINES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_DEBUG_REQ_RLTD_LINES_V,  object_name:QP_DEBUG_REQ_RLTD_LINES_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 related lines. ,  implementation_dba_data: APPS.QP_DEBUG_REQ_RLTD_LINES_V , 

  • View: QPBV_PRODUCT_BENEFITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRODUCT_BENEFITS,  object_name:QPBV_PRODUCT_BENEFITS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the 'Benefit' products of a Other item discount and Promotional Goods. ,  implementation_dba_data: APPS.QPBV_PRODUCT_BENEFITS , 

  • View: QPBV_PRODUCT_BENEFITS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRODUCT_BENEFITS,  object_name:QPBV_PRODUCT_BENEFITS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the 'Benefit' products of a Other item discount and Promotional Goods. ,  implementation_dba_data: APPS.QPBV_PRODUCT_BENEFITS , 

  • View: QPFV_PRICE_BREAK_LINES 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRICE_BREAK_LINES,  object_name:QPFV_PRICE_BREAK_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the price break lines attached to a Price Break header of a Modifier or a Price List. ,  implementation_dba_data: APPS.QPFV_PRICE_BREAK_LINES , 

  • View: QPFV_PRICE_BREAK_LINES 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRICE_BREAK_LINES,  object_name:QPFV_PRICE_BREAK_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the price break lines attached to a Price Break header of a Modifier or a Price List. ,  implementation_dba_data: APPS.QPFV_PRICE_BREAK_LINES , 

  • View: QPBV_PRICE_BREAK_LINES 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRICE_BREAK_LINES,  object_name:QPBV_PRICE_BREAK_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the price break lines attached to a Price Break header of a Modifier or a Price List. ,  implementation_dba_data: APPS.QPBV_PRICE_BREAK_LINES , 

  • View: QPBV_PRICE_BREAK_LINES 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_PRICE_BREAK_LINES,  object_name:QPBV_PRICE_BREAK_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the price break lines attached to a Price Break header of a Modifier or a Price List. ,  implementation_dba_data: APPS.QPBV_PRICE_BREAK_LINES , 

  • View: QPFV_PRODUCT_BENEFITS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRODUCT_BENEFITS,  object_name:QPFV_PRODUCT_BENEFITS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the 'Benefit' products of a Other item discount and Promotional Goods. ,  implementation_dba_data: APPS.QPFV_PRODUCT_BENEFITS , 

  • View: QPFV_PRODUCT_BENEFITS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_PRODUCT_BENEFITS,  object_name:QPFV_PRODUCT_BENEFITS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about the 'Benefit' products of a Other item discount and Promotional Goods. ,  implementation_dba_data: APPS.QPFV_PRODUCT_BENEFITS , 

  • 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: 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_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: 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: 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: 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.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: 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: 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: 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: 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_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 , 

  • 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_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_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_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_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_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_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 ,