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_BUS_VARIABLES_VL

Line 1534: okc_bus_variables_vl busvar,

1530: busvar.variable_name variable_name,
1531: busdoc.name doc_type
1532: FROM okc_k_articles_b kart,
1533: okc_k_art_variables var,
1534: okc_bus_variables_vl busvar,
1535: okc_bus_doc_types_v busdoc
1536: WHERE kart.document_type=p_doc_type
1537: and kart.document_id=p_doc_id
1538: and var.cat_id=kart.id

Line 1561: okc_bus_variables_vl busvar ,

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
1564: and kart.document_id=p_doc_id
1565: and allwd.template_id=kart.document_id

Line 1605: okc_bus_variables_vl busvar,

1601: busvar.variable_name variable_name,
1602: busdoc.name doc_type
1603: FROM okc_k_articles_b kart,
1604: okc_k_art_variables var,
1605: okc_bus_variables_vl busvar,
1606: okc_bus_doc_types_v busdoc
1607: WHERE kart.document_type=p_doc_type
1608: and kart.document_id=p_doc_id
1609: and var.cat_id=kart.id

Line 1637: okc_bus_variables_vl busvar ,

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
1640: and kart.document_id=p_doc_id
1641: and allwd.template_id=kart.document_id

Line 1694: okc_bus_variables_vl busvar ,

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
1696: WHERE rule.template_id = p_doc_id
1697: and allwd.template_id=p_doc_id
1698: and vers.article_id = rule.clause_id

Line 2059: okc_bus_variables_vl busvar

2055: var.external_yn,
2056: var.variable_value_id
2057: FROM okc_k_articles_b kart,
2058: okc_k_art_variables var,
2059: okc_bus_variables_vl busvar
2060: WHERE kart.document_type=p_doc_type
2061: and kart.document_id=p_doc_id
2062: and var.cat_id=kart.id
2063: and busvar.variable_code=var.variable_code