Previous Topic: EXIT_STATENext Topic: Joins to Retrieve Exit State Messages


Task

List all the exit states defined for a specific Business System.

SELECT EXS.NAME
  FROM
  MODEL,
  BUSINESS_SYS BSYS,
  EXIT_STATE EXS
  WHERE
  MODEL.NAME = 'my model name'
  AND BSYS.MODEL_ID = MODEL.ID
  AND BSYS.NAME = 'my business system name'
  AND EXS.BUSINESS_SYS_ID = BSYS.ID
ORDER BY EXS.NAME