Skip to Content
0
Former Member
Apr 13, 2009 at 10:15 AM

Query for Complex BOM

76 Views

Hi All,

Gonna ask u a help reg BOM. We have BOMs like the following,

P1 - C3

C3 - C2

C2 - C1 + R1

P2 - CH2

CH2 - CH1

CH1 - R2

I need a query which ll display those as like below,

P1 - C3

P1 - C2

P1 - C1

P2 - CH2

P2 - CH1

Can any one help me with query?

Thanks,

Raj.