Index: src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java
===================================================================
diff -u -r9ffbafd9a6c2fba110441f7a50b87ff64cf013ee -re842cca0d4cce17fcfdd82a738d376a072c4d787
--- src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java	(.../ReviewDAOImpl.java)	(revision 9ffbafd9a6c2fba110441f7a50b87ff64cf013ee)
+++ src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java	(.../ReviewDAOImpl.java)	(revision e842cca0d4cce17fcfdd82a738d376a072c4d787)
@@ -2777,7 +2777,7 @@
                     + " nvl(hub.sim_hub_part_ct,0) as \"hubSimPartsCount\", SSP.DECLINE_ORDER as \"declineOrder\", SSP.DECLINE_RETURN as \"declineReturn\", "
                     + " TO_CHAR(CAST(ssp.last_sale_dt AS TIMESTAMP WITH TIME ZONE), 'YYYY-MM-DD\"T\"HH24:MI:SS.FF3TZHTZM') as \"lastSaleDate\", "
                     + " REGEXP_REPLACE(ssp.BUSINESS_RULES_APPLIED, '(.)(.)(.)', '\\1,\\2,\\3') as \"ruleInfo\", "
-                    + " (CASE WHEN REASON_ID = 8 THEN 1 ELSE 0 END) as \"isNewNumber\",dcWideSales12, dcWideSales24 , hubDemand12 as \"hubDemand12\", hubDemand24 as \"hubDemand24\" ,hub_min_gtr_0 as \"hub_min_gtr_0\"" + " FROM "
+                    + " (CASE WHEN REASON_ID = 8 THEN 1 ELSE 0 END) as \"isNewNumber\",dcWideSales12, dcWideSales24 , hubDemand12 as \"hubDemand12\", hubDemand24 as \"hubDemand24\" ,hub_min_gtr_0 as \"hubSiteCount\"" + " FROM "
                     + (isFinalized ? " SESSION_SITE_PRODUCT_FINALIZED " : " SESSION_SITE_PRODUCT ")
                     + " SSP INNER JOIN PRODUCT P ON SSP.PRODUCT_ID = P.PRODUCT_ID "
                     + " INNER JOIN SITE S ON S.SITE_ID = SSP.SITE_ID "
@@ -2901,7 +2901,7 @@
                         + " (case when fh.isFleet is not null then 1 else null end) as \"isFleetSku\", nvl(sim.sim_part_ct,0) as \"siteSimPartsCount\", "
                         + " nvl(hub.sim_hub_part_ct,0) as \"hubSimPartsCount\",0 as \"declineOrder\", 0 as \"declineReturn\", "
                         + " TO_CHAR(CAST(last_sale_dt AS TIMESTAMP WITH TIME ZONE), 'YYYY-MM-DD\"T\"HH24:MI:SS.FF3TZHTZM') as \"lastSaleDate\", "
-                        + " REGEXP_REPLACE(BUSINESS_RULES_APPLIED, '(.)(.)(.)', '\\1,\\2,\\3') as \"ruleInfo\", 0 as \"isNewNumber\" , NULL as dcWideSales12, NULL as dcWideSales24 ,  NULL as \"hubDemand12\",   NULL as \"hubDemand24\" ,   0 as \"hub_min_gtr_0\""
+                        + " REGEXP_REPLACE(BUSINESS_RULES_APPLIED, '(.)(.)(.)', '\\1,\\2,\\3') as \"ruleInfo\", 0 as \"isNewNumber\" , NULL as dcWideSales12, NULL as dcWideSales24 ,  NULL as \"hubDemand12\",   NULL as \"hubDemand24\" ,   0 as \"hubSiteCount\""
                         + " FROM (select site_id, product_id, level4_parent_id, SOLD_LAST_12_MONTHS, SOLD_LAST_24_MONTHS, LOST_SALES_12_MONTHS, LOST_SALES_24_MONTHS, DC_SALES_LAST_12_MONTHS, DC_SALES_LAST_24_MONTHS, "
                         + " ON_HAND, MIN_STOCKING_QTY, MAX_STOCKING_QTY, INITIAL_STOCK_AMOUNT, VIO, PCT_MARKET, INITIAL_STOCKING_DT, OCCURANCE_12_MONTHS, OCCURANCE_24_MONTHS, DISPLAY_QTY, KEEP_FLAG, CLASS, "
                         + " CLUSTER_PCT_SALE, TRANSFER_12_MONTHS, TRANSFER_24_MONTHS, SUPERSEDE_12_MONTHS, SUPERSEDE_24_MONTHS, PEER_SALES_12, PTS, block_order, 0 as DECLINE_ORDER,  0 as DECLINE_RETURN, "