Objektová akce

Kód:

34

Tělo:

SELECT SUM(MDS2.LocalTAmount), 
       0.00
FROM PLMJobOrders JO
JOIN PLMJONodes N ON N.Parent_ID = JO.ID
JOIN PLMJOInputItems MIPL ON MIPL.Owner_ID = N.ID
JOIN PLMMIPLMaterialDistrib MD ON MD.Parent_ID = MIPL.ID
JOIN Storedocuments2 MDS2 ON MD.StoreDocument2_id = MDS2.ID
WHERE
  JO.ID = :OBJID AND
  JO.FinishedAt$Date > 0
UNION ALL
SELECT 0.00, 
       -SUM(RMDS2.LocalTAmount)
FROM PLMJobOrders JO
JOIN PLMJONodes N ON N.Parent_ID = JO.ID
JOIN PLMJOInputItems MIPL ON MIPL.Owner_ID = N.ID
JOIN PLMMIPLRMaterialDistrib RMD ON RMD.Parent_ID = MIPL.ID
JOIN Storedocuments2 RMDS2 ON RMD.StoreDocument2_id = RMDS2.ID
WHERE
  JO.ID = :OBJID AND
  JO.FinishedAt$Date > 0

Generated by ABRA Software a.s. 27.10.2021 16:34:49