Objektová akce

Kód:
3
Tělo:
/* Skladové doklady */
SELECT DISTINCT SD.DocumentType, SD.ID
FROM PickingLists2 PL2
JOIN StoreDocuments SD on SD.ID = PL2.Provide_ID
WHERE PL2.Parent_ID = :OBJID
  
/* Expediční listy */
UNION ALL
SELECT DISTINCT 'EL', SL2.Parent_ID
FROM PickingLists2 PL2
JOIN ShippingLists2 SL2 ON SL2.ProvideRow_ID = PL2.ProvideRow_ID
WHERE PL2.Parent_ID = :OBJID

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