PeopleSoft Wiki

Print AE Program Flow Layout from AppDesigner

SELECT A.AE_SECTION, A.AE_STEP,
DECODE (A.AE_STMT_TYPE,
'C' ,'Call Section',
'D' ,'Do Select',
'H' ,'Do When',
'N' ,'Do Until',
'S' ,'Select',
'U' ,'Update/Insert/Delete',
'W' ,'Do While',
'P' ,'PeopleCode') "Stmt Type", A.DESCR
, S.SQLTEXT
FROM PSAESTEPDEFN STEP
JOIN PSAESTMTDEFN A
ON STEP.AE_APPLID = A.AE_APPLID
AND STEP.AE_SECTION = A.AE_SECTION
AND STEP.MARKET = A.MARKET
AND STEP.DBTYPE = A.DBTYPE
AND STEP.EFFDT = A.EFFDT
AND STEP.AE_STEP = A.AE_STEP
LEFT OUTER JOIN PSSQLTEXTDEFN S ON A.SQLID = S.SQLID
WHERE A.AE_APPLID = '????????'
ORDER BY DECODE(A.AE_SECTION,'MAIN','0', '1' || A.AE_SECTION), STEP.AE_SEQ_NUM ;