Public Interface Export Function › Design Objects › Screen Design Tool Objects › SCRN_VAR_IO (Screen Variable Input/Output) › Task

Task

List the attribute views that appear on a screen.

SELECT PS.NAME, EV.NAME, ET.NAME, A.NAME
  FROM
  MODEL,
  BUS_PROC_STEP PS,
  SCREEN_DEF SCRN,
  SCRN_VAR_DEF SVD,
  SCRN_VAR_IO SVIO,
  ATTR_VIEW AV,
  ATTRIBUTE A,
  ENTITY_VIEW EV,
  ENTITY_TYPE ET
  WHERE
  MODEL.NAME = 'my model name'
  AND PS.MODEL_ID = MODEL.ID
  AND SCRN.BUS_PROC_STEP_ID = PS.ID
  AND SVD.SCREEN_DEF_ID = SCRN.ID
  AND SVIO.SCRN_VAR_DEF_ID = SVD.ID
  AND SVIO.ATTR_VIEW_ID = AV.ID
  AND AV.ATTRIBUTE_ID = A.ID
  AND AV.ENTITY_VIEW_ID = EV.ID
  AND EV.ENTITY_ID = ET.ID
ORDER BY PS.NAME, ET.NAME, EV.NAME, A.NAME;