Results for “qpfv_pricing_attributes”
16 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
QPFV_PRICING_ATTRIBUTES is a read-only view owned by the APPS schema in Oracle E-Business Suite Advanced Pricing (QP). It exposes the pricing attributes that are attached to either a modifier (a price adjustment) or a price list line, providing a flattened, user-readable presentation of the underlying qualification and pricing rules. Because Advanced Pricing stores attributes in a normalized form using context, attribute, and value triplets, the raw base table is not directly interpretable. This view resolves those coded values into descriptive names by invoking Advanced Pricing PL/SQL APIs, making it suitable for reporting, data extraction, and integration scenarios.
In EBS 12.1.1 and 12.2.2 the view is delivered with the Advanced Pricing product and carries a status of VALID. The definition includes the WITH READ ONLY clause, so it cannot be used for DML. Its runtime cost is higher than a plain table query because several columns are populated through function calls executed per row, which has implications for high-volume extracts.
Underlying Base Objects
The view is defined over four documented base objects in the APPS schema:
- QP_PRICING_ATTRIBUTES (SYNONYM) — the primary driving table, aliased
PA, holding the stored attribute rows attached to price list lines and modifiers. - MTL_UNITS_OF_MEASURE (SYNONYM) — joined with an outer join (
PA.PRODUCT_UOM_CODE = MTL.UOM_CODE (+)) to resolve the product unit of measure description intoUOM_NAME. - QP_QP_FORM_PRICING_ATTR (PACKAGE) — supplies
GET_ATTRIBUTEandGET_ATTRIBUTE_VALUE, which translate context/attribute identifiers into display names and formatted values. - QP_PRICE_LIST_LINE_UTIL (PACKAGE) — supplies
GET_PRODUCT_VALUE, used to derive thePRODUCT_ATTR_VALUEcolumn.
The filter conditions restrict output to rows where PRICING_ATTRIBUTE_CONTEXT IS NOT NULL and EXCLUDER_FLAG = 'N', so only inclusion-type attribute rows are returned. The literal 'QP_ATTR_DEFNS_PRICING' passed to the API calls identifies the pricing attribute definition set, which is why a search for qp_attr_defns_pricing leads to this view.
Key Columns
The view exposes approximately twenty columns. The principal ones include:
- LIST_HEADER_ID and LIST_LINE_ID — identify the price list header and line to which the attribute belongs.
- PRODUCT_ATTRIBUTE_CONTEXT and PRODUCT_ATTRIBUTE — the product-side qualification context and attribute, with PRODUCT_ATTR_VALUE holding the resolved value and PRODUCT_UOM_CODE/UOM_NAME giving the unit of measure.
- PRICING_ATTRIBUTE_CONTEXT and PRICING_ATTRIBUTE — the pricing-side context and attribute, with PRICING_ATTR_VALUE_FROM and PRICING_ATTR_VALUE_TO expressing the qualifying range.
- COMPARISON_OPERATOR_CODE and its descriptive equivalent — the operator applied to the pricing attribute range.
- QUALIFICATION_IND — distinguishes qualification versus pricing attribute usage.
- PRICING_PHASE_ID — links the record to the pricing phase (for example, list price or adjustment).
- EXCLUDER_FLAG — inclusion or exclusion indicator; rows with 'Y' are filtered out.
- Standard audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and the surrogate PRICING_ATTRIBUTE_ID.
Common Use Cases and Queries
Typical uses include validating price list setup before cutover, auditing modifier qualification rules, and feeding downstream pricing extracts or BI reports. A basic inquiry by price list is shown below; note that all identifiers are numeric and the view is read-only.
- Attributes for a price list:
SELECT list_line_id, product_attribute_context, product_attribute, product_attr_value, pricing_attribute_context, pricing_attribute, pricing_attr_value_from, pricing_attr_value_to FROM apps.qpfv_pricing_attributes WHERE list_header_id = :p_list_header_id; - Attributes for a specific pricing attribute:
SELECT list_line_id, pricing_phase_id, pricing_attr_value_from, pricing_attr_value_to FROM apps.qpfv_pricing_attributes WHERE pricing_attribute = :p_attr AND qualification_ind = 'Y';
Because API calls execute per row, large extracts should be filtered to the narrowest possible set of price lists or phases to control response time.
-
This view gives information about Pricing Attributes attached to a Modifier or a Price List.
APPS.QPFV_PRICING_ATTRIBUTES·↳ MTL_UNITS_OF_MEASURE·↳ QP_PRICE_LIST_LINE_UTIL·↳ QP_PRICING_ATTRIBUTES·Explore QP module →
-
This view gives information about Pricing Attributes attached to a Modifier or a Price List.
APPS.QPFV_PRICING_ATTRIBUTES·↳ MTL_UNITS_OF_MEASURE·↳ QP_PRICE_LIST_LINE_UTIL·↳ QP_PRICING_ATTRIBUTES·Explore QP module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2
-
eTRM - QP Tables and Views 12.2.2
This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade.
-
eTRM - QP Tables and Views 12.1.1
This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - QP Tables and Views 12.1.1
This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade.
-
eTRM - QP Tables and Views 12.2.2
This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade.