select s.Item, s.Loc, SUM (s.OH + s.UDC_ActualIT + s.UDC_CommitIT - s.UDC_AllCustOrd  s.UDC_ADJ_AvgDailyDmd*(p.DRPCovDur/1440) - s.UDC_SafetyStock)
as NetNeed from SKU s, SKUPlanningParam p where s.Item = p.Item and s.Loc = p.Loc group by s.Item, s.Loc