Previous Topic: ADD_DEPENDENCY/ADD_ATOM_DEPNext Topic: Task


Task

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;