云星空创建组织下BOM和使用组织下BOM不一致查询sql
SELECT C.AFNUMBER,C.BFNUMBER,F.EFNUMBER FROM(SELECT A.FID,A.FNUMBER AFNUMBER,B.FNUMBER BFNUMBER FROM T_ENG_BOM A INNER JOIN T_BD_MATERIAL B ON(A.FMATERIALID=B.FMATERIALID AND A.FFORBIDSTATUS='A' AND A.FUSEORGID=使用组织ID)) C INNER JOIN (SELECT D.FID,E.FNUMBER EFNUMBER FROM T_ENG_BOMCHILD D INNER JOIN T_BD_MATERIAL E ON(D.FMATERIALID=E.FMATERIALID))F ON(C.FID=F.FID)
EXCEPT
SELECT C.AFNUMBER,C.BFNUMBER,F.EFNUMBER FROM(SELECT A.FID,A.FNUMBER AFNUMBER,B.FNUMBER BFNUMBER FROM T_ENG_BOM A INNER JOIN T_BD_MATERIAL B ON(A.FMATERIALID=B.FMATERIALID AND A.FUSEORGID=创建组织ID)) C
INNER JOIN (SELECT D.FID,E.FNUMBER EFNUMBER FROM T_ENG_BOMCHILD D INNER JOIN T_BD_MATERIAL E ON(D.FMATERIALID=E.FMATERIALID))F ON(C.FID=F.FID)ORDER BY AFNUMBER
注意这个创建组织id和使用组织id是用的组织内码哦
云星空创建组织下BOM和使用组织下BOM不一致查询sql
本文2024-09-16 17:18:18发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-14842.html