APEX

I'm trying to create a tree for Bill of Materials from Oracle Applications 11.5.10. In other words, I'd like to create a HTML DB report that simply shows a BOM in a tree format that someone can explode/collapse/view. I use the following SQL code right now to display it. I hard-code the "assembly_item_id" to run this ad-hoc, currently.

select bic.component_item_id Component ,
msi.segment1 Name,
msi.description Description,
bic.component_quantity Quantity,
lpad( ' ', level*2 ) || level
from bom_bill_of_materials bbm
,bom_inventory_components bic
, mtl_system_items msi
where bbm.bill_Sequence_id = bic.bill_sequence_id
and msi.inventory_item_id = bic.component_item_id
and msi.organization_id = bbm.organization_id
start with bbm.assembly_item_id = 271962
and bbm.organization_id = 85
connect by prior bic.component_item_id = bbm.assembly_item_id;

Anyway, is there a way to create a tree in HTML DB from this data?

Thanks!
Steve