Custom BOM Quantity Rollout Report

Question

Hi,

I am trying to develop a custom BOM Quantity Rollout report, we have been able to pull in all the information we need from the Parts and Part BOM however, we need help pulling in the Manufacturer Part from the Part AML,

I need help in determining what I must add to the query in order to pull in the Part AML correctly, below is the current query:

<Item type="Part" action="get" id="{@id}" select="item_number,name,cavi_manufacturer">
 <Relationships>
  <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)">
   <related_id>
    <Item type="Part" select="item_number,name,cavi_manufacturer">
     <Relationships>
      <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)">
       <related_id>
        <Item type="Part" select="item_number,name,cavi_manufacturer">
         <Relationships>
          <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)">
           <related_id>
            <Item type="Part" select="item_number,name,cavi_manufacturer">
             <Relationships>
              <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)">
               <related_id>
                <Item type="Part" select="item_number,name,cavi_manufacturer">
                 <Relationships>
                  <Item type="Part BOM" select="sort_order,quantity,related_id(item_number,name,cavi_manufacturer)">
                   <related_id>
                    <Item type="Part" select="item_number,name,cavi_manufacturer"></Item>
                   </related_id>
                  </Item>
                 </Relationships>
                </Item>
               </related_id>
              </Item>
             </Relationships>
            </Item>
           </related_id>
          </Item>
         </Relationships>
        </Item>
       </related_id>
      </Item>
     </Relationships>
    </Item>
   </related_id>
  </Item>
 </Relationships>
</Item>

Any help on how to modify this to include the Part AML would be greatly appreciated,

Thanks in advance,