SELECT -- TOP 100
       [prh].[No_] AS [kupivip_incomes_marking_id]

/* , [prh].[Order No_]
     , [prh].[Order Date]
     , [prh].[Posting Date]
     , [prh].[Vendor Order No_]
     , [prh].[Campaign No_]*/

     , [prl].[Line No_] AS [kupivip_incomes_marking_line_id]
     , [prl].[No_] AS [kupivip_products_code]
     , [prl].[Variant Code] AS [kupivip_variants_code]
     , [prl].[Quantity] AS [cnt]
     , [prl].[Unit Cost]
     , [ve].[Document Type]
     , [ile].[Lot No_]
     , CAST([ve].[Cost Amount (Actual)] AS DECIMAL(15, 2)) AS [products_cost]
FROM
     [dbo].[Privat Trade$Purch_ Rcpt_ Header](NOLOCK) AS [prh]
     JOIN [dbo].[Privat Trade$Purch_ Rcpt_ Line](NOLOCK) AS [prl]
         ON [prl].[Document No_] = [prh].[No_]
     LEFT JOIN [dbo].[Privat Trade$Value Entry](NOLOCK) AS [ve]
         ON [ve].[Document Line No_] = [prl].[Line No_]
            AND [ve].[Document No_] = [prl].[Document No_]
            AND [ve].[Document Type] = 5
     LEFT JOIN [dbo].[Privat Trade$Item Ledger Entry](NOLOCK) AS [ile]
         ON [ile].[Entry No_] = [ve].[Item Ledger Entry No_]
WHERE 1 = 1
      AND [prh].[No_] = 'PPR20-032206'
      AND [prh].[Lot No_] = 'NO_LOT'
      AND [prh].[Store No_] = 'MAMSY';