/* Project Details */
select * from dm_projects prj, branches br, boms b
where prj.proj_id = br.proj_id
and b.BRANCH_ID = br.branch_id
and b.bom_id = :BOM_ID
   