Retrieving Content Type custom fields in OTBI

Summary:

Custom SQL for retrieving article and their associated custom Content Type schema for purposes of building a reference report with basic details of the article and key fields from the Content Type schema.

Content (please ensure you mask any confidential information):

Example - I tried using a data model in OTBI to pull data out of the table CSO_CONTENT and I could not find the field associated with 'Content Type'. I tried some others like CSO_CONTENT_TEXT as well. The hyperlinks go to the Oracle docs sites for the tables.

Version (include the version you are using, if applicable):