MENUITEMLANG_VW

index back

Menu Item Translate Language


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))

PeopleSoft Field Name Field Type Column Type Description
MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
BARLABEL Character(10) VARCHAR2(10) NOT NULL Menu Bar Label
ITEMLABEL Character(30) VARCHAR2(30) NOT NULL Menu Item Label
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19