SELECT   s.NAME , uo.NAME unit_name,
            bac.date_stamp AS date_stamp,       
            (SELECT ROUND (  (TO_NUMBER (suoipi1.data_item) + 32.0 / 1.8) / (1. / 1.8),2)
               FROM fv_site_user_object_item_prod suoipi1,
                    fv_variable dp,
                    fv_variable_desc vd
              WHERE suoipi1.data_point_id = dp.variable_id
                AND suoipi1.site_id = s.site_id
                AND (    dp.variable_id_string = vd.variable_id_string
                     AND vd.long_name = 'Max Ambient Temp'
                     AND vd.VERSION = '1-1-2'
                    )
                AND suoipi1.site_id = s.site_id
                AND suoipi1.date_stamp = bac.date_stamp
                AND suoipi1.site_user_object_id = uo.site_user_object_id
                AND suoipi1.data_item IS NOT NULL) MaxAmbientTemp,
            (SELECT ROUND ( (TO_NUMBER (suoipi1.data_item) + 32.0 / 1.8) / (1. / 1.8),2)
               FROM fv_site_user_object_item_prod suoipi1,
                    fv_variable dp,
                    fv_variable_desc vd
              WHERE suoipi1.data_point_id = dp.variable_id
                AND suoipi1.site_id = s.site_id
                AND (    dp.variable_id_string = vd.variable_id_string
                     AND vd.long_name = 'Min Ambient Temp'
                     AND vd.VERSION = '1-1-2'
                    )
                AND suoipi1.site_id = s.site_id
                AND suoipi1.date_stamp = bac.date_stamp
                AND suoipi1.site_user_object_id = uo.site_user_object_id
                AND suoipi1.data_item IS NOT NULL) MinAmbientTemp ,
--           (SELECT   to_number(( suoipi1.data_item*24)) 
--               FROM fv_site_user_object_item_prod suoipi1,
--                    fv_variable dp,
--                    fv_variable_desc vd
--              WHERE suoipi1.data_point_id = dp.variable_id
--                AND suoipi1.site_id = s.site_id
--                AND (    dp.variable_id_string = vd.variable_id_string
--                     AND vd.long_name = 'Max Ambient Temp Reading Time'
--                    AND vd.VERSION = '1-1-2'
--                    )
--                AND suoipi1.site_id = s.site_id
--                AND suoipi1.date_stamp = bac.date_stamp
--                AND suoipi1.site_user_object_id = uo.site_user_object_id
--                AND suoipi1.data_item IS NOT NULL) Max_Ambient_time  ,
              (SELECT   to_char(to_date(( suoipi1.data_item)*24, 'HH24.MI'), 'HH:MI:SS AM') 
               FROM fv_site_user_object_item_prod suoipi1,
                    fv_variable dp,
                    fv_variable_desc vd
              WHERE suoipi1.data_point_id = dp.variable_id
                AND suoipi1.site_id = s.site_id
                AND (    dp.variable_id_string = vd.variable_id_string
                     AND vd.long_name = 'Min Ambient Temp Reading Time'
                    AND vd.VERSION = '1-1-2'
                    )
                AND suoipi1.site_id = s.site_id
                AND suoipi1.date_stamp = bac.date_stamp
                AND suoipi1.site_user_object_id = uo.site_user_object_id
                AND suoipi1.data_item IS NOT NULL) Min_Ambient_time    ,
            (SELECT distinct(suoipi1.data_item)
               FROM fv_site_user_object_item_prod suoipi1,
                    fv_variable dp,
                    fv_variable_desc vd
              WHERE suoipi1.data_point_id = dp.variable_id
                AND suoipi1.site_id = s.site_id
                AND (    dp.variable_id_string = vd.variable_id_string
                     AND vd.long_name = 'Chemical Name'
                     AND vd.VERSION = '1-1-2'
                    )
                AND suoipi1.site_id = s.site_id
                AND suoipi1.date_stamp = bac.date_stamp
                AND suoipi1.site_user_object_id = uo.site_user_object_id
                AND suoipi1.data_item IS NOT NULL) Chem_name,
           (SELECT distinct(suoipi1.data_item)
               FROM fv_site_user_object_item_prod suoipi1,
                    fv_variable dp,
                    fv_variable_desc vd
              WHERE suoipi1.data_point_id = dp.variable_id
                AND suoipi1.site_id = s.site_id
                AND (    dp.variable_id_string = vd.variable_id_string
                     AND vd.long_name = 'Consumption'
                     AND vd.VERSION = '1-1-2'
                    )
                AND suoipi1.site_id = s.site_id
                AND suoipi1.date_stamp = bac.date_stamp
                AND suoipi1.site_user_object_id = uo.site_user_object_id
                AND suoipi1.data_item IS NOT NULL) Consumption_UnitKG,
           (SELECT distinct(suoipi1.data_item)
               FROM fv_site_user_object_item_prod suoipi1,
                    fv_variable dp,
                    fv_variable_desc vd
              WHERE suoipi1.data_point_id = dp.variable_id
                AND suoipi1.site_id = s.site_id
                AND (    dp.variable_id_string = vd.variable_id_string
                     AND vd.long_name = 'Stock'
                     AND vd.VERSION = '1-1-2'
                    )
                AND suoipi1.site_id = s.site_id
                AND suoipi1.date_stamp = bac.date_stamp
                AND suoipi1.site_user_object_id = uo.site_user_object_id
                AND suoipi1.data_item IS NOT NULL) Stock_UnitKG                                      
       FROM fv_site s, fv_site_user_objects uo, fv_battery_app_calc bac
      WHERE s.site_id = bac.site_id
        AND s.site_id = '123-123-101'
        AND uo.site_id = s.site_id
        AND ( uo.NAME = 'Ambient Temperature' OR uo.NAME = 'Chemical 1'OR uo.NAME = 'Chemical 2' OR uo.NAME = 'Chemical 3' OR uo.NAME = 'Chemical 4' OR uo.NAME = 'Chemical 5' OR uo.NAME = 'Chemical 6' OR uo.NAME = 'Chemical 7'
              OR uo.NAME = 'Chemical 8' OR uo.NAME = 'Chemical 9' OR uo.NAME = 'Chemical 10')
        AND bac.date_stamp = '23-OCT-2015'
   ORDER BY uo.NAME ASC;