qtd 0

select * from t_order
where cust_po_number is not null
and order_number in (select order_number from t_al_host_order_detail where qty = 0)
and type_id = '1669';


select * from t_al_host_order_master alorm
where (alorm.order_number, alorm.wh_id) in (select order_number, wh_id from t_order
                                            where order_id in (2345904,2085631,2085632,2085633,2085635,2101152,2363964,2363966,2345903,2085634,2101153))
order by order_number;