ACL_PAGES_LVW2

(SQL View)
 Index Back

Permission List Pages view


SELECT DISTINCT A.MENUNAME , A.ITEMNUM , B.SUBITEMNUM , D.LANGUAGE_CD , A.BARNAME , A.ITEMNAME , B.ITEMNAME , D.BARLABEL , D.ITEMLABEL , E.ITEMLABEL , C.ACTIONS , A.PNLGRPNAME FROM PSMENUITEM A , PSPNLGROUP B , PSPNLGRPDEFN C , PSMENUITEMLANG D ,PSPNLGROUPLANG E WHERE A.ITEMTYPE = 5 AND A.PNLGRPNAME = B.PNLGRPNAME AND A.MARKET = B.MARKET AND B.MARKET = C.MARKET AND B.PNLGRPNAME = C.PNLGRPNAME AND A.MENUNAME=D.MENUNAME AND A.BARNAME=D.BARNAME AND A.ITEMNAME=D.ITEMNAME AND B.PNLGRPNAME = E.PNLGRPNAME AND B.MARKET = E.MARKET AND B.PNLNAME= E.PNLNAME AND D.LANGUAGE_CD = E.LANGUAGE_CD

  • Related Language Record for ACL_PAGES_VW2

    • # 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 ITEMNUM Number(4,0) SMALLINT NOT NULL Item Number
    3 SUBITEMNUM Number(4,0) SMALLINT NOT NULL Sub Item Number
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    6 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
    7 PNLITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
    8 BARLABEL Character(10) VARCHAR2(10) NOT NULL Menu Bar Label
    9 ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
    10 PNLNAME Character(30) VARCHAR2(30) NOT NULL Panel Name (see PSPNLDEFN).
    11 ACTIONS Number(4,0) SMALLINT NOT NULL Actions
    12 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name