SELECT ol.OBITNO,ol.OBITDS,sum(ol.OBORQA) as TOT_QTY,
sum(ol.OBORQA*ol.OBNEPR) as TOT_AMOUNT,
ol.OBSMCD
FROM MVXJDTA.OOHEAD AS oh
INNER JOIN MVXJDTA.OOLINE AS ol ON oh.OAORNO = ol.OBORNO
INNER JOIN MVXJDTA.OCUSMA AS cu ON oh.OACUNO = cu.OKCUNO
WHERE ((oh.OAORDT IN (00)) AND (ol.OBSMCD='') and (oh.OAORTP in('941','041','011','A11')))
AND OBITNO NOT IN('VARY','DC01','DM01','DC02','DC03')
group by ol.OBITNO,ol.OBITDS,ol.OBSMCD
ORDER BY ol.OBITDS ASCSUMMARY
ItemCode |
ItemName |
Qty |
Amount |
|
| TOTAL |
|
0.00 |
0.00 |