BOM_OPERATION_RESOURCES

-- ============================================================
-- Table  : BOM_OPERATION_RESOURCES — Resources required per routing operation — usage rate, assigned units, and the basis and charge types that drive costing, capacity, and scheduling
-- Purpose: Column-selected read of BOM_OPERATION_RESOURCES — auto-generated from field metadata
-- Grain  : One row per OPERATION_SEQUENCE_ID + RESOURCE_SEQ_NUM
-- 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.OPERATION_SEQUENCE_ID AS "The routing operation the resource is assigned to — working key with the resource sequence",
  t.RESOURCE_SEQ_NUM AS "Resource sequence within the operation — working key with the operation",
  t.RESOURCE_ID AS "The resource being used",
  t.ACTIVITY_ID AS "Costing activity",
  t.ASSIGNED_UNITS AS "Units of the resource assigned",
  t.USAGE_RATE_OR_AMOUNT AS "Usage rate or fixed amount per basis",
  t.USAGE_RATE_OR_AMOUNT_INVERSE AS "The inverse form of the usage rate",
  t.BASIS_TYPE AS "Item vs lot basis for the usage",
  t.SCHEDULE_FLAG AS "Whether the resource is scheduled",
  t.AUTOCHARGE_TYPE AS "How the resource charges as work moves — numeric, undecoded",
  t.STANDARD_RATE_FLAG AS "Whether charges use the standard rate",
  t.RESOURCE_OFFSET_PERCENT AS "Lead-time offset of the resource within the routing"
FROM <catalog>.<schema>.BOM_OPERATION_RESOURCES t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.OPERATION_SEQUENCE_ID = <OPERATION_SEQUENCE_ID>
  -- AND t.RESOURCE_SEQ_NUM = <RESOURCE_SEQ_NUM>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.OPERATION_SEQUENCE_ID;