Multi Level Backflush report for Serialized parts

Hi All, im looking to produce a report to output the multilevel materials and components on a finished serialized part or even at the shop order level rather than serial level.

I cant find a view in IFS and am having difficulty finding which tables and views will allow me to make a query to establish this connection.

i have tried to describe the kind of connection im looking for below but for N levels and N components

shop ord
	component a
		shop ord
			component 1
				shop ord
					component #
					component #
			component 2
				shop ord
					component #
					component #
	component B
		shop ord
			component 1
				shop ord
					component #
					component #
			component 2
				shop ord
					component #
					component #

any help or support anyone can offer to point me in the right direction will be appreciated.