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

Line 1112: OKC_ARTICLE_ADOPTIONS ADP

1108: ADP.GLOBAL_ARTICLE_VERSION_ID article_version_id,
1109: NVL(VERS.default_section,'UNASSIGNED') scn_code,
1110: NVL(VERS.PROVISION_YN,'N') provision_yn
1111: FROM OKC_ARTICLE_VERSIONS VERS,
1112: OKC_ARTICLE_ADOPTIONS ADP
1113: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
1114: AND VERS.ARTICLE_ID = b_article_id
1115: AND nvl(b_article_effective_date,sysdate) >= VERS.START_DATE
1116: AND nvl(b_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(b_article_effective_date,sysdate) +1)

Line 1129: OKC_ARTICLE_ADOPTIONS ADP

1125: ADP.GLOBAL_ARTICLE_VERSION_ID article_version_id,
1126: NVL(VERS.default_section,'UNASSIGNED') scn_code,
1127: NVL(VERS.PROVISION_YN,'N') provision_yn
1128: FROM OKC_ARTICLE_VERSIONS VERS,
1129: OKC_ARTICLE_ADOPTIONS ADP
1130: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
1131: AND VERS.ARTICLE_ID = b_article_id
1132: AND VERS.ARTICLE_STATUS IN ('ON_HOLD','APPROVED')
1133: AND ADP.ADOPTION_TYPE = 'ADOPTED'