WITH STOCK_MANAGEMENT_TARGET_ITEM AS (
    SELECT ITEM_CODE AS CODE
    FROM STOCK
    WHERE STOCK_MANAGEMENT_TYPE = 1
),

ITEM_LAST_DELIVERY_DATE AS (
    SELECT ITEM_CODE AS CODE,
           MAX(LAST_DELIVERY_DATE) AS LDD
    FROM STOCK
    GROUP BY ITEM_CODE
)

DELETE FROM ITEM
WHERE 
  ITEM_CODE IN (SELECT CODE FROM STOCK_MANAGEMENT_TARGET_ITEM)
  AND  
     (ITEM_CODE NOT IN (SELECT DISTINCT ITEM_CODE FROM STOCK)
   OR ITEM_CODE     IN (SELECT          ITEM_CODE FROM STOCK 
                                                  WHERE ITEM_CODE IN (
                                                                      SELECT ITEM_CODE 
                                                                      FROM STOCK
                                                                      JOIN ITEM_LAST_DELIVERY_DATE
                                                                      ON STOCK.ITEM_CODE = ITEM_LAST_DELIVERY_DATE.CODE
                                                                      WHERE LDD <= '2022-12-01'
                                                                      )
                                                    AND ACTUAL_AMT = 0
                        )
    )