金蝶云星空更新生产用料清单是否关键件（和物料清单保持一致）
update t1 set FISKEYCOMPONENT=t4.FISKEYCOMPONENT from T_PRD_PPBOMENTRY_C t1 inner join T_PRD_PPBOM t2 on t1.FID=t2.FID inner join T_PRD_PPBOMENTRY t3 on t1.FENTRYID=t3.FENTRYID inner join (select v1.FID,v2.FISKEYCOMPONENT,v2.FMATERIALID,v2.FISSUETYPE from T_ENG_BOM v1 inner join T_ENG_BOMCHILD v2 on v1.FID=v2.FID) t4 on t3.FMATERIALID=t4.FMATERIALID and t2.FBOMID=t4.FID inner join T_BD_MATERIAL_L t5 on t3.FMATERIALID=t5.FMATERIALID where T2.FCREATEDATE>='2023-04-01'
最新回复 (0)
