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.

[Home] [Help]

APPS.OKC_TERMS_COPY_PVT dependencies on OKC_ARTICLE_ADOPTIONS

Line 651: OKC_ARTICLE_ADOPTIONS ADP,

647: SELECT ADP.LOCAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
648: ADP.ADOPTION_TYPE,
649: VERS1.ARTICLE_ID
650: FROM OKC_ARTICLE_VERSIONS VERS,
651: OKC_ARTICLE_ADOPTIONS ADP,
652: OKC_ARTICLE_VERSIONS VERS1
653: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
654: AND VERS.ARTICLE_ID = b_article_id
655: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE

Line 667: OKC_ARTICLE_ADOPTIONS ADP

663: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
664: ADP.ADOPTION_TYPE,
665: VERS.ARTICLE_ID
666: FROM OKC_ARTICLE_VERSIONS VERS,
667: OKC_ARTICLE_ADOPTIONS ADP
668: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
669: AND VERS.ARTICLE_ID = b_article_id
670: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
671: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 697: FROM OKC_ARTICLE_ADOPTIONS ADP

693:
694: CURSOR l_get_max_local_article_csr(b_article_id IN NUMBER, b_article_org_id IN NUMBER) IS
695: SELECT DECODE(ADP.LOCAL_ARTICLE_VERSION_ID,NULL,ADP.GLOBAL_ARTICLE_VERSION_ID,ADP.LOCAL_ARTICLE_VERSION_ID),
696: ADP.ADOPTION_TYPE
697: FROM OKC_ARTICLE_ADOPTIONS ADP
698: WHERE ADP.LOCAL_ORG_ID = b_article_org_id
699: AND ADP.adoption_status IN ( 'APPROVED', 'ON_HOLD')
700: AND ADP.GLOBAL_ARTICLE_VERSION_ID IN (SELECT ARTICLE_VERSION_ID
701: FROM OKC_ARTICLE_VERSIONS