CST_COST_DISTRIBUTIONS

-- ============================================================
-- Table  : CST_COST_DISTRIBUTIONS — Cost distribution headers — one per costed transaction event, carrying the cost org/book, item, event class, GL date, and accounting state ahead of subledger accounting
-- Purpose: Column-selected read of CST_COST_DISTRIBUTIONS — auto-generated from field metadata
-- Grain  : One row per DISTRIBUTION_ID
-- Caution: Distributions explode once per cost org-book — filter to the primary book (via the org-book association) or amounts double-count
-- 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.DISTRIBUTION_ID AS "Surrogate key of the distribution header",
  t.COST_ORGANIZATION_ID AS "The cost org — spelled COST_ORGANIZATION_ID here, COST_ORG_ID everywhere else",
  t.COST_BOOK_ID AS "Cost book — filter to the primary book or amounts double-count",
  t.INVENTORY_ITEM_ID AS "Item on the transaction",
  t.TRANSACTION_ID AS "The costing transaction distributed",
  t.EVENT_CLASS_CODE AS "Subledger accounting event class",
  t.EVENT_TYPE_CODE AS "Subledger accounting event type",
  t.COST_TRANSACTION_TYPE AS "Issue, receipt, or adjustment",
  t.GL_DATE AS "Accounting date",
  t.BASE_CURRENCY_CODE AS "Legal entity base currency",
  t.LEGAL_ENTITY_ID AS "Legal entity of the cost org",
  t.LEDGER_ID AS "Ledger of the org-book",
  t.PERIOD_NAME AS "Costed period (periodic average books)",
  t.ACCOUNTED_FLAG AS "N, draft, or final accounting state"
FROM <catalog>.<schema>.CST_COST_DISTRIBUTIONS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.DISTRIBUTION_ID = <DISTRIBUTION_ID>
  -- AND t.GL_DATE >= DATE '<DATE_FROM>'
  -- AND t.GL_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.DISTRIBUTION_ID;