select sf.SOURCE_FEATURE_ID AS "SF ID", 
lut.LOC_UNCERTAINTY_TYPE_DESC as "Locational Uncertainty Type", 
cft.CONC_FEATURE_TYPE_DESC as "Conceptual Feature Type",
ra.est_rep_accuracy_desc as "Current SF RA",
eosf.eo_id "EO ID",
eora.est_rep_accuracy_desc as "Current EO RA"
from SOURCE_FEATURE sf, EO_SOURCE_FEATURE eosf, D_LOC_UNCERTAINTY_TYPE lut, D_CONC_FEATURE_TYPE cft, D_EST_REP_ACCURACY ra, EO, D_EST_REP_ACCURACY eora
where sf.SHAPE_ID  = eosf.SOURCE_FEATURE_SHAPE_ID (+)
and sf.d_loc_uncertainty_type_id = lut.d_loc_uncertainty_type_id (+)
and sf.d_conc_feature_type_id = cft.d_conc_feature_type_id (+)
and sf.d_est_rep_accuracy_id = ra.d_est_rep_accuracy_id (+)
and eosf.eo_id = eo.eo_id (+)
and eo.d_est_rep_accuracy_id = eora.d_est_rep_accuracy_id (+)
ORDER BY eosf.EO_ID, sf.source_feature_id