U8BOM查询

SELECT a.bomid,b.OpComponentId,a2.Description AS [工序名称],
g.cinvcode as 母件编码,
g.cInvName as 母件名称,
g.cInvStd as 母件规格,
a.Version  as bom版本号,
f.cinvcode as 子件编码,
f.cInvName as 子件名称,
f.cInvStd as 子件规格,
b.BaseQtyN as 基本用量_分子,
b.BaseQtyD as 基本用量_分母 
FROM bom_bom a                                         ---BOM资料 
LEFT JOIN bom_opcomponent b ON b.BomId = a.BomId ---BOM子件资料 
LEFT JOIN bom_parent c ON a.bomid=c.bomid       ---BOM母件资料
LEFT JOIN bas_part d ON b.componentid=d.partid  ---物料表跟子件关联
LEFT JOIN bas_part  e ON c.parentid=e.partid    ---物料表跟母件关联
LEFT JOIN inventory f ON d.invcode=f.cinvcode   ---子件
LEFT JOIN inventory g ON e.invcode=g.cinvcode   ---母件
LEFT JOIN sfc_proutingpart a1 ON  a1.partid =e.partid
LEFT JOIN sfc_proutingdetail a2 ON a1.PRoutingId =a2.PRoutingId AND a2.OpSeq=b.OpSeq

WHERE 1=1  AND g.cInvCode='a1124'