In search of a query for showing all assembly-component level details in join with table WIP_REQUIRE

Hi ,

I have created below query which shows only assembly level data, I want a multiple drill down information, how can we achieve it

For example outfut shows 'HVD566PNK114P' as an Assembly level which is made up of component (R1,R2,R3,ZZZ) where R1,R2,R3 are end/child items and ZZZ is again the assemply/parent which is further made up of components (C1,C2), so in my final result I have to show R1,R2,R3,C1,C2

Please advise how can I proceed

select wro.ORGANIZATION_ID,wro.INVENTORY_ITEM_ID,mstb.segment1,wro.CONCATENATED_SEGMENTS,wro.ITEM_DESCRIPTION,wro.ITEM_PRIMARY_UOM_CODE,