Search Results modifier_level_code




Overview
Explore in AI Chat

Overview

QPBV_TERM_SUBSTITUTIONS is an Oracle E-Business Suite view owned by the APPS schema within the QP (Advanced Pricing) product family. As its description states, the view exposes information about Term Substitutions type of Modifiers. In Oracle Advanced Pricing, a modifier is a pricing adjustment or list-line rule that governs how prices are calculated, substituted, or constrained. Term substitutions represent a specialized modifier category used to replace one term (such as a payment term, shipping term, or similar qualifier) with an alternative under controlled conditions.

The view is classified as VALID in the ETRM metadata for both 12.1.1 and 12.2.2, and it behaves as a filtered, read-only projection rather than a stored table. Its principal analytical role is to consolidate only those list lines whose LIST_LINE_TYPE_CODE equals 'TSN', thereby isolating term substitution records from the broader population of pricing list lines. This makes it a convenient reporting and integration surface for developers, business analysts, and interface designers who need to retrieve substitution-specific modifier data without manually applying the type filter against the underlying base table.

Underlying Base Objects

The documented base object referenced by QPBV_TERM_SUBSTITUTIONS is QP_LIST_LINES, accessed through a synonym in the APPS schema. The view is defined as a straightforward SELECT from QP_LIST_LINES with a single predicate restricting returned rows to LIST_LINE_TYPE_CODE = 'TSN'. All columns exposed by the view are drawn directly from the base table; no joins, aggregations, or computed expressions are introduced.

Because the view inherits the structure of QP_LIST_LINES, it carries the standard EBS audit and concurrency columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) alongside pricing-specific attributes. The view therefore does not create or duplicate data—it filters and re-presents existing modifier definitions maintained through the Advanced Pricing setup and the Modifier (Pricing) windows.

Key Columns

  • MODIFIER_LEVEL_CODE — Identifies the level at which the modifier applies (for example, line, order, or group level). This is frequently searched because it determines the scope over which a substitution modifier operates.
  • LIST_HEADER_ID and LIST_LINE_ID — The primary keys of the parent price list and the specific list line, respectively.
  • LIST_LINE_NO — The display sequence number of the line within its list.
  • LIST_LINE_TYPE_CODE — Always 'TSN' in this view, confirming the line is a term substitution.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — Effective dating that governs when the substitution is active.
  • SUBSTITUTION_CONTEXT, SUBSTITUTION_ATTRIBUTE, SUBSTITUTION_VALUE — The context, attribute, and value that define what is being substituted and with what.
  • INCOMPATIBILITY_GRP_CODE — The incompatibility group used to prevent conflicting substitutions from co-applying.
  • PRODUCT_PRECEDENCE — Controls resolution priority when multiple substitutions apply.
  • PRICING_PHASE_ID — Links the line to the pricing phase in which it is evaluated.
  • ESTIM_GL_VALUE — The estimated general ledger value associated with the line.

Common Use Cases and Queries

Typical uses include auditing active term substitutions, validating effective dates, and feeding substitution data into integrations or custom pricing reports. Because the view already filters for 'TSN', queries remain simple.

  • List all term substitutions active on a given date: 
    SELECT list_header_id, list_line_no, modifier_level_code,
       substitution_context, substitution_attribute, substitution_value
FROM   apps.qpbv_term_substitutions
WHERE  TRUNC(SYSDATE) BETWEEN start_date_active
       AND NVL(end_date_active, TRUNC(SYSDATE));
  • Filter by modifier level to inspect scope: 
    SELECT list_line_id, list_header_id, modifier_level_code, product_precedence
FROM   apps.qpbv_term_substitutions
WHERE  modifier_level_code = 'LINE';
  • Review incompatibility grouping for conflict analysis: 
    SELECT list_header_id, list_line_no, incompatibility_grp_code
FROM   apps.qpbv_term_substitutions
ORDER  BY incompatibility_grp_code, product_precedence;

In each case, the view supplies a reliable, pre-filtered foundation for substitution-focused reporting within Oracle Advanced Pricing.

  • Lookup Type: MODIFIER_LEVEL_CODE 12.1.1

    product: QP - Advanced Pricing ,  meaning: Modifier Level Code ,  description: 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. , 

  • Lookup Type: MODIFIER_LEVEL_CODE 12.2.2

    product: QP - Advanced Pricing ,  meaning: Modifier Level Code ,  description: 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_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.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_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: QPFV_ITEM_UPGRADES 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_ITEM_UPGRADES,  object_name:QPFV_ITEM_UPGRADES,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Item Upgrades type of modifiers. ,  implementation_dba_data: APPS.QPFV_ITEM_UPGRADES , 

  • View: QPFV_ITEM_UPGRADES 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_ITEM_UPGRADES,  object_name:QPFV_ITEM_UPGRADES,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Item Upgrades type of modifiers. ,  implementation_dba_data: APPS.QPFV_ITEM_UPGRADES , 

  • View: QPFV_TERM_SUBSTITUTIONS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_TERM_SUBSTITUTIONS,  object_name:QPFV_TERM_SUBSTITUTIONS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Term Substitutuions type of Modifiers. ,  implementation_dba_data: APPS.QPFV_TERM_SUBSTITUTIONS , 

  • View: QPFV_TERM_SUBSTITUTIONS 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QPFV_TERM_SUBSTITUTIONS,  object_name:QPFV_TERM_SUBSTITUTIONS,  status:VALID,  product: QP - Advanced Pricing ,  description: This view gives information about Term Substitutuions type of Modifiers. ,  implementation_dba_data: APPS.QPFV_TERM_SUBSTITUTIONS , 

  • 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_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_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_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: 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: 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: 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: QP_PREQ_LINE_ATTRS_TMP 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PREQ_LINE_ATTRS_TMP,  object_name:QP_PREQ_LINE_ATTRS_TMP,  status:VALID,  product: QP - Advanced Pricing ,  description: Based on QP_PREQ_LINE_ATTRS_TMP_T. This view has the information pertaining to the current pricing engine call. ,  implementation_dba_data: APPS.QP_PREQ_LINE_ATTRS_TMP , 

  • View: QP_PREQ_LINE_ATTRS_TMP 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:QP.QP_PREQ_LINE_ATTRS_TMP,  object_name:QP_PREQ_LINE_ATTRS_TMP,  status:VALID,  product: QP - Advanced Pricing ,  description: Based on QP_PREQ_LINE_ATTRS_TMP_T. This view has the information pertaining to the current pricing engine call. ,  implementation_dba_data: APPS.QP_PREQ_LINE_ATTRS_TMP , 

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

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

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