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 1873: from OKC_ARTICLE_RELATNS_ALL

1869: CURSOR alt_csr IS
1870: SELECT 1
1871: FROM dual
1872: WHERE exists (select 1
1873: from OKC_ARTICLE_RELATNS_ALL
1874: where org_id = p_org_id
1875: and source_article_id = p_article_id
1876: and relationship_type = 'ALTERNATE');
1877: BEGIN

Line 1960: FROM okc_article_relatns_all reln,

1956: l_alternate_yn varchar(1) := 'N';
1957:
1958: CURSOR alt_csr IS
1959: SELECT 1
1960: FROM okc_article_relatns_all reln,
1961: okc_article_versions ver
1962: WHERE reln.source_article_id = p_article_id
1963: AND reln.relationship_type = 'ALTERNATE'
1964: AND reln.target_article_id = ver.article_id

Line 2001: FROM okc_article_relatns_all reln,

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