202504---<HR>SELECT ol.OBORNO as ORNO,
(sum(ol.OBNEPR))+(oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100)) as NEW_AMT
FROM MVXJDTA.OOLINE AS ol 
INNER JOIN MVXJDTA.OOHEAD AS oh ON ol.OBORNO = oh.OAORNO 
WHERE (((ol.OBITNO like 'PRO%') OR (ol.OBITNO = 'DIS') OR (ol.OBITNO in('VARY','DC01','DIS','DC02','DM01'))))
and oh.OAORTP IN('021','921','A11','011')
and left(oh.OAORDT,6) like '202504'
GROUP BY ol.OBORNO,oh.OANTLA,oh.OAOTDP
ORDER BY ol.OBORNO ASC