Component's Navigation path

Substitute the :menu and :component prompts with the menu and component you are looking for. The 'MARKET' is defaulted to 'GBL' if you are an international setup replace that to the appropriate Market code you are looking for.


WITH PORTAL_REGISTRY (PORTAL_NAME, PORTAL_REFTYPE, PORTAL_OBJNAME, PORTAL_LABEL, PORTAL_URI_SEG1, PORTAL_URI_SEG2, PORTAL_URI_SEG3, PATH) AS
  (SELECT P.PORTAL_NAME ,
    P.PORTAL_REFTYPE ,
    P.PORTAL_OBJNAME ,
    P.PORTAL_LABEL ,
    PORTAL_URI_SEG1 ,
    PORTAL_URI_SEG2 ,
    PORTAL_URI_SEG3 ,
    to_clob(P.PORTAL_LABEL) AS PATH
  FROM PSPRSMDEFN P
  WHERE P.PORTAL_PRNTOBJNAME = ' '
  UNION ALL
  SELECT P_ONE.PORTAL_NAME ,
    P_ONE.PORTAL_REFTYPE ,
    P_ONE.PORTAL_OBJNAME ,
    P_ONE.PORTAL_LABEL ,
    P_ONE.PORTAL_URI_SEG1 ,
    P_ONE.PORTAL_URI_SEG2 ,
    P_ONE.PORTAL_URI_SEG3 ,
    to_clob(PATH    || ' --> '     || P_ONE.PORTAL_LABEL) AS PATH
  FROM PORTAL_REGISTRY P
  INNER JOIN PSPRSMDEFN P_ONE
  ON P.PORTAL_NAME                = P_ONE.PORTAL_NAME
  AND P.PORTAL_REFTYPE            = 'F'
  AND P.PORTAL_OBJNAME            = P_ONE.PORTAL_PRNTOBJNAME
  WHERE P_ONE.PORTAL_PRNTOBJNAME != ' '   )
SELECT PORTAL_NAME ,
  PORTAL_OBJNAME ,
  PORTAL_REFTYPE ,
  PATH ,
  PORTAL_LABEL
FROM PORTAL_REGISTRY
WHERE PORTAL_REFTYPE != 'F'
and PORTAL_NAME       = 'EMPLOYEE'
and PORTAL_URI_SEG1   = :Menu
AND PORTAL_URI_SEG2   = :component
AND PORTAL_URI_SEG3   = 'GBL';