Finding the navigation for a given component in oracle.
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 = 'EY_RANK_EXP_PNL' 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