FND_LOOKUP_VALUES

-- ============================================================
-- Table  : FND_LOOKUP_VALUES — The generic lookup view — every seeded and user-defined code list (lookup type + code) with its meaning and description, one row per code per installed language; the decode target for coded columns across every module
-- Purpose: Column-selected read of FND_LOOKUP_VALUES — auto-generated from field metadata
-- Grain  : One row per LOOKUP_TYPE + LOOKUP_CODE + VIEW_APPLICATION_ID + SET_ID
-- Notes  : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. 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. Documented view — land its base tables for extraction; see the table notes.
-- ============================================================
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.SET_ID AS "Reference data set striping — part of the full key; a Fusion addition EBS didn't have",
  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.SET_ID = <SET_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.LOOKUP_TYPE;