0041340: Multiple joins when loading a verified return

# HG changeset patch
# User Rafael Queralta <rafaelcuba81@gmail.com>
# Date 1563441813 14400
#      Thu Jul 18 05:23:33 2019 -0400
# Node ID a2be3012b470ec4cb212194adb74a8f05de6ed3d
# Parent  f4e7b6c23d6cee16ddebe74f272a2b6ac18d23b0
Fixed issue 41340: Multiple joins when loading a verified return

- Removed unnecessary joins

diff --git a/src/org/openbravo/retail/posterminal/PaidReceipts.java b/src/org/openbravo/retail/posterminal/PaidReceipts.java
--- a/src/org/openbravo/retail/posterminal/PaidReceipts.java
+++ b/src/org/openbravo/retail/posterminal/PaidReceipts.java
@@ -208,8 +208,8 @@
 
           if (paidReceiptLine.has("goodsShipmentLine")
               && !paidReceiptLine.getString("goodsShipmentLine").equals("null")) {
-            String hqlShipLines = "select ordLine.goodsShipmentLine.salesOrderLine.salesOrder.documentNo, ordLine.goodsShipmentLine.salesOrderLine.id "
-                + "from OrderLine as ordLine where ordLine.id = :lineId ";
+            String hqlShipLines = "select retOrdLine.salesOrder.documentNo, retOrdLine.id "
+                + "from OrderLine as ordLine join ordLine.goodsShipmentLine.salesOrderLine as retOrdLine where ordLine.id = :lineId ";
             OBDal.getInstance().getSession().createQuery(hqlShipLines);
             Query<Object[]> shipLines = OBDal.getInstance()
                 .getSession()