INV_ONHAND_QUANTITIES_DETAIL

-- ============================================================
-- Table  : INV_ONHAND_QUANTITIES_DETAIL — The on-hand balance detail — receipt-level slices of stock per item, org, subinventory, locator, and lot, consumed in FIFO order as material issues
-- Purpose: Column-selected read of INV_ONHAND_QUANTITIES_DETAIL — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + ONHAND_QUANTITIES_ID
-- Caution: Rows are FIFO receipt slices — SUM PRIMARY_TRANSACTION_QUANTITY at your chosen grain; a single row is not a balance
-- 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.ONHAND_QUANTITIES_ID AS "Surrogate key of the on-hand slice",
  t.INVENTORY_ITEM_ID AS "Item on hand",
  t.ORGANIZATION_ID AS "Inventory org holding the stock",
  t.SUBINVENTORY_CODE AS "Subinventory holding the stock",
  t.LOCATOR_ID AS "Locator holding the stock",
  t.LOT_NUMBER AS "Lot, when lot-controlled",
  t.PRIMARY_TRANSACTION_QUANTITY AS "Slice quantity in the item's primary UOM — SUM this for on-hand",
  t.TRANSACTION_QUANTITY AS "Slice quantity in the entered UOM",
  t.TRANSACTION_UOM_CODE AS "UOM of the creating transaction — note the _CODE suffix the transaction ledger's TRANSACTION_UOM lacks",
  t.SECONDARY_TRANSACTION_QUANTITY AS "Slice quantity in the secondary UOM (dual-UOM items)",
  t.SECONDARY_UOM_CODE AS "Secondary UOM",
  t.DATE_RECEIVED AS "Receipt date of the slice — orders the FIFO consumption",
  t.PROJECT_ID AS "Project stripe on the slice",
  t.TASK_ID AS "Task stripe on the slice",
  t.COUNTRY_OF_ORIGIN_CODE AS "Country-of-origin stripe on the slice"
FROM <catalog>.<schema>.INV_ONHAND_QUANTITIES_DETAIL t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.ONHAND_QUANTITIES_ID = <ONHAND_QUANTITIES_ID>
  -- AND t.DATE_RECEIVED >= DATE '<DATE_FROM>'
  -- AND t.DATE_RECEIVED <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.ONHAND_QUANTITIES_ID;