Objektová akce

Kód:

7

Tělo:

/* Nabidky vydane. */
SELECT 
  DISTINCT 'IF', A.Provide_ID
FROM
  ReceivedOrders2 A
WHERE
  A.Parent_ID = :OBJID AND
  A.Provide_ID IS NOT NULL AND
  A.Revided_ID IS NULL

UNION ALL

/* Dodaci listy */
SELECT 
  DISTINCT '21', B.Parent_ID
FROM
  ReceivedOrders2 A
  JOIN StoreDocuments2 B ON A.ID = B.ProvideRow_ID
  JOIN StoreDocuments SD ON SD.ID = B.Parent_ID
WHERE
  A.Parent_ID = :OBJID AND
  SD.DocumentType = '21' 

UNION ALL

/* Faktury vydane */
SELECT 
  DISTINCT '03', C.Parent_ID
FROM
  ReceivedOrders2 A
  JOIN StoreDocuments2 B ON A.ID = B.ProvideRow_ID
  JOIN IssuedInvoices2 C ON B.ID = C.ProvideRow_ID
WHERE
  A.Parent_ID = :OBJID
 
UNION ALL

/* Pokladni prijmy */
SELECT 
  DISTINCT '05', C.Parent_ID
FROM
  ReceivedOrders2 A
  JOIN StoreDocuments2 B ON A.ID = B.ProvideRow_ID
  JOIN CashReceived2 C ON B.ID = C.ProvideRow_ID
WHERE
  A.Parent_ID = :OBJID
  
UNION ALL
  
/* ZLV */
SELECT DISTINCT 
  '10', A.ID
FROM 
  IssuedDInvoices A
WHERE 
  A.ReceivedOrder_ID = :OBJID

UNION ALL
    
/* Prevodky vydej */
SELECT DISTINCT
  '22', B.ID
FROM
  StoreDocuments2 A
  JOIN StoreDocuments B ON B.ID = A.Parent_ID
WHERE
  (A.Provide_ID = :OBJID)
  AND (B.DocumentType = '22')
  
union all

select distinct 'IO', IO2.Parent_ID
from ReceivedOrdersToIssuedOrders A
join IssuedOrders2 IO2 on IO2.ID = A.Target_ID
join ReceivedOrders2 RO2 on RO2.ID = A.Source_ID
where RO2.Parent_ID = :OBJID
  
UNION ALL
    
/* Prijemky */
SELECT DISTINCT
  '20', B.ID
FROM
  StoreDocuments2 A
  JOIN StoreDocuments B ON B.ID = A.Parent_ID
WHERE
  (A.Provide_ID = :OBJID)
  AND (B.DocumentType = '20')
  AND (A.ProvideRowType='RO')

UNION ALL 
  
/* Odeslana Posta */  
SELECT 
  DISTINCT 'P0', A.LeftSide_ID
FROM
  Relations A 
WHERE
  A.RightSide_ID = :OBJID AND
  A.Rel_Def = 1431
     

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