Public Interface Export Function › Analysis Objects › Analysis Tasks Related to Processes › ADD_DEPENDENCY/ADD_ATOM_DEP › Task

Task

Select all dependencies from a process to an external object as defined in the PDD.

SELECT D.ID, FD.NAME, TD.NAME
  FROM
  MODEL M,
  PROCESS_DEF FD,
  ACTIV_USAGE F,
  XTERNL_OBJECT TD,
  XT_OBJ_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 = FD.ID
  AND T.XTERNL_OBJECT_ID = TD.ID
ORDER BY D.ID, FD.NAME, TD.NAME;

Note: The tables ADD_DEPENDNCY and ADD_ATOM_DEP contain the same information as tables PDD_DEPENDNCY and PDD_ATOM_DEP.