BOM卷算标准工时代码分享

BOM卷算标准工时代码分享原创

迷路的绵羊

4人赞赏了该文章 101次浏览未经作者许可，禁止转载编辑于2024年03月07日 11:07:30

select

(select isnull(sum(bom1activityqty),0.0) from t_YD_BomSelectOPRoute) as 标准加工总工时,

Bom0FMATERIALID as 父项物料内码,

Bom1FMATERIALID as 子项物料内码,

Bom0FMATERIALName as 父项物料名称,

Bom1FMATERIALName as 子项物料内码,

Bom0Leve as 父项BOM层级,

Bom1Leve as 子项BOM层级,

Bom1ACTIVITYQTY as 子项标准工时

from t_YD_BomSelectOPRoute

order by Bom0Leve , Bom0FMATERIALID,bom1leve

select dbo.func_getmaterialactivityqty(106379)

select * from T_BD_MATERIAL

赞 4