EXP_GAE_PVT_SAMPLE

CREATE OR REPLACE FORCE VIEW EXP_GAE_PVT_SAMPLE(ID, UWI, TEMPERATURE, PRESSURE, STANDARD_LAYER_NAME, SAMPLE_NUMBER, FILE_NAME, FLUID_SAMPLE_ID, WELL_ID, ALIAS_NAME, FILE_NAME_ALIAS) AS SELECT FA.ID,
            W.UWI,
            fa.Analysis_Temperature Temperature,
            fa.Analysis_Pressure Pressure,
            NVL (GL.STANDARD_LAYER_NAME, RA.ALIAS_NAME),
            FS.SAMPLE_NUMBER,
            w.uwi || '_' || FA.ID FILE_NAME,
            FS.ID FLUID_SAMPLE_ID,
            w.id,
            BA.ALIAS_NAME,
            BA.ALIAS_NAME || '_' || FA.ID FILE_NAME_ALIAS
       FROM well w,
            borehole bh,
            Borehole_Alias ba,
            well_completion wc,
            facility_composition fc,
            well_completion wc1,
            well_completion_reservoir wcr,
            reservoir r,
            Reservoir_Alias ra,
            geologic_layer gl,
            Fluid_Sample_Acquisition fsa,
            Fluid_Sample fs,
            fluid_analysis fa
      
WHERE     BH.WELL_ID = W.ID
            AND WC.BOREHOLE_ID = BH.ID
            AND WC.WELL_COMPLETION_TYPE = 'FLUID_ACQUISITION_COMPLETION'
            AND FC.WHOLE_FACILITY_ID = WC.ID
            AND WC1.ID = FC.PART_FACILITY_ID
            AND WC1.WELL_COMPLETION_TYPE = 'FLUID_ACQUISITION_ZONE'
            AND WCR.WELL_COMPLETION_ID = WC1.ID
            AND WCR.RESERVOIR_ID = R.ID
            AND R.GEOLOGIC_LAYER_ID = GL.ID(+)
            AND R.ID = RA.RESERVOIR_ID(+)
            AND FSA.ACQUIRED_FROM_FACILITY_ID = WC.ID
            AND FS.FLUID_ACQUISITION_ID = FSA.ID
            AND FA.FLUID_SAMPLE_ID = FS.ID
            AND FA.ANALYSIS_METHOD = 'CONVENTIONAL_FLUID_ANALYSIS'
            AND BA.BOREHOLE_ID(+) = BH.ID
            AND BA.ALIAS_TYPE(+) = 'SIMULATION'
   ORDER BY 6