Common Table Expressions - multiple references to the same CTE

cte_1.sql

WITH 
  ProductQty (PID, LID, Shelf, Bin, Qty) AS
  (SELECT 
    ProductId, LocationId, Shelf, Bin, Quantity
  FROM
    Production.ProductInventory)
  
SELECT 
  p1.PID,
  SUM(p1.Qty) AS ShelfQty_A,
  SUM(p2.Qty) AS ShelfQty_B

FROM
  ProductQty AS p1
  
  INNER JOIN
    ProductQty AS p2
      ON
        p1.PID = p2.PID

WHERE 
  p1.Shelf = 'A' AND
  p2.Shelf = 'B'

GROUP BY
  p1.PID;