Details |
Last modification |
View Log
| RSS feed
| Rev |
Author |
Line No. |
Line |
| 29 |
jtweddle |
1 |
/* Formatted on 2006/07/25 11:41 (Formatter Plus v4.8.6) */
|
|
|
2 |
SELECT count(1) AS NUM
|
|
|
3 |
FROM boms bm, bom_contents bc, network_nodes nn
|
|
|
4 |
WHERE bm.bom_id = :bom_id
|
|
|
5 |
AND bm.bom_id = bc.bom_id
|
|
|
6 |
AND nn.node_id = bc.node_id
|
|
|
7 |
AND nn.node_type_id IN (1)
|