CST_COST_ELEMENTS_B

-- ============================================================
-- Table  : CST_COST_ELEMENTS_B — The cost element master — the buckets (material, overhead, and so on) item cost decomposes into, striped by reference data set
-- Purpose: Column-selected read of CST_COST_ELEMENTS_B — auto-generated from field metadata
-- Grain  : One row per COST_ELEMENT_ID + SET_ID
-- 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.COST_ELEMENT_ID AS "Surrogate key of the cost element",
  t.SET_ID AS "Reference data set — elements are set-striped, not org-striped; part of the documented unique key (SET_ID + COST_ELEMENT_CODE)",
  t.COST_ELEMENT_CODE AS "Element code",
  t.COST_ELEMENT_TYPE AS "Element type — material, overhead, and so on",
  t.INV_ORG_ID AS "Inventory org identifier — nullable, not a partition",
  tl.COST_ELEMENT_DESC AS "Element description"
FROM <catalog>.<schema>.CST_COST_ELEMENTS_B t
LEFT JOIN <catalog>.<schema>.CST_COST_ELEMENTS_TL tl
  ON tl.COST_ELEMENT_ID = t.COST_ELEMENT_ID
 AND tl.LANGUAGE = '<language>'  -- one language or rows multiply
WHERE
  t.SET_ID = <SET_ID>  -- reference data set — the stripe that replaced the org stripe; one set or codes double-load; see quirks guide #set-id
  -- AND t.COST_ELEMENT_ID = <COST_ELEMENT_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.COST_ELEMENT_ID;