Cloud Enterprise Contract Clause Query
============================
select
ch.contract_number,
cab.label||’ ‘||caa.article_title
from okc_k_headers_vl ch,okc_k_articles_b cab,okc_articles_all caa, okc_article_versions cv
where ch.id = cab.document_id
and cab.article_version_id = cv.article_version_id
and cv.article_id = caa.article_id
Recent Posts