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;