Hi All ,
I would like to know what are the possiblilites ways to find the navigation in peoplesoft.
Is it possible to find using only RUN_CONTROL_ID same like Process name , component name ? .
Please provide the SQL to find the possible ways.
Advance thanks for your great help ,
Vinoth Kumar C
Edited by: 962735 on Mar 14, 2013 4:28 PM
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.