INV_ORG_PARAMETERS

-- ============================================================
-- Table  : INV_ORG_PARAMETERS — Inventory organization parameters — one row per inventory org, holding the short org code, the item-master org it points to, its business unit and legal entity, and the org's locator/lot/serial control defaults; the org list every ORGANIZATION_ID resolves against
-- Purpose: Column-selected read of INV_ORG_PARAMETERS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) — see the Fields section for the full key
-- 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.ORGANIZATION_ID AS "The inventory org's key — what every ORGANIZATION_ID column resolves against",
  t.ORGANIZATION_CODE AS "Short org code practitioners know the org by",
  t.MASTER_ORGANIZATION_ID AS "The item-master org this org points to — a self-join answers which orgs share a master",
  t.BUSINESS_UNIT_ID AS "The business unit the org belongs to — joins the business units view on BU_ID",
  t.LEGAL_ENTITY_ID AS "The org's legal entity",
  t.INVENTORY_FLAG AS "Whether the org tracks inventory",
  t.WMS_ENABLED_FLAG AS "Warehouse-management-enabled org",
  t.EAM_ENABLED_FLAG AS "Maintenance (EAM) org",
  t.NEGATIVE_INV_RECEIPT_CODE AS "Whether negative on-hand is allowed",
  t.STOCK_LOCATOR_CONTROL_CODE AS "Locator control level for the org",
  t.LOT_NUMBER_GENERATION AS "Where lot numbers are generated (org vs item level)",
  t.LOT_NUMBER_UNIQUENESS AS "Lot uniqueness scope",
  t.SERIAL_NUMBER_GENERATION AS "Where serial numbers are generated",
  t.SERIAL_NUMBER_TYPE AS "Serial uniqueness control",
  t.SOURCE_ORGANIZATION_ID AS "Default replenishment source org",
  t.SOURCE_SUBINVENTORY AS "Default replenishment source subinventory",
  t.SOURCE_TYPE AS "Inventory vs supplier sourcing for replenishment",
  t.TIMEZONE_ID AS "The org's time zone"
FROM <catalog>.<schema>.INV_ORG_PARAMETERS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.ORGANIZATION_ID;