Index: src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java
===================================================================
diff -u -rdd0992de00092b0e0a5dddf88e31ee111b94a70f -rdb19ae58166c44fe14a4e5095262b50026db63dc
--- src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java	(.../ReviewDAOImpl.java)	(revision dd0992de00092b0e0a5dddf88e31ee111b94a70f)
+++ src/main/java/com/napa/pulse/dao/impl/ReviewDAOImpl.java	(.../ReviewDAOImpl.java)	(revision db19ae58166c44fe14a4e5095262b50026db63dc)
@@ -2770,11 +2770,11 @@
                     + " SELECT s.site_id, dc.site_id dc_id  ,(select hsnm.HSN_NETWORK_ID from hub_spoke_network_mapping hsnm where  hsnm.is_active = 1 AND hsnm.hsn_site_id = s.site_id) as HSN_NETWORK_ID "
                     + " FROM site s, site dc "
                     + " WHERE s.product_availability_id = dc.product_availability_id "
-                    + " AND s.site_type_code <> 'DC' "
+
                     + " AND dc.site_type_code = 'DC' "
                     + " AND s.active_flag = 'Y' AND dc.active_flag = 'Y' "
-                    + " AND s.virtual_site_flag IS NULL AND dc.virtual_site_flag IS NULL "
 
+
                     + " ) dc ON ss.site_id= dc.site_id "
                     + " JOIN site_product sp ON (sp.site_id = dc.dc_id) "
                     + " WHERE session_id = :sessionId) DC_SAL LEFT OUTER JOIN STORE_SALES_ROLLUP_NEW SSRN ON DC_SAL.DC_ID=SSRN.DC_SITE_ID AND DC_SAL.PRODUCT_ID=SSRN.PRODUCT_ID "