WIP_ACCOUNTING_CLASSES

-- ============================================================
-- Table  : WIP_ACCOUNTING_CLASSES — The WIP accounting class master per organization — class code, type, and the elemental valuation and variance accounts jobs charge through
-- Purpose: Column-selected read of WIP_ACCOUNTING_CLASSES — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + CLASS_CODE
-- 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.CLASS_CODE AS "The accounting class code — key together with the organization",
  t.ORGANIZATION_ID AS "Inventory organization — part of the key; class codes repeat across orgs",
  t.CLASS_TYPE AS "Class type — standard vs non-standard, asset vs expense; numeric, undecoded",
  t.DESCRIPTION AS "Class description",
  t.DISABLE_DATE AS "When the class was disabled — NULL while active",
  t.MATERIAL_ACCOUNT AS "GL valuation account (CCID) for material",
  t.RESOURCE_ACCOUNT AS "GL valuation account for resource charges",
  t.OVERHEAD_ACCOUNT AS "GL valuation account for overhead",
  t.MATERIAL_VARIANCE_ACCOUNT AS "Material variance account",
  t.RESOURCE_VARIANCE_ACCOUNT AS "Resource variance account"
FROM <catalog>.<schema>.WIP_ACCOUNTING_CLASSES t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.CLASS_CODE = '<CLASS_CODE>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.CLASS_CODE;