CST_STD_COSTS

-- ============================================================
-- Table  : CST_STD_COSTS — Standard cost records — the date-effective standard unit cost per cost org, cost book, and item (optionally per valuation unit), with publish status
-- Purpose: Column-selected read of CST_STD_COSTS — auto-generated from field metadata
-- Grain  : One row per STD_COST_ID
-- Caution: Date-effective: the current standard is the row whose EFFECTIVE_END_DATE is open — filter the window or costs multiply across revisions
-- 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.STD_COST_ID AS "Surrogate key of the standard cost record",
  t.COST_ORG_ID AS "Cost organization of the standard",
  t.COST_BOOK_ID AS "Cost book of the standard",
  t.INVENTORY_ITEM_ID AS "The item",
  t.INVENTORY_ORG_ID AS "The item's MASTER org — not the plant, not the cost org",
  t.ORGANIZATION_ID AS "The manufacturing plant — populated only for rolled-up costs",
  t.VAL_UNIT_ID AS "Valuation unit of the standard",
  t.TOTAL_COST AS "Total standard unit cost over the effective window",
  t.CURRENCY_CODE AS "Currency of the standard",
  t.UOM_CODE AS "Costing UOM",
  t.EFFECTIVE_START_DATE AS "Date-effective start of the standard",
  t.EFFECTIVE_END_DATE AS "Date-effective end — open means current",
  t.STATUS_CODE AS "Publish/processing status of the standard",
  t.COST_TYPE AS "STANDARD or BUY"
FROM <catalog>.<schema>.CST_STD_COSTS t
WHERE
  CURRENT_DATE BETWEEN t.EFFECTIVE_START_DATE AND t.EFFECTIVE_END_DATE  -- current row of a date-effective table — see quirks guide #date-effective
  -- AND t.STD_COST_ID = <STD_COST_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.STD_COST_ID;