select unique
mic.category_set_id,
mic.sr_category_id,
mic.sr_instance_id,
mic.category_name,
mic.description
from msc_item_categories mic,msc_category_sets mcs
where mcs.category_set_id IN
(
to_number(fnd_profile.value_specific('MSC_HUB_CAT_SET_ID_1',-1)), --- need to make sure it takes site level in mv
to_number(fnd_profile.value_specific('MSC_HUB_CAT_SET_ID_2',-1)),
to_number(fnd_profile.value_specific('MSC_HUB_CAT_SET_ID_3',-1))
)
and mcs.category_set_id = mic.category_set_id