DELETE FROM ITEM
WHERE NOT EXISTS
(SELECT 1 FROM STOCK WHERE ITEM.ITEM_CODE = STOCK.ITEM_CODE 
AND ITEM.STOCK_MANAGEMENT_TYPE = 1
AND STOCK.LAST_DELIVERY_DATE IS NOT NULL
)
;

DELETE FROM ITEM
WHERE EXISTS
(SELECT 1
FROM STOCK
WHERE LAST_DELIVERY_DATE < '2022-12-01'
AND ACTUAL_AMT = 0 
AND ITEM.STOCK_MANAGEMENT_TYPE = 1
AND STOCK.LAST_DELIVERY_DATE IS NOT NULL
)
;