PSMENUGROUP_LVW

(SQL View)
Index Back

Menu Group View


SELECT DISTINCT A.MENUGROUP , LANGUAGE_CD , B.MENUGROUP FROM PSMENUDEFN A , PSMENUDEFNLANG B WHERE A.MENUGROUP <> ' ' AND A.INSTALLED = 1 AND A.MENUNAME = B.MENUNAME

  • Related Language Record for PSMENUGROUP_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PORTAL_MENUGRP Character(30) VARCHAR2(30) NOT NULL Menu Group
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 MENUGROUP Character(30) VARCHAR2(30) NOT NULL Menu Group