Not able to Print Contract Term Clauses in the Custom Report as it's a CLOB and HTML embedded.
Here ARTICLE_TEXT is having CLOB
select
ch.contract_number,
cab.label||''||caa.article_title article,fl.meaning,cab.document_id,cv.ARTICLE_TEXT
from okc_k_headers_vl ch,okc_k_articles_b cab,
okc_articles_all caa, okc_article_versions cv,
FND_LOOKUPS fl
where ch.id = cab.document_id
and cab.article_version_id = cv.article_version_id
and cv.article_id = caa.article_id
and ch.id=300000040575901
and fl.lookup_type='OKC_SUBJECT'
and caa.article_type=fl.lookup_code
and cab.ARTICLE_VERSION_ID=cv.ARTICLE_VERSION_ID
order by cab.label
0