stored proc to deplete subItems from Inventory

The Overall project is to create an application to subtract the subItems from Inventory based on the Sales order number. The sales order has line numbers. Each line number has part number, if part number is a family part is comprised of subItems. This query gets all the subItems from the family part. --get all the subItems from Family part select ppm.PRTNUM_01, ppm.PMDES1_01, ppm.PMDES2_01, ppm.BOMUOM_01 from Part_Master ppm where ppm.PRTNUM_01 in ( select ps.COMPRT_02 from Part_Master pm left join Product_Structure ps on pm.PRTNUM_01 = ps.PARPRT_02 where pm.PRTNUM_01='0631-0021-0001' ) -- list amount of material to use in subItem SELECT PARPRT_02,COMPRT_02,QTYPER_02,QTYCDE_02--,* FROM Product_Structure WHERE ALTCDE_02 = '' AND PARPRT_02 = '0631-0021-0001' AND COMPRT_02 = '349-00006005-04' --based on the amounts in the query the stock is depleted. update Part_Stock set QTYOH_06 = 1717 WHERE PRTNUM_06 = '399-00001002-04 ' AND STK_06 = '11305'