SQL Query to Retrieve Content ID for Licenses and Certifications

SELECT 
    ITEM.CONTENT_ITEM_ID,
    ITEM.CONTENT_TYPE_ID,
    ITEM.CONTENT_ITEM_CODE,
    ITEM.DATE_FROM,
    ITEM.BUSINESS_GROUP_ID,
    TL.NAME,
    TL.ITEM_DESCRIPTION,
    TYPE.CONTEXT_NAME,
    ITEM.CREATED_BY,
    ITEM.CREATION_DATE,
    ITEM.LAST_UPDATED_BY,
    ITEM.LAST_UPDATE_DATE
FROM 
    HRT_CONTENT_ITEMS_B ITEM,
    HRT_CONTENT_ITEMS_TL TL,
    HRT_CONTENT_TYPES_B TYPE
WHERE 
    ITEM.CONTENT_ITEM_ID = TL.CONTENT_ITEM_ID
    AND ITEM.CONTENT_TYPE_ID = TYPE.CONTENT_TYPE_ID
    AND UPPER(TYPE.CONTEXT_NAME) = UPPER('CERTIFICATION')

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.