Public Interface Export Function › Analysis Objects › Analysis Tasks Related to Processes › FUNCTION_DEF, PROCESS_DEF, and ACTIV_USAGE › Task

Task

Select all the functions and processes in the activity hierarchy. Order in hierarchical sequence.

• If parent is function, child is function.

  SELECT P.NAME, C.NAME, U.SEQH
    FROM
    MODEL M,
    FUNCTION_DEF P,
    FUNCTION_DEF C,
    ACTIV_USAGE U
    WHERE
    MODEL.NAME = 'my model name'
    AND P.MODEL_ID = M.ID
    AND C.MODEL_ID = M.ID
    AND U.PARENT_ACTIV_ID = P.ID
    AND U.CHILD_ACTIV_ID = C.ID
  UNION
  

• If parent is function, child is process.

  SELECT P.NAME, C.NAME, U.SEQH
    FROM
    MODEL M,
    FUNCTION_DEF P,
    PROCESS_DEF C,
    ACTIV_USAGE U
    WHERE
    MODEL.NAME = 'my model name'
    AND P.MODEL_ID = M.ID
    AND C.MODEL_ID = M.ID
    AND U.PARENT_ACTIV_ID = P.ID
    AND U.CHILD_ACTIV_ID = C.ID
  UNION
  

• If parent is process, child is process.

  SELECT P.NAME, C.NAME, U.SEQH
    FROM
    MODEL M,
    PROCESS_DEF P,
    PROCESS_DEF C,
    ACTIV_USAGE U
    WHERE
    MODEL.NAME = 'my model name'
    AND P.MODEL_ID = M.ID
    AND C.MODEL_ID = M.ID
    AND U.PARENT_ACTIV_ID = P.ID
    AND U.CHILD_ACTIV_ID = C.ID
  ORDER BY 3;