Incase item import messed up and needed to import new set with exact same name,   look for the item number in Item table and change the item number and Read More

SELECT ‘<<item number>>’ AS PARENT_ITEM, a.item_number, LEVEL FROM AGILE.BOM A START WITH (A.ITEM = (SELECT DISTINCT i.id FROM agile.item i, agile.bom b WHERE i.id = b.item AND i.item_number = ‘<<item Read More