FND_FLEX_VALUES

-- ============================================================
-- Table  : FND_FLEX_VALUES — The valid values belonging to each flexfield value set — one row per segment value, with enabled/date-effectivity flags and the parent-value linkage dependent and rollup hierarchies use
-- Purpose: Column-selected read of FND_FLEX_VALUES — auto-generated from field metadata
-- Grain  : One row per FLEX_VALUE_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.FLEX_VALUE_ID AS "Surrogate key of the flexfield value",
  t.FLEX_VALUE_SET_ID AS "The value set this value belongs to — joins to FND_FLEX_VALUE_SETS",
  t.FLEX_VALUE AS "The stored segment value itself",
  t.ENABLED_FLAG AS "Whether the value is active",
  t.START_DATE_ACTIVE AS "Effectivity start date",
  t.END_DATE_ACTIVE AS "Effectivity end date",
  t.SUMMARY_FLAG AS "Whether this is a summary (rollup) value rather than a postable detail value",
  t.PARENT_FLEX_VALUE_LOW AS "Parent value for dependent value sets — the independent value this row is valid under",
  t.VALUE_CATEGORY AS "Descriptive-flexfield context category on the value",
  t.STRUCTURED_HIERARCHY_LEVEL AS "Hierarchy level for structured value sets"
FROM <catalog>.<schema>.FND_FLEX_VALUES t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.FLEX_VALUE_ID = <FLEX_VALUE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.FLEX_VALUE_ID;