DOO_ORDER_CHARGES

-- ============================================================
-- Table  : DOO_ORDER_CHARGES — The price-waterfall charge header — one row per charge (product price, freight, fees) applied to a fulfillment line, classified by charge type, subtype, and price type
-- Purpose: Column-selected read of DOO_ORDER_CHARGES — auto-generated from field metadata
-- Grain  : One row per ORDER_CHARGE_ID
-- Caution: No amounts live here — the money is entirely in the charge components; and ROLLUP_FLAG rows aggregate other charges, so filter them before counting
-- Notes  : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. 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.ORDER_CHARGE_ID AS "Surrogate key of the charge",
  t.PARENT_ENTITY_CODE AS "What the charge is attached to — Line or Line Coverage; the documented parent linkage",
  t.PARENT_ENTITY_ID AS "Id of the parent entity named by PARENT_ENTITY_CODE — polymorphic, so cast/route deliberately",
  t.CHARGE_DEFINITION_CODE AS "Single code combining price type, charge type, and subtype",
  t.CHARGE_TYPE_CODE AS "Charge category — goods sale, service, shipping, restocking…",
  t.CHARGE_SUBTYPE_CODE AS "Finer charge category (freight charge, shipping insurance…)",
  t.PRICE_TYPE_CODE AS "One-time, recurring, or usage pricing",
  t.CHARGE_APPLIES_TO AS "Whether the charge applies to product, shipping, or return",
  t.CHARGE_CURRENCY_CODE AS "Currency of the charge",
  t.PRICED_QUANTITY AS "Quantity the charge was priced against",
  t.PRICED_QUANTITY_UOM_CODE AS "UOM of the priced quantity",
  t.PRIMARY_FLAG AS "Marks the line's primary (product) charge vs freight and fees",
  t.ROLLUP_FLAG AS "Marks a rollup/aggregate charge row — exclude before summing",
  t.SEQUENCE_NUMBER AS "Display/order sequence of the charge"
FROM <catalog>.<schema>.DOO_ORDER_CHARGES t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.ORDER_CHARGE_ID = <ORDER_CHARGE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.ORDER_CHARGE_ID;