SELECT     p.stockcode,
           p.contracttype   AS contract,
           p.fixedprice     AS price,
           p.customerbuygrp AS customer,
           p.fixeduom       AS uom,
           a.shiptoaddr1,
           a.shiptoaddr2,
           a.shiptoaddr3,
           a.shiptoaddr4,
           a.shiptoaddr5,
           a.shippostalcode,
           (
                  SELECT Sum(morderqty)
                  FROM   sordetail
                  WHERE  salesorder = @SalesOrder
                  AND    mstockcode = p.stockcode) AS orderqty,
           i.description                           AS stockdes,
           i.warehousetouse                        AS warehouse
FROM       sorcontractprice                        AS p
INNER JOIN arcustomer                              AS a
ON         a.customer = p.customerbuygrp
INNER JOIN invmaster i
ON         p.stockcode = i.stockcode
WHERE      (
                      p.contracttype = 'C'
           AND        p.customerbuygrp =
                      (
                             SELECT customer
                             FROM   sormaster
                             WHERE  salesorder = @SalesOrder))
OR         (
                      p.contracttype = 'B'
           AND        p.customerbuygrp IN
                      (
                             SELECT buyinggroup1
                             FROM   arcustomer
                             WHERE  customer =
                                    (
                                           SELECT customer
                                           FROM   sormaster
                                           WHERE  salesorder = @SalesOrder))