Objektová akce

Kód:

1

Tělo:

SELECT  
  (CASE LinkSourceType
  WHEN '  ' THEN
    (SELECT Code || ' ' || Name FROM Firms WHERE ID = :LinkSourcePK)
  WHEN '03' THEN  
    (SELECT B.Code || '-' || CAST(A.OrdNumber AS VARCHAR(10)) ||  '/' || C.Code FROM IssuedInvoices A, DocQueues B, Periods C WHERE A.DocQueue_ID=B.ID AND A.Period_ID=C.ID AND A.ID = :LinkSourcePK)
  ELSE
    ''
  END) DisplayName
  FROM
    PayReminderSetExclusions 
  WHERE
    ID = :OBJID      

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