select sf.shape, sf.source_feature_id ID, source_feature.element_subnational_id, shape.digital_mapping_by as MAP_BY, shape.digital_mapping_date as MAP_DATE, luc.location_use_class_desc as LOC_USE, cf.CONC_FEATURE_TYPE_DESC CONC_FEAT_, lut.LOC_UNCERTAINTY_TYPE_DESC loc_uncert, source_feature.LOC_UNCERTAINTY_DISTANCE distance, D_UNIT.UNIT_DESC DIST_UNIT
from source_feature_pre_poly sf, working_list_src_feat_data wl, shape, source_feature, d_location_use_class luc, D_CONC_FEATURE_TYPE cf, D_LOC_UNCERTAINTY_TYPE lut, D_UNIT
where sf.source_feature_id=wl.data_id
and wl.working_list_id = xxxxx
and sf.source_feature_id=source_feature.source_feature_id
and source_feature.shape_id = shape.shape_id
and source_feature.d_location_use_class_id=luc.d_location_use_class_id(+)
and source_feature.D_CONC_FEATURE_TYPE_ID=cf.D_CONC_FEATURE_TYPE_ID (+)
and source_feature.D_LOC_UNCERTAINTY_TYPE_ID=lut.D_LOC_UNCERTAINTY_TYPE_ID (+)
and source_feature.LOC_UNCERTAINTY_UNIT_ID=D_UNIT.D_UNIT_ID (+)
order by element_subnational_id