PeopleSoft Panel Navigation

Here is the MS SQL query which will give you the panel/page navigation in PeopleSoft.

Select Distinct
RTrim(LTrim(IsNull(Level13.PORTAL_LABEL,''))) + Case When Level13.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level12.PORTAL_LABEL,''))) + Case When Level12.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level11.PORTAL_LABEL,''))) + Case When Level11.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level10.PORTAL_LABEL,''))) + Case When Level10.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level9.PORTAL_LABEL,''))) + Case When Level9.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level8.PORTAL_LABEL,''))) + Case When Level8.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level7.PORTAL_LABEL,''))) + Case When Level7.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level6.PORTAL_LABEL,''))) + Case When Level6.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level5.PORTAL_LABEL,''))) + Case When Level5.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level4.PORTAL_LABEL,''))) + Case When Level4.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level3.PORTAL_LABEL,''))) + Case When Level3.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level2.PORTAL_LABEL,''))) + Case When Level2.PORTAL_LABEL Is Null Then '' Else ' > ' End +
RTrim(LTrim(IsNull(Level1.PORTAL_LABEL,'')))
From PSPRSMDEFN Level1
Left Outer Join PSPRSMDEFN Level2
On Level2.PORTAL_OBJNAME = Level1.PORTAL_PRNTOBJNAME
And Level2.PORTAL_NAME = Level1.PORTAL_NAME
Left Outer Join PSPRSMDEFN Level3
On Level3.PORTAL_OBJNAME = Level2.PORTAL_PRNTOBJNAME
And Level3.PORTAL_NAME = Level2.PORTAL_NAME
Left Outer Join PSPRSMDEFN Level4
On Level4.PORTAL_OBJNAME = Level3.PORTAL_PRNTOBJNAME
And Level4.PORTAL_NAME = Level3.PORTAL_NAME
Left Outer Join PSPRSMDEFN Level5
On Level5.PORTAL_OBJNAME = Level4.PORTAL_PRNTOBJNAME
And Level5.PORTAL_NAME = Level4.PORTAL_NAME
Left Outer Join PSPRSMDEFN Level6
On Level6.PORTAL_OBJNAME = Level5.PORTAL_PRNTOBJNAME
And Level6.PORTAL_NAME = Level5.PORTAL_NAME
Left Outer Join PSPRSMDEFN Level7
On Level7.PORTAL_OBJNAME = Level6.PORTAL_PRNTOBJNAME
And Level7.PORTAL_NAME = Level6.PORTAL_NAME
Left Outer Join PSPRSMDEFN Level8
On Level8.PORTAL_OBJNAME = Level7.PORTAL_PRNTOBJNAME
And Level8.PORTAL_NAME = Level7.PORTAL_NAME
Left Outer Join PSPRSMDEFN Level9
On Level9.PORTAL_OBJNAME = Level8.PORTAL_PRNTOBJNAME
And Level9.PORTAL_NAME = Level8.PORTAL_NAME
Left Outer Join PSPRSMDEFN Level10
On Level10.PORTAL_OBJNAME = Level9.PORTAL_PRNTOBJNAME
And Level10.PORTAL_NAME = Level9.PORTAL_NAME
Left Outer Join PSPRSMDEFN Level11
On Level11.PORTAL_OBJNAME = Level10.PORTAL_PRNTOBJNAME
And Level11.PORTAL_NAME = Level10.PORTAL_NAME
Left Outer Join PSPRSMDEFN Level12
On Level12.PORTAL_OBJNAME = Level11.PORTAL_PRNTOBJNAME
And Level12.PORTAL_NAME = Level11.PORTAL_NAME
Left Outer Join PSPRSMDEFN Level13
On Level13.PORTAL_OBJNAME = Level12.PORTAL_PRNTOBJNAME
And Level13.PORTAL_NAME = Level12.PORTAL_NAME
Where Level1.PORTAL_NAME = 'EMPLOYEE'
And (Level1.PORTAL_URI_SEG2 In (Select PNLGRPNAME From PSPNLGRPDEFN Where LOWER(DESCR) Like '%component description here%')
Or Level1.PORTAL_URI_SEG2 In (Select PNLGRPNAME From PSPNLGROUP Where PNLNAME In
(Select PNLNAME From PSPNLDEFN Where LOWER(DESCR) Like '%page description here%'))
Or LOWER(Level1.PORTAL_LABEL) Like '%link label here%')