RSEC_ST_MENU_VW

(SQL View)
 Index Back

View of config search menu's

View of config search menu's used for application security.

SELECT A.MENUNAME , A.BARNAME , A.ITEMNAME , C.ITEMNAME , B.DESCR FROM PSMENUITEM A , PSPNLGRPDEFN B , PSPNLGROUP C , PS_RSEC_STAT_MENU D WHERE A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND B.PNLGRPNAME = C.PNLGRPNAME AND B.MARKET = C.MARKET AND A.MENUNAME = D.MENUNAME AND A.BARNAME = D.BARNAME AND A.ITEMNAME = D.ITEMNAME AND C.ITEMNAME = D.PANELITEMNAME

  • Related Language Record: RSEC_SMN_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    2 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name

    Prompt Table: RSEC_MENU_VW1

    3 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name

    Prompt Table: RSEC_MENU_VW2

    4 PANELITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name

    Prompt Table: RSEC_MENU_VW3

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description