Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
13 rsolanki 1 
/*Bom Location Details */
2 
SELECT bo.bom_id, proj.proj_name, br.branch_name, bn.bom_name, bo.bom_version,
3 
       bo.bom_lifecycle
4 
  FROM boms bo,
5 
  	   bom_names bn,
6 
       branches br,
7 
       dm_projects proj
8 
 WHERE bn.bom_name_id = bo.bom_name_id
9 
   AND br.branch_id = bo.branch_id
10 
   AND proj.proj_id = br.proj_id
11 
   AND bo.BOM_ID = :BOM_ID
12