MTL_PARAMETERS

-- ============================================================
-- Table  : MTL_PARAMETERS — Inventory organization parameters — one row per inventory org, holding the short org code, the master org it points to, and the org's costing method and locator/lot/serial control defaults; the org list every ORGANIZATION_ID resolves against
-- Purpose: Column-selected read of MTL_PARAMETERS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) — see the Fields section for the full key
-- 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.ORGANIZATION_ID AS "The inventory organization's id — one row per org",
  t.ORGANIZATION_CODE AS "The short org code (3 characters) users see everywhere",
  t.MASTER_ORGANIZATION_ID AS "The item-master org this org draws item definitions from — a self-join answers which orgs share a master",
  t.PRIMARY_COST_METHOD AS "The org's costing method (standard, average, FIFO, LIFO)",
  t.DEFAULT_COST_GROUP_ID AS "Default cost group for the org",
  t.NEGATIVE_INV_RECEIPT_CODE AS "Whether the org allows negative on-hand",
  t.STOCK_LOCATOR_CONTROL_CODE AS "Org-level locator control default",
  t.LOT_NUMBER_UNIQUENESS AS "Lot number uniqueness rule for the org",
  t.SERIAL_NUMBER_TYPE AS "Serial number uniqueness rule for the org",
  t.CALENDAR_CODE AS "The workday calendar the org runs on",
  t.WMS_ENABLED_FLAG AS "Whether the org runs Warehouse Management — WMS orgs extend the on-hand grain with LPNs and cost groups"
FROM <catalog>.<schema>.MTL_PARAMETERS t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.ORGANIZATION_ID;