Objektová akce

Kód:

8

Tělo:

/* OP */
SELECT DISTINCT 'RO', A.ReceivedOrder_ID
FROM IssuedDInvoices A
WHERE (A.ID = :OBJID) AND (A.ReceivedOrder_ID IS NOT NULL)

UNION ALL

/* FV */
SELECT DISTINCT '03', A.PDocument_ID
FROM IssuedDepositUsages A
WHERE (A.DepositDocument_ID = :OBJID) AND (A.PDocumentType = '03')

/* DO */
UNION ALL
SELECT
  DISTINCT 'DO', A.LeftSide_ID
FROM
  Relations A
WHERE
  (A.RightSide_ID = :OBJID) AND (Rel_Def = 1674)

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