Results for “on_invoice_flag”

4 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ASO_PRICE_ADJUSTMENTS is a core Order Capture (ASO) transactional table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the price adjustments applied to quotes and quote lines. Within the ASO schema, it captures the outcome of the pricing engine as it is persisted against a quote header, quote line, and optionally a quote shipment. Each row represents a single adjustment — a discount, surcharge, surcharge override, or rebate-related modifier — that has been evaluated or applied during quote pricing.

The table is owned by the ASO schema and is documented as VALID in ETRM 12.2.2 with 94 columns. Its single-column primary key, ASO_PRICE_ADJUSTMENTS_PK, is enforced on PRICE_ADJUSTMENT_ID, which is also carried by the unique index ASO_PRICE_ADJUSTMENTS_U1. Heuristic Data Vault classification, mined from the foreign-key structure, suggests a satellite-leaning model: the table hangs off several parent hubs (quotes, lines, shipments) and holds descriptive, time-versioned adjustment detail rather than defining new business entities.

Key Information Stored

The surrogate primary key is PRICE_ADJUSTMENT_ID, which uniquely identifies each adjustment and serves as the join key for dependent child tables. The principal business identifiers are the foreign keys QUOTE_HEADER_ID, QUOTE_LINE_ID, and QUOTE_SHIPMENT_ID, which tie an adjustment to its owning quote, line, and shipment respectively.

Pricing definition attributes include MODIFIER_HEADER_ID, MODIFIER_LINE_ID, MODIFIER_LINE_TYPE_CODE, MODIFIER_MECHANISM_TYPE_CODE, MODIFIER_LEVEL_CODE, and PRICING_PHASE_ID (referencing QP_PRICING_PHASES). These establish which modifier produced the adjustment and at what pricing phase it was applied. LIST_HEADER_ID and LIST_LINE_ID (referencing QP_LIST_LINES) identify the price list line underneath the adjustment, supported by LIST_LINE_TYPE_CODE, LIST_LINE_NO, and ORIG_SYS_DISCOUNT_REF.

Calculation and value columns include OPERAND, ARITHMETIC_OPERATOR, OPERAND_PER_PQTY, ADJUSTED_AMOUNT, ADJUSTED_AMOUNT_PER_PQTY, RANGE_BREAK_QUANTITY, PRICE_BREAK_TYPE_CODE, and MODIFIED_FROM / MODIFIED_TO, which bound the adjusted value. Status and control flags govern behavior: APPLIED_FLAG, AUTOMATIC_FLAG, UPDATE_ALLOWABLE_FLAG, UPDATED_FLAG, ON_INVOICE_FLAG, PRINT_ON_INVOICE_FLAG, INVOICED_FLAG, ESTIMATED_FLAG, ACCRUAL_FLAG, REDEEMED_FLAG, INCLUDE_ON_RETURNS_FLAG, and CREDIT_OR_CHARGE_FLAG. Audit and concurrency columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, OBJECT_VERSION_NUMBER, and CHANGE_SEQUENCE follow standard EBS conventions, while SECURITY_GROUP_ID supports multi-org data security and PARENT_ADJUSTMENT_ID links child adjustments to their parent.

Common Use Cases and Queries

Typical reporting scenarios include retrieving all adjustments for a quote, reconciling the net extended price against list price, and tracing which modifier or price list line produced a discount. A representative query joins the adjustment to its quote header and the pricing phase:

  • SELECT a.price_adjustment_id, a.quote_header_id, a.quote_line_id, a.modifier_line_id, a.adjusted_amount, a.applied_flag, p.name phase_name
  • FROM aso.aso_price_adjustments a, qp.qp_pricing_phases p
  • WHERE a.pricing_phase_id = p.pricing_phase_id
  • AND a.quote_header_id = :quote_header_id;

Other common patterns filter on APPLIED_FLAG = 'Y' to report only adjustments that affected the quoted price, aggregate ADJUSTED_AMOUNT by MODIFIER_LINE_ID to measure discount utilization, or isolate ON_INVOICE_FLAG = 'Y' rows for invoicing and accrual reporting. Rebate-focused queries use REBATE_TRANSACTION_TYPE_CODE, REBATE_TRANSACTION_REFERENCE, and REDEEMED_FLAG. Because the table holds volatile pricing detail, queries should join on the unique PRICE_ADJUSTMENT_ID rather than attempting natural-key matching.

Related Objects

The table participates in a well-defined parent-child network. Inbound foreign keys reference the following parents:

Two child tables depend on this table through PRICE_ADJUSTMENT_ID: ASO_PRICE_ADJ_ATTRIBS, which stores descriptive flexfield attribute detail for each adjustment, and ASO_PRICE_ADJ_RELATIONSHIPS, which records relationships between adjustments (for example, parent-child or applied-to groupings). Together these three tables form the adjustment sub-model within Order Capture, with ASO_PRICE_ADJUSTMENTS acting as the central detail entity referenced by both extension tables.