GL_LEDGERS

-- ============================================================
-- Table  : GL_LEDGERS — One row per ledger, tying together the four Cs — currency, calendar, chart of accounts, and accounting convention; the R12 replacement for the 11i sets-of-books table, and the ledger context every operating unit resolves to
-- Purpose: Column-selected read of GL_LEDGERS — auto-generated from field metadata
-- Grain  : One row per LEDGER_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.LEDGER_ID AS "Surrogate key of the ledger — what operating units and subledgers point at",
  t.NAME AS "Ledger name (unique)",
  t.SHORT_NAME AS "Ledger short name (unique)",
  t.DESCRIPTION AS "Ledger description",
  t.LEDGER_CATEGORY_CODE AS "Primary, secondary, or reporting-currency ledger — filter to primary for most analytics",
  t.CURRENCY_CODE AS "The ledger currency",
  t.CHART_OF_ACCOUNTS_ID AS "The chart of accounts (accounting flexfield structure) the ledger posts against",
  t.PERIOD_SET_NAME AS "The accounting calendar the ledger runs on",
  t.ACCOUNTED_PERIOD_TYPE AS "Which period type within the calendar the ledger accounts in"
FROM <catalog>.<schema>.GL_LEDGERS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.LEDGER_ID = <LEDGER_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.LEDGER_ID;