ACL_PAGES_VW2

index back

Permission List Pages view


SELECT A.MENUNAME , A.ITEMNUM , B.SUBITEMNUM , A.BARNAME , A.ITEMNAME , B.ITEMNAME , A.BARLABEL , A.ITEMLABEL , B.ITEMLABEL ,c.actions , A.PNLGRPNAME FROM PSMENUITEM A , PSPNLGROUP B , PSPNLGRPDEFN C WHERE A.ITEMTYPE = 5 AND B.PNLGRPNAME = A.PNLGRPNAME AND A.MARKET = B.MARKET AND B.MARKET = C.MARKET AND B.PNLGRPNAME = C.PNLGRPNAME

  • Related language record: ACL_PAGES_LVW2
  • 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
    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