Public Interface Export Function › Design Objects › Screen Design Tool Objects › TMPLT_USAGE (Screen Template Usage) › Task

Task

List all screens that use templates.

SELECT PS.NAME, TMPLT.NAME
  FROM
  MODEL,
  BUSINESS_SYS BSYS,
  BUSINESS_PROC BP,
  BUS_PROC_STEP PS,
  SCREEN_DEF SCRN,
  SCREEN_TMPLT TMPLT,
  TMPLT_USAGE
  WHERE
  MODEL.NAME = 'my model name'
  AND BSYS.NAME = 'my business system name'
  AND BSYS.MODEL_ID = MODEL.ID
  AND BP.BUSINESS_SYS_ID = BSYS.ID
  AND PS.BUS_PROCEDURE_ID = BP.ID
  AND SCRN.BUS_PROC_STEP_ID = PS.ID
  AND SCRN.ID = TMPLT_USAGE.SCREEN_DEF_ID
  AND TMPLT.ID = TMPLT_USAGE.SCREEN_TMPLT_ID
ORDER BY PS.NAME, TMPLT.NAME;