/* Node List */
SELECT nt.NODE_ICON,
       nn.NODE_ID,
	   nn.NODE_NAME,
	   nn.NODE_COMMENTS,
	   nn.NODE_VERSION,
	   nn.NODE_LIFE_CYCLE
  FROM BOM_CONTENTS bc,
  	   NETWORK_NODES nn,
	   NODE_TYPES nt
 WHERE bc.NODE_ID = nn.NODE_ID
   AND nn.NODE_TYPE_ID = nt.NODE_TYPE_ID
   AND bc.BOM_ID = :BOM_ID	
 ORDER BY bc.SEQ_NUM, UPPER(nn.NODE_NAME)