CST_COST_ORG_BOOKS

-- ============================================================
-- Table  : CST_COST_ORG_BOOKS — The cost org + book association — the working grain of Fusion costing, carrying the ledger, currency, calendar, and whether accounting is created for the combination
-- Purpose: Column-selected read of CST_COST_ORG_BOOKS — auto-generated from field metadata
-- Grain  : One row per COST_ORG_ID + 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_ORG_ID AS "The cost organization",
  t.COST_BOOK_ID AS "The cost book attached to it",
  t.LEDGER_ID AS "GL ledger for the org-book — NULL means a ledger-less simulation book",
  t.PRIMARY_BOOK_FLAG AS "Y = tied to the primary ledger — the double-count filter",
  t.CURRENCY_CODE AS "Costing currency",
  t.CALENDAR_ID AS "Accounting calendar",
  t.CONVERSION_TYPE AS "Currency conversion rate type",
  t.FROM_DATE AS "Association validity start",
  t.TO_DATE AS "Association validity end",
  t.CREATE_ACCOUNTING_FLAG AS "Whether subledger entries are created for this book",
  t.FIRST_LEDGER_PERIOD_NAME AS "First open costing period",
  t.OPEN_PERIODS_NUM AS "Maximum concurrent open periods"
FROM <catalog>.<schema>.CST_COST_ORG_BOOKS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.COST_ORG_ID = <COST_ORG_ID>
  -- 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_ORG_ID;