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_ADOPTIONS

Line 2015: FROM okc_article_ADOPTIONS ADP

2011: AND ( (p_org_id = art.org_id
2012: )
2013: OR
2014: ( exists ( SELECT 1
2015: FROM okc_article_ADOPTIONS ADP
2016: WHERE adp.global_article_version_id = ver.article_version_id
2017: AND adp.adoption_type = 'ADOPTED'
2018: AND adp.local_org_id = p_org_id
2019: AND adp.adoption_status IN ( 'APPROVED', 'ON_HOLD')

Line 2617: OKC_ARTICLE_ADOPTIONS ADP,

2613: SELECT ADP.LOCAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2614: ADP.ADOPTION_TYPE,
2615: VERS1.ARTICLE_ID
2616: FROM OKC_ARTICLE_VERSIONS VERS,
2617: OKC_ARTICLE_ADOPTIONS ADP,
2618: OKC_ARTICLE_VERSIONS VERS1
2619: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2620: AND VERS.ARTICLE_ID = p_article_id
2621: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE

Line 2634: OKC_ARTICLE_ADOPTIONS ADP

2630: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2631: ADP.ADOPTION_TYPE,
2632: VERS.ARTICLE_ID
2633: FROM OKC_ARTICLE_VERSIONS VERS,
2634: OKC_ARTICLE_ADOPTIONS ADP
2635: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2636: AND VERS.ARTICLE_ID = p_article_id
2637: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
2638: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 2649: OKC_ARTICLE_ADOPTIONS ADP,

2645: SELECT ADP.LOCAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2646: ADP.ADOPTION_TYPE,
2647: VERS1.ARTICLE_ID
2648: FROM OKC_ARTICLE_VERSIONS VERS,
2649: OKC_ARTICLE_ADOPTIONS ADP,
2650: OKC_ARTICLE_VERSIONS VERS1
2651: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2652: AND VERS.ARTICLE_ID = p_article_id
2653: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE

Line 2665: OKC_ARTICLE_ADOPTIONS ADP

2661: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2662: ADP.ADOPTION_TYPE,
2663: VERS.ARTICLE_ID
2664: FROM OKC_ARTICLE_VERSIONS VERS,
2665: OKC_ARTICLE_ADOPTIONS ADP
2666: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2667: AND VERS.ARTICLE_ID = p_article_id
2668: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
2669: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 3669: FROM OKC_ARTICLE_ADOPTIONS ADP,

3665:
3666: -- cursor to get latest adopted article version id for global article
3667: CURSOR l_get_max_adopted_article_csr(b_article_id IN NUMBER, b_current_org_id IN NUMBER) IS
3668: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID
3669: FROM OKC_ARTICLE_ADOPTIONS ADP,
3670: OKC_ARTICLE_VERSIONS VER
3671: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.article_version_id
3672: AND VER.article_id = b_article_id
3673: AND ADP.LOCAL_ORG_ID = b_current_org_id

Line 4168: FROM okc_article_adoptions adp,

4164: AND kart.document_type = 'TEMPLATE'
4165: AND ver.article_id = kart.sav_sae_id
4166: AND ver.global_yn = 'Y'
4167: AND NOT EXISTS (SELECT 1
4168: FROM okc_article_adoptions adp,
4169: okc_article_versions ver1
4170: WHERE adp.global_article_version_id = ver1.article_version_id
4171: AND ver1.article_id = ver.article_id
4172: AND adp.local_org_id = lc_org_id