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_PVT dependencies on OKC_ARTICLE_RELATNS_ALL

Line 1915: from OKC_ARTICLE_RELATNS_ALL

1911: CURSOR alt_csr IS
1912: SELECT 1
1913: FROM dual
1914: WHERE exists (select 1
1915: from OKC_ARTICLE_RELATNS_ALL
1916: where org_id = p_org_id
1917: and source_article_id = p_article_id
1918: and relationship_type = 'ALTERNATE');
1919: BEGIN

Line 2002: FROM okc_article_relatns_all reln,

1998: l_alternate_yn varchar(1) := 'N';
1999:
2000: CURSOR alt_csr IS
2001: SELECT 1
2002: FROM okc_article_relatns_all reln,
2003: okc_article_versions ver
2004: WHERE reln.source_article_id = p_article_id
2005: AND reln.relationship_type = 'ALTERNATE'
2006: AND reln.target_article_id = ver.article_id

Line 2043: FROM okc_article_relatns_all reln,

2039: l_alternate_yn varchar(1) := 'N';
2040:
2041: CURSOR alt_csr(cp_effective_date DATE) IS
2042: SELECT 1
2043: FROM okc_article_relatns_all reln,
2044: okc_article_versions ver,
2045: okc_articles_all art
2046: WHERE reln.source_article_id = p_article_id
2047: AND reln.relationship_type = 'ALTERNATE'