Additional Queries › Exit States › Exit State Message Listing › Query for Exit State Message Listing

Query for Exit State Message Listing

SELECT M.NAME, M.CR_DATE,M.CR_TIME, B.NAME, B.TERMINAT_ACTION,
 E.NAME, D.TEXT
 FROM
 MODEL M,
 EXIT_STATE B,
 BUS_SYS_EXIT_STATE C
 BUSINESS_SYS E,
 TEXT D
 WHERE
 M.NAME='my model name'
 AND M.ID=B.MODEL_ID
 AND B.ID=D.ID
 AND C.EXIT_STATE_ID=B.ID
 AND C.BUSINESS_SYS_ID=E.ID
ORDER BY M.NAME, B.NAME;