Objektová akce

Kód:

19

Tělo:

SELECT {FIELDS} 
FROM MainInvProtocolPositions A 
JOIN LOGSTOREPOSITIONS SP on SP.ID = A.StorePosition_ID 
WHERE A.Parent_ID =:OBJID and a.closed = 'N' and  
(      a.ID in (select pipr.MIPPosition_id
                 from partialinvprotocols pip
                 join partialinvprotocolPositions pipr on pipr.parent_id = pip.id
                 where pip.mainprotocol_id = a.parent_id and
                       pip.closed = 'N'
               )
      Or
      a.id not in (select pipr.MIPPosition_id
                     from partialinvprotocols pip
                     join partialinvprotocolPositions pipr on pipr.parent_id = pip.id
                     where pip.mainprotocol_id = a.parent_id
               )
)
{ORDER_BY}

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