202504---20250401<HR><font size='2'>SELECT oh.OAORDT,oh.OAORNO,
ol.OBITNO AS ITEMNO, 
CONVERT(DECIMAL(10,2),sum(ol.OBORQT)) as qty_pcs,
CONVERT(DECIMAL(10,2),(sum(ol.OBORQT)/(select max(un.MUCOFA) from MVXJDTA.MITAUN as un where ol.OBITNO=un.MUITNO))) as qty_ctn, 
CONVERT(DECIMAL(10,2),sum(ol.OBORQA*ol.OBNEPR)) AS amount, 
oh.OACUNO as custno,
CASE WHEN (ol.OBSMCD in('10001','10034','10061')) THEN 'MT' 
WHEN (ol.OBSMCD like '3%') THEN 'PC' 
WHEN (ol.OBSMCD like '4%') THEN 'IDS' 
WHEN (oh.OACUNO like 'EX%') THEN 'EX' 
ELSE cu.OKSDST
END AS OKSDST,
cu.OKCFC1,
ol.OBSMCD,
CASE WHEN ((ol.OBSMCD like '1%') AND (ol.OBSMCD not in('10001','10034','10061'))) THEN 'CR' 
WHEN ((ol.OBSMCD like '1%') AND (ol.OBSMCD in('10001','10034','10061'))) THEN 'MT' 
WHEN (ol.OBSMCD like '2%') THEN 'CA' 
WHEN (ol.OBSMCD like '3%') THEN 'PC' 
WHEN (ol.OBSMCD like '4%') THEN 'IDS' 
WHEN (oh.OACUNO like 'EX%') THEN 'EX' 
END AS CHANNEL
,oh.OANTLA-(oh.OANTLA*oh.OAOTDP/100) as TOT_AMT
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 
INNER JOIN MVXJDTA.MITMAS AS it ON ol.OBITNO = it.MMITNO 
INNER JOIN MVXJDTA.CMNUSR as cm ON ol.OBSMCD = cm.JUUSID 
WHERE (oh.OAORDT like('202504%')) AND (oh.OAORTP IN ('021','035','051','011','041','281','911','921','941','A11')) 
AND (((oh.OAORST between '22' and '79') OR (oh.OAORST in ('99'))) and (oh.OAORSL not in('99'))) AND (ol.OBORST not in ('90','99')) 
AND (ol.OBSAPR>=1) AND (ol.OBSMCD not in('11000','30001','30002','30003','30004')) 
AND ol.OBORNO not in('1972100017')
--AND (cu.OKCFC1 <> '' or cu.OKCFC1 <> null) 
GROUP BY oh.OAORNO,oh.OAORDT,oh.OACUNO,ol.OBSMCD,ol.OBITNO,cu.OKSDST,cu.OKCFC1,oh.OANTLA,oh.OAOTDP
ORDER BY oh.OAORNO,OAORDT ASC</font>