Objektová akce

Kód:

12

Tělo:

/* OP */  
SELECT 
  DISTINCT 'RO', B.Provide_ID
FROM
  IssuedInvoices2 A join
  StoreDocuments2 B on B.ID = A.ProvideRow_ID
WHERE
  A.Parent_ID = :OBJID AND
  B.Provide_ID IS NOT NULL

/* DV */  
UNION ALL
SELECT 
  DISTINCT '60', A.Parent_ID
FROM
  IssuedCreditNotes2 A 
WHERE
  A.RSourceParent_ID = :OBJID
  
/* DZLV */  
UNION ALL
SELECT
  DISTINCT '62', A.VATDeposit_ID
FROM
  IssuedInvoices2 A
WHERE
  A.Parent_ID = :OBJID and
  not VATDEPOSIT_ID = '0000000000'    
  
/* ZL */
UNION ALL
SELECT
  DISTINCT '10', A.DepositDocument_ID
FROM
  IssuedDepositUsages A
WHERE
  (A.PDocument_ID = :OBJID) AND (PDocumentType = '03')
/* DO */
UNION ALL
SELECT
  DISTINCT 'DO', A.LeftSide_ID
FROM
  Relations A
WHERE
  (A.RightSide_ID = :OBJID) AND (Rel_Def = 1670)
  
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='03' AND PO3.PDocument_ID=:OBJID))   

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='03' AND PO3.PDocument_ID=:OBJID)           

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