PSMENU_PRMTVW1 (SQL View)	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)

PSMENU_PRMTVW1

(SQL View)

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 Name PeopleSoft Field Type Database Column Type Description

1 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
Prompt Table: PSMENUDEFN_VW