Select all the functions and processes in the activity hierarchy. Order in hierarchical sequence.
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
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
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;
|
Copyright © 2013 CA.
All rights reserved.
|
|