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

Line 907: OKC_ARTICLE_ADOPTIONS ADP,

903: SELECT ADP.LOCAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
904: ADP.ADOPTION_TYPE,
905: VERS1.ARTICLE_ID
906: FROM OKC_ARTICLE_VERSIONS VERS,
907: OKC_ARTICLE_ADOPTIONS ADP,
908: OKC_ARTICLE_VERSIONS VERS1
909: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
910: AND VERS.ARTICLE_ID = b_article_id
911: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE

Line 923: OKC_ARTICLE_ADOPTIONS ADP

919: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
920: ADP.ADOPTION_TYPE,
921: VERS.ARTICLE_ID
922: FROM OKC_ARTICLE_VERSIONS VERS,
923: OKC_ARTICLE_ADOPTIONS ADP
924: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
925: AND VERS.ARTICLE_ID = b_article_id
926: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
927: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 953: FROM OKC_ARTICLE_ADOPTIONS ADP

949:
950: CURSOR l_get_max_local_article_csr(b_article_id IN NUMBER, b_article_org_id IN NUMBER) IS
951: SELECT DECODE(ADP.LOCAL_ARTICLE_VERSION_ID,NULL,ADP.GLOBAL_ARTICLE_VERSION_ID,ADP.LOCAL_ARTICLE_VERSION_ID),
952: ADP.ADOPTION_TYPE
953: FROM OKC_ARTICLE_ADOPTIONS ADP
954: WHERE ADP.LOCAL_ORG_ID = b_article_org_id
955: AND ADP.adoption_status IN ( 'APPROVED', 'ON_HOLD')
956: AND ADP.GLOBAL_ARTICLE_VERSION_ID IN (SELECT ARTICLE_VERSION_ID
957: FROM OKC_ARTICLE_VERSIONS