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
