SQL for Bill of Material (BOM) Listing Report

Thanks on these, Vic - very handy references!


--- In vantage@yahoogroups.com, "Vic Drecchio" wrote:
>
> PartMtl table.
>
>
>
> Check out the FILES section of the site. I put up a couple schemas a while
> back; one of them is for the Part module.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> reportinggurus
> Sent: Wednesday, January 09, 2013 4:31 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] SQL for Bill of Material (BOM) Listing Report
>
>
>
>
>
> Hi,
>
> We are trying to recreate the Indented Level Bill of Material Listing
> Report. We are writing a recursive query to
>
> The main problem we are having is to get the BOM relationship and what
> table(s) that is located in? How do you find out what parts are used to put
> together a parent part? How do we get the Parent / Chile relationship
> between Parts in a BOM?
>
> thanks in advance!!
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2637/5521 - Release Date: 01/09/13
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.2221 / Virus Database: 2637/5521 - Release Date: 01/09/13
>
> [Non-text portions of this message have been removed]
>
Hi,

We are trying to recreate the Indented Level Bill of Material Listing Report. We are writing a recursive query to

The main problem we are having is to get the BOM relationship and what table(s) that is located in? How do you find out what parts are used to put together a parent part? How do we get the Parent / Chile relationship between Parts in a BOM?

thanks in advance!!
PartMtl table.



Check out the FILES section of the site. I put up a couple schemas a while
back; one of them is for the Part module.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
reportinggurus
Sent: Wednesday, January 09, 2013 4:31 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SQL for Bill of Material (BOM) Listing Report





Hi,

We are trying to recreate the Indented Level Bill of Material Listing
Report. We are writing a recursive query to

The main problem we are having is to get the BOM relationship and what
table(s) that is located in? How do you find out what parts are used to put
together a parent part? How do we get the Parent / Chile relationship
between Parts in a BOM?

thanks in advance!!



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2637/5521 - Release Date: 01/09/13




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2637/5521 - Release Date: 01/09/13

[Non-text portions of this message have been removed]