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

	
	 