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_UTIL_GRP dependencies on OKC_ARTICLES_ALL

Line 726: FROM okc_k_articles_b kart, okc_articles_all a

722: l_return_value VARCHAR2(100) := G_NO_ARTICLE_EXIST;
723:
724: CURSOR find_art_crs IS
725: SELECT a.standard_yn
726: FROM okc_k_articles_b kart, okc_articles_all a
727: WHERE kart.document_type=p_doc_type
728: AND kart.document_id=p_doc_id
729: AND nvl(kart.amendment_operation_code,'?')<>G_AMEND_CODE_DELETED
730: AND nvl(kart.summary_amend_operation_code,'?')<>G_AMEND_CODE_DELETED

Line 1272: FROM okc_k_articles_b kart, okc_articles_all a

1268: l_dummy VARCHAR2(1) := '?';
1269: l_return_value VARCHAR2(100) := G_NO_ARTICLE_AMENDED;
1270: CURSOR find_art_crs IS
1271: SELECT a.standard_yn
1272: FROM okc_k_articles_b kart, okc_articles_all a
1273: WHERE kart.document_type=p_doc_type
1274: AND kart.document_id=p_doc_id
1275: AND kart.summary_amend_operation_code IS NOT NULL
1276: AND a.article_id = kart.sav_sae_id