--BOM查询
select a.BomId,a.invcode,b.invcode,c.cinvname,c.cInvStd,d.cComUnitName
from v_bom_bomparent a join v_bom_opcomponent_rpt b on a.BomId=b.BomId
join inventory c on b.InvCode=c.cInvCode
join ComputationUnit d on c.cComUnitCode=d.cComunitCode where b.InvCode like '%%'
--子件查询
select a.InvCode,b.BaseQtyD,b.CompScrap,c.cInvName,c.cInvStd,d.cComUnitName
from v_bom_bomparent a join v_bom_opcomponent_rpt b on a.BomId=b.BomId
join inventory c on b.InvCode=c.cInvCode
join ComputationUnit d on d.cComUnitCode=c.cComunitCode where a.InvCode like '%%'