EXP_GAE_PROS_FLOW_DOV

CREATE OR REPLACE FORCE VIEW EXP_GAE_PROS_FLOW_DOV(ID, UWI, STRING_TYPE, START_DATE, WELL_TEST_TYPE, FINAL_TEMPERATURE, FINAL_FLOWING_PRESSURE, OIL_FLOW_RATE, WATER_FLOW_RATE, GAS_RATE, EXP_GAE_PROSPER_PSFO_DOV_ID) AS SELECT wts.id Id,
          w.uwi,
          ts.string_type,
          wt.start_date,
          wt.well_test_type,
          wtsy.final_temperature FINAL_TEMPERATURE,
          wtsy.final_flowing_pressure FINAL_FLOWING_PRESSURE,
          NVL(WTSY.AVERAGE_FLOW_RATE , wtfr1.flow_rate) OIL_FLOW_RATE,
          wtfr3.flow_rate WATER_FLOW_RATE,
          wtfr2.flow_rate GAS_RATE,
          p.id EXP_GAE_PROSPER_PSFO_DOV_Id
     FROM well_completion wc,
          well_test wt,
          well_test_summary wtsy,
          well_test_stage wts,
          well_test_fluid_recovery wtfr1,
          well_test_fluid_recovery wtfr2,
          well_test_fluid_recovery wtfr3,
          tubing_string ts,
          borehole b,
          well w,
          EXP_GAE_PROS_PSFO_DOV p
    WHERE    
 w.id = b.well_id
          AND w.uwi = b.ubhi
          AND ts.borehole_id = b.id
          AND wc.borehole_id = b.id
          AND wc.tubing_string_id = ts.id
          AND wt.well_completion_id = wc.id
          AND wt.well_test_type = 'FT'
          AND wtsy.well_test_id = wt.id
          AND wts.well_test_id = wt.id
          AND wtfr1.well_test_stage_id(+) = wts.ID
          AND wtfr1.well_test_stage_id(+) = wts.ID
          AND wtfr1.material_type(+) = 'OIL'
          AND wtfr2.well_test_stage_id(+) = wts.ID
          AND wtfr2.material_type(+) = 'GAS'
          AND wtfr3.well_test_stage_id(+) = wts.ID
          AND wtfr3.material_type(+) = 'WATER'
          AND p.well_id = w.id
          AND p.tubing_string_id = ts.id
          AND p.borehole_id = b.id