Objektová akce

Kód:

21

Tělo:

SELECT 1 
FROM GlobData 
WHERE EXISTS (
  SELECT 1
  FROM IssuedInvoices A
  JOIN IssuedInvoices2 A2 ON A2.Parent_ID = A.ID
  LEFT JOIN StoreCardDRCArticles SCDA ON SCDA.Parent_ID = A2.StoreCard_ID 
    AND SCDA.Country_ID = A.VATCountry_ID AND SCDA.DRCVATMode = 'A'
  LEFT JOIN VATIssuedDInvoices2 VIDI2 ON VIDI2.ID = A2.VATDepositRow_ID 
  WHERE A.ID = :OBJID
    AND COALESCE(VIDI2.DRCArticle_ID, SCDA.DRCArticle_ID, A2.DRCArticle_ID) IS NOT NULL
)

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