with item_info_one as (
select
    ITEM_CODE
    ,max(LAST_DELIVERY_DATE) as max_last_delivery_date
from stock
group by ITEM_CODE
having max_last_delivery_date < '2023-01-01'
)

, item_info_two as (
select
    ITEM_CODE
    ,ACTUAL_AMT
from stock
where ACTUAL_AMT = 0
)

select
    ITEM.*
from ITEM
join STOCK
on ITEM.ITEM_CODE = STOCK.ITEM_CODE
left join  item_info_one
on ITEM.ITEM_CODE = item_info_one.ITEM_CODE
left join item_info_two 
on ITEM.ITEM_CODE = item_info_two.ITEM_CODE
where STOCK_MANAGEMENT_TYPE = 1
and (item_info_one.ITEM_CODE is null
or  item_info_two.ITEM_CODE is null)