APPS.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_GROUP_USAGES

Line 315: , jtf_rs_group_usages usg

311: AND mgr.resource_id = res.resource_id
312: AND res.user_id IS NOT NULL
313: ) x
314: , jtf_rs_groups_b g
315: , jtf_rs_group_usages usg
316: WHERE x.group_id = g.group_id
317: AND x.group_id = usg.group_id
318: AND usg.usage = l_usage
319: ;

Line 364: , jtf_rs_group_usages usg

360: ,l_sysdate, l_user_id
361: ,DECODE(d1.active_flag,'Y','Y','N')
362: ,l_sysdate, l_user_id, usg.usage
363: FROM jtf_rs_groups_denorm d1 , jtf_rs_dbi_mgr_groups n1
364: , jtf_rs_group_usages usg
365: WHERE n1.group_id = d1.actual_parent_id
366: AND d1.denorm_level = 1
367: AND d1.latest_relationship_flag = 'Y'
368: AND d1.group_id = usg.group_id

Line 411: ,jtf_rs_group_usages usg

407: ,DECODE(d1.active_flag,'Y','Y','N')
408: ,l_sysdate, l_user_id, usg.usage
409: FROM jtf_rs_groups_denorm d1 , jtf_rs_groups_denorm d2,
410: jtf_rs_dbi_mgr_groups n1
411: ,jtf_rs_group_usages usg
412: WHERE n1.group_id = d1.parent_group_id
413: AND d1.group_id = d2.actual_parent_id
414: AND n1.group_id = d2.parent_group_id
415: AND d1.group_id <> d2.group_id

Line 460: ,jtf_rs_group_usages usg

456: ,l_sysdate, l_user_id
457: ,DECODE(d1.active_flag,'Y','Y','N')
458: ,l_sysdate, l_user_id, usg.usage
459: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
460: ,jtf_rs_group_usages usg
461: WHERE n1.group_id = d1.parent_group_id
462: AND d1.latest_relationship_flag = 'Y'
463: AND d1.group_id = usg.group_id
464: AND usg.usage = l_usage

Line 505: ,jtf_rs_group_usages usg

501: ,l_sysdate, l_user_id
502: ,DECODE(d1.active_flag,'Y','Y','N')
503: ,l_sysdate, l_user_id, usg.usage
504: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
505: ,jtf_rs_group_usages usg
506: WHERE n1.group_id = d1.parent_group_id
507: AND d1.denorm_level > 0
508: AND d1.latest_relationship_flag = 'Y'
509: AND d1.group_id = usg.group_id

Line 562: ,jtf_rs_group_usages usg1

558: SELECT /*+ use_hash(gm1 rrl1 rol1 usg1) PARALLEL(gm1) PARALLEL(rrl1) PARALLEL(rol1) PARALLEL(usg1)*/
559: DISTINCT gm1.resource_id, gm1.group_id
560: , 'A' mem_status, usg1.usage
561: FROM jtf_rs_group_members gm1, jtf_rs_role_relations rrl1, jtf_rs_roles_b rol1
562: ,jtf_rs_group_usages usg1
563: WHERE gm1.group_member_id = rrl1.role_resource_id
564: AND gm1.delete_flag = 'N'
565: AND rrl1.role_resource_type = 'RS_GROUP_MEMBER'
566: AND rrl1.delete_flag = 'N'

Line 577: ,jtf_rs_group_usages usg2

573: SELECT /*+ use_hash(gm2 rrl2 rol2 usg2) PARALLEL(gm2) PARALLEL(rrl2) PARALLEL(rol2) PARALLEL(usg2) */
574: DISTINCT gm2.resource_id, gm2.group_id
575: , 'I' mem_status, usg2.usage
576: FROM jtf_rs_group_members gm2, jtf_rs_role_relations rrl2, jtf_rs_roles_b rol2
577: ,jtf_rs_group_usages usg2
578: WHERE gm2.group_member_id = rrl2.role_resource_id
579: AND gm2.delete_flag = 'N'
580: AND rrl2.role_resource_type = 'RS_GROUP_MEMBER'
581: AND rrl2.delete_flag = 'N'

Line 592: , jtf_rs_group_usages usg3

588: SELECT /*+ use_hash(gm3 rrl3 rol3 usg3) PARALLEL(gm3) PARALLEL(rrl3) PARALLEL(rol3) PARALLEL(usg3)*/
589: '1'
590: FROM jtf_rs_group_members gm3, jtf_rs_role_relations rrl3
591: , jtf_rs_roles_b rol3
592: , jtf_rs_group_usages usg3
593: WHERE gm3.group_member_id = rrl3.role_resource_id
594: AND gm3.delete_flag = 'N'
595: AND rrl3.role_resource_type = 'RS_GROUP_MEMBER'
596: AND rrl3.delete_flag = 'N'

Line 635: ,jtf_rs_group_usages usg

631: FROM jtf_rs_group_members gm
632: ,jtf_rs_role_relations rrl
633: ,jtf_rs_roles_b rol
634: ,jtf_rs_resource_extns_vl res
635: ,jtf_rs_group_usages usg
636: WHERE gm.delete_flag = 'N'
637: AND gm.group_member_id = rrl.role_resource_id
638: AND rrl.role_resource_type = 'RS_GROUP_MEMBER'
639: AND rrl.delete_flag = 'N'