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 NameField TypeColumn TypeDescription
MENUNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Name (see PSMENUDEFN).
BARNAMECharacter(30)VARCHAR2(30) NOT NULLMenu Bar Name
ITEMNAMECharacter(30)VARCHAR2(30) NOT NULLItem Name
LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
BARLABELCharacter(10)VARCHAR2(10) NOT NULLMenu Bar Label
ITEMLABELCharacter(30)VARCHAR2(30) NOT NULLMenu Item Label
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19