-- THANKS JOHN SIMON

select *
from (
select id, attrid, decode(attrtype, -18, valstr, -7, valdate, -1, valstr, 5, valint, 10, valstr, 11, vallong, 14, valint, 10013, valstr, 10130, valstr) as attrvalue
from llattrdata
where defid = 45882 and defvern = (
select versionnum from dtree where dataid = 45882)
)
pivot (
max(attrvalue) for attrid in (
2 as COUNTRY_OF_CONTENT,
3 as COMPANY_NAME,
4 as RM_UNIT,
5 as RM_RECORD_OWNER_INT,
6 as RM_VITAL_RECORD_INT));