How to Query Contract Terms Template Clauses
Hi Everyone,
I need to extract all data on Contract Terms Templates page, and don´t know how to join the Terms Template Table with Clauses and Contracts too. as I've found a join from contracts to okc_terms_templates_all table stuck at identifying the join between clauses and templates.
Terms Template Table:
- OKC_TERMS_TEMPLATES_ALL
Key: TEMPLATE_ID
Clauses Table:
- OKC_ARTICLES_ALL
- OKC_ARTICLE_VERSIONS
Key: ARTICLE_ID
Has anyone tell me how to link these tables?
Tagged:
0