Objektová akce

Kód:

11

Tělo:

SELECT 
  DISTINCT 'RO', A.Provide_ID
FROM
  StoreDocuments2 A
WHERE
  A.Parent_ID = :OBJID AND
  A.Provide_ID IS NOT NULL

UNION ALL

SELECT 
  DISTINCT '03', A.Parent_ID
FROM
  IssuedInvoices2 A
WHERE
  A.Provide_ID = :OBJID

UNION ALL

SELECT 
  DISTINCT '05', A.Parent_ID
FROM
  CashReceived2 A
WHERE
  A.Provide_ID = :OBJID

UNION ALL

/* vratky */
SELECT 
  DISTINCT '23', A.ID
FROM
  StoreDocuments A
WHERE
  A.RDocument_ID = :OBJID
  

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