Sales Order Detail - Source code

/* ***** Source for query: SalesOrder ***** */

SELECT SOH.SalesOrderNumber, S.Name AS Store, SOH.OrderDate, C.FirstName AS SalesFirstName, C.LastName AS SalesLastName, E.Title AS SalesTitle,
SOH.PurchaseOrderNumber, SM.Name AS ShipMethod, BA.AddressLine1 AS BillAddress1, BA.AddressLine2 AS BillAddress2, BA.City AS BillCity,
BA.PostalCode AS BillPostalCode, BSP.Name AS BillStateProvince, BCR.Name AS BillCountryRegion,
SA.AddressLine1 AS ShipAddress1, SA.AddressLine2 AS ShipAddress2, SA.City AS ShipCity, SA.PostalCode AS ShipPostalCode,
SSP.Name AS ShipStateProvince, SCR.Name AS ShipCountryRegion, CC.Phone AS CustPhone,
CC.FirstName AS CustFirstName, CC.LastName AS CustLastName
FROM Person.Address SA INNER JOIN
Person.StateProvince SSP ON SA.StateProvinceID = SSP.StateProvinceID INNER JOIN
Person.CountryRegion SCR ON SSP.CountryRegionCode = SCR.CountryRegionCode RIGHT OUTER JOIN
Sales.SalesOrderHeader SOH LEFT OUTER JOIN
Person.Contact CC ON SOH.ContactID = CC.ContactID LEFT OUTER JOIN
Person.Address BA INNER JOIN
Person.StateProvince BSP ON BA.StateProvinceID = BSP.StateProvinceID INNER JOIN
Person.CountryRegion BCR ON BSP.CountryRegionCode = BCR.CountryRegionCode ON SOH.BillToAddressID = BA.AddressID ON
SA.AddressID = SOH.ShipToAddressID LEFT OUTER JOIN
Person.Contact C RIGHT OUTER JOIN
HumanResources.Employee E ON C.ContactID = E.ContactID ON SOH.SalesPersonID = E.EmployeeID LEFT OUTER JOIN
Purchasing.ShipMethod SM ON SOH.ShipMethodID = SM.ShipMethodID LEFT OUTER JOIN
Sales.Store S ON SOH.CustomerID = S.CustomerID
WHERE (SOH.SalesOrderNumber = @SalesOrderNumber)

/* ***** Source for query: SalesOrderDetail ***** */

SELECT SOD.SalesOrderDetailID, SOD.OrderQty, SOD.UnitPrice,
CASE WHEN SOD.UnitPriceDiscount IS NULL THEN 0 ELSE SOD.UnitPriceDiscount END AS UnitPriceDiscount,
SOD.LineTotal, SOD.CarrierTrackingNumber, SOD.SalesOrderID, P.Name, P.ProductNumber
FROM Sales.SalesOrderDetail SOD INNER JOIN
Production.Product P ON SOD.ProductID = P.ProductID INNER JOIN
Sales.SalesOrderHeader SOH ON SOD.SalesOrderID = SOH.SalesOrderID
WHERE (SOH.SalesOrderNumber = @SalesOrderNumber)
ORDER BY SOD.SalesOrderDetailID