INV_ONHAND_QUANTITIES_SUMMARY

-- ============================================================
-- Table  : INV_ONHAND_QUANTITIES_SUMMARY — Pre-aggregated on-hand at the item + location grain, maintained automatically in step with the detail table — the ready-made balance EBS never had
-- Purpose: Column-selected read of INV_ONHAND_QUANTITIES_SUMMARY — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + ONHAND_SUMMARY_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.ONHAND_SUMMARY_ID AS "Surrogate key of the summary row",
  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.QUANTITY AS "Consolidated on-hand in the primary UOM — the ready-made balance",
  t.PRIMARY_UOM_CODE AS "Primary UOM of the balance",
  t.SECONDARY_UOM_QUANTITY AS "Balance converted to the secondary UOM",
  t.SECONDARY_UOM_CODE AS "Secondary UOM",
  t.STOCKING_UOM_QUANTITY AS "Balance converted to the stocking UOM",
  t.STOCKING_UOM_CODE AS "Stocking UOM",
  t.LAST_QUANTITY AS "Prior balance (primary UOM) before the last change",
  t.LOT_CONTROL_CODE AS "Item lot-control setting denormalized onto the row",
  t.SERIAL_NUMBER_CONTROL_CODE AS "Item serial-control setting denormalized onto the row",
  t.REVISION_QTY_CONTROL_CODE AS "Item revision-control setting denormalized onto the row"
FROM <catalog>.<schema>.INV_ONHAND_QUANTITIES_SUMMARY t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.ONHAND_SUMMARY_ID = <ONHAND_SUMMARY_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.ONHAND_SUMMARY_ID;