select ordnumber from oe where id in (select distinct trans_id from inventory where warehouse_id =0);