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