ACL_PAGES_LVW2

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 Field Type Column Type Description
    MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    ITEMNUM Number(4,0) SMALLINT NOT NULL Item Number
    SUBITEMNUM Number(4,0) SMALLINT NOT NULL Sub Item Number
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
    BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
    PNLITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
    BARLABEL Character(10) VARCHAR2(10) NOT NULL Menu Bar Label
    ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
    PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
    ACTIONS Number(4,0) SMALLINT NOT NULL Actions
    PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19