Search product (bundle) including childrens and display relationship

Hello,

In our order management implementation we're using Siebel bundle products (Product type = Bundle). we create bundles of simple products. We also create bundle of bundled product.

Here is an example

Prod1 - Simple product

Prod 2 - Its bundle product. its made up of Prod1- This is Orderable

Prod3 - Its bundle product. Its made up of Prod2. This Orderable

Only bundle products are Orderable and can be sold. Our business users are asking us to search bundle product with its children in Siebel UI. Also, if productX is part of 5 bundles they would like to know the relationship as well.