--
select
mai.instance_code
, mxm.sr_instance_id
, mxm.entity_name
, mxm.attribute_name
, mxm.source_value
, mxm.target_value
from
msc_xref_mapping mxm
, msc_apps_instances mai
where
mai.instance_id = mxm.sr_instance_id
and entity_name = 'UOM_CODES'
order by
1
, 3
, 4