How to get the process/program run page path from PeopleSoft

How to get the process/program run page path from PeopleSoft

In PeopleSoft, the SQR, Application Engine are designed to run based a component. Then when we run the programs we need to know the component/page path first. But how to get the path? For a quick steps, you can create a view of fields prcsname, prcstype, pnlgrpname, descr, navigation, portal_descr254 based the following SQL. So you can get the program path easily from the view every time.

SELECT DP.PRCSNAME,
       DP.PRCSTYPE,
       DP.PNLGRPNAME,
       P.DESCR,
       lvl0.PORTAL_LABEL ||
       DECODE(NVL(lvl1.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl1.PORTAL_LABEL ||
       DECODE(NVL(lvl2.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl2.PORTAL_LABEL ||
       DECODE(NVL(lvl3.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl3.PORTAL_LABEL ||
       DECODE(NVL(lvl4.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl4.PORTAL_LABEL "Navigation",
       lvl0.PORTAL_OBJNAME ||
       DECODE(NVL(lvl1.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl1.PORTAL_OBJNAME ||
       DECODE(NVL(lvl2.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl2.PORTAL_OBJNAME ||
       DECODE(NVL(lvl3.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl3.PORTAL_OBJNAME ||
       DECODE(NVL(lvl4.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl4.PORTAL_OBJNAME "Navigate_Component"
  FROM PSPRSMDEFN     lvl0,
       PSPRSMDEFN     lvl1,
       PSPRSMDEFN     lvl2,
       PSPRSMDEFN     lvl3,
       PSPRSMDEFN     lvl4,
       PS_PRCSDEFN    P,
       PS_PRCSDEFNPNL DP
 WHERE lvl0.PORTAL_NAME = 'EMPLOYEE'
   AND lvl0.PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT'
   AND lvl1.PORTAL_NAME = lvl0.PORTAL_NAME    /* e.g. 'EMPLOYEE' */
   AND lvl2.PORTAL_NAME(+) = lvl1.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl3.PORTAL_NAME(+) = lvl2.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl4.PORTAL_NAME(+) = lvl3.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl1.PORTAL_PRNTOBJNAME = lvl0.PORTAL_OBJNAME
   AND lvl2.PORTAL_PRNTOBJNAME(+) = lvl1.PORTAL_OBJNAME
   AND lvl3.PORTAL_PRNTOBJNAME(+) = lvl2.PORTAL_OBJNAME
   AND lvl4.PORTAL_PRNTOBJNAME(+) = lvl3.PORTAL_OBJNAME
   AND (lvl0.PORTAL_SEQ_NUM < 1000    /* 1000 Employee Self-Service */
       OR lvl0.PORTAL_SEQ_NUM = 9110  /* 9110 Set Up Financials/Supply Chain */
       OR lvl0.PORTAL_SEQ_NUM = 9955) /* 9955 PeopleTools */ /* User folder + "Set Up Financials/Supply Chain" */
   AND P.PRCSNAME = DP.PRCSNAME
   AND DP.PNLGRPNAME IN (lvl4.PORTAL_URI_SEG2,
                         lvl3.PORTAL_URI_SEG2,
                         lvl2.PORTAL_URI_SEG2,
                         lvl1.PORTAL_URI_SEG2)
UNION /* JOBS */
SELECT DJ.PRCSJOBNAME,
       J.PRCSTYPE,
       DJ.PNLGRPNAME,
       J.DESCR,
       lvl0.PORTAL_LABEL ||
       DECODE(NVL(lvl1.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl1.PORTAL_LABEL ||
       DECODE(NVL(lvl2.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl2.PORTAL_LABEL ||
       DECODE(NVL(lvl3.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl3.PORTAL_LABEL ||
       DECODE(NVL(lvl4.PORTAL_LABEL, ' '), ' ', '', ' > ') ||
       lvl4.PORTAL_LABEL "Navigation",
       lvl0.PORTAL_OBJNAME ||
       DECODE(NVL(lvl1.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl1.PORTAL_OBJNAME ||
       DECODE(NVL(lvl2.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl2.PORTAL_OBJNAME ||
       DECODE(NVL(lvl3.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl3.PORTAL_OBJNAME ||
       DECODE(NVL(lvl4.PORTAL_OBJNAME, ' '), ' ', '', ' > ') ||
       lvl4.PORTAL_OBJNAME "Navigate_Component"
  FROM PSPRSMDEFN     lvl0,
       PSPRSMDEFN     lvl1,
       PSPRSMDEFN     lvl2,
       PSPRSMDEFN     lvl3,
       PSPRSMDEFN     lvl4,
       PS_PRCSJOBDEFN J,
       PS_PRCSJOBPNL  DJ
 WHERE lvl0.PORTAL_NAME = 'EMPLOYEE'
   AND lvl0.PORTAL_PRNTOBJNAME = 'PORTAL_ROOT_OBJECT'
   AND lvl1.PORTAL_NAME = lvl0.PORTAL_NAME    /* e.g. 'EMPLOYEE' */
   AND lvl2.PORTAL_NAME(+) = lvl1.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl3.PORTAL_NAME(+) = lvl2.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl4.PORTAL_NAME(+) = lvl3.PORTAL_NAME /* e.g. 'EMPLOYEE' */
   AND lvl1.PORTAL_PRNTOBJNAME = lvl0.PORTAL_OBJNAME
   AND lvl2.PORTAL_PRNTOBJNAME(+) = lvl1.PORTAL_OBJNAME
   AND lvl3.PORTAL_PRNTOBJNAME(+) = lvl2.PORTAL_OBJNAME
   AND lvl4.PORTAL_PRNTOBJNAME(+) = lvl3.PORTAL_OBJNAME
   AND (lvl0.PORTAL_SEQ_NUM < 1000    /* 1000 Employee Self-Service */
       OR lvl0.PORTAL_SEQ_NUM = 9110  /* 9110 Set Up Financials/Supply Chain */
       OR lvl0.PORTAL_SEQ_NUM = 9955) /* 9955 PeopleTools */ /* User folder + "Set Up Financials/Supply Chain" */
   AND J.PRCSJOBNAME = DJ.PRCSJOBNAME
   AND DJ.PNLGRPNAME IN (lvl4.PORTAL_URI_SEG2,
                         lvl3.PORTAL_URI_SEG2,
                         lvl2.PORTAL_URI_SEG2,
                         lvl1.PORTAL_URI_SEG2)
 ORDER BY 1 /* ORDER BY DP.PRCSNAME, lvl0.PORTAL_SEQ_NUM, lvl0.PORTAL_OBJNAME , lvl1.PORTAL_SEQ_NUM, lvl1.PORTAL_OBJNAME , lvl2.PORTAL_SEQ_NUM, lvl2.PORTAL_OBJNAME , lvl3.PORTAL_SEQ_NUM, lvl3.PORTAL_OBJNAME , lvl4.PORTAL_SEQ_NUM, lvl4.PORTAL_OBJNAME*/