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

Line 4447: FROM okc_articles_all art,

4443: and rownum < 2;
4444:
4445: CURSOR l_approved_ver_csr(p_article_id NUMBER, effective_date DATE) IS
4446: SELECT ver.article_id, ver.article_version_id, 'L'
4447: FROM okc_articles_all art,
4448: okc_article_versions ver
4449: WHERE art.article_id = p_article_id
4450: AND art.article_id = ver.article_id
4451: AND ver.article_status IN ('APPROVED','ON_HOLD')

Line 4904: FROM okc_articles_all

4900:
4901: RETURN VARCHAR2 IS
4902: CURSOR c1 IS
4903: SELECT article_title
4904: FROM okc_articles_all
4905: WHERE article_id=to_number(p_object_value_code);
4906:
4907: CURSOR C2 IS
4908: SELECT question_name

Line 7550: FROM okc_articles_all a,okc_article_versions ver

7546:
7547: --Bug#4757731 cursor to get clause title and clause description
7548: CURSOR csr_clause_details(b_article_id NUMBER, b_article_version_id NUMBER) IS
7549: SELECT article_title,article_description
7550: FROM okc_articles_all a,okc_article_versions ver
7551: WHERE a.article_id = b_article_id
7552: AND a.article_id = ver.article_id
7553: AND ver.article_version_id = b_article_version_id;
7554: