Search Results product_attribute_context

Overview

QPFV_PRODUCT_EXCLUSIONS is a read-only view owned by the APPS schema in Oracle E-Business Suite, defined within the Oracle Advanced Pricing (QP) module. It is documented as VALID in both release 12.1.1 and 12.2.2. The view presents information about products that have been explicitly excluded from an Advanced Pricing modifier, such as a price list, discount, surcharge, or promotion. In the pricing engine, a modifier normally applies to a defined set of products or product hierarchies; the exclusion records surfaced by this view represent the inverse — product entries flagged so that the modifier does not apply to them.

Because the view is marked WITH READ ONLY, it functions strictly as an inquiry and reporting object. It is intended for concurrent programs, custom reports, OAF/Forms-based inquiry pages, and integration extracts that need to identify excluded product assignments without navigating the underlying pricing attribute structures. Its primary role in reporting and integration is to flatten modifier exclusion data into a human-readable form by resolving the pricing attribute context and attribute value into descriptive text through the packaged helper functions described below.

Underlying Base Objects

The view is defined over three documented objects:

QP_PRICING_ATTRIBUTES (SYNONYM) — The driving base object. It stores the pricing attribute rows that qualify or exclude products from modifiers. The view filters this table with the predicate EXCLUDER_FLAG = 'Y', so only exclusion rows are returned.
QP_QP_FORM_PRICING_ATTR (PACKAGE) — Supplies the GET_ATTRIBUTE function, which resolves the internal PRODUCT_ATTRIBUTE code against the attribute definitions in QP_ATTR_DEFNS_PRICING and the supplied PRODUCT_ATTRIBUTE_CONTEXT, returning the descriptive attribute name for display.
QP_PRICE_LIST_LINE_UTIL (PACKAGE) — Supplies GET_PRODUCT_VALUE, which resolves the product attribute value code (PRODUCT_ATTR_VALUE) into a meaningful product or value description using the same attribute definition context. This is the function that turns a stored ID or code into a recognizable product name.

The view performs no joins to other pricing tables; all enrichment is achieved through these two package function calls, making the base relationship a single-table filter with two scalar function projections.

Key Columns

LIST_LINE_ID — Identifier of the pricing list line to which the exclusion applies, linking the row to its parent modifier line.
EXCLUDER_FLAG — Always 'Y' in this view, indicating the row represents an exclusion. This is the filter predicate that defines the view's purpose.
PRODUCT_ATTRIBUTE_CONTEXT — The attribute context under which the product attribute is defined; this is the column referenced in the user's search term and is passed as the second argument to both helper functions.
PRODUCT_ATTRIBUTE — The internal code identifying the product attribute used for the exclusion (e.g., item, item category).
PRODUCT_ATTR_VALUE — The specific value of the attribute being excluded, such as an inventory item or category identifier.
LIST_HEADER_ID — Identifier of the parent list or modifier header.
PRICING_ATTRIBUTE_ID — Unique identifier of the pricing attribute row in the base table.
CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — Standard EBS audit columns.
_DF — Descriptive flexfield context descriptor column, set to '_DF:QP:QP_PRICING_ATTRIBUTES:QP_PRICING_ATTRIBUTES'.

Common Use Cases and Queries

Typical scenarios include auditing which products are excluded from a given price list, reconciling modifier setup during pricing implementations, and extracting exclusion data for downstream systems. A representative query retrieving all exclusions for a specific list header:

SELECT list_line_id, product_attribute_context, product_attribute, product_attr_value FROM qpfv_product_exclusions WHERE list_header_id = :p_list_header_id;
Filtering by context: SELECT * FROM qpfv_product_exclusions WHERE product_attribute_context = 'ITEM';
Auditing recent changes: SELECT * FROM qpfv_product_exclusions WHERE last_update_date > SYSDATE - 30;

Because the descriptive product and attribute names are produced by package functions rather than stored columns, queries should account for the associated function-call overhead when processing large volumes.

View: QPFV_PRODUCT_EXCLUSIONS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PRODUCT_EXCLUSIONS, object_name:QPFV_PRODUCT_EXCLUSIONS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about products excluded from a Modifier. , implementation_dba_data: APPS.QPFV_PRODUCT_EXCLUSIONS ,
View: QPFV_PRODUCT_EXCLUSIONS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PRODUCT_EXCLUSIONS, object_name:QPFV_PRODUCT_EXCLUSIONS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about products excluded from a Modifier. , implementation_dba_data: APPS.QPFV_PRODUCT_EXCLUSIONS ,
View: QPBV_PRODUCT_EXCLUSIONS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PRODUCT_EXCLUSIONS, object_name:QPBV_PRODUCT_EXCLUSIONS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about products excluded from a Modifier. , implementation_dba_data: APPS.QPBV_PRODUCT_EXCLUSIONS ,
View: QPBV_PRODUCT_EXCLUSIONS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PRODUCT_EXCLUSIONS, object_name:QPBV_PRODUCT_EXCLUSIONS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about products excluded from a Modifier. , implementation_dba_data: APPS.QPBV_PRODUCT_EXCLUSIONS ,
View: QPBV_PRODUCTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PRODUCTS, object_name:QPBV_PRODUCTS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about a 'Buy' Product of a Modifier or Product of a Price list. , implementation_dba_data: APPS.QPBV_PRODUCTS ,
View: QPBV_PRODUCTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PRODUCTS, object_name:QPBV_PRODUCTS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about a 'Buy' Product of a Modifier or Product of a Price list. , implementation_dba_data: APPS.QPBV_PRODUCTS ,
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_PRICING_ATTRIBUTES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PRICING_ATTRIBUTES, object_name:QPBV_PRICING_ATTRIBUTES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Pricing Attributes attached to a Modifier or a Price List. , implementation_dba_data: APPS.QPBV_PRICING_ATTRIBUTES ,
View: QPFV_PRODUCTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PRODUCTS, object_name:QPFV_PRODUCTS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about a 'Buy' Product of a Modifier or Product of a Price list. , implementation_dba_data: APPS.QPFV_PRODUCTS ,
View: QPFV_PRODUCTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PRODUCTS, object_name:QPFV_PRODUCTS, status:VALID, product: QP - Advanced Pricing , description: This view gives information about a 'Buy' Product of a Modifier or Product of a Price list. , implementation_dba_data: APPS.QPFV_PRODUCTS ,
View: QPBV_ADDITIONAL_BUY_PRODUCTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_ADDITIONAL_BUY_PRODUCTS, object_name:QPBV_ADDITIONAL_BUY_PRODUCTS, status:VALID, product: QP - Advanced Pricing , description: This view gives the information about the additional BUY product in a discount. For example, Buy 1 Shampoo and 1 Conditioner, Get 20% discount. This view gives information about additional product - 1 conditioner. , implementation_dba_data: APPS.QPBV_ADDITIONAL_BUY_PRODUCTS ,
View: QPBV_ADDITIONAL_BUY_PRODUCTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_ADDITIONAL_BUY_PRODUCTS, object_name:QPBV_ADDITIONAL_BUY_PRODUCTS, status:VALID, product: QP - Advanced Pricing , description: This view gives the information about the additional BUY product in a discount. For example, Buy 1 Shampoo and 1 Conditioner, Get 20% discount. This view gives information about additional product - 1 conditioner. , implementation_dba_data: APPS.QPBV_ADDITIONAL_BUY_PRODUCTS ,
View: QPBV_PRICING_ATTRIBUTES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPBV_PRICING_ATTRIBUTES, object_name:QPBV_PRICING_ATTRIBUTES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Pricing Attributes attached to a Modifier or a Price List. , implementation_dba_data: APPS.QPBV_PRICING_ATTRIBUTES ,
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_PRICING_ATTRIBUTES 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PRICING_ATTRIBUTES, object_name:QPFV_PRICING_ATTRIBUTES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Pricing Attributes attached to a Modifier or a Price List. , implementation_dba_data: APPS.QPFV_PRICING_ATTRIBUTES ,
View: QPFV_PRICING_ATTRIBUTES 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_PRICING_ATTRIBUTES, object_name:QPFV_PRICING_ATTRIBUTES, status:VALID, product: QP - Advanced Pricing , description: This view gives information about Pricing Attributes attached to a Modifier or a Price List. , implementation_dba_data: APPS.QPFV_PRICING_ATTRIBUTES ,
View: QPFV_ADDITIONAL_BUY_PRODUCTS 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_ADDITIONAL_BUY_PRODUCTS, object_name:QPFV_ADDITIONAL_BUY_PRODUCTS, status:VALID, product: QP - Advanced Pricing , description: This view gives the information about the additional BUY product in a discount. For example, Buy 1 Shampoo and 1 Conditioner, Get 20% discount. This view gives information about additional product - 1 conditioner. , implementation_dba_data: APPS.QPFV_ADDITIONAL_BUY_PRODUCTS ,
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 ,
View: QPFV_ADDITIONAL_BUY_PRODUCTS 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:QP.QPFV_ADDITIONAL_BUY_PRODUCTS, object_name:QPFV_ADDITIONAL_BUY_PRODUCTS, status:VALID, product: QP - Advanced Pricing , description: This view gives the information about the additional BUY product in a discount. For example, Buy 1 Shampoo and 1 Conditioner, Get 20% discount. This view gives information about additional product - 1 conditioner. , implementation_dba_data: APPS.QPFV_ADDITIONAL_BUY_PRODUCTS ,
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_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_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: 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 ,
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 ,