/* Network Nodes Spec Files List */
SELECT nn.NODE_ID,
	   nn.NODE_NAME,
	   nn.NODE_VERSION,
	   nn.NODE_LIFE_CYCLE,
	   br.BRANCH_NAME,
	   bm.BOM_NAME ||''|| b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS VERSION,
	   os.NODE_SPEC_FILE,
	   os.OS_NAME,
	   bm.BOM_NAME,
	   dp.PROJ_NAME,
	   os.OS_ID,
	   b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS SBOM_VERSION
  FROM BOM_CONTENTS bc,
       NETWORK_NODES nn,
	   BRANCHES br,
	   BOMS b,
	   OPERATING_SYSTEMS os,
	   BOM_NAMES bm,
	   DM_PROJECTS dp
 WHERE bc.NODE_ID = nn.NODE_ID
   AND bc.BOM_ID = :BOM_ID
   AND br.BRANCH_ID = b.BRANCH_ID
   AND b.BOM_ID = bc.BOM_ID	 
   AND os.NODE_ID = nn.NODE_ID
   AND os.NODE_SPEC_FILE IS NOT NULL
   AND bm.BOM_NAME_ID = b.BOM_NAME_ID
   AND dp.PROJ_ID = br.PROJ_ID
   
           