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.ORACLEMYPAGE dependencies on FND_SECURITY_GROUPS

Line 558: FROM fnd_security_groups

554:
555: BEGIN
556: SELECT security_group_id
557: INTO l_sgid
558: FROM fnd_security_groups
559: WHERE security_group_key=c_sec_grp_id;
560: EXCEPTION
561: WHEN no_data_found THEN
562: raise e_no_sgid;

Line 695: from FND_SECURITY_GROUPS_VL fsg,

691: fsg.SECURITY_GROUP_NAME,
692: fsg.SECURITY_GROUP_ID,
693: fsg.security_group_key,
694: fa.application_short_name
695: from FND_SECURITY_GROUPS_VL fsg,
696: fnd_responsibility_vl a,
697: FND_USER_RESP_GROUPS b,
698: FND_APPLICATION fa
699: where b.user_id = icx_sec.g_user_id

Line 724: from FND_SECURITY_GROUPS_VL fsg,

720: fsg.SECURITY_GROUP_NAME,
721: fsg.SECURITY_GROUP_ID,
722: fsg.security_group_key,
723: fa.application_short_name
724: from FND_SECURITY_GROUPS_VL fsg,
725: fnd_responsibility_vl a,
726: FND_USER_RESP_GROUPS b,
727: FND_APPLICATION fa
728: where b.user_id = icx_sec.g_user_id

Line 880: from FND_SECURITY_GROUPS_VL fsg,

876:
877: -- how many valid resps?
878: -- 1584711 nlbarlow remove order by
879: select count(*) INTO l_resps_count
880: from FND_SECURITY_GROUPS_VL fsg,
881: FND_RESPONSIBILITY_VL a,
882: FND_USER_RESP_GROUPS b
883: where b.user_id = l_user_id
884: and b.start_date <= sysdate

Line 909: from FND_SECURITY_GROUPS_VL fsg,

905: l_agent := FND_WEB_CONFIG.WEB_SERVER||icx_plug_utilities.getPLSQLagent;
906:
907: end if;
908: select a.version INTO l_resp_type
909: from FND_SECURITY_GROUPS_VL fsg,
910: FND_RESPONSIBILITY_VL a,
911: FND_USER_RESP_GROUPS b
912: where b.user_id = l_user_id
913: and b.start_date <= sysdate