MapicsPartNumberQuery

SELECT CAST(AMFLIB7.ITMRVA.ITNBR AS CHAR(16) ccsid 37) AS "ItemNumber", CAST(AMFLIB7.ITMRVA.ITDSC AS CHAR(64) ccsid 37) AS "Description", AMFLIB7.ITRBPR.BZANVA AS "Price"
FROM AMFLIB7.ITMRVA
INNER JOIN AMFLIB7.ITRBPR ON AMFLIB7.ITRBPR.ITNBR = AMFLIB7.ITMRVA.ITNBR
WHERE AMFLIB7.ITMRVA.ITNBR = '350212'
ORDER BY AMFLIB7.ITRBPR.BZBLDT DESC
FETCH FIRST 1 ROWS ONLY