/*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
  
