Does anyone have a SQL query for Vantage that will return the
end-items (manufactured parts) that a given purchased part?
I've written a query that explodes a BOM from the top, but I want to
go the other way around and generate a 'where used' list of parts from a
given purchased part.
-brian
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>
[Non-text portions of this message have been removed]
end-items (manufactured parts) that a given purchased part?
I've written a query that explodes a BOM from the top, but I want to
go the other way around and generate a 'where used' list of parts from a
given purchased part.
-brian
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>
[Non-text portions of this message have been removed]