/*
说明：反查订单号BOM物料预用量。
格式 ：exec pro_BOMFind 开始订单号，结束订单号，物料编号
Author:Sam
Builde Date:2009-04-16
Update Date:
*/
if not exists (select 1 from sysobjects where name ='pro_BOMfind' and type ='P' )
create PROCEDURE pro_BOMFind (
@begin_Odr_NO varchar(20)='%', --开始订单号
@end_odr_no varchar(20)='%', --结束订单号
@matNo varchar(30)='%' -- 物料编号
)
as
begin
select odr_no ,sum(uQty_Qty) as UQty_Qty ,kcdw ,matNo ,mat_NM from odr_sampleBom
where ( odr_no between @begin_odr_no and @end_odr_no ) and matNO like @matNO
group by odr_no,kcdw,matNo,mat_nm
union all
--加工明细材料BOM表。
select r.odr_no,r.plan_qty,r.kcdw,r.matNO_jg ,m.mat_nm from
( select b.odr_no,sum(b.plan_qty) as plan_qty, a.kcdw,b.matNo_jg from odr_sampleBom_jg b ,odr_sampleBom a
where a.flowNo=b.flowNo and ( b.odr_no between @begin_odr_NO and @end_odr_no) and matNO_jg like @matNO
group by b.odr_no,a.kcdw,b.matNO_jg
) r, mat_material m
where r.matNo_jg=m.matNo
end
go
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/729024/viewspace-1020656/ ，如需转载，请注明出处，否则将追究法律责任。
