PSMENU_PRMTVW1

index back

List all non-popup menus

This SQL view provides a list of menu names in the ACL_MENU2 page of the Permissions List component (ACCESS_CNTRL_LISTX)
SELECT menuname FROM psmenudefn WHERE menutype = 0

  • Parent record: PSOPRDEFN
  • PeopleSoft Field NameField TypeColumn TypeDescription
    MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).

    Prompt Table: PSMENUDEFN_VW

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19