with tbl as (
    SELECT ITEM_CODE FROM stock
    WHERE
    (LAST_DELIVERY_DATE is NULL OR LAST_DELIVERY_DATE < '2023-01-01')
    AND ACTUAL_AMT = 0
)

delete from ITEM
WHERE
STOCK_MANAGEMENT_TYPE = 1
AND
(
  ITEM_CODE NOT IN (SELECT ITEM_CODE FROM STOCK)
  OR ITEM_CODE IN (SELECT ITEM_CODE FROM tbl)
)