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.AMS_ACCESS_DENORM_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 313: jtf_rs_group_members jgm

309: AND edit_metrics_yn = 'Y'
310: AND not exists ( SELECT 1
311: FROM ams_act_access aac,
312: jtf_rs_groups_denorm jgd,
313: jtf_rs_group_members jgm
314: WHERE aac.arc_act_access_to_object = p_object_type
315: AND aac.act_access_to_object_id = p_object_id
316: AND arc_user_or_role_type = 'GROUP'
317: AND user_or_role_id = jgd.parent_group_id

Line 350: jtf_rs_group_members jgm -- INtroduce soft DELETE flag FOR resources.

346: AND object_id = p_object_id
347: AND not exists ( SELECT 1
348: FROM ams_act_access aac,
349: jtf_rs_groups_denorm jgd,
350: jtf_rs_group_members jgm -- INtroduce soft DELETE flag FOR resources.
351: WHERE aac.arc_act_access_to_object = p_object_type
352: AND aac.act_access_to_object_id = p_object_id
353: AND arc_user_or_role_type = 'GROUP'
354: AND user_or_role_id = jgd.parent_group_id

Line 383: jtf_rs_group_members jgm

379: AND resource_id = p_resource_id
380: AND resource_id not IN (SELECT jgm.resource_id
381: FROM ams_act_access aac,
382: jtf_rs_groups_denorm jgd,
383: jtf_rs_group_members jgm
384: WHERE aac.arc_act_access_to_object = p_object_type
385: AND aac.act_access_to_object_id = p_object_id
386: AND arc_user_or_role_type = 'GROUP'
387: AND user_or_role_id = jgd.parent_group_id

Line 424: jtf_rs_group_members jgm

420: WHERE object_type = p_object_type
421: AND object_id = p_object_id
422: AND resource_id IN ( SELECT jgm.resource_id
423: FROM jtf_rs_groups_denorm jgd,
424: jtf_rs_group_members jgm
425: WHERE jgd.parent_group_id = p_group_id
426: AND jgd.group_id = jgm.group_id
427: AND jgd.start_date_active <= TRUNC(SYSDATE)
428: AND NVL(jgd.end_date_active,TRUNC(SYSDATE)) >= TRUNC(SYSDATE)

Line 462: jtf_rs_group_members jgm

458: , l_login_id
459: FROM (
460: SELECT DISTINCT resource_id
461: FROM jtf_rs_groups_denorm jgd,
462: jtf_rs_group_members jgm
463: WHERE jgd.parent_group_id = p_group_id
464: AND jgd.group_id = jgm.group_id
465: AND jgd.start_date_active <= TRUNC(SYSDATE)
466: AND NVL(jgd.end_date_active,TRUNC(SYSDATE)) >= TRUNC(SYSDATE)

Line 501: jtf_rs_group_members jgm

497: AND edit_metrics_yn = 'N'
498: AND EXISTS ( SELECT 1
499: FROM ams_act_access aac,
500: jtf_rs_groups_denorm jgd,
501: jtf_rs_group_members jgm
502: WHERE aac.arc_act_access_to_object = p_object_type
503: AND aac.act_access_to_object_id = p_object_id
504: AND arc_user_or_role_type = 'GROUP'
505: AND user_or_role_id = p_group_id

Line 532: jtf_rs_group_members jgm

528: /* Roliing back perf suggested change
529: AND EXISTS ( SELECT 1
530: FROM ams_act_access aac,
531: jtf_rs_groups_denorm jgd,
532: jtf_rs_group_members jgm
533: WHERE aac.arc_act_access_to_object = p_object_type
534: AND aac.act_access_to_object_id = p_object_id
535: AND arc_user_or_role_type = 'GROUP'
536: AND user_or_role_id = jgd.parent_group_id

Line 549: jtf_rs_group_members jgm

545: */
546: AND EXISTS ( SELECT 1
547: FROM ams_act_access aac,
548: jtf_rs_groups_denorm jgd,
549: jtf_rs_group_members jgm
550: WHERE aac.arc_act_access_to_object = p_object_type
551: AND aac.act_access_to_object_id = p_object_id
552: AND arc_user_or_role_type = 'GROUP'
553: AND user_or_role_id = jgd.parent_group_id

Line 564: jtf_rs_group_members jgm

560: )
561: AND NOT EXISTS ( SELECT 1
562: FROM ams_act_access aac,
563: jtf_rs_groups_denorm jgd,
564: jtf_rs_group_members jgm
565: WHERE aac.arc_act_access_to_object = p_object_type
566: AND aac.act_access_to_object_id = p_object_id
567: AND arc_user_or_role_type = 'GROUP'
568: AND user_or_role_id = jgd.parent_group_id

Line 608: jtf_rs_group_members jgm

604: WHERE object_type = p_object_type
605: AND object_id = p_object_id
606: AND resource_id IN ( SELECT jgm.resource_id
607: FROM jtf_rs_groups_denorm jgd,
608: jtf_rs_group_members jgm
609: WHERE jgd.parent_group_id = p_group_id
610: AND jgd.group_id = jgm.group_id
611: AND jgd.start_date_active <= TRUNC(SYSDATE)
612: -- delete every group even if it was end dated earlier than SYSDATE - SVEERAVE 05/15/02

Line 618: jtf_rs_group_members jgm

614: AND jgm.delete_flag='N' )
615: AND NOT EXISTS ( SELECT 1
616: FROM ams_act_access aac,
617: jtf_rs_groups_denorm jgd,
618: jtf_rs_group_members jgm
619: WHERE aac.arc_act_access_to_object = p_object_type
620: AND aac.act_access_to_object_id = p_object_id
621: AND arc_user_or_role_type = 'GROUP'
622: AND aac.delete_flag = 'N'

Line 654: jtf_rs_group_members jgm

650: AND object_id = p_object_id
651: AND resource_id NOT IN ( SELECT jgm.resource_id
652: FROM ams_act_access aac,
653: jtf_rs_groups_denorm jgd,
654: jtf_rs_group_members jgm
655: WHERE aac.arc_act_access_to_object = p_object_type
656: AND aac.act_access_to_object_id = p_object_id
657: AND arc_user_or_role_type = 'GROUP'
658: AND user_or_role_id = jgd.parent_group_id

Line 710: jtf_rs_group_members jgm

706: WHERE aacd.object_type = p_object_type
707: AND aacd.object_id = p_object_id
708: AND NOT EXISTS ( SELECT 1 --anchaudh 21-MAR-03
709: FROM jtf_rs_groups_denorm jgd,
710: jtf_rs_group_members jgm
711: WHERE jgd.parent_group_id = p_group_id
712: AND jgd.group_id = jgm.group_id
713: AND jgd.start_date_active <= TRUNC(SYSDATE)
714: AND NVL(jgd.end_date_active,SYSDATE) >= TRUNC(SYSDATE)

Line 720: jtf_rs_group_members jgm

716: AND jgm.resource_id = aacd.resource_id) --anchaudh 21-MAR-03
717: AND NOT EXISTS ( SELECT 1
718: FROM ams_act_access aac,
719: jtf_rs_groups_denorm jgd,
720: jtf_rs_group_members jgm
721: WHERE aac.arc_act_access_to_object = p_object_type
722: AND aac.act_access_to_object_id = p_object_id
723: AND arc_user_or_role_type = 'GROUP'
724: AND aac.delete_flag = 'N'

Line 1008: jtf_rs_group_members jgm

1004: , jgm.last_update_date
1005: ,aac.admin_flag
1006: FROM ams_act_access aac,
1007: jtf_rs_groups_denorm jrg,
1008: jtf_rs_group_members jgm
1009: WHERE aac.arc_user_or_role_type = 'GROUP'
1010: AND aac.user_or_role_id= jrg.parent_group_id
1011: AND jrg.group_id = jgm.group_id
1012: AND jrg.start_date_active <= trunc(sysdate)

Line 1164: jtf_rs_group_members jgm

1160: , jgm.last_update_date
1161: , aac.admin_flag
1162: FROM ams_act_access aac,
1163: jtf_rs_groups_denorm jrg,
1164: jtf_rs_group_members jgm
1165: WHERE
1166: ( aac.arc_user_or_role_type = 'GROUP'
1167: AND aac.user_or_role_id= jrg.parent_group_id
1168: AND aac.delete_flag='N'

Line 1200: jtf_rs_group_members jgm

1196: , jgm.last_update_date
1197: , aac.admin_flag
1198: FROM ams_act_access aac,
1199: jtf_rs_groups_denorm jrg,
1200: jtf_rs_group_members jgm
1201: WHERE
1202: ( aac.arc_user_or_role_type = 'GROUP'
1203: AND aac.user_or_role_id= jrg.parent_group_id
1204: AND aac.delete_flag='N'

Line 1218: jtf_rs_group_members jgm

1214: , jgm.last_update_date
1215: , aac.admin_flag
1216: FROM ams_act_access aac,
1217: jtf_rs_groups_denorm jrg,
1218: jtf_rs_group_members jgm
1219: WHERE
1220: ( aac.arc_user_or_role_type = 'GROUP'
1221: AND aac.user_or_role_id= jrg.parent_group_id
1222: AND aac.delete_flag='N'

Line 1236: jtf_rs_group_members jgm

1232: , jgm.last_update_date
1233: , aac.admin_flag
1234: FROM ams_act_access aac,
1235: jtf_rs_groups_denorm jrg,
1236: jtf_rs_group_members jgm
1237: WHERE
1238: ( aac.arc_user_or_role_type = 'GROUP'
1239: AND aac.user_or_role_id= jrg.parent_group_id
1240: AND aac.delete_flag='N'

Line 1259: jtf_rs_group_members jgm

1255: , jgm.last_update_date
1256: , aac.admin_flag
1257: FROM ams_act_access aac,
1258: jtf_rs_groups_denorm jrg,
1259: jtf_rs_group_members jgm
1260: WHERE
1261: ( aac.arc_user_or_role_type = 'GROUP'
1262: AND aac.user_or_role_id= jrg.parent_group_id
1263: AND aac.delete_flag='N'

Line 1295: jtf_rs_group_members jgm

1291: , jgm.last_update_date
1292: , aac.admin_flag
1293: FROM ams_act_access aac,
1294: jtf_rs_groups_denorm jrg,
1295: jtf_rs_group_members jgm
1296: WHERE
1297: ( aac.arc_user_or_role_type = 'GROUP'
1298: AND aac.user_or_role_id= jrg.parent_group_id
1299: AND aac.delete_flag='N'

Line 1313: jtf_rs_group_members jgm

1309: , jgm.last_update_date
1310: , aac.admin_flag
1311: FROM ams_act_access aac,
1312: jtf_rs_groups_denorm jrg,
1313: jtf_rs_group_members jgm
1314: WHERE
1315: ( aac.arc_user_or_role_type = 'GROUP'
1316: AND aac.user_or_role_id= jrg.parent_group_id
1317: AND aac.delete_flag='N'

Line 1331: jtf_rs_group_members jgm

1327: , jgm.last_update_date
1328: , aac.admin_flag
1329: FROM ams_act_access aac,
1330: jtf_rs_groups_denorm jrg,
1331: jtf_rs_group_members jgm
1332: WHERE
1333: ( aac.arc_user_or_role_type = 'GROUP'
1334: AND aac.user_or_role_id= jrg.parent_group_id
1335: AND aac.delete_flag='N'