Previous Topic: COMMANDNext Topic: CMD_SYNONYM (Command Synonym)


Task

List all the commands defined for a specific Business System.

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