CST_TRANSACTIONS

-- ============================================================
-- Table  : CST_TRANSACTIONS — The costed-transaction spine — inventory transactions after import into costing, exploded per cost org-book and stamped with cost status; what distributions and cost rows hang off
-- Purpose: Column-selected read of CST_TRANSACTIONS — auto-generated from field metadata
-- Grain  : One row per TRANSACTION_ID
-- Caution: Every source transaction appears once per cost org-book combination — filter to the primary book before summing quantities
-- 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_ID AS "Surrogate key of the costing transaction",
  t.COST_ORG_ID AS "Cost organization",
  t.COST_BOOK_ID AS "Cost book — the explode-per-book grain",
  t.INVENTORY_ITEM_ID AS "The item",
  t.INVENTORY_ORG_ID AS "Inventory org of the source transaction",
  t.COST_TRANSACTION_TYPE AS "Issue or receipt",
  t.TRANSACTION_DATE AS "Source transaction date",
  t.COST_DATE AS "Date costing processed it",
  t.TRANSACTION_QTY AS "Transacted quantity",
  t.TRANSACTION_UOM_CODE AS "UOM of the quantity",
  t.COSTED_QTY AS "Quantity costed so far",
  t.COST_STATUS AS "New, pending, costed, or error",
  t.CST_INV_TRANSACTION_ID AS "Costing's own copy of the inventory transaction — the documented chain stops there"
FROM <catalog>.<schema>.CST_TRANSACTIONS t
WHERE
  1 = 1  -- no automatic partition anchor on this table; the filters below are optional
  -- AND t.TRANSACTION_ID = <TRANSACTION_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.TRANSACTION_ID;