Search Results qp_list_lines




The QP_LIST_LINES table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Pricing module (Advanced Pricing). It stores detailed pricing rules, adjustments, and modifiers that are applied to products, customers, or transactions within the Oracle Order Management and Quoting modules. This table serves as the foundation for defining complex pricing strategies, including discounts, surcharges, promotions, and special pricing agreements. Below is a detailed summary of its structure, purpose, and key attributes.

Purpose and Functionality

The QP_LIST_LINES table holds individual pricing lines that are part of a price list (QP_LIST_HEADERS). Each record represents a specific pricing rule or modifier tied to a product, category, or customer. These rules determine how prices are calculated during sales transactions, ensuring consistency and flexibility in pricing strategies. The table integrates with other Oracle EBS modules, such as Order Management, Inventory, and Accounts Receivable, to enforce pricing policies dynamically.

Key Columns and Attributes

  • LIST_LINE_ID: Primary key identifier for each pricing line.
  • LIST_HEADER_ID: Foreign key linking to QP_LIST_HEADERS, associating the line with a price list.
  • LIST_LINE_TYPE_CODE: Defines the type of pricing rule (e.g., DISCOUNT, PRICING_PHASE, SURCHARGE).
  • PRODUCT_ATTR_VALUE: Specifies the product or category to which the pricing rule applies.
  • OPERAND: The value used in calculations (e.g., percentage discount, fixed amount).
  • ARITHMETIC_OPERATOR: Determines the calculation method (e.g., +, -, *, /).
  • START_DATE_ACTIVE and END_DATE_ACTIVE: Define the validity period of the pricing rule.
  • MODIFIER_LEVEL_CODE: Indicates whether the rule applies at the LINE, HEADER, or other levels.

Integration with Other Modules

The QP_LIST_LINES table interacts with several Oracle EBS tables and modules:
  • QP_LIST_HEADERS: Contains header information for price lists.
  • QP_PRICING_ATTRIBUTES: Stores additional attributes for pricing rules.
  • OE_ORDER_LINES: Applies pricing rules during order entry.
  • INV_ITEMS: Links products to pricing rules.

Business Use Cases

  1. Discount Management: Define tiered or volume-based discounts for specific products or customers.
  2. Promotional Pricing: Create time-bound promotions with start/end dates.
  3. Customer-Specific Pricing: Assign unique pricing for preferred customers.
  4. Surcharges: Apply additional fees based on product attributes or order conditions.

Technical Considerations

  • Indexing: The LIST_LINE_ID and LIST_HEADER_ID columns are typically indexed for performance.
  • Data Volume: Large enterprises may have millions of records, requiring partitioning or archiving strategies.
  • Custom Extensions: Custom PL/SQL or APIs may extend functionality for complex pricing scenarios.

Conclusion

The QP_LIST_LINES table is a cornerstone of Oracle Advanced Pricing, enabling organizations to implement granular and dynamic pricing strategies. Its integration with core EBS modules ensures accurate and automated price calculations, supporting diverse business requirements. Proper configuration and maintenance of this table are essential for achieving optimal pricing performance and accuracy in Oracle EBS 12.1.1 and 12.2.2 environments.

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

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

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

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

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

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

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