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_GROUPS_DENORM

Line 312: jtf_rs_groups_denorm jgd,

308: AND resource_id = p_resource_id
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'

Line 349: jtf_rs_groups_denorm jgd,

345: AND object_type = p_object_type
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'

Line 382: jtf_rs_groups_denorm jgd,

378: AND object_id = p_object_id
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'

Line 423: FROM jtf_rs_groups_denorm jgd,

419: , last_update_login = l_login_id
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)

Line 461: FROM jtf_rs_groups_denorm jgd,

457: , l_user_id
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)

Line 500: jtf_rs_groups_denorm jgd,

496: AND object_id = p_object_id
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'

Line 531: jtf_rs_groups_denorm jgd,

527: AND edit_metrics_yn = 'Y'
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'

Line 548: jtf_rs_groups_denorm jgd,

544: )
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'

Line 563: jtf_rs_groups_denorm jgd,

559: AND aac.delete_flag = 'N'
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'

Line 607: FROM jtf_rs_groups_denorm jgd,

603: DELETE FROM ams_act_access_denorm aacd
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)

Line 617: jtf_rs_groups_denorm jgd,

613: -- AND NVL(jgd.end_date_active,TRUNC(SYSDATE)) >= TRUNC(SYSDATE)
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'

Line 653: jtf_rs_groups_denorm jgd,

649: WHERE object_type = p_object_type
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'

Line 709: FROM jtf_rs_groups_denorm jgd,

705: DELETE FROM ams_act_access_denorm aacd
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)

Line 719: jtf_rs_groups_denorm jgd,

715: AND jgm.delete_flag='N'
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'

Line 1007: jtf_rs_groups_denorm jrg,

1003: , jgm.creation_date
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

Line 1163: jtf_rs_groups_denorm jrg,

1159: , jgm.resource_id
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

Line 1199: jtf_rs_groups_denorm jrg,

1195: , jgm.resource_id
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

Line 1217: jtf_rs_groups_denorm jrg,

1213: , jgm.resource_id
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

Line 1235: jtf_rs_groups_denorm jrg,

1231: , jgm.resource_id
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

Line 1258: jtf_rs_groups_denorm jrg,

1254: , jgm.resource_id
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

Line 1294: jtf_rs_groups_denorm jrg,

1290: , jgm.resource_id
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

Line 1312: jtf_rs_groups_denorm jrg,

1308: , jgm.resource_id
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

Line 1330: jtf_rs_groups_denorm jrg,

1326: , jgm.resource_id
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