DOO_ORDER_CHARGE_COMPONENTS

-- ============================================================
-- Table  : DOO_ORDER_CHARGE_COMPONENTS — The price-waterfall detail — one row per price element (list price, discounts, net price, margin) under each charge, carrying the actual amounts in both charge and header currency
-- Purpose: Column-selected read of DOO_ORDER_CHARGE_COMPONENTS — auto-generated from field metadata
-- Grain  : One row per ORDER_CHARGE_COMPONENT_ID
-- Caution: Filter PRICE_ELEMENT_CODE (e.g. net price) rather than summing everything, and exclude ROLLUP_FLAG rows — the waterfall double-counts otherwise
-- 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_COMPONENT_ID AS "Surrogate key of the waterfall component",
  t.ORDER_CHARGE_ID AS "Parent charge",
  t.SEQUENCE_NUMBER AS "Waterfall sequence",
  t.PRICE_ELEMENT_CODE AS "Waterfall element — list price, net price, margin…; filter this rather than summing everything",
  t.PRICE_ELEMENT_USAGE_CODE AS "How the component is used (list price, invoice price…)",
  t.CHARGE_CURRENCY_CODE AS "Currency of the charge-side amounts",
  t.CHARGE_CURRENCY_UNIT_PRICE AS "Per-unit price or adjustment in charge currency",
  t.CHARGE_CURRENCY_EXT_AMOUNT AS "Extended amount in charge currency — note the abbreviated EXT_AMOUNT spelling",
  t.HEADER_CURRENCY_CODE AS "Currency of the order header",
  t.HEADER_CURRENCY_UNIT_PRICE AS "Per-unit price or adjustment in header currency",
  t.HEADER_CURRENCY_EXT_AMOUNT AS "Extended amount in header currency — every amount exists on both currency sides",
  t.PERCENT_OF_COMPARISON_ELEMENT AS "This price as a percent of a basis element (default list price) — margin math",
  t.ROLLUP_FLAG AS "Marks a rollup/aggregate component — exclude before summing",
  t.TAX_INCLUDED_FLAG AS "Whether tax is embedded in the price",
  t.PARENT_CHARGE_COMPONENT_ID AS "Contributing component under a rollup charge"
FROM <catalog>.<schema>.DOO_ORDER_CHARGE_COMPONENTS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.ORDER_CHARGE_COMPONENT_ID = <ORDER_CHARGE_COMPONENT_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.ORDER_CHARGE_COMPONENT_ID;