You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!