FND_LOOKUP_VALUES

-- ============================================================
-- Table  : FND_LOOKUP_VALUES — The generic lookup table — every seeded and user-defined code list (lookup type + code) with its meaning and description, one row per code per language; the decode target for coded columns across every module (EBS's analog of JDE's UDC table)
-- Purpose: Column-selected read of FND_LOOKUP_VALUES — auto-generated from field metadata
-- Grain  : One row per LOOKUP_TYPE + LOOKUP_CODE + VIEW_APPLICATION_ID + SECURITY_GROUP_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.LOOKUP_TYPE AS "Lookup type — the name of the code list this row belongs to",
  t.LOOKUP_CODE AS "Lookup code — the stored value coded columns carry",
  t.LANGUAGE AS "Language of this row's meaning and description — filter to one or decode joins multiply",
  t.VIEW_APPLICATION_ID AS "Application scope of the lookup type — part of the full key",
  t.SECURITY_GROUP_ID AS "Security group — part of the full key; 0 in most installs",
  t.MEANING AS "The short display label the code decodes to",
  t.DESCRIPTION AS "Longer description of the code",
  t.SOURCE_LANG AS "The language this row's text was translated from",
  t.ENABLED_FLAG AS "Whether the code is active",
  t.START_DATE_ACTIVE AS "Effectivity start date",
  t.END_DATE_ACTIVE AS "Effectivity end date",
  t.TAG AS "Free-form grouping tag some lookup types use to sub-classify codes"
FROM <catalog>.<schema>.FND_LOOKUP_VALUES t
WHERE
  t.LANGUAGE = '<language>'  -- one language or rows multiply; translations fall back to SOURCE_LANG
  -- AND t.LOOKUP_TYPE = '<LOOKUP_TYPE>'
  -- AND t.LOOKUP_CODE = '<LOOKUP_CODE>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.LOOKUP_TYPE;