Index: src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java
===================================================================
diff -u -rd310aaf10099a500598d0db16a3b437615c639a9 -rdadb68a28029768be7f775712f9a816754fcd0ab
--- src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java	(.../SessionDAOImpl.java)	(revision d310aaf10099a500598d0db16a3b437615c639a9)
+++ src/main/java/com/napa/pulse/dao/impl/SessionDAOImpl.java	(.../SessionDAOImpl.java)	(revision dadb68a28029768be7f775712f9a816754fcd0ab)
@@ -2029,7 +2029,7 @@
                             "    NVL(a.max_stocking_qty,0) * NVL(c.golden_price,0) - NVL(a.curr_max, 0) * NVL(c.golden_price, 0) else 0 end depthDec\n" +
                             "FROM session_site_product a,  product c\n" +
                             "WHERE session_id = ? AND a.site_id  " + ( onlyForSingleSite ? ( " = " + siteId ) : ( " IN (SELECT site_id FROM session_site WHERE session_Id = " + sessionId + " )" ) ) + "\n" +
-                            "AND a.reviewed " + (reviewOnly ? ("=1") : ("IN (select reviewed from session_site_product where session_id =" +sessionId + ")")) +"  \n" +
+                            "AND (a.reviewed " + (reviewOnly ? ("=1)") : ("IN (select reviewed from session_site_product where session_id =" +sessionId  + ") or reviewed is null or reviewed =0 or reviewed=1 and session_id = "+sessionId  + " )")) +"  \n" +
                             "AND a.product_id = c.product_id)\n" +
                             "group by site_id,site_short_name,session_id)  s \n" +
                             "on (ss.session_id=s.session_id and ss.site_id=s.site_id)\n" +
@@ -2052,9 +2052,9 @@
                 "INNER JOIN PRODUCT P ON SSP.PRODUCT_ID = P.PRODUCT_ID\n" +
                 "INNER JOIN min_max_calc_line cl ON cl.field_abbr = p.field_abbr\n" +
                 "INNER JOIN pulse_config pc ON pc.config_code = 'FILTERS_LEAD_TIME'\n" +
-                "WHERE SSP.SESSION_ID = ?)";
+                "WHERE SSP.SESSION_ID = ? and (SSP.reviewed  "+  (reviewOnly  ? ( "=1))" ) : ("IN (select ssp.reviewed from session_site_product ssp where ssp.session_id = "+sessionId  + ") or ssp.reviewed is null or ssp.reviewed =0 or ssp.reviewed=1 and ssp.session_id = "+sessionId  + " ))"));
         jdbcTemplate.update ( insertTransmissionSQL , sessionId );
-//        System.out.println("inserttransmission" +insertTransmissionSQL);
+//
 
         List<Integer> sites = jdbcTemplate.queryForList ( "SELECT SITE_ID FROM SESSION_SITE WHERE SESSION_ID = ? " ,
                 new Object[]{sessionId} , Integer.class );
@@ -2077,7 +2077,7 @@
                             + " BLOCK_ORDER, BLOCK_RETURN, USER_ID, REASON_ID, FORECAST_MODEL_ID, CLUSTER_PCT_SALE, DC_SALES_LAST_12_MONTHS, "
                             + " DC_SALES_LAST_24_MONTHS, TRANSFER_12_MONTHS, TRANSFER_24_MONTHS, PEER_SALES_12, REVIEWED, FLEET_FLAG, SYSTEM_FLAG, SYSTEM_RECOMMENDED,  "
                             + " EDIT_LINKED_SIM_PROD_ID, SIMILAR_PRODUCT_EDIT, DECLINE_ORDER, DECLINE_RETURN, LAST_SALE_DT, BUSINESS_RULES_APPLIED, HQ_ORDER_QTY, HQ_KEEP_QTY,ORG_MIN_STOCKING_QTY,ORG_MAX_STOCKING_QTY "
-                            + " from session_site_product where site_Id = ? and session_id = ? and reviewed "+  (reviewOnly ? (" =1) ") : ("IN (select reviewed from session_site_product where session_id =" +sessionId  + ") or reviewed is null or reviewed =0 or reviewed=1 )") ), s , sessionId ) ;
+                            + " from session_site_product where site_Id = ? and session_id = ? and (reviewed "+  (reviewOnly ? (" =1)) ") : ("IN (select reviewed from session_site_product where session_id =" +sessionId  + ") or reviewed is null or reviewed =0 or reviewed=1 and session_id = "+sessionId  + " ))") ), s , sessionId ) ;
 
         }