Select Coalesce(Sum(Amount), 0) From ( Select Coalesce(AC.OtherCostAmount, 0) As Amount, AC.ID From additionalCosts Ac Join plmJobOrderAd AD On AD.AdditionalCosts_ID=Ac.ID And AD.parent_ID=:OBJID Union Select Coalesce(AC.OtherCostAmount, 0) As Amount, AC.ID From additionalCosts Ac Join plmCooperationAd CAD On CAD.AdditionalCosts_ID=Ac.ID Join plmCooperations C On C.ID=CAD.parent_ID And C.JobOrder_ID=:OBJID Union Select Coalesce(AC.OtherCostAmount, 0) As Amount, AC.ID From additionalCosts Ac Join plmJobOrdersRoutineAd RAD On RAD.AdditionalCosts_ID=Ac.ID Join plmJobOrdersRoutines R On R.ID=RAD.parent_ID Join plmJOOutputItems MI On MI.ID=R.parent_ID Join plmJONodes N On N.ID=MI.Owner_ID And N.Parent_ID=:OBJID ) A
Generated by ABRA Software a.s. 27.10.2021 16:34:49