INV_SECONDARY_INVENTORIES

-- ============================================================
-- Table  : INV_SECONDARY_INVENTORIES — The subinventory master — each row a named section of stock within an organization (stores, staging, receiving, rejects) with its asset/expense nature, tracking and reservability controls, and replenishment source
-- Purpose: Column-selected read of INV_SECONDARY_INVENTORIES — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + SECONDARY_INVENTORY_NAME
-- 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.SECONDARY_INVENTORY_NAME AS "The subinventory code — other tables reference it as SUBINVENTORY_CODE",
  t.ORGANIZATION_ID AS "Owning inventory org — the other half of the key",
  t.DESCRIPTION AS "Subinventory description (untranslated copy)",
  t.ASSET_INVENTORY AS "Asset vs expense subinventory — a NUMBER code, not Y/N",
  t.QUANTITY_TRACKED AS "Whether on-hand is tracked here — a NUMBER code",
  t.AVAILABILITY_TYPE AS "Whether stock here nets and is available",
  t.RESERVABLE_TYPE AS "Whether hard reservations are allowed",
  t.INVENTORY_ATP_CODE AS "Include in ATP or not",
  t.LOCATOR_TYPE AS "Locator control level for the subinventory",
  t.PICKING_ORDER AS "Pick-sequencing priority",
  t.DISABLE_DATE AS "When the subinventory stops being usable",
  t.SOURCE_TYPE AS "Replenishment source type (inventory vs supplier)",
  t.SOURCE_ORGANIZATION_ID AS "Replenishment source org",
  t.SOURCE_SUBINVENTORY AS "Replenishment source subinventory",
  t.STATUS_ID AS "Material status id of the subinventory",
  t.SUBINVENTORY_TYPE AS "Storage vs receiving subinventory"
FROM <catalog>.<schema>.INV_SECONDARY_INVENTORIES t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.SECONDARY_INVENTORY_NAME = '<SECONDARY_INVENTORY_NAME>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.SECONDARY_INVENTORY_NAME;