Not able to Print Enterprise Contract Terms in Custom Report as ARTICLE_TEXT is HTML embedded

Snehashis_Santra

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

Kevin M-Oracle

What application are you using, Oracle Analytics, Fusion Applications, EBS,…?

What is your question?

Rgds,

Kevin

Snehashis_Santra

Fusion Application.

How come, we will print CLOB text which is HTML embedded in Custom as it's generating from Oracle application?

Kevin M-Oracle

Please post Fusion Application questions to the Cloud Customer Connect.

Rgds,

Kevin