QP Views (116)

QP - Advanced Pricing — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

View	Description
`OE_AGREEMENTS_115_VL`	Pricing Agreement information. Provided for backward compatibility for other applications.
`OE_AGREEMENTS_V`	Obsolete
`OE_AGREEMENTS_VL`	View of OE_AGREEMENTS_B and OE_AGREEMENTS_TL. Displays the translated columns on pricing agreements in the local language.
`OE_DISCOUNTS_V`	Obsolete
`OE_DISCOUNT_BY_V`	Obsolete
`OE_DISCOUNT_CUSTOMERS_V`	Obsolete
`OE_DISCOUNT_LINES_115_V`	Discount Line information. Provided for backward compatibility for other applications.
`OE_DISCOUNT_LINES_V`	Obsolete
`OE_PRC_CONTRACT_LINES_V`	Pricing Agreement line details. Used in the Define Pricing Agreements form.
`OE_PRICE_BREAK_LINES_V`	Obsolete
`OE_PRICE_LISTS_115_VL`	Price List information. Provided for backward compatibility for other applications and upgrade.
`OE_PRICE_LISTS_ACTIVE_V`	Shows all the price lists that are active as of today (sysdate). Provided for backward compatibility for other applications.
`OE_PRICE_LISTS_V`	Price List information. Provided for backward compatibility for other applications.
`OE_PRICE_LISTS_VL`	Price List information. Displays the translated columns on List Headers in the local language. Provided for backward compatibility for other
`OE_PRICE_LIST_LINES_115_V`	Price List Line information. Provided for backward compatibility for other applications.
`OE_PRICE_LIST_LINES_V`	Price List Line information. Provided for backward compatibility for other applications.
`OE_PRICING_CONTRACTS_V`	Obsolete
`OE_PRICING_ENTITIES_V`	Obsolete
`OE_PRICING_RULES_VL`	Obsolete
`QPBV_ADDITIONAL_BUY_PRODUCTS`	This view gives the information about the additional BUY product in a discount. For example, Buy 1 Shampoo and 1 Conditioner, Get 20% discou
`QPBV_AGREEMENTS`	This view gives information about the agreements.
`QPBV_COUPON_ISSUES`	This view gives information about Coupon Issue type of modifier.
`QPBV_FACTOR_ASSO_PRICING_ATTRS`	This view gives the information of associated pricing attributes of a Factor list.
`QPBV_FACTOR_BASE_PRICING_ATTRS`	This view gives the information of base pricing attributes of a Factor list.
`QPBV_FORMULA_HEADERS`	This gives information about formula headers
`QPBV_FORMULA_LINES`	This gives information about formula lines.
`QPBV_ITEM_UPGRADES`	This view gives information about Item Upgrades type of modifiers.
`QPBV_MODIFIER_HEADERS`	This view gives information about Discount List, Surcharge List and Freight and Special charges type of modifier headers.
`QPBV_MODIFIER_LINES`	This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional g
`QPBV_PRICE_BREAK_LINES`	This view gives information about the price break lines attached to a Price Break header of a Modifier or a Price List.
`QPBV_PRICE_LISTS`	This view gives information about Standard and Agreement Price list headers.
`QPBV_PRICE_LIST_LINES`	This view gives information about Price List lines.
`QPBV_PRICING_ATTRIBUTES`	This view gives information about Pricing Attributes attached to a Modifier or a Price List.
`QPBV_PRODUCTS`	This view gives information about a 'Buy' Product of a Modifier or Product of a Price list.
`QPBV_PRODUCT_BENEFITS`	This view gives information about the 'Benefit' products of a Other item discount and Promotional Goods.
`QPBV_PRODUCT_EXCLUSIONS`	This view gives information about products excluded from a Modifier.
`QPBV_PROMOTION_HEADERS`	This view gives information about Deal and Promotion type of Modifier headers.
`QPBV_QUALIFIERS`	This view gives information about Qualifiers attached to a Modifier or a Price List.
`QPBV_SECONDARY_PRICE_LISTS`	This view gives information about Primary Price list and its Secondary Price list.
`QPBV_TERM_SUBSTITUTIONS`	This view gives information about Term Substitutuions type of Modifiers.
`QPFV_ADDITIONAL_BUY_PRODUCTS`	This view gives the information about the additional BUY product in a discount. For example, Buy 1 Shampoo and 1 Conditioner, Get 20% discou
`QPFV_AGREEMENTS`	This view gives information about the agreements.
`QPFV_COUPON_ISSUES`	This view gives information about Coupon Issue type of modifier.
`QPFV_FACTOR_ASSO_PRICING_ATTRS`	This view gives the information of associated pricing attributes of a Factor list.
`QPFV_FACTOR_BASE_PRICING_ATTRS`	This view gives the information of base pricing attributes of a Factor list.
`QPFV_FORMULA_LINES`	This gives information about formula lines.
`QPFV_ITEM_UPGRADES`	This view gives information about Item Upgrades type of modifiers.
`QPFV_MODIFIER_HEADERS`	This view gives information about Discount List, Surcharge List and Freight and Special charges type of modifier headers.
`QPFV_MODIFIER_LINES`	This view gives information about Discount, Surcharge, Freight and Special Charge, Price Break Header, Other item discount and Promotional g
`QPFV_PRICE_BREAK_LINES`	This view gives information about the price break lines attached to a Price Break header of a Modifier or a Price List.
`QPFV_PRICE_LISTS`	This view gives information about Standard and Agreement Price list headers.
`QPFV_PRICE_LIST_LINES`	This view gives information about Price List lines.
`QPFV_PRICING_ATTRIBUTES`	This view gives information about Pricing Attributes attached to a Modifier or a Price List.
`QPFV_PRODUCTS`	This view gives information about a 'Buy' Product of a Modifier or Product of a Price list.
`QPFV_PRODUCT_BENEFITS`	This view gives information about the 'Benefit' products of a Other item discount and Promotional Goods.
`QPFV_PRODUCT_EXCLUSIONS`	This view gives information about products excluded from a Modifier.
`QPFV_PROMOTION_HEADERS`	This view gives information about Deal and Promotion type of Modifier headers.
`QPFV_QUALIFIERS`	This view gives information about Qualifiers attached to a Modifier or a Price List.
`QPFV_TERM_SUBSTITUTIONS`	This view gives information about Term Substitutuions type of Modifiers.
`QP_AGR_PRICE_BREAK_LINES_V`	List of price breaks in agreements
`QP_CHARGE_LOOKUP`	Charge Types available for the setup of Freight and Special charges.
`QP_CURRENCY_LISTS_VL`	This view is based on QP_CURRENCY_LISTS_B, QP_CURRENCY_LISTS_TL and QP_CURRENCY_DETAILS tables. The block, Multi-Currency Conversion List, o
`QP_CUSTOMERS_V`	This view is for segment SOLD_TO_ORG_ID in customer context for "Qualifiers Contexts" flexfield
`QP_CUSTOMER_ITEMS_V`	Customer item details. Used in the Pricing Agreements form.
`QP_DEBUG_FORMULA_STEP_VALUES_V`	View that joins QP_DEBUG_FORMULA_STEP_VALUES and QP_PRICE_FORMULAS_B. It contains information about the formula step values which are insert
`QP_DEBUG_REQ_LDETS_V`	View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the line details being priced. It has adjustme
`QP_DEBUG_REQ_LINES_V`	View that joins QP_DEBUG_REQ_LINES and QP_DEBUG_REQ_RLTD_LINES. It contains information about the lines being priced.
`QP_DEBUG_REQ_PRI_LINE_ATTRS_V`	View based on QP_DEBUG_REQ_LINE_ATTRS. It contains information on the Pricingr attributes that the attribute mapping functionality passed t
`QP_DEBUG_REQ_PROD_LINE_ATTRS_V`	View based on QP_DEBUG_REQ_LINE_ATTRS. It contains information on the Productr attributes that the attribute mapping functionality passed t
`QP_DEBUG_REQ_QUAL_LINE_ATTRS_V`	View based on QP_DEBUG_REQ_LINE_ATTRS. It contains information on the Qualifier attributes that the attribute mapping functionality passed
`QP_DEBUG_REQ_RLTD_LINES_V`	View that joins QP_DEBUG_REQ_LDETS and QP_DEBUG_REQ_RLTD_LINES. It contains information about the related lines.
`QP_DEBUG_REQ_V`	View based on QP_DEBUG_REQ. It contains information about the Debug requests.
`QP_ENTITY_PARAMETERS_V`	Obsolete
`QP_FORMULA_STEP_VALUES_TMP`	Based on QP_FORMULA_STEP_VALUES_TMP_T. This view has the information pertaining to the current pricing engine call.
`QP_HDR_LVL_QUAL_V`	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 ty
`QP_HDR_PRICING_ATTRIBS_V`	View based on QP_ATTRIBUTE_DEFNS. Used when defining sourcing rules for header level pricing attributes for a source system.
`QP_HDR_QUALIF_ATTRIBS_V`	View based on QP_ATTRIBUTE_DEFNS. Used when defining sourcing rules for header level qualifier attributes for a source system.
`QP_LDETS_V`	This view is for OM to get the post-pricing adjustment/modifier details.
`QP_LIMITS_V`	Will hold the definition of the limit, and the Promotion, Deal or Modifier for which the limit is set.
`QP_LIMIT_ATTRIBUTES_V`
`QP_LIMIT_BALANCES_V`	Holds the balances for the limit.
`QP_LINES_SUMMARY_V`	This view is used to display the Modifier Lines summary for a given query criteria in the Pricing Organizer.
`QP_LINE_LVL_QUAL_V`	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 ty
`QP_LINE_PRICING_ATTRIBS_V`	View based on QP_ATTRIBUTE_DEFNS. Used when defining sourcing rules for line level pricing attributes for a source system.
`QP_LINE_QUALIF_ATTRIBS_V`	View based on QP_ATTRIBUTE_DEFNS. Used when defining sourcing rules for line level qualifier attributes for a source system.
`QP_LISTS_V`	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
`QP_LIST_ATTRIBUTES_V`	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
`QP_LIST_HEADERS_V`	This view gives details of all standard price lists setup in pricing.
`QP_LIST_HEADERS_VL`	View of QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL. Displays the translated columns on List Headers in the local language.
`QP_LIST_LINES_V`	Price List Lines information - used for List Lines block in Price Lists form.
`QP_LIST_SUMMARY_VL`	This view is used to display the Modifier Header summary for a given query criteria in the Pricing Organizer.
`QP_LOOKUPS`	Oracle Pricing lookup codes
`QP_MODIFIER_SUMMARY_V`	Modifier Summary information for Modifier Lists. Used by the Modifiers form (for summary block).
`QP_PRC_CONTEXTS_V`	This view contains all the details of all the contexts along with thier translated names and description. This table is based on QP_PRC_CONT
`QP_PREQ_LDETS_TMP`	Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.
`QP_PREQ_LINES_TMP`	Based on QP_PREQ_LDETS_TMP_T. This view has the information pertaining to the current pricing engine call.
`QP_PREQ_LINE_ATTRS_FORMULA_TMP`	Based on QP_PREQ_LINE_ATTRS_FORMULA_TMP_T. This view has the information pertaining to the current pricing engine call.
`QP_PREQ_LINE_ATTRS_TMP`	Based on QP_PREQ_LINE_ATTRS_TMP_T. This view has the information pertaining to the current pricing engine call.
`QP_PREQ_QUAL_TMP`	Based on QP_PREQ_QUAL_TMP_T. This view has the information pertaining to the current pricing engine call.
`QP_PREQ_RLTD_LINES_TMP`	Based on QP_PREQ_RLTD_LINES_TMP_T. This view has the information pertaining to the current pricing engine call.
`QP_PRICE_BREAKS_V`	Price or Modifier Break lines information. Used by Price List and Modifiers form.
`QP_PRICE_FACTORS_V`	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
`QP_PRICE_FORMULAS_VL`	View of QP_PRICE_FORMULAS_B and QP_PRICE_FORMULAS_TL. Displays the translated columns on pricing formulas in the local language.
`QP_PRICE_LISTS_V`	Price List information. Provided for backward compatibility for other applications.
`QP_PRICE_LIST_LINES_V`	Price List Line information. Provided for backward compatibility for other applications.
`QP_PRICE_REQ_SOURCES_V`
`QP_PRICING_ATTR_GET_V`	View of Benefit or Get Products for a Modifier. Used by Modifiers Form.
`QP_PRICING_ATTR_V`	View of additonal qualification items for modifiers. Used by Modifiers Form (for Additional buy products block).
`QP_PTE_CONTEXT_TYPES_V`	This view is used by QPXPTMAP.fmb to display the all Pricing transaction entities for all the Context type for which at least one attribute
`QP_PTE_REQUEST_TYPES_V`	This view contains all the Pricing Transaction entities with all the Request types associated with it. It stores all global information abou
`QP_QUALIFIERS_V`	View of Qualifier information
`QP_QUALIFIER_CONTEXT_V`	This view is required to change the valueset definition of QP_QUALIFIER_CONTEXT being used in two reports (QPXPACRL.rdf and QPXPRQFS.rdf) as
`QP_QUALIFIER_RULES_V`	View of Qualifier Rule information
`QP_SECONDARY_PRICE_LISTS_V`	Secondary price lists for each price list. Used for Secondary Price Lists block in Price Lists form.
`QP_SEGMENTS_V`	This view contains all details about all the attributes along with thier translated names. This view is based on QP_SEGMENTS_B and QP_SEGMEN
`QP_SHIP_TO_ORGS_V`	Ship to Organizations.