RB_MENU_VW

(SQL View)
 Index Back

SELECT DISTINCT A.MARKET , B.MENUNAME FROM PSMENUITEM A , PSMENUDEFN B WHERE A.MENUNAME = B.MENUNAME AND A.MARKET <> ' ' AND B.INSTALLED = 1 AND B.MENUTYPE = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MARKET Character(3) VARCHAR2(3) NOT NULL Market
2 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).