MENUITEMLANG_VW

Platform	View Text
Default	SELECT A.MENUNAME , A.BARNAME , A.ITEMNAME , A.LANGUAGE_CD , A.BARLABEL , A.ITEMLABEL FROM PSMENUITEMLANG A WHERE A.ITEMNAME IN ( SELECT B.ITEMNAME FROM PSMENUITEM B WHERE B.ITEMNAME = A.ITEMNAME AND B.MENUNAME = A.MENUNAME AND B.BARNAME = A.BARNAME AND B.MENUNAME IN ( SELECT C.MENUNAME FROM PSMENUDEFN C))
Sybase	SELECT A.MENUNAME , A.BARNAME , A.ITEMNAME , A.LANGUAGE_CD , A.BARLABEL , A.ITEMLABEL FROM PSMENUITEMLANG A , PSMENUITEM B , PSMENUDEFN C WHERE A.ITEMNAME= B.ITEMNAME AND B.MENUNAME = A.MENUNAME AND B.BARNAME = A.BARNAME AND B.ITEMTYPE <> 8 AND B.MENUNAME= C.MENUNAME

PeopleSoft Field Name	Description
MENUNAME	Menu Name
BARNAME	Menu Bar Name
ITEMNAME	Item Name
LANGUAGE_CD	Language Code translate values
BARLABEL	Menu Bar Label
ITEMLABEL	Menu Item Label

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010