/* Formatted on 2006/07/25 11:41 (Formatter Plus v4.8.6) */
SELECT count(1) AS NUM
  FROM boms bm, bom_contents bc, network_nodes nn
 WHERE bm.bom_id = :bom_id
   AND bm.bom_id = bc.bom_id
   AND nn.node_id = bc.node_id
   AND nn.node_type_id IN (1)