CST_COST_TYPES

-- ============================================================
-- Table  : CST_COST_TYPES — The cost type master — the seeded Frozen, Average, and Pending types plus user-defined types for rollups and simulations, with the fallback pointer rollups use for missing costs
-- Purpose: Column-selected read of CST_COST_TYPES — auto-generated from field metadata
-- Grain  : One row per COST_TYPE_ID
-- Notes  : Auto-generated skeleton for Oracle EBS R12 data landed in your lakehouse. 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_TYPE_ID AS "Surrogate key of the cost type",
  t.COST_TYPE AS "The cost type name — Frozen, Average, Pending, or user-defined",
  t.DESCRIPTION AS "Cost type description",
  t.COSTING_METHOD_TYPE AS "Standard vs average method family — numeric, undecoded",
  t.FROZEN_STANDARD_FLAG AS "Whether this is the frozen standard type",
  t.DEFAULT_COST_TYPE_ID AS "The fallback cost type rollups read missing costs from",
  t.ORGANIZATION_ID AS "Nullable — seeded and shared cost types carry NULL, so don't blanket-filter on it",
  t.ALLOW_UPDATES_FLAG AS "Whether the type's costs may be edited",
  t.COMPONENT_YIELD_FLAG AS "Whether rollups apply component yield",
  t.DISABLE_DATE AS "When the type was disabled — NULL while active"
FROM <catalog>.<schema>.CST_COST_TYPES t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.COST_TYPE_ID = <COST_TYPE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.COST_TYPE_ID;