MTL_SECONDARY_INVENTORIES

-- ============================================================
-- Table  : MTL_SECONDARY_INVENTORIES — The subinventory master — each row a named section of stock within an organization (stores, staging, WIP, rejects) with its asset/expense nature, tracking and reservability controls, and default accounts
-- Purpose: Column-selected read of MTL_SECONDARY_INVENTORIES — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + SECONDARY_INVENTORY_NAME
-- Notes  : Auto-generated skeleton for Oracle EBS R12 data landed in your lakehouse. 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 (10 characters max) balances and transactions carry",
  t.ORGANIZATION_ID AS "Inventory organization — subinventory names are unique per org, not globally",
  t.DESCRIPTION AS "Subinventory description",
  t.AVAILABILITY_TYPE AS "Whether the subinventory's stock nets into available-to-promise",
  t.RESERVABLE_TYPE AS "Whether stock here can be reserved",
  t.LOCATOR_TYPE AS "Locator control for the subinventory (none, prespecified, dynamic)",
  t.ASSET_INVENTORY AS "Asset vs expense subinventory — expense subinventories don't carry inventory value",
  t.QUANTITY_TRACKED AS "Whether on-hand is tracked here at all",
  t.DISABLE_DATE AS "When the subinventory was disabled — NULL while active",
  t.MATERIAL_ACCOUNT AS "The GL account combination (CCID) material value in this subinventory posts to"
FROM <catalog>.<schema>.MTL_SECONDARY_INVENTORIES t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.SECONDARY_INVENTORY_NAME = '<SECONDARY_INVENTORY_NAME>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.SECONDARY_INVENTORY_NAME;