PeopleSoft Community Network
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
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
ORDER BY ae_level ,ae1.AE_section_ORDER
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 (firstname.lastname@example.org)