FUN_ALL_BUSINESS_UNITS_V

-- ============================================================
-- Table  : FUN_ALL_BUSINESS_UNITS_V — The delivered view that enumerates business units — the BU domain later waves' documents stripe on — with the legal entity, primary ledger, and default set each BU resolves to
-- Purpose: Column-selected read of FUN_ALL_BUSINESS_UNITS_V — auto-generated from field metadata
-- Grain  : One row per BU_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.BU_ID AS "The business unit's id — the value later waves' ORG_ID stripes resolve to",
  t.BU_NAME AS "Business unit name (translated)",
  t.STATUS AS "Active/inactive status from the org classification row",
  t.LEGAL_ENTITY_ID AS "Associated legal entity — read from a generic attribute column, arrives as text; cast before numeric joins",
  t.PRIMARY_LEDGER_ID AS "The BU's primary ledger — arrives as text from a generic attribute column; cast before joining GL_LEDGERS",
  t.DEFAULT_SET_ID AS "Default reference data set — arrives as text from a generic attribute column",
  t.DEFAULT_CURRENCY_CODE AS "The BU's default currency",
  t.PROFIT_CENTER_FLAG AS "Profit-center business unit indicator",
  t.BUSINESS_GROUP_ID AS "Enterprise partition the BU belongs to",
  t.LOCATION_ID AS "The BU's location record",
  t.DATE_FROM AS "Effective start of the org slice the view surfaced (today's row only)",
  t.DATE_TO AS "Effective end of the org slice the view surfaced"
FROM <catalog>.<schema>.FUN_ALL_BUSINESS_UNITS_V t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.BU_ID = <BU_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.BU_ID;