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 1578: okc_allowed_tmpl_usages allwd ,

1574: busvar.variable_name variable_name,
1575: busdoc.name doc_type
1576: FROM okc_k_articles_b kart,
1577: okc_article_versions vers,
1578: okc_allowed_tmpl_usages allwd ,
1579: okc_article_variables var,
1580: okc_bus_variables_vl busvar ,
1581: okc_bus_doc_types_v busdoc
1582: WHERE kart.document_type=G_TMPL_DOC_TYPE

Line 1654: okc_allowed_tmpl_usages allwd ,

1650: busvar.variable_name variable_name,
1651: busdoc.name doc_type
1652: FROM okc_k_articles_b kart,
1653: okc_article_versions vers,
1654: okc_allowed_tmpl_usages allwd ,
1655: okc_article_variables var,
1656: okc_bus_variables_vl busvar ,
1657: okc_bus_doc_types_v busdoc
1658: WHERE kart.document_type=G_TMPL_DOC_TYPE

Line 1710: okc_allowed_tmpl_usages allwd ,

1706: var.variable_code variable_code,
1707: busvar.variable_name variable_name,
1708: busdoc.name doc_type
1709: FROM okc_xprt_clauses_v rule,
1710: okc_allowed_tmpl_usages allwd ,
1711: okc_article_versions vers,
1712: okc_article_variables var,
1713: okc_bus_variables_vl busvar ,
1714: okc_bus_doc_types_v busdoc

Line 2753: FROM OKC_ALLOWED_TMPL_USAGES

2749:
2750: --Bug 4126819 Added cursor to get check if the template is associated to the document.
2751: CURSOR l_get_template_usg_csr IS
2752: SELECT 'Y'
2753: FROM OKC_ALLOWED_TMPL_USAGES
2754: WHERE TEMPLATE_ID = (SELECT TEMPLATE_ID
2755: FROM OKC_TEMPLATE_USAGES
2756: WHERE DOCUMENT_ID = p_doc_id
2757: AND DOCUMENT_TYPE = p_doc_type)