CST_TRANSACTION_COSTS

-- ============================================================
-- Table  : CST_TRANSACTION_COSTS — The actual cost attached to each costing transaction — one row per transaction, cost element, and expense pool per effective date; a complete cost history including every adjustment
-- Purpose: Column-selected read of CST_TRANSACTION_COSTS — auto-generated from field metadata
-- Grain  : One row per TRANSACTION_COST_ID
-- Caution: Adjustments rewrite the FULL cost as fresh rows — take the latest EFF_DATE per transaction + element + pool or costs overstate
-- 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.TRANSACTION_COST_ID AS "Surrogate key of the cost row",
  t.TRANSACTION_ID AS "The costing transaction — join up for the item; there is no item column here",
  t.COST_ELEMENT_ID AS "Cost element of this slice",
  t.EXPENSE_POOL_ID AS "Expense pool of the slice",
  t.COST_ORG_ID AS "Cost organization",
  t.COST_BOOK_ID AS "Cost book",
  t.UNIT_COST AS "Unit cost for this element in the costing currency",
  t.CURRENCY_CODE AS "Costing currency",
  t.EFF_DATE AS "When this cost became effective — take the latest per transaction + element + pool",
  t.COST_DATE AS "Cost date",
  t.COST_SOURCE AS "Where the cost came from (PO, AP…)",
  t.COSTED_QTY AS "Quantity costed",
  t.POSTED_FLAG AS "Whether the cost propagated to the layer/average tables",
  t.VALID_COST_FLAG AS "Usable for inventory valuation"
FROM <catalog>.<schema>.CST_TRANSACTION_COSTS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.TRANSACTION_COST_ID = <TRANSACTION_COST_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.TRANSACTION_COST_ID;