RBT_MENU_VW

(SQL View)
 Index Back

SELECT DISTINCT B.MENUNAME , A.MARKET 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 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
2 MARKET Character(3) VARCHAR2(3) NOT NULL Market