OE_PRICE_ADJUSTMENTS

-- ============================================================
-- Table  : OE_PRICE_ADJUSTMENTS — Pricing modifier applications — discounts, surcharges, and freight/special charges applied to an order or a line, with the modifier list that produced them and the monetary effect; the gap between list and selling price
-- Purpose: Column-selected read of OE_PRICE_ADJUSTMENTS — auto-generated from field metadata
-- Grain  : One row per PRICE_ADJUSTMENT_ID
-- Caution: Mixed grain: header-level rows carry LINE_ID NULL, and applied, unapplied, and accrual-only rows share the table — filter APPLIED_FLAG (and ACCRUAL_FLAG) before summing
-- Notes  : Auto-generated skeleton for Oracle EBS R12 data landed in your lakehouse. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts.
-- ============================================================
SELECT
  t.PRICE_ADJUSTMENT_ID AS "Surrogate key of the adjustment",
  t.HEADER_ID AS "The order the adjustment belongs to",
  t.LINE_ID AS "The adjusted line — NULL for header-level adjustments (mixed grain)",
  t.LIST_HEADER_ID AS "The pricing modifier list that produced the adjustment",
  t.LIST_LINE_ID AS "The modifier list line",
  t.LIST_LINE_TYPE_CODE AS "Modifier kind — discount, surcharge, freight charge…",
  t.MODIFIER_LEVEL_CODE AS "Level the modifier applied at — line, order, or line group",
  t.CHARGE_TYPE_CODE AS "Freight/special-charge classification, for charge rows",
  t.ARITHMETIC_OPERATOR AS "How the operand applies — percent, amount, or new price",
  t.OPERAND AS "The percent or amount value applied",
  t.ADJUSTED_AMOUNT AS "The monetary effect of the adjustment — the margin-analysis column",
  t.AUTOMATIC_FLAG AS "Auto-applied vs manually entered",
  t.APPLIED_FLAG AS "Whether the adjustment actually hit the price — filter before summing",
  t.ACCRUAL_FLAG AS "Accrual-only modifier — recorded but not price-affecting"
FROM <catalog>.<schema>.OE_PRICE_ADJUSTMENTS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.PRICE_ADJUSTMENT_ID = <PRICE_ADJUSTMENT_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.PRICE_ADJUSTMENT_ID;