Batch report for multi stage production process

Hello,

Out client has all their items batch managed and they have 6 stage production process and in each stage the finished good is given a batch.

Is there any report to find out all the batches by giving the final end product or by giving the first level raw material.

Thank you

Vani