SQL:Finding the Navigation of PeopleSoft Components :
SQL Query 1: SELECT LEVEL0.PORTAL_LABEL || ' > ' || LEVEL1.PORTAL_LABEL || ' > ' || LEVEL2.PORTAL_LABEL || ' > ' || level3.PORTAL_LABEL PATH_TO_COMPONENT FROM PSPRSMDEFN level3 , PSPRSMDEFN level2 , PSPRSMDEFN level1 , PSPRSMDEFN LEVEL0 WHERE level3.PORTAL_URI_SEG2 = 'COMPONENT NAME' AND level3.PORTAL_PRNTOBJNAME = level2.PORTAL_OBJNAME AND level2.PORTAL_PRNTOBJNAME = level1.PORTAL_OBJNAME AND level1.PORTAL_PRNTOBJNAME = LEVEL0.PORTAL_OBJNAME AND level3.PORTAL_NAME = level2.PORTAL_NAME AND level2.PORTAL_NAME = level1.PORTAL_NAME AND level1.PORTAL_NAME = LEVEL0.PORTAL_NAME; SQL Query 2: Below is the alternate SQL which is more robust in my opinion. SELECT REPLACE(navigation,'',' > ') "PIA Navigation" , url , MENU_NAME , COMPONENT_NAME , portal_objname , portal_prntobjname , portal_uri_seg3 , portal_label FROM (SELECT SYS_CONNECT_BY_PATH (a.portal_label,'>>') navigation