SQL to list all materials from MBOM

Hi,

I need a SQL statement, using MANUF_STRUCRE view, this SQL can be drilled down to the bottom of the MBOM, and have all the materials listed?  The layout will be like the contents in the window Product Structure Tab Multilevel Structure. is it possible to have this SQL statement?

Thank you.