cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Most commonly used components

Highlighted
Aquamarine

Most commonly used components

This query can be used to find the components that are most commonly
called out on BOMS (Product Structures).



SELECT COMPONENT, COUNT(*)

FROM

(SELECT DISTINCT M1.WTPARTNUMBER COMPONENT, M2.WTPARTNUMBER ASM

FROM WTPARTMASTER M1, WTPARTMASTER M2, WTPARTUSAGELINK, WTPART

WHERE

M1.IDA2A2 = WTPARTUSAGELINK.IDA3B5 AND

WTPART.IDA3MASTERREFERENCE = M2.IDA2A2 AND

WTPART.IDA2A2 = WTPARTUSAGELINK.IDA3A5 AND

WTPART.IDA3VIEW = 1447) MYTABLE

GROUP BY COMPONENT

HAVING COUNT(*) >10

ORDER BY COUNT(*) DESC



The query discounts effects of iterations so the count is not skewed by
one BOM having numerous iterations.

The HAVING and ORDER BY clauses are optional. I could care less if a
component was used only once since I was looking for the most frequent.

The where clause for views, WTPART.IDAVIEW, is also optional. I was
filtering on a secondary view version.



My goal was to determine the most commonly used components and make a
helper BOM. My users can call this BOM up in a secondary PSE window and
copy/paste from it to their assembly.

Announcements