Objektová akce

Kód:

3

Tělo:

SELECT DISTINCT
  '07', CR2.parent_id
FROM
  refundedcashreceived2 CR2,
  storedocuments SD,
  storedocuments2 SD2
WHERE
  ((SD.id = :OBJID) AND
  (SD2.parent_id = SD.id) AND
  (CR2.providerow_id IN (SELECT id FROM storedocuments2 WHERE (parent_id = SD.id))))

UNION ALL

SELECT DISTINCT
  '60', II2.parent_id
FROM
  issuedcreditnotes2 II2,
  storedocuments SD,
  storedocuments2 SD2
WHERE
  ((SD.id = :OBJID) AND
  (SD2.parent_id = SD.id) AND
  (II2.providerow_id IN (SELECT id FROM storedocuments2 WHERE (parent_id = SD.id))))

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