delete from ITEM as ITM
where ITM.STOCK_MANAGEMENT_TYPE <> 1
and   not exists (
select 'x'
from STOCK as STK
where ITM.ITEM_CODE = STK.ITEM_CODE
and   STK.LAST_DELIVERY_DATE >= '2022-12-01'
and   STK.ACTUAL_AMT > 0
)