MTL_CATEGORIES_B

-- ============================================================
-- Table  : MTL_CATEGORIES_B — The category master — one row per category code combination, with the SEGMENTn flexfield columns the category name concatenates from, keyed by the flexfield structure
-- Purpose: Column-selected read of MTL_CATEGORIES_B — auto-generated from field metadata
-- Grain  : One row per CATEGORY_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_ID AS "Surrogate key of the category",
  t.STRUCTURE_ID AS "The flexfield structure the category's segments belong to",
  t.SEGMENT1 AS "Category flexfield segment 1 — the category name is the configured concatenation",  -- flexfield segment: concatenation is configuration-defined — see quirks guide #flexfields
  t.SEGMENT2 AS "Category flexfield segment 2",  -- flexfield segment: concatenation is configuration-defined — see quirks guide #flexfields
  t.SEGMENT3 AS "Category flexfield segment 3",  -- flexfield segment: concatenation is configuration-defined — see quirks guide #flexfields
  t.DESCRIPTION AS "Category description — untranslated copy; the language-correct text is on the TL companion",
  t.ENABLED_FLAG AS "Whether the category is active",
  t.DISABLE_DATE AS "When the category was disabled — NULL while active",
  t.SUMMARY_FLAG AS "Whether this is a summary (rollup) category"
FROM <catalog>.<schema>.MTL_CATEGORIES_B t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.CATEGORY_ID = <CATEGORY_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.CATEGORY_ID;