Additional Queries › Action Blocks › Action Block Cross-Reference

Action Block Cross-Reference

The Action Block Cross-Reference lists all action blocks in the model that use other action blocks and the names of the action blocks being used.

Query for Action Block Cross-Reference

SELECT DISTINCT M.NAME, M.CR_DATE, M.CR_TIME, B.NAME, D.NAME, D.INTEXT
 FROM
 MODEL M,
 ACTION_BLOCK B,
 ACTN_BLK_USE C,
 ACTION_BLOCK D
 WHERE M.NAME='my model name'
 AND M.ID=B.MODEL_ID
 AND B.ID=C.ACTN_BLK_ID
 AND C.USED_ACTN_BLK_ID=D.ID
ORDER BY B.NAME, D.NAME;