Public Interface Export Function › Analysis Objects › Analysis Tasks Related to Processes › PAD_CREATE, VIEW_SET, ENTITY_VIEW › Task

Task

Select all the elementary processes that create an entity type. Order by process name.

SELECT P.NAME, V.NAME, E.NAME
  MODEL M,
  PROCESS_DEF P,
  VIEW_SET S,
  ENTITY_VIEW V,
  ENTITY_TYPE E,
  PAD_CREATE C
  WHERE
  M.NAME = 'my model name'
  AND P.MODEL_ID = M.ID
  AND E.MODEL_ID = M.ID
  AND S.ACTIVITY_ID = P.ID
  AND V.PARENT_ID = S.ID
  AND V.ENTITY_ID = E.ID
  AND C.ENTITY_VIEW_ID = V.ID
ORDER BY P.NAME;