/* Network Nodes List */
SELECT nn.NODE_ID,
	   nn.NODE_NAME,
	   nn.NODE_VERSION,
	   nn.NODE_LIFE_CYCLE,
	   br.BRANCH_NAME,
	   bn.BOM_NAME ||''|| b.BOM_VERSION ||'.'|| b.BOM_LIFECYCLE AS VERSION
  FROM BOM_CONTENTS bc,
       NETWORK_NODES nn,
	   BRANCHES br,
	   BOMS b,
	   BOM_NAMES bn
 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 nn.NOT_XML IS NULL
   AND bn.BOM_NAME_ID = b.BOM_NAME_ID		         
