Subversion Repositories DevTools

/*Bom Location Details */

SELECT bo.bom_id, proj.proj_name, br.branch_name, bn.bom_name, bo.bom_version,

       bo.bom_lifecycle

  FROM boms bo, 

  	   bom_names bn, 

       branches br, 

       dm_projects proj

 WHERE bn.bom_name_id = bo.bom_name_id

   AND br.branch_id = bo.branch_id

   AND proj.proj_id = br.proj_id

   AND bo.BOM_ID = :BOM_ID