This content has been marked as final. Show 4 replies
My two favorite SQL's are documented here http://jjmpsj.blogspot.com/2012/10/query-for-component-andor-cref.html and here http://jjmpsj.blogspot.com/2007/12/query-for-component-andor-cref.html. These are just for CREF information (menu, market, component or CREF ID). Process scheduler information could be included since the run control component is part of the meta-data used to configure a process definition.
Try this one..
select distinct prcstype, ltrim (sys_connect_by_path (portal_label, ' > '), ' > ') path from (select * from (select * from psprsmdefn, ps_prcsdefnpnl where portal_name = 'EMPLOYEE' and prcsname = upper('&PrcsName')) connect by prior portal_prntobjname = portal_objname start with ( portal_uri_seg2 = pnlgrpname and portal_reftype = 'C' and portal_cref_usgt = 'TARG')) where portal_reftype = 'C' connect by portal_prntobjname = prior portal_objname start with (portal_objname = 'PORTAL_ROOT_OBJECT' and portal_reftype = 'F')