select *  from boms bm, production_bom prodbom, bom_names bn, dm_projects dmp
where bm.bom_id = prodbom.bom_id
and bn.bom_name_id = bm.bom_name_id
and dmp.proj_id = prodbom.proj_id
order by dmp.proj_name