BOM卷算标准工时代码分享

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层级,

Bom1ACT