Objektová akce

Kód:

4

Tělo:

/* Prijemky */
SELECT 
  DISTINCT '20', B.Parent_ID
FROM
  IssuedOrders2 A
  JOIN StoreDocuments2 B ON A.ID = B.ProvideRow_ID
  JOIN StoreDocuments SD ON SD.ID = B.Parent_ID
WHERE
  A.Parent_ID = :OBJID AND
  SD.DocumentType = '20' AND
  B.ProvideRowType = 'IO'
  
UNION ALL

select distinct 'RO', RO2.Parent_ID
from ReceivedOrdersToIssuedOrders A
join IssuedOrders2 IO2 on IO2.ID = A.Target_ID
join ReceivedOrders2 RO2 on RO2.ID = A.Source_ID
where IO2.Parent_ID = :OBJID 

UNION ALL

/* ZLP */
SELECT DISTINCT '11', A.ID
FROM 
  ReceivedDInvoices A
WHERE 
  A.IssuedOrder_ID = :OBJID  

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