How to determine the PeopleSoft navigation?

While working on my previous projects, I had some difficulties identifying the menu navigation for a process or report in PeopleSoft. So I developed this SQL that will help determine the navigation.

select distinct b.menugroup||’ > ‘ ||b.menulabel||

‘ > ‘||barlabel||’ > ‘||a.itemlabel||’ > ‘

||d.pnlgrpname||’ – ‘||prcstype||’ – ‘||prcsname“Navigation”

from psmenuitem a, psmenudefn b, ps_prcsdefnpnl c, pspnlgroup d

where a.menuname=b.menuname

and a.pnlgrpname = c.pnlgrpname

and a.pnlgrpname = d.pnlgrpname

and prcsname like upper(‘&prcsname’)

group by b.menuname, b.menugroup, b.menulabel, barlabel, a.itemlabel,

d.pnlgrpname, prcstype, prcsname

/

Navigation
—————————————————————————-

Mana&ge Assets > &Interface Asset Information > &Process > &Transaction Loader > RUN_AMIF1000 – Application Engine – AMIF1000

Read More about Peoplesoft Navigation