Tuesday, January 12, 2010

Check the component registration


    Use below script to determine where your component is registered.

      SELECT LPAD(’–’,2*(LEVEL-1)) || PORTAL_LABEL “NAVIGATION”

      FROM (SELECT PORTAL_LABEL, PORTAL_PRNTOBJNAME, PORTAL_OBJNAME, PORTAL_URI_SEG2 FROM PSPRSMDEFN A

      WHERE PORTAL_NAME = ‘EMPLOYEE’ ) B

      WHERE B.PORTAL_PRNTOBJNAME != ‘ ‘

      START WITH (B.PORTAL_URI_SEG2 IN

      (SELECT D.PNLGRPNAME

      FROM PSMENUITEM A, PSMENUDEFN B, PSPNLGROUP D

      WHERE A.MENUNAME=B.MENUNAME

      AND A.PNLGRPNAME = D.PNLGRPNAME

      AND A.PNLGRPNAME LIKE UPPER(’&COMPONENTNAME’))

      )

      CONNECT BY  PRIOR B.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAME

0 comments:

Post a Comment

Total Pageviews

Copyright © Tech & Management Notes