SELECT i.item_number As “Parent Item”,a.item_number As “Component”,LEVELFROM AGILE.BOM A,agile.item iwhere a.item=i.id and level=1START WITH (A.ITEM In (SELECT DISTINCT i.idFROM agile.item i, agile.bom bWHERE i.id = b.item AND i.item_number in (‘500040-505’))AND Read More