EXP_GAE_PROS_PRESS_DOV

CREATE OR REPLACE FORCE VIEW EXP_GAE_PROS_PRESS_DOV(ID, UWI, STRING_TYPE, START_DATE, WELL_TEST_TYPE, RESERVOIR_DD_PRESSURE, RESERVOIR_GAUGE_PRESSURE, PRODUCTIVITY_INDEX, PERMEABILITY, PERMEABILITY_THICKNESS, EFFECTIVE_RADIUS, SKIN_EFFECT, TRUE_SKIN_FACTOR, FLOW_RATE, GAUGE_DEPTH_BHP, EXP_GAE_PROSPER_PSFO_DOV_ID) AS SELECT wt.id,
            w.uwi,
            ts.string_type,
            wt.start_date,
            wt.well_test_type,
            wti.reservoir_dd_pressure,
            wti.reservoir_gauge_pressure,
            wti.productivity_index * 1000,
            wti.permeability,
            wti.permeability_thickness,
            wti.effective_radius,
            wti.skin_effect,
            wti.true_skin_factor,
            wtfr.flow_rate,
            wti.gauge_depth_bhp,
            p.Id EXP_GAE_PROSPER_PSFO_DOV_Id
       FROM well_completion wc,
            well_test wt,
            well_test_interpretation wti,
            well_test_stage wts,
            
well_test_fluid_recovery wtfr,
            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 wti.well_test_id = wt.id
            AND wt.well_test_type IN ('PBU', 'PFO')
            AND wts.well_test_id = wt.id
            AND wtfr.well_test_stage_id = wts.id
            AND wtfr.material_type IN ('OIL')
            AND p.well_id = w.id
            AND p.tubing_string_id = ts.id
            AND p.borehole_id = b.id
   ORDER BY start_date DESC