/* Usage of Central references in local records */ select ruv.table_used, ruv.record_id, ruv.used_as , r.reference_code, ruv.assoc_id_desc, ruv.assoc_id, ruv.assoc_name , ruv.d_maintained_by_status_id assoc_maint_stat, ruv.inactive_ind , r.reference_id, r.d_maintained_by_status_id ref_maint_stat, r.full_citation from reference_usage_vw ruv, reference r where ruv.reference_id = r.reference_id and ruv.USED_AS != 'DISTRIBUTION_REFERENCE_ID' and ruv.TABLE_USED not in('ELEMENT_GROUP_REFERENCE','HIGHER_CLASS_UNIT_REF') and r.d_maintained_by_status_id=1 and (ruv.d_maintained_by_status_id=2 or ruv.d_maintained_by_status_id is null) and (ruv.inactive_ind='N' or ruv.inactive_ind is null) order by ruv.table_used, ruv.used_as, r.reference_code