SELECT 
	   prj.PROJ_NAME, br.BRANCH_NAME,
	   b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS SBOM_VERSION,
	   b.BOM_VERSION,
	   b.BOM_LIFECYCLE,
	   nn.NODE_NAME,
	   os.OS_NAME		
FROM 
	   BOMS b,
	   BRANCHES br,
	   DM_PROJECTS prj,
	   OPERATING_SYSTEMS os,
	   NETWORK_NODES nn
WHERE  
	   b.BOM_ID = :BOM_ID
AND    os.OS_ID = :OS_IDA
AND    b.BRANCH_ID = br.BRANCH_ID
AND    br.PROJ_ID = prj.PROJ_ID
AND    os.NODE_ID = nn.NODE_ID
	   

	
	 