Objektová akce

Kód:

18

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 = 'A'
               )
      and
      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 and
                           pip.closed = 'N'
               ) 
{ORDER_BY}

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