用友 U8 获取全阶 Bom 语句

WITH MaxVersion AS ( --获取每个母件的最大版本号
select y.* from (SELECT *
FROM (
    SELECT 
        invcode,
        c.bomid,
        Define4,
        Version,
        COUNT(*) OVER (PARTITION BY invcode, Version) AS cnt,
        ROW_NUMBER() OVER (PARTITION BY invcode ORDER BY Version DESC) AS rn 
    FROM bas_part a
    LEFT JOIN bom_parent b ON a.PartId = b.ParentId
    INNER JOIN bom_bom c ON c.BomId = b.BomId
    WHERE Version IS NOT NULL 
) t
WHERE t.cnt > 0 AND t.rn = 1 
)y
),
AnchorQuery AS (
 SELECT
 MaxV.BomId as '母件Bomid',
 MaxV.BomId as '子件Bomid',
c.InvCode as '母件编码',
g.InvCode as '子件编码',
    b.sortSeq,
    b.ComponentId,
    b.Bas