MATERIALIZED VIEW: APPS.CSF_MD_HYDROS_MAT_V

Source

SELECT hydros.feature_code, hydros.water_type, hydros.geometry, names.NAME
   FROM csf_md_hydros hydros, csf_md_names names
   WHERE hydros.hydrography_id = names.hydrography_id
    AND hydros.feature_code = 4310
    AND names.admin_bound_id IS NULL
    AND names.railroad_segment_id IS NULL
    AND names.landuse_id IS NULL
 UNION ALL
 SELECT hydros.feature_code, hydros.water_type, hydros.geometry, NULL
   FROM csf_md_hydros hydros
  WHERE NOT EXISTS (SELECT 1
                    FROM   csf_md_names names
                    WHERE  hydros.hydrography_id = names.hydrography_id)