SELECT bvsu.date_of_use, 
          bvsu.emission_point emission_point,
          bvsu.product_id, 
          prd.product_name||prd.product_color product_name,
          prd. product_type,
          NVL(bve.voc_content_percent,0) vcp,
          TO_CHAR(epn.mint,'HH24:MI:SS'),
          TO_CHAR(epn.maxt,'HH24:MI:SS'),
           env.start_time, env.stop_time -- time range table
FROM (SELECT date_of_use
                  ,product_id
                  ,product_type
                  ,mix_id
                  ,NVL(product_use_gallons_emissions,0) product_use_gallons_emissions
                  ,bsi_org
                  ,emission_point
                   FROM SITE_USE_T) bvsu
     , (SELECT DISTINCT date_of_use
                  ,emission_point
                  ,MAX(paint_end_time) maxt
                  ,MIN(paint_start_time) mint
                  ,(MAX(paint_end_time) - MIN(paint_start_time))*24  hours
           FROM SITE_USE_T
         WHERE product_type NOT IN ( 'BLAST MEDIA','SOLVENT')
             AND mix_id IS NOT NULL
        GROUP BY date_of_use, emission_point) epn, 
 (SELECT DISTINCT product_id, date_of_use,start_time, stop_time FROM TIMERANGES_RPT_T ) env
      , (SELECT product_id
                 ,product_name
                 ,product_type
                 ,product_color
          FROMPRODUCT_LISTING_T) prd
      ,(SELECT product_id
                 ,msds_revision_date
                 ,voc_content_weight
                 ,specific_gravity
                 ,voc_content_percent
                 ,product_weight
          FROM EMISSIONS_T) bve
WHERE bvsu.date_of_use BETWEEN :P_begin_date AND :P_end_date
  AND bvsu.mix_id IS NOT NULL
  AND bvsu.bsi_org = :P_bsi_org
  AND prd.product_id = bvsu.product_id
  AND bve.product_id = prd.product_id
  AND epn.date_of_use = bvsu.date_of_use AND env.product_id = bvsu.product_id
  AND env.date_of_use = bvsu.date_of_use--new
     AND bve.msds_revision_date = (SELECT MAX(msds_revision_date)
                                                       FROM EMISSIONS_T bve1
                                                     WHERE bve1.product_id = bve.product_id
                                                         AND msds_revision_date <= bvsu.date_of_use)
  AND bvsu.product_type NOT IN ('BLASTING SAND' ,'SOLVENT')
  AND prd.product_type <> 'BLAST MEDIA'
GROUP BY bvsu.date_of_use, bvsu.emission_point, bvsu.product_id,   env.start_time, env.stop_time,bvsu.msds_revision_date, prd.product_name||prd.product_color, prd. product_type, bve.specific_gravity, bve.voc_content_weight, bve.voc_content_percent, bve.product_weight,epn.hours, epn.mint, epn.maxt