CST_COST_ORGS_V

-- ============================================================
-- Table  : CST_COST_ORGS_V — The delivered view that enumerates cost organizations — the costing scope every CST table's COST_ORG_ID resolves to, with code, effectivity, and owning legal entity
-- Purpose: Column-selected read of CST_COST_ORGS_V — auto-generated from field metadata
-- Grain  : One row per COST_ORG_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. Documented view — land its base tables for extraction; see the table notes.
-- ============================================================
SELECT
  t.COST_ORG_ID AS "The cost organization's id — literally an HR organization id carrying the CST classification",
  t.COST_ORG_NAME AS "Cost organization name",
  t.COST_ORG_CODE AS "Cost organization code",
  t.EFFECTIVE_START_DATE AS "Classification effectivity start",
  t.EFFECTIVE_END_DATE AS "Classification effectivity end",
  t.STATUS AS "Classification status — the view filters to active",
  t.LEGAL_ENTITY_ID AS "Owning legal entity"
FROM <catalog>.<schema>.CST_COST_ORGS_V 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.COST_ORG_ID = <COST_ORG_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.COST_ORG_ID;