Public Interface Export Function › Design Objects › Screen Design Tool Objects › SCRN_FLD_LIT (Screen Field Literal) › Task

Task

Select all the literals from a template that the screen uses.

SELECT PS.NAME, FL.ROW, FL.COL, FL.TEXT
  FROM
  MODEL,
  BUS_PROC_STEP PS,
  SCREEN_DEF SCRN,
  SCREEN_TMPLT TMPLT,
  TMPLT_USAGE TU,
  SCRN_FLD_LIT FL,
  WHERE
  MODEL.NAME = 'my model name'
  AND PS.MODEL_ID = MODEL.ID
  AND SCRN.BUS_PROC_STEP_ID = PS.ID
  AND SCRN.ID = TU.SCREEN_DEF_ID
  AND TMPLT.ID = TU.SCREEN_TMPLT_ID
  AND FL.SCREEN_DEF_ID = TMPLT.ID;