Query to get content_item_id for HDL

 select hci.name,
hci.content_item_code,
hci.content_item_id
from hrt_content_tp_valuesets_vl hctv,
hrt_content_items_vl hci
where hctv.value_set_name like 'Degrees'
and hctv.content_type_id = (select content_type_id from HRT_CONTENT_TYPES_TL CT where 1=1 and CONTENT_TYPE_NAME ='Degrees')
and hci.content_value_set_id = hctv.content_value_set_id
order by hci.content_item_code, hci.name