supersobbie sql

SELECT COUNT(*)
  FROM    (   DWGEN.HVAC_ORDER_HEADER_VW HVAC_ORDER_HEADER_VW
           INNER JOIN
              DWGEN.HVAC_ORDER_ITEMS_VW HVAC_ORDER_ITEMS_VW
           ON (HVAC_ORDER_HEADER_VW.HBOH_PLANT_NO =
                  HVAC_ORDER_ITEMS_VW.HBOI_PLANT_NO))
       INNER JOIN
          DWGEN.HVAC_INVENT_MASTER_VW HVAC_INVENT_MASTER_VW
       ON (HVAC_INVENT_MASTER_VW.HBIM_PLANT_NO =
              HVAC_ORDER_HEADER_VW.HBOH_PLANT_NO)
 WHERE     (HVAC_INVENT_MASTER_VW.HBIM_PLANT_NO = 111)
       AND (HVAC_ORDER_ITEMS_VW.HBOI_PLANT_NO = 111)
       AND (HVAC_INVENT_MASTER_VW.HBIM_PROD_CODE IN (955, 912))
       AND (HVAC_ORDER_HEADER_VW.HBOH_ORDER_STATUS = 2)
       AND (HVAC_ORDER_HEADER_VW.HBOH_ORDER_NO <= 900000)
       AND (HVAC_ORDER_HEADER_VW.HBOH_MFG_PLANT = 111)
       AND (HVAC_ORDER_HEADER_VW.HBOH_EST_SHP_DATE <
               ( SELECT SYSDATE +35  FROM DUAL ) );