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 2057: FROM okc_article_ADOPTIONS ADP

2053: AND ( (p_org_id = art.org_id
2054: )
2055: OR
2056: ( exists ( SELECT 1
2057: FROM okc_article_ADOPTIONS ADP
2058: WHERE adp.global_article_version_id = ver.article_version_id
2059: AND adp.adoption_type = 'ADOPTED'
2060: AND adp.local_org_id = p_org_id
2061: AND adp.adoption_status IN ( 'APPROVED', 'ON_HOLD')

Line 2659: OKC_ARTICLE_ADOPTIONS ADP,

2655: SELECT ADP.LOCAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2656: ADP.ADOPTION_TYPE,
2657: VERS1.ARTICLE_ID
2658: FROM OKC_ARTICLE_VERSIONS VERS,
2659: OKC_ARTICLE_ADOPTIONS ADP,
2660: OKC_ARTICLE_VERSIONS VERS1
2661: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2662: AND VERS.ARTICLE_ID = p_article_id
2663: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE

Line 2676: OKC_ARTICLE_ADOPTIONS ADP

2672: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2673: ADP.ADOPTION_TYPE,
2674: VERS.ARTICLE_ID
2675: FROM OKC_ARTICLE_VERSIONS VERS,
2676: OKC_ARTICLE_ADOPTIONS ADP
2677: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2678: AND VERS.ARTICLE_ID = p_article_id
2679: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
2680: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 2691: OKC_ARTICLE_ADOPTIONS ADP,

2687: SELECT ADP.LOCAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2688: ADP.ADOPTION_TYPE,
2689: VERS1.ARTICLE_ID
2690: FROM OKC_ARTICLE_VERSIONS VERS,
2691: OKC_ARTICLE_ADOPTIONS ADP,
2692: OKC_ARTICLE_VERSIONS VERS1
2693: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2694: AND VERS.ARTICLE_ID = p_article_id
2695: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE

Line 2707: OKC_ARTICLE_ADOPTIONS ADP

2703: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2704: ADP.ADOPTION_TYPE,
2705: VERS.ARTICLE_ID
2706: FROM OKC_ARTICLE_VERSIONS VERS,
2707: OKC_ARTICLE_ADOPTIONS ADP
2708: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2709: AND VERS.ARTICLE_ID = p_article_id
2710: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
2711: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 3712: FROM OKC_ARTICLE_ADOPTIONS ADP,

3708:
3709: -- cursor to get latest adopted article version id for global article
3710: CURSOR l_get_max_adopted_article_csr(b_article_id IN NUMBER, b_current_org_id IN NUMBER) IS
3711: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID
3712: FROM OKC_ARTICLE_ADOPTIONS ADP,
3713: OKC_ARTICLE_VERSIONS VER
3714: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.article_version_id
3715: AND VER.article_id = b_article_id
3716: AND ADP.LOCAL_ORG_ID = b_current_org_id

Line 4217: FROM okc_article_adoptions adp,

4213: AND kart.document_type = 'TEMPLATE'
4214: AND ver.article_id = kart.sav_sae_id
4215: AND ver.global_yn = 'Y'
4216: AND NOT EXISTS (SELECT 1
4217: FROM okc_article_adoptions adp,
4218: okc_article_versions ver1
4219: WHERE adp.global_article_version_id = ver1.article_version_id
4220: AND ver1.article_id = ver.article_id
4221: AND adp.local_org_id = lc_org_id