CST_COST_BOOKS_B

-- ============================================================
-- Table  : CST_COST_BOOKS_B — The cost book master — book codes that attach to cost organizations to give multiple parallel cost representations of the same operations
-- Purpose: Column-selected read of CST_COST_BOOKS_B — auto-generated from field metadata
-- Grain  : One row per COST_BOOK_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_BOOK_ID AS "Surrogate key of the cost book",
  t.COST_BOOK_CODE AS "Unique book code",
  t.PERIODIC_AVERAGE_FLAG AS "The book is a periodic-average book"
FROM <catalog>.<schema>.CST_COST_BOOKS_B t
WHERE
  1 = 1  -- no automatic partition anchor on this table; the filters below are optional
  -- AND t.COST_BOOK_ID = <COST_BOOK_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.COST_BOOK_ID;