RSEC_SMN_LNG_VW

(SQL View)
 Index Back

View of related language menu

Related language view of search menu's used for application security.

SELECT A.MENUNAME , A.BARNAME , A.ITEMNAME , C.ITEMNAME , E.LANGUAGE_CD , E.DESCR FROM PSMENUITEM A , PSPNLGRPDEFN B , PSPNLGROUP C , PS_RSEC_STAT_MENU D , PSPNLGDEFNLANG E 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 AND B.PNLGRPNAME = E.PNLGRPNAME AND B.MARKET = E.MARKET

  • Related Language Record for RSEC_STAT_MN_VW RSEC_ST_MENU_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_VW1

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description