0030563: Loaded product characteristic values of products that are not in the webpos database.

diff -r 81c382043bba src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java
--- a/src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java	Tue Sep 29 13:46:40 2015 +0200
+++ b/src/org/openbravo/retail/posterminal/master/ProductCharacteristicValue.java	Wed Sep 30 11:20:41 2015 +0200
@@ -42,15 +42,15 @@
   protected List<String> getQuery(JSONObject jsonsent) throws JSONException {
     String orgId = OBContext.getOBContext().getCurrentOrganization().getId();
     final OBRETCOProductList productList = POSUtils.getProductListByOrgId(orgId);
-    
+
     final Date terminalDate = OBMOBCUtils.calculateServerDate(jsonsent.getJSONObject("parameters")
-            .getString("terminalTime"),
-            jsonsent.getJSONObject("parameters").getJSONObject("terminalTimeOffset").getLong("value"));
-    
+        .getString("terminalTime"),
+        jsonsent.getJSONObject("parameters").getJSONObject("terminalTimeOffset").getLong("value"));
+
     final PriceList priceList = POSUtils.getPriceListByOrgId(orgId);
     final PriceListVersion priceListVersion = POSUtils.getPriceListVersionByOrgId(orgId,
         terminalDate);
-    
+
     List<String> hqlQueries = new ArrayList<String>();
 
     HQLPropertyList regularProductsCharacteristicHQLProperties = ModelExtensionUtils
@@ -63,8 +63,9 @@
             + "where pcv.product.id in (select product.id from OBRETCO_Prol_Product assort where obretcoProductlist.id= '"
             + productList.getId()
             + "') "
-            + "AND exists (select 1 from PricingProductPrice ppp,PricingPriceListVersion pplv WHERE (pplv.id='"+ priceListVersion.getId() 
-            +"') AND (ppp.priceListVersion.id = pplv.id) AND (ppp.product.id=pcv.product.id) ) "
+            + "AND exists (select 1 from PricingProductPrice ppp WHERE (ppp.priceListVersion.id='"
+            + priceListVersion.getId()
+            + "') AND (ppp.product.id=pcv.product.id) ) "
             + "and $naturalOrgCriteria and $readableSimpleClientCriteria and (pcv.$incrementalUpdateCriteria"
             + "OR pcv.characteristic.$incrementalUpdateCriteria OR pcv.characteristicValue.$incrementalUpdateCriteria)");