领料套数计算公式

select freplacegroup,min((FBASEPICKEDQTY+FBASEREPICKEDQTY-FBASESCRAPQTY-FBASEGOODRETURNQTY-FBASEINCDEFECTRETURNQTY-FBASEPRCDEFECTRETURNQTY)*FBASEDENOMINATOR 

/a.FBASENUMERATOR )  

from  T_PRD_PPBOMentry a 

inner join T_PRD_PPBOMENTRY_q b on a.fentryid=b.fentryid 

inner join T_PRD_PPBOM t on a.fid=t.FID

w