INV_ITEM_LOCATIONS

-- ============================================================
-- Table  : INV_ITEM_LOCATIONS — The stock locator master — the physical bin/row/rack positions inside a subinventory, with the human-readable locator name, capacity limits, and pick sequencing
-- Purpose: Column-selected read of INV_ITEM_LOCATIONS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + INVENTORY_LOCATION_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.INVENTORY_LOCATION_ID AS "Locator surrogate key — unique only within an organization",
  t.ORGANIZATION_ID AS "Owning inventory org — carry it in every locator join",
  t.SUBINVENTORY_CODE AS "Parent subinventory name",
  t.SUBINVENTORY_ID AS "Parent subinventory surrogate id",
  t.LOCATOR_NAME AS "The concatenated, human-readable locator — use this rather than the SEGMENTn columns",
  t.DESCRIPTION AS "Short locator description",
  t.INVENTORY_LOCATION_TYPE AS "Locator type (dock door, staging, storage…)",
  t.LOCATOR_STATUS AS "Material status id of the locator",
  t.PICKING_ORDER AS "Pick-sequencing rank",
  t.DISABLE_DATE AS "Date the locator stops being usable",
  t.ENABLED_FLAG AS "Whether the locator is active",
  t.START_DATE_ACTIVE AS "Active window start",
  t.END_DATE_ACTIVE AS "Active window end",
  t.INVENTORY_ITEM_ID AS "When populated, the locator is dedicated to this single item",
  t.EMPTY_FLAG AS "Y when nothing is stored in the locator",
  t.MIXED_ITEMS_FLAG AS "Y when more than one item occupies the locator",
  t.LOCATION_MAXIMUM_UNITS AS "Unit capacity of the locator",
  t.LOCATION_CURRENT_UNITS AS "Units currently occupying the locator"
FROM <catalog>.<schema>.INV_ITEM_LOCATIONS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.INVENTORY_LOCATION_ID = <INVENTORY_LOCATION_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.INVENTORY_LOCATION_ID;