Objektová akce

Kód:

8

Tělo:

/* OP */  
SELECT 
  DISTINCT 'RO', B.Provide_ID
FROM
  CashReceived2 A join
  StoreDocuments2 B on B.ID = A.ProvideRow_ID
WHERE
  A.Parent_ID = :OBJID AND
  B.Provide_ID IS NOT NULL
  
/* VPP */  
UNION ALL
SELECT 
  DISTINCT '07', A.Parent_ID
FROM
  RefundedCashReceived2 A 
WHERE
  A.RSourceParent_ID = :OBJID
  

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