Objektová akce

Kód:

1

Tělo:

SELECT 
  SUM(VR2.quantity)
FROM 
  storedocuments2 DL2, 
  storedocuments2 VR2, 
  cashreceived2 CR2
WHERE 
  (CR2.id = :OBJID) AND 
  (CR2.providerow_id = DL2.id) AND 
  (VR2.rdocumentrow_id = DL2.id) AND
  (VR2.id NOT IN (SELECT providerow_id FROM issuedcreditnotes2))

UNION ALL

SELECT 
  VR2.quantity
FROM 
  storedocuments2 DL2, 
  storedocuments2 VR2,  
  cashreceived2 CR2,
  issuedcreditnotes2 DV2 
WHERE 
  (CR2.id = :OBJID) AND 
  (CR2.providerow_id = DL2.id) AND 
  (VR2.rdocumentrow_id = DL2.id) AND 
  ((DV2.providerow_id = VR2.id) AND (DV2.rsource_id = CR2.id))

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