Oracle HCM: Querying Content Items by Context Type

SELECT  HCTB.CONTEXT_NAME,HCIB.CONTENT_ITEM_CODE, HCIT.NAME
FROM    HRT_CONTENT_ITEMS_B HCIB , HRT_CONTENT_ITEMS_TL HCIT, HRT_CONTENT_TYPES_B HCTB
WHERE   HCIB.CONTENT_ITEM_ID = HCIT.CONTENT_ITEM_ID
AND     HCIB.CONTENT_TYPE_ID = HCTB.CONTENT_TYPE_ID
AND     HCTB.CONTEXT_NAME IN ( 'CERTIFICATION', 'TRAIN','Skills','G4S_IE_OPS_CUSTOMER_SKILL') 
ORDER BY  HCTB.CONTEXT_NAME,HCIT.NAME

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