SHARE
TWEET

MapicsPartNumberQuery

CryptoJones Aug 6th, 2019 70 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 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"
  2. FROM AMFLIB7.ITMRVA
  3. INNER JOIN AMFLIB7.ITRBPR ON AMFLIB7.ITRBPR.ITNBR = AMFLIB7.ITMRVA.ITNBR
  4. WHERE AMFLIB7.ITMRVA.ITNBR = '350212'
  5. ORDER BY AMFLIB7.ITRBPR.BZBLDT DESC
  6. FETCH FIRST 1 ROWS ONLY
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top