select AttributePicklistValueid
,label
,OptionSetView.Name
,AttributePicklistValueView.Value
--,AttributePicklistValueView.ExternalValue
,ObjectColumnName
from LocalizedLabelView
join
AttributePicklistValueView
on AttributePicklistValueView.AttributePicklistValueid = LocalizedLabelView.objectid
join
OptionSetView
on
OptionSetView.OptionSetId = AttributePicklistValueView.OptionSetId
--where OptionSetView.IsGlobal =1 and LocalizedLabelView.label <> ''
where OptionSetView.Name like '%new_oppst%'
order by OptionSetView.Name