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.ORACLENAVIGATE dependencies on FND_USER_RESP_GROUPS

Line 537: FND_USER_RESP_GROUPS b,

533: m.TYPE,
534: m.menu_id
535: from FND_SECURITY_GROUPS_VL fsg,
536: FND_RESPONSIBILITY_VL a,
537: FND_USER_RESP_GROUPS b,
538: fnd_menus m
539: where b.user_id = icx_sec.g_user_id
540: AND a.menu_id = m.menu_id
541: and b.start_date <= sysdate

Line 814: FND_USER_RESP_GROUPS b

810: l_responsibility_description,
811: l_security_group_name
812: from FND_SECURITY_GROUPS_VL fsg,
813: FND_RESPONSIBILITY_VL a,
814: FND_USER_RESP_GROUPS b
815: where b.USER_ID = icx_sec.g_user_id
816: and a.APPLICATION_ID = b.RESPONSIBILITY_APPLICATION_ID
817: and a.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
818: and a.RESPONSIBILITY_ID = l_responsibility_id

Line 1223: FND_USER_RESP_GROUPS b,

1219: m.type,
1220: a.version
1221: from FND_SECURITY_GROUPS_VL fsg,
1222: fnd_responsibility_vl a,
1223: FND_USER_RESP_GROUPS b,
1224: FND_APPLICATION fa,
1225: FND_MENUS m
1226: where b.user_id = icx_sec.g_user_id
1227: AND m.menu_id = a.menu_id

Line 1436: select RESPONSIBILITY_ID from fnd_user_resp_groups where

1432: (select responsibility_id from
1433: icx_custom_menu_entries
1434: where USER_ID=icx_sec.g_user_id
1435: intersect
1436: select RESPONSIBILITY_ID from fnd_user_resp_groups where
1437: USER_ID=icx_sec.g_user_id
1438: and
1439: start_date <= sysdate
1440: and

Line 1799: FND_USER_RESP_GROUPS b

1795: b.security_group_id,
1796: fsg.SECURITY_GROUP_NAME
1797: from FND_SECURITY_GROUPS_VL fsg,
1798: fnd_responsibility_vl a,
1799: FND_USER_RESP_GROUPS b
1800: where b.user_id = icx_sec.g_user_id
1801: and b.start_date <= sysdate
1802: and (b.end_date is null or b.end_date > sysdate)
1803: and b.RESPONSIBILITY_id = a.responsibility_id