Hello,

Sometimes in Peopletools->Portal->Structure and Content
We might hide some Portal links, So it is better include the following in the SQL

AND NOT EXISTS (SELECT '1' FROM PSPRSMSYSATTR d WHERE d.PORTAL_OBJNAME=a.PORTAL_OBJNAME
AND PORTAL_ATTR_NAM='PORTAL_HIDE_FROM_NAV')
-------------------------------------------------------------------------------
SELECT a.portal_label AS PORTAL_LINK_NAME, a.portal_objname, a.portal_name, a.portal_reftype
FROM psprsmdefn a, psprsmperm b, psclassdefn c
WHERE a.portal_reftype = 'C'
AND a.portal_cref_usgt = 'TARG'
AND a.portal_name = b.portal_name
AND a.portal_reftype = b.portal_reftype
AND a.portal_objname = b.portal_objname
AND c.classid = b.portal_permname
AND a.portal_uri_seg1 <> ' '
AND a.portal_uri_seg2 <> ' '
AND a.portal_uri_seg3 <> ' '
AND c.classid = :permissionlist
AND a.portal_name = :portalname
AND NOT EXISTS (SELECT '1' FROM PSPRSMSYSATTR d WHERE d.PORTAL_OBJNAME=a.PORTAL_OBJNAME
AND PORTAL_ATTR_NAM='PORTAL_HIDE_FROM_NAV')

Thanks Sakthi, really appreciate your feedback.