PORTAL  |  20.04.2026

 

SELECT DISTINCT checknumber FROM MF_EAME.PPOR_VCHECK_DETAIL CD
WHERE CD.BUSINESSDATE >= TO_DATE('20221115', 'YYYYMMDD') AND CD.BUSINESSDATE < TO_DATE('20221115', 'YYYYMMDD') + 1
AND (-1 IN (42) OR CD.STORE_HIERSTRUCID IN (42))
and detailtype=4
group by checknumber
having count (detailtype)>1
ORDER BY checknumber