EGP_SYSTEM_ITEMS_TL

-- ============================================================
-- Table  : EGP_SYSTEM_ITEMS_TL — The item master's translation companion — item description and long description in every installed language, one row per item per organization per language; the only place the item description exists
-- Purpose: Column-selected read of EGP_SYSTEM_ITEMS_TL — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + INVENTORY_ITEM_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.
-- ============================================================
SELECT
  t.INVENTORY_ITEM_ID AS "Item this translation row belongs to",
  t.ORGANIZATION_ID AS "Organization of the item row",
  t.LANGUAGE AS "Language of this row — filter to one or item joins multiply",
  t.SOURCE_LANG AS "The language this row's text was authored in",
  t.DESCRIPTION AS "Item short description — the only place it exists",
  t.LONG_DESCRIPTION AS "Item extended description"
FROM <catalog>.<schema>.EGP_SYSTEM_ITEMS_TL t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  AND t.LANGUAGE = '<language>'  -- one language or rows multiply; translations fall back to SOURCE_LANG
  -- AND t.INVENTORY_ITEM_ID = <INVENTORY_ITEM_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.INVENTORY_ITEM_ID;