EXP_GAE_PROS_DEV_DOV

CREATE OR REPLACE FORCE VIEW EXP_GAE_PROS_DEV_DOV(ID, START_DATE, END_DATE, STRING_TYPE, BOREHOLE_ID, BULK_ID, EXP_GAE_PROSPER_PSFO_DOV_ID) AS SELECT w.id Id,
          fs.start_date START_DATE,
          fs.end_date END_DATE,
          w.uwi || '/' || ts.string_type STRING_TYPE,
          b.id Borehole_Id,
          ds.Deviation_Survey_Bulk_Data_Id,
          p.id EXP_GAE_PROSPER_PSFO_DOV_Id
     FROM Facility_Status fs,
          well_completion wc,
          tubing_string ts,
          well w,
          borehole b,
          borehole b1,
          deviation_survey ds,
          EXP_GAE_PROS_PSFO_DOV p
    WHERE     fs.facility_id = wc.id
          AND wc.Borehole_Id = b.id
          AND wc.tubing_string_id = ts.id
          AND b1.ubhi = w.uwi
          AND b1.well_id = w.id
          AND ts.Borehole_Id = b1.id
          AND b.well_id = w.id
          AND ds.Borehole_Id = b.id
          AND ds.Interpretation_Status = 'PROC'
          AND ds.Preferred_Flag = 1
          AND 
p.well_id = w.id
          AND p.tubing_string_id = ts.id
          AND p.Borehole_Id = b1.id