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