Třídová akce

Kód:

17

Tělo:

SELECT
  RPL.StoreCard_ID,
  RPL.SupposedStore_ID,
  RPL.Quantity,
  RPL.Issue
FROM
  PLMPieceLists PL
  join PLMPieceLists2 RPL on PL.ID = RPL.Parent_ID
WHERE
  PL.Revision = (
    Select
      Max(PLI.Revision)
    From
      PLMPieceLists PLI
    Where
      (PLI.StoreCard_ID = PL.StoreCard_ID)
  ) and
  PL.StoreCard_ID = :RootStoreCard_ID

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