SELECT l.MRTRNR,l.MRTRDT,
RTRIM(l.MRITNO) as ITNO,
CONVERT(DECIMAL(10,0),l.MRRPQT) as QTY,
h.MGTWLO,
l.MRITDS as NO_ITEMNAME,
CONVERT(DECIMAL(10,0),l.MRTRQT) as REQ_QTY,
CONVERT(DECIMAL(10,0),((l.MRRPQT)/(select max(un.MUCOFA) from MVXJDTA.MITAUN as un where l.MRITNO=un.MUITNO))) as NO_CONVERT_CTN,
l.MRTRSH as NO_STATUS
FROM MVXJDTA.MGLINE AS l
INNER JOIN MVXJDTA.MGHEAD AS h ON l.MRTRNR = h.MGTRNR
WHERE (((h.MGTRDT in('20160501','20160502','20160503','20160504') and (h.MGTWLO between '201' and '850'))))
and ((l.MRTRSH in('99','29')) and (l.MRRPQT>0))   --Check For Upload / Compare Doc outing
ORDER BY h.MGTRDT,h.MGTWLO,l.MRTRNR,l.MRPONR,RTRIM(l.MRITNO)