The following table directs you to the PI table explanation that contains SQL for Analysis tasks related to processes.
|
If You Want To |
See |
|---|---|
|
Select an activity and all its dependent activities |
FUNCTION_DEF PROCESS_DEF ACTIV_USAGE_ |
|
Select the functions and processes in a model's activity hierarchy |
FUNCTION_DEF PROCESS_DEF ACTIV_USAGE_ |
|
Select all dependencies between processes |
ADD_DEPENDNCY/ |
|
Select all dependencies from a process to an external object |
ADD_DEPENDNCY/ |
|
Select all elementary processes that create an entity type |
PAD_CREATE VIEW_SET ENTITY_VIEW |
|
Select a process definition and its action block |
PROCESS_DEF/ACTION_BLOCK |
|
Select the derivation algorithms in a model |
DERIVATION_ALGOR |
|
Select the system‑supplied functions in a model |
PAD_FUNCTION |
|
Copyright © 2013 CA.
All rights reserved.
|
|