Search Results modifier_header_id

Overview

The APPS.ASO_PRICE_ADJUSTMENTS_V view is a reporting and integration object within the ASO - Order Capture module of Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes pricing adjustment data captured against quotes and quote lines during the order capture and pricing cycle, including modifier references, arithmetic operators, operands, and tax-related attributes. The view is documented as VALID in the APPS schema and is defined over the ASO_PRICE_ADJUSTMENTS table, which serves as the principal store of pricing adjustment records generated when pricing engine modifiers are applied to a quote or order.

Functionally, the view provides a stable, query-friendly interface to the underlying adjustment records. Because it is a view rather than a table, it does not store data independently; all rows are sourced from the referenced base objects at execution time. This makes it suitable for ad hoc reporting, integration extracts, and analytical queries that need to reconcile applied discounts, surcharges, and rebates against quote headers and lines.

Underlying Base Objects

The documented base objects referenced by ASO_PRICE_ADJUSTMENTS_V are ASO_PRICE_ADJUSTMENTS (SYNONYM), QP_LIST_HEADERS_B (SYNONYM), and QP_LIST_HEADERS_TL (SYNONYM). The primary projection is a straight column-by-column select from ASO_PRICE_ADJUSTMENTS, as evidenced by the view text, which references every exposed column through the PRICE_ADJ alias along with the ROWID pseudocolumn. The inclusion of QP_LIST_HEADERS_B and QP_LIST_HEADERS_TL indicates that the view resolves modifier or price list header definitions from the Oracle Advanced Pricing schema, allowing consumers to associate an adjustment with its parent list header and its translated name.

In ETRM terms, the view is therefore a composite: it carries the transactional adjustment facts from ASO and enriches them with descriptive header context from the QP pricing list tables. This relationship is important because the ASO table alone does not always carry the human-readable list name, which is maintained in QP_LIST_HEADERS_TL and keyed by language.

Key Columns

The view exposes the full column set of ASO_PRICE_ADJUSTMENTS. Among the most significant are:

• PRICE_ADJUSTMENT_ID — the primary identifier for each adjustment record.
• QUOTE_HEADER_ID and QUOTE_LINE_ID — the quote-level foreign keys that situate the adjustment within an order capture transaction.
• MODIFIER_HEADER_ID and MODIFIER_LINE_ID — references to the pricing modifier and modifier line that produced the adjustment.
• MODIFIER_MECHANISM_TYPE_CODE and MODIFIER_LINE_TYPE_CODE — classify the mechanism (for example, discount, surcharge, or rebate) and the line type applied.
• OPERAND and ARITHMETIC_OPERATOR — define the value and operation used to compute the adjustment.
• ADJUSTED_AMOUNT — the resulting monetary amount of the adjustment.
• APPLIED_FLAG, UPDATED_FLAG, UPDATE_ALLOWABLE_FLAG, AUTOMATIC_FLAG, ON_INVOICE_FLAG, INVOICED_FLAG, and ESTIMATED_FLAG — status and behavior flags that govern how the adjustment is treated through the pricing and billing lifecycle.
• LIST_HEADER_ID and LIST_LINE_ID — identifiers that link the adjustment to its originating price list.
• CHARGE_TYPE_CODE, CHARGE_SUBTYPE_CODE, TAX_CODE, and TAX_EXEMPT_FLAG — charge and tax classification attributes, relevant to rebate and invoicing scenarios.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield columns.

Because users frequently search for rebate payment terms such as "rebate_payment_system_code", it is worth noting that such values are typically held in the descriptive flexfield segments or in related QP pricing constructs rather than as a dedicated column in this view. Practitioners should inspect the ATTRIBUTEn segments and the modifier configuration in Advanced Pricing when tracing rebate payment logic.

Common Use Cases and Queries

Typical uses include reconciliation of quote-level discounts, analysis of applied versus unapplied adjustments, and extraction of adjustment detail for downstream order or billing interfaces. A representative query joining to translated header names is shown below.

A sample retrieval of adjustments for a given quote:

• SELECT v.price_adjustment_id, v.quote_header_id, v.quote_line_id, v.modifier_mechanism_type_code, v.arithmetic_operator, v.operand, v.adjusted_amount, v.applied_flag FROM appls.aso_price_adjustments_v v WHERE v.quote_header_id = :p_quote_header_id;

A sample enrichment with the price list header name:

• SELECT v.price_adjustment_id, v.list_header_id, h.name AS list_name FROM apps.aso_price_adjustments_v v, apps.qp_list_headers_b h WHERE v.list_header_id = h.list_header_id AND v.quote_header_id = :p_quote_header_id;

These queries illustrate the view's role as a convenient access layer over ASO pricing adjustment data, while the underlying QP headers supply the descriptive context required for reporting and integration.