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 1553: okc_bus_variables_vl busvar,

1549: busvar.variable_name variable_name,
1550: busdoc.name doc_type
1551: FROM okc_k_articles_b kart,
1552: okc_k_art_variables var,
1553: okc_bus_variables_vl busvar,
1554: okc_bus_doc_types_v busdoc
1555: WHERE kart.document_type=p_doc_type
1556: and kart.document_id=p_doc_id
1557: and var.cat_id=kart.id

Line 1580: okc_bus_variables_vl busvar ,

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

Line 1624: okc_bus_variables_vl busvar,

1620: busvar.variable_name variable_name,
1621: busdoc.name doc_type
1622: FROM okc_k_articles_b kart,
1623: okc_k_art_variables var,
1624: okc_bus_variables_vl busvar,
1625: okc_bus_doc_types_v busdoc
1626: WHERE kart.document_type=p_doc_type
1627: and kart.document_id=p_doc_id
1628: and var.cat_id=kart.id

Line 1656: okc_bus_variables_vl busvar ,

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

Line 1713: okc_bus_variables_vl busvar ,

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
1715: WHERE rule.template_id = p_doc_id
1716: and allwd.template_id=p_doc_id
1717: and vers.article_id = rule.clause_id

Line 2081: okc_bus_variables_vl busvar

2077: var.mr_variable_html,
2078: var.mr_variable_xml
2079: FROM okc_k_articles_b kart,
2080: okc_k_art_variables var,
2081: okc_bus_variables_vl busvar
2082: WHERE kart.document_type=p_doc_type
2083: and kart.document_id=p_doc_id
2084: and var.cat_id=kart.id
2085: and busvar.variable_code=var.variable_code