MATERIALIZED VIEW: APPS.CSF_MD_ADM_BOUNDS_MAT_V

Source

SELECT adm.feature_code, adm.area, adm.geometry, names.NAME
   FROM csf_md_adm_bounds adm, csf_md_names names
  WHERE adm.admin_bound_id = names.admin_bound_id
    AND names.railroad_segment_id IS NULL
    AND names.landuse_id IS NULL
    AND names.hydrography_id IS NULL
 UNION ALL
 SELECT adm.feature_code, adm.area, adm.geometry, NULL
   FROM csf_md_adm_bounds adm
  WHERE NOT EXISTS (SELECT 1
                    FROM   csf_md_names names
                    WHERE adm.admin_bound_id = names.admin_bound_id)