BOM_RESOURCES

-- ============================================================
-- Table  : BOM_RESOURCES — The resource master — machines, labor, and outside processing, plus overhead and material sub-elements sharing the table (the cost element discriminates), each with its UOM, charge behavior, and absorption account
-- Purpose: Column-selected read of BOM_RESOURCES — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + RESOURCE_ID
-- 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.RESOURCE_ID AS "Surrogate key of the resource",
  t.RESOURCE_CODE AS "The resource code users see — unique per org and cost code type",
  t.ORGANIZATION_ID AS "Inventory organization",
  t.DESCRIPTION AS "Resource description",
  t.RESOURCE_TYPE AS "Machine, person, and other kinds — numeric, undecoded",
  t.UNIT_OF_MEASURE AS "The resource's UOM — currency-unit resources carry a currency code here",
  t.COST_ELEMENT_ID AS "The cost element the resource charges — also what separates real resources from overhead sub-elements in this table",
  t.DEFAULT_BASIS_TYPE AS "Default item-vs-lot basis",
  t.STANDARD_RATE_FLAG AS "Whether charges use the standard rate",
  t.ALLOW_COSTS_FLAG AS "Whether the resource may carry costs",
  t.ABSORPTION_ACCOUNT AS "The absorption account (CCID) charges credit",
  t.RATE_VARIANCE_ACCOUNT AS "The rate variance account (CCID)",
  t.DISABLE_DATE AS "When the resource was disabled — NULL while active"
FROM <catalog>.<schema>.BOM_RESOURCES t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.RESOURCE_ID = <RESOURCE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.RESOURCE_ID;