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_CA_UTIL_PVT dependencies on OKC_ARTICLE_ADOPTIONS

Line 154: select 1 from okc_article_adoptions

150: okc_article_versions
151: where article_id = l_article_id
152: and article_status in ('APPROVED','ON_HOLD')
153: and exists (
154: select 1 from okc_article_adoptions
155: where global_article_version_id = article_version_id
156: and local_org_id = p_org_id
157: and adoption_type = 'ADOPTED'
158: and adoption_status = 'APPROVED'

Line 280: okc_article_adoptions a,

276: 'ADOPTED' adoption_type,
277: org_name
278: from
279: okc_articles_all art,
280: okc_article_adoptions a,
281: okc_article_versions v,
282: ( select
283: orgu.organization_id org_id,
284: orgu.name org_name

Line 317: okc_article_adoptions a1

313: max(start_date),
314: max(article_version_number)
315: from
316: okc_article_versions v1,
317: okc_article_adoptions a1
318: where global_yn = 'Y'
319: and v1.article_version_id = a1.global_article_version_id
320: and v1.article_status in ('APPROVED','ON_HOLD')
321: and a1.adoption_type = 'ADOPTED'

Line 386: okc_article_adoptions a,

382: article_version_number,
383: 'ADOPTED' adoption_type,
384: org_name
385: from
386: okc_article_adoptions a,
387: okc_ca_art_versions_gt t,
388: ( select
389: orgu.organization_id org_id,
390: orgu.name org_name

Line 509: from okc_article_adoptions

505: and a.article_id = t.article_id
506: and t.article_adoption_type = 'ADOPTED'
507: and exists (
508: select 1
509: from okc_article_adoptions
510: where local_org_id = t.article_org_id
511: and global_article_version_id = a.article_version_id
512: and adoption_type = 'ADOPTED'
513: and adoption_status = 'APPROVED'