Hello,
We want to create a GI that lists all sub assemblies of a kit specification. Below is an example:
CJ60 has kit components : CJ30, CJPC, CJLP, CJCB and CBLUE. Similarly, CJ30 has kit components - CJ12,CJTC, CJTD and TH10.

We would like this information along with their lot serial numbers into a GI. Currently, I am using INTran table and self joined the same tables multiple times. But it is not working as expected.

Will really appreciate if you could share any ideas/ suggestions to get this to work. thank you! I can share the xml file of this GI if needed.