MTL_CATEGORY_SETS_B

-- ============================================================
-- Table  : MTL_CATEGORY_SETS_B — Category set definitions — validation rules, control level (master-org vs org-level), the multiple-assignments flag, and the default category new items inherit
-- Purpose: Column-selected read of MTL_CATEGORY_SETS_B — auto-generated from field metadata
-- Grain  : One row per CATEGORY_SET_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.CATEGORY_SET_ID AS "Surrogate key of the category set",
  t.STRUCTURE_ID AS "The flexfield structure the set's categories use",
  t.VALIDATE_FLAG AS "Whether assignments are validated against the set's category list",
  t.MULT_ITEM_CAT_ASSIGN_FLAG AS "Whether one item may carry multiple categories in this set — the flag behind category-rollup double counting",
  t.CONTROL_LEVEL AS "Whether assignments are controlled at the master org or per org",
  t.DEFAULT_CATEGORY_ID AS "The category new items inherit in this set",
  t.HIERARCHY_ENABLED AS "Whether the set supports category hierarchies"
FROM <catalog>.<schema>.MTL_CATEGORY_SETS_B t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.CATEGORY_SET_ID = <CATEGORY_SET_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.CATEGORY_SET_ID;