How to get the Hierarchy of Peoplesoft App Engine execution sequence

Hierarchy of AE called within AE 
How to get the order of peoplesoft App Engine execution sequence 

e.g for GL_JEDIT it goes upto 12 level deeper 

Select 
ae1.ae_level, 
ae1.AE_section_ORDER, 
ae1.stmt_tree,ae.descr, ae.DESCRLONG from PSAEAPPLDEFN AE, ( 
select SYS_CONNECT_BY_PATH(A.AE_DO_APPL_ID||':'||AE_DO_SE CTION,'->') as stmt_tree,a.AE_DO_APPL_ID 
,a.AE_SEQ_NUM as AE_section_ORDER 
,level AS ae_level 
from PSAESTEPDEFN a 
where AE_DO_APPL_ID <> ' ' 
start with AE_APPLID= 'GL_JEDIT' 
connect by NOCYCLE prior AE_DO_APPL_ID=AE_APPLID ) AE1 
where ae.AE_APPLID=ae1.AE_DO_APPL_ID 
ORDER BY ae_level ,ae1.AE_section_ORDER

Read More:http://peoplesoft.ittoolbox.com/groups/technical-functional/peoplet...

Views: 159

Reply to This

Replies to This Discussion

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)

RSS

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2020   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service