Update Last In Cost from F43121 - Brazil

SELECT * FROM testdta.F43121
WHERE prmatc = '1' AND
prlitm = 'F231947' AND
prmcu = '     3110082' AND
prrcdj = 111243 AND
--prdoc = 80484 AND
prglc LIKE  'IN%'
ORDER BY pritm asc , prmcu ASC, prdoc desc , prupmj DESC, prtday DESC

SELECT * FROM testdta.F43121
WHERE prmatc = '1' AND prlitm = 'F231947' AND prmcu = '     3110082' AND prrcdj = 111243 AND prdoc = 57797 AND pralin = 2 AND prlnid = 191000