Objektová akce

Kód:

8

Tělo:

/* VR */
SELECT 
  DISTINCT '23', A.Provide_ID
FROM
  IssuedCreditNotes2 A
WHERE
  A.Parent_ID = :OBJID AND
  A.Provide_ID IS NOT NULL
  
/* FV */
UNION ALL
SELECT 
  DISTINCT '03', A.RSourceParent_ID
FROM
  IssuedCreditNotes2 A
WHERE
  A.Parent_ID = :OBJID
  
UNION ALL

/* Plat. prikaz */
SELECT distinct '18', PO.ID
FROM PaymentOrders PO
WHERE PO.ID IN (SELECT PO2.Parent_ID 
  FROM PaymentOrders2 PO2
  WHERE PO2.ID IN (SELECT PO3.Parent_ID 
    FROM PaymentOrders3 PO3
    WHERE PO3.PDocumentType='60' AND PO3.PDocument_ID=:OBJID))  
  
/* DO */
UNION ALL
SELECT
  DISTINCT 'DO', A.LeftSide_ID
FROM
  Relations A
WHERE
  (A.RightSide_ID = :OBJID) AND (Rel_Def = 1672) 
  
union all
/* Žádosti plat. prikazů */    
SELECT distinct 'PO', PO2.ID
  FROM PaymentOrders2 PO2
  WHERE
    PO2.parent_id is null AND
    PO2.ID IN (SELECT PO3.Parent_ID
    FROM PaymentOrders3 PO3
    WHERE PO3.PDocumentType='60' AND PO3.PDocument_ID=:OBJID)   

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