CASE WHEN tr.sTrans_Type_CD ='PR' THEN tr.decTrans_Qty WHEN (tr.sTrans_Type_CD = 'PT' AND tr.decTrans_Qty > 0) THEN tr.decTrans_Qty > ELSE 0 >END AS Receipt >