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_UTIL dependencies on DUAL

Line 1688: AND rrr.role_resource_type = 'RS_INDIVIDUAL'

1684: WHERE res.user_id = fnd_global.user_id
1685: AND l_date between res.start_date_active
1686: and nvl(res.end_date_active, l_date)
1687: AND res.resource_id = rrr.role_resource_id
1688: AND rrr.role_resource_type = 'RS_INDIVIDUAL'
1689: AND nvl(rrr.delete_flag,'N') = 'N'
1690: AND l_date between rrr.start_date_active
1691: and nvl(rrr.end_date_active, l_date)
1692: AND rrr.role_id = rr.role_id

Line 3361: INTO l_tmpl_id FROM DUAL;

3357: CLOSE get_apps_upg_tmpl_id_crs;
3358:
3359: IF l_tmpl_id IS NULL THEN
3360: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL
3361: INTO l_tmpl_id FROM DUAL;
3362: INSERT INTO OKC_TERMS_TEMPLATES_ALL(
3363: TEMPLATE_NAME,
3364: TEMPLATE_ID,
3365: WORKING_COPY_FLAG,