Select all dependencies between processes as defined in the ADD.
SELECT D.ID, FD.NAME, TD.NAME FROM MODEL M, PROCESS_DEF FD, ACTIV_USAGE F, PROCESS_DEF TD, ACTIV_USAGE T, ADD_DEPENDNCY D, ADD_ATOM_DEP A WHERE MODEL.NAME = 'my model name' AND F.MODEL_ID = M.ID AND T.MODEL_ID = M.ID AND D.MODEL_ID = M.ID AND A.ADD_DEPENDNCY_ID = D.ID AND A.EXPORT_USAGE_ID = F.ID AND A.IMPORT_USAGE_ID = T.ID AND F.CHILD_ACTIV_ID = F.ID AND T.CHILD_ACTIV_ID = TD.ID ORDER BY D.ID, FD.NAME, TD.NAME;
|
Copyright © 2013 CA.
All rights reserved.
|
|