How to get the Xlate value

How to get the xlate value.

SELECT FIELDNAME, FIELDVALUE || ' - ' || XLATSHORTNAME, XLATLONGNAME

  FROM PSXLATITEM

 WHERE FIELDNAME = 'XLATEFIELD'

 ORDER BY FIELDNAME, FIELDVALUE;