Rev 29 | Details | Compare with Previous | Last modification | View Log | RSS feed
/* 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)