MATERIALIZED VIEW: APPS.CSF_MD_RAIL_SEGS_MAT_V

Source

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