Additional Queries › Action Blocks › Action Block Where Used › Query for Action Block Where Used

Query for Action Block Where Used

SELECT DISTINCT M.NAME, M.CR_DATE, M.CR_TIME, B.NAME, B.INTEXT, D.NAME
 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.USED_ACTN_BLK_ID
 AND C.ACTN_BLK_ID=D.ID
ORDER BY M.NAME, B.NAME, D.NAME;