Search Results QP_LIST_LINES




Overview
Explore in AI Chat

Overview

The QP_LIST_LINES table is a core data repository within the Oracle E-Business Suite Advanced Pricing (QP) module. It serves as the detailed line-level storage for all pricing modifiers and list price entries defined in the system. Each record in this table represents a specific pricing rule or price point that is attached to a parent pricing list, qualifier, or modifier header stored in QP_LIST_HEADERS_B. The table is fundamental to the pricing engine's operation, enabling the complex calculation of prices, discounts, surcharges, and promotions applied to transactions across Oracle EBS, including Order Management, Receivables, and Procurement.

Key Information Stored

The table's primary key is LIST_LINE_ID, which uniquely identifies each pricing line. Its most critical foreign key is LIST_HEADER_ID, linking the line to its parent definition in QP_LIST_HEADERS_B. Other significant columns define the pricing logic and application. The PRICING_PHASE_ID indicates when the modifier is applied (e.g., line, order, or shipment level). Key attribute columns, such as INVENTORY_ITEM_ID, ORGANIZATION_ID, and RELATED_ITEM_ID, store the product, inventory organization, and product relationship criteria that qualify a transaction for the pricing line. The PRICE_BY_FORMULA_ID and GENERATE_USING_FORMULA_ID columns reference QP_PRICE_FORMULAS_B to enable formula-based pricing. The BENEFIT_PRICE_LIST_LINE_ID supports benefit (giveaway) modifiers by linking to another line within the same table.

Common Use Cases and Queries

Primary use cases involve troubleshooting pricing calculations, auditing price list configurations, and generating custom pricing reports. A common query retrieves all modifiers for a specific product to understand its pricing structure. For example:

  • Identifying active list prices for an item: SELECT list_line_id, list_price, start_date_active, end_date_active FROM qp_list_lines qll, qp_list_headers_b qlh WHERE qll.list_header_id = qlh.list_header_id AND qlh.list_type_code = 'PRL' AND qll.inventory_item_id = <item_id> AND SYSDATE BETWEEN nvl(qll.start_date_active, SYSDATE) AND nvl(qll.end_date_active, SYSDATE);
  • Analyzing all modifiers on a specific price list header: SELECT list_line_id, modifier_level_code, arithmetic_operator, operand FROM qp_list_lines WHERE list_header_id = <header_id> ORDER BY list_line_number;
  • Debugging a transaction price by joining to QP_DEBUG_REQ_LINE_ATTRS using the LIST_LINE_ID.

Related Objects

