EOEC_NAV_LVW

(SQL View)
 Index Back

Navigation View

View for finding navigation Path

SELECT POR.PORTAL_NAME , MNU.MENUNAME , MNU.BARNAME , MNU.ITEMNAME , MNU.PNLGRPNAME , MNU.MARKET , PNL.PNLNAME , POR.LANGUAGE_CD , POR.PORTAL_LABEL FROM PSPNLGROUP PNL , PSMENUITEM MNU , PSPRSMDEFNLANG POR , PSPRSMDEFN POR2 , PSPNLGRPDEFN GRP WHERE PNL.PNLGRPNAME=MNU.PNLGRPNAME AND POR.PORTAL_REFTYPE='C' AND PNL.PNLGRPNAME=GRP.PNLGRPNAME AND PNL.MARKET=GRP.MARKET AND PNL.HIDDEN=0 AND POR.PORTAL_NAME=POR2.PORTAL_NAME AND POR.PORTAL_REFTYPE=POR2.PORTAL_REFTYPE AND POR.PORTAL_OBJNAME=POR2.PORTAL_OBJNAME AND POR2.PORTAL_URI_SEG1=MNU.MENUNAME AND POR2.PORTAL_URI_SEG2=MNU.PNLGRPNAME AND POR2.PORTAL_URI_SEG3=MNU.MARKET AND PNL.SUBITEMNUM = ( SELECT MIN(PNL2.SUBITEMNUM) FROM PSPNLGROUP PNL2 WHERE PNL2.PNLGRPNAME=PNL.PNLGRPNAME AND PNL2.HIDDEN=0)

  • Related Language Record for EODP_COMPNAV_VW EOEC_NAV_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
    2 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
    3 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    4 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
    5 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    6 MARKET Character(3) VARCHAR2(3) NOT NULL Market
    7 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
    8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    9 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label