EXP_GAE_PVT_EXP

CREATE OR REPLACE FORCE VIEW EXP_GAE_PVT_EXP(TEMPERATURE, ANALYSIS_METHOD, ID, FLUID_ANALYSIS_ID, ROWNUM1) AS SELECT EXP.*, ROWNUM
     FROM (  SELECT DISTINCT fa.Analysis_Temperature TEMPERATURE,
                             fa.ANALYSIS_METHOD,
                             fa.fluid_sample_id ID,
                             FA1.ID fluid_analysis_id
               FROM fluid_analysis fa,
                    fluid_analysis fa1,
                    fluid_sample fs,
                    Fluid_State_Pty_Set fsps
              WHERE     FA1.FLUID_SAMPLE_ID = FS.ID
                    AND FS.ID = FA.FLUID_SAMPLE_ID
                    AND FSPS.FLUID_ANALYSIS_ID(+) = FA.ID
                    AND fa.ANALYSIS_METHOD IN
                           ('DIFFERENTIAL_VAPORIZATION',
                            'PRESSURE_VOLUME_RELATION',
                            'SEPARATION')
           ORDER BY fa.ANALYSIS_METHOD, fa.Analysis_Temperature) EXP