QP_LIST_LINES maintains extensive relationships with numerous EBS objects, underscoring its central role. Its primary parent is QP_LIST_HEADERS_B. Key transactional child tables include OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJS_IFACE_ALL, which store applied modifiers from sales orders. For debugging and formula execution, it links to QP_DEBUG_REQ_LINE_ATTRS, QP_DEBUG_REQ_RLTD_LINES, and QP_DEBUG_FORMULA_STEP_VALUES. It is referenced by other modules for specialized pricing: AMS_EVENT_OFFERS_ALL_B (Marketing), OKC_K_LINES_B (Contracts), OZF_RELATED_DEAL_LINES (Trade Management), and FTE_LOAD_CHARGES (Transportation). The table also has a recursive relationship with itself via BENEFIT_PRICE_LIST_LINE_ID to model benefit modifiers.

  • Table: QP_LIST_LINES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES,  object_name:QP_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_LIST_LINES , 

  • Table: QP_LIST_LINES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES,  object_name:QP_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_LIST_LINES , 

  • Table: QP_DEBUG_REQ_RLTD_LINES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_DEBUG_REQ_RLTD_LINES,  object_name:QP_DEBUG_REQ_RLTD_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: This table contains information about the related lines. ,  implementation_dba_data: QP.QP_DEBUG_REQ_RLTD_LINES , 

  • Table: QP_RLTD_MODIFIERS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_RLTD_MODIFIERS,  object_name:QP_RLTD_MODIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_RLTD_MODIFIERS stores the relationship between modifier lines. ,  implementation_dba_data: QP.QP_RLTD_MODIFIERS , 

  • Table: QP_RLTD_MODIFIERS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_RLTD_MODIFIERS,  object_name:QP_RLTD_MODIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_RLTD_MODIFIERS stores the relationship between modifier lines. ,  implementation_dba_data: QP.QP_RLTD_MODIFIERS , 

  • Table: QP_PRICE_FORMULAS_B 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_B,  object_name:QP_PRICE_FORMULAS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICE_FORMULAS_B stores the pricing formula header information. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_B , 

  • Table: QP_DEBUG_REQ_RLTD_LINES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_DEBUG_REQ_RLTD_LINES,  object_name:QP_DEBUG_REQ_RLTD_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: This table contains information about the related lines. ,  implementation_dba_data: QP.QP_DEBUG_REQ_RLTD_LINES , 

  • Table: QP_PRICE_FORMULAS_B 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICE_FORMULAS_B,  object_name:QP_PRICE_FORMULAS_B,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICE_FORMULAS_B stores the pricing formula header information. ,  implementation_dba_data: QP.QP_PRICE_FORMULAS_B , 

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

  • Table: QP_INTERFACE_LIST_LINES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_INTERFACE_LIST_LINES,  object_name:QP_INTERFACE_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_INTERFACE_LIST_LINES , 

  • Table: QP_INTERFACE_LIST_LINES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_INTERFACE_LIST_LINES,  object_name:QP_INTERFACE_LIST_LINES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_LIST_LINES stores all list lines for lists in QP_LIST_HEADERS_B. ,  implementation_dba_data: QP.QP_INTERFACE_LIST_LINES , 

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

  • Table: QP_PRICING_ATTRIBUTES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICING_ATTRIBUTES,  object_name:QP_PRICING_ATTRIBUTES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICING_ATTRIBUTES stores product information and pricing attributes. ,  implementation_dba_data: QP.QP_PRICING_ATTRIBUTES , 

  • Table: QP_COUPONS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_COUPONS,  object_name:QP_COUPONS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_COUPONS stores any Coupons which have been issued. ,  implementation_dba_data: QP.QP_COUPONS , 

  • Table: QP_QUALIFIERS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIERS,  object_name:QP_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIERS stores qualifier attribute information. ,  implementation_dba_data: QP.QP_QUALIFIERS , 

  • Table: QP_PRICING_PHASES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICING_PHASES,  object_name:QP_PRICING_PHASES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICING_PHASES stores all pricing phases. ,  implementation_dba_data: QP.QP_PRICING_PHASES , 

  • Table: QP_PRICING_ATTRIBUTES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICING_ATTRIBUTES,  object_name:QP_PRICING_ATTRIBUTES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICING_ATTRIBUTES stores product information and pricing attributes. ,  implementation_dba_data: QP.QP_PRICING_ATTRIBUTES , 

  • View: QP_PRICE_FACTORS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FACTORS_V,  object_name:QP_PRICE_FACTORS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View to get a list of those formula lines which are of type Price Modifier List along with the List of Adjustment Factors & Ranges making up the formula line and the discount modifier list to which the formula is attached. ,  implementation_dba_data: APPS.QP_PRICE_FACTORS_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 , 

  • Table: QP_PRICING_PHASES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_PRICING_PHASES,  object_name:QP_PRICING_PHASES,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_PRICING_PHASES stores all pricing phases. ,  implementation_dba_data: QP.QP_PRICING_PHASES , 

  • 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_FACTORS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PRICE_FACTORS_V,  object_name:QP_PRICE_FACTORS_V,  status:VALID,  product: QP - Advanced Pricing ,  description: View to get a list of those formula lines which are of type Price Modifier List along with the List of Adjustment Factors & Ranges making up the formula line and the discount modifier list to which the formula is attached. ,  implementation_dba_data: APPS.QP_PRICE_FACTORS_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 , 

  • Table: QP_COUPONS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_COUPONS,  object_name:QP_COUPONS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_COUPONS stores any Coupons which have been issued. ,  implementation_dba_data: QP.QP_COUPONS , 

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

  • Table: QP_LIMIT_TRANSACTIONS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIMIT_TRANSACTIONS,  object_name:QP_LIMIT_TRANSACTIONS,  status:VALID,  product: QP - Advanced Pricing ,  description: This table holds details of all the transactions which consumed or increased the available balance on all the limits. ,  implementation_dba_data: QP.QP_LIMIT_TRANSACTIONS , 

  • Table: QP_LIMIT_TRANSACTIONS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIMIT_TRANSACTIONS,  object_name:QP_LIMIT_TRANSACTIONS,  status:VALID,  product: QP - Advanced Pricing ,  description: This table holds details of all the transactions which consumed or increased the available balance on all the limits. ,  implementation_dba_data: QP.QP_LIMIT_TRANSACTIONS , 

  • Table: QP_QUALIFIERS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_QUALIFIERS,  object_name:QP_QUALIFIERS,  status:VALID,  product: QP - Advanced Pricing ,  description: QP_QUALIFIERS stores qualifier attribute information. ,  implementation_dba_data: QP.QP_QUALIFIERS , 

  • Table: QP_LIST_LINES_EBS_LOG 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES_EBS_LOG,  object_name:QP_LIST_LINES_EBS_LOG,  status:VALID,  product: QP - Advanced Pricing ,  description: Log table for the Euro conversion of QP_LIST_LINES table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. ,  implementation_dba_data: QP.QP_LIST_LINES_EBS_LOG , 

  • Table: QP_DEBUG_REQ_LDETS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_DEBUG_REQ_LDETS,  object_name:QP_DEBUG_REQ_LDETS,  status:VALID,  product: QP - Advanced Pricing ,  description: 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. ,  implementation_dba_data: QP.QP_DEBUG_REQ_LDETS , 

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

  • Table: QP_LIMITS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIMITS,  object_name:QP_LIMITS,  status:VALID,  product: QP - Advanced Pricing ,  description: This table table holds the definition of the limit, and the Promotion, Deal or modifier for which the limit is set. ,  implementation_dba_data: QP.QP_LIMITS , 

  • Table: QP_LIST_LINES_EBS_LOG 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIST_LINES_EBS_LOG,  object_name:QP_LIST_LINES_EBS_LOG,  status:VALID,  product: QP - Advanced Pricing ,  description: Log table for the Euro conversion of QP_LIST_LINES table. This table is used only by the Euro Conversion concurrent program to store the mapping between the Original NCU column values and the corresponding Euro converted values. ,  implementation_dba_data: QP.QP_LIST_LINES_EBS_LOG , 

  • Table: QP_DEBUG_REQ_LINE_ATTRS 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_DEBUG_REQ_LINE_ATTRS,  object_name:QP_DEBUG_REQ_LINE_ATTRS,  status:VALID,  product: QP - Advanced Pricing ,  description: 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. ,  implementation_dba_data: QP.QP_DEBUG_REQ_LINE_ATTRS , 

  • Table: QP_LIMITS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_LIMITS,  object_name:QP_LIMITS,  status:VALID,  product: QP - Advanced Pricing ,  description: This table table holds the definition of the limit, and the Promotion, Deal or modifier for which the limit is set. ,  implementation_dba_data: QP.QP_LIMITS , 

  • Table: QP_DEBUG_REQ_LDETS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_DEBUG_REQ_LDETS,  object_name:QP_DEBUG_REQ_LDETS,  status:VALID,  product: QP - Advanced Pricing ,  description: 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. ,  implementation_dba_data: QP.QP_DEBUG_REQ_LDETS , 

  • Table: QP_DEBUG_FORMULA_STEP_VALUES 12.1.1

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_DEBUG_FORMULA_STEP_VALUES,  object_name:QP_DEBUG_FORMULA_STEP_VALUES,  status:VALID,  product: QP - Advanced Pricing ,  description: This table contains information about the formula step values which are inserted into the table QP_FORMULA_STEP_VALUES. The step values are inserted into the table during the evaluation of formula attached to the price lists. ,  implementation_dba_data: QP.QP_DEBUG_FORMULA_STEP_VALUES , 

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

  • Table: QP_DEBUG_FORMULA_STEP_VALUES 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_DEBUG_FORMULA_STEP_VALUES,  object_name:QP_DEBUG_FORMULA_STEP_VALUES,  status:VALID,  product: QP - Advanced Pricing ,  description: This table contains information about the formula step values which are inserted into the table QP_FORMULA_STEP_VALUES. The step values are inserted into the table during the evaluation of formula attached to the price lists. ,  implementation_dba_data: QP.QP_DEBUG_FORMULA_STEP_VALUES , 

  • Table: QP_DEBUG_REQ_LINE_ATTRS 12.2.2

    owner:QP,  object_type:TABLE,  fnd_design_data:QP.QP_DEBUG_REQ_LINE_ATTRS,  object_name:QP_DEBUG_REQ_LINE_ATTRS,  status:VALID,  product: QP - Advanced Pricing ,  description: 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. ,  implementation_dba_data: QP.QP_DEBUG_REQ_LINE_ATTRS , 

  • 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: 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_FACTOR_ASSO_PRICING_ATTRS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPBV_FACTOR_ASSO_PRICING_ATTRS,  object_name:QPBV_FACTOR_ASSO_PRICING_ATTRS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives the information of associated pricing attributes of a Factor list. ,  implementation_dba_data: APPS.QPBV_FACTOR_ASSO_PRICING_ATTRS ,