eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_QA_PVT dependencies on OKC_ALLOWED_TMPL_USAGES

Line 1559: okc_allowed_tmpl_usages allwd ,

1555: busvar.variable_name variable_name,
1556: busdoc.name doc_type
1557: FROM okc_k_articles_b kart,
1558: okc_article_versions vers,
1559: okc_allowed_tmpl_usages allwd ,
1560: okc_article_variables var,
1561: okc_bus_variables_vl busvar ,
1562: okc_bus_doc_types_v busdoc
1563: WHERE kart.document_type=G_TMPL_DOC_TYPE

Line 1635: okc_allowed_tmpl_usages allwd ,

1631: busvar.variable_name variable_name,
1632: busdoc.name doc_type
1633: FROM okc_k_articles_b kart,
1634: okc_article_versions vers,
1635: okc_allowed_tmpl_usages allwd ,
1636: okc_article_variables var,
1637: okc_bus_variables_vl busvar ,
1638: okc_bus_doc_types_v busdoc
1639: WHERE kart.document_type=G_TMPL_DOC_TYPE

Line 1691: okc_allowed_tmpl_usages allwd ,

1687: var.variable_code variable_code,
1688: busvar.variable_name variable_name,
1689: busdoc.name doc_type
1690: FROM okc_xprt_clauses_v rule,
1691: okc_allowed_tmpl_usages allwd ,
1692: okc_article_versions vers,
1693: okc_article_variables var,
1694: okc_bus_variables_vl busvar ,
1695: okc_bus_doc_types_v busdoc

Line 2719: FROM OKC_ALLOWED_TMPL_USAGES

2715:
2716: --Bug 4126819 Added cursor to get check if the template is associated to the document.
2717: CURSOR l_get_template_usg_csr IS
2718: SELECT 'Y'
2719: FROM OKC_ALLOWED_TMPL_USAGES
2720: WHERE TEMPLATE_ID = (SELECT TEMPLATE_ID
2721: FROM OKC_TEMPLATE_USAGES
2722: WHERE DOCUMENT_ID = p_doc_id
2723: AND DOCUMENT_TYPE = p_doc_type)