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 NameField TypeColumn TypeDescription
    MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN

    ITEMNUMNumber(4,0)SMALLINT NOT NULLItem Number
    SUBITEMNUMNumber(4,0)SMALLINT NOT NULLSub Item Number
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    BARNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Bar Name
    BARITEMNAMECharacter(30)VARCHAR2(30) NOT NULLBar Item Name
    PNLITEMNAMECharacter(30)VARCHAR2(30) NOT NULLPanel Item Name
    BARLABELCharacter(10)VARCHAR2(10) NOT NULLMenu Bar Label
    ITEMLABELCharacter(30)VARCHAR2(30) NOT NULLMenu Item Label
    PNLNAMECharacter(30)VARCHAR2(30) NOT NULLPage Name (see PSPNLDEFN).
    ACTIONSNumber(4,0)SMALLINT NOT NULLActions
    PNLGRPNAMECharacter(18)VARCHAR2(18) NOT NULLComponent Name
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19