APPS.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_GROUP_USAGES

Line 322: , jtf_rs_group_usages usg

318: AND mgr.resource_id = res.resource_id
319: AND res.user_id IS NOT NULL
320: ) x
321: , jtf_rs_groups_b g
322: , jtf_rs_group_usages usg
323: WHERE x.group_id = g.group_id
324: AND x.group_id = usg.group_id
325: AND usg.usage = l_usage
326: ;

Line 371: , jtf_rs_group_usages usg

367: ,l_sysdate, l_user_id
368: ,DECODE(d1.active_flag,'Y','Y','N')
369: ,l_sysdate, l_user_id, usg.usage
370: FROM jtf_rs_groups_denorm d1 , jtf_rs_dbi_mgr_groups n1
371: , jtf_rs_group_usages usg
372: WHERE n1.group_id = d1.actual_parent_id
373: AND d1.denorm_level = 1
374: AND d1.latest_relationship_flag = 'Y'
375: AND d1.group_id = usg.group_id

Line 418: ,jtf_rs_group_usages usg

414: ,DECODE(d1.active_flag,'Y','Y','N')
415: ,l_sysdate, l_user_id, usg.usage
416: FROM jtf_rs_groups_denorm d1 , jtf_rs_groups_denorm d2,
417: jtf_rs_dbi_mgr_groups n1
418: ,jtf_rs_group_usages usg
419: WHERE n1.group_id = d1.parent_group_id
420: AND d1.group_id = d2.actual_parent_id
421: AND n1.group_id = d2.parent_group_id
422: AND d1.group_id <> d2.group_id

Line 467: ,jtf_rs_group_usages usg

463: ,l_sysdate, l_user_id
464: ,DECODE(d1.active_flag,'Y','Y','N')
465: ,l_sysdate, l_user_id, usg.usage
466: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
467: ,jtf_rs_group_usages usg
468: WHERE n1.group_id = d1.parent_group_id
469: AND d1.latest_relationship_flag = 'Y'
470: AND d1.group_id = usg.group_id
471: AND usg.usage = l_usage

Line 512: ,jtf_rs_group_usages usg

508: ,l_sysdate, l_user_id
509: ,DECODE(d1.active_flag,'Y','Y','N')
510: ,l_sysdate, l_user_id, usg.usage
511: FROM jtf_rs_groups_denorm d1, jtf_rs_dbi_mgr_groups n1
512: ,jtf_rs_group_usages usg
513: WHERE n1.group_id = d1.parent_group_id
514: AND d1.denorm_level > 0
515: AND d1.latest_relationship_flag = 'Y'
516: AND d1.group_id = usg.group_id

Line 569: ,jtf_rs_group_usages usg1

565: SELECT /*+ use_hash(gm1 rrl1 rol1 usg1) PARALLEL(gm1) PARALLEL(rrl1) PARALLEL(rol1) PARALLEL(usg1)*/
566: DISTINCT gm1.resource_id, gm1.group_id
567: , 'A' mem_status, usg1.usage
568: FROM jtf_rs_group_members gm1, jtf_rs_role_relations rrl1, jtf_rs_roles_b rol1
569: ,jtf_rs_group_usages usg1
570: WHERE gm1.group_member_id = rrl1.role_resource_id
571: AND gm1.delete_flag = 'N'
572: AND rrl1.role_resource_type = 'RS_GROUP_MEMBER'
573: AND rrl1.delete_flag = 'N'

Line 584: ,jtf_rs_group_usages usg2

580: SELECT /*+ use_hash(gm2 rrl2 rol2 usg2) PARALLEL(gm2) PARALLEL(rrl2) PARALLEL(rol2) PARALLEL(usg2) */
581: DISTINCT gm2.resource_id, gm2.group_id
582: , 'I' mem_status, usg2.usage
583: FROM jtf_rs_group_members gm2, jtf_rs_role_relations rrl2, jtf_rs_roles_b rol2
584: ,jtf_rs_group_usages usg2
585: WHERE gm2.group_member_id = rrl2.role_resource_id
586: AND gm2.delete_flag = 'N'
587: AND rrl2.role_resource_type = 'RS_GROUP_MEMBER'
588: AND rrl2.delete_flag = 'N'

Line 599: , jtf_rs_group_usages usg3

595: SELECT /*+ use_hash(gm3 rrl3 rol3 usg3) PARALLEL(gm3) PARALLEL(rrl3) PARALLEL(rol3) PARALLEL(usg3)*/
596: '1'
597: FROM jtf_rs_group_members gm3, jtf_rs_role_relations rrl3
598: , jtf_rs_roles_b rol3
599: , jtf_rs_group_usages usg3
600: WHERE gm3.group_member_id = rrl3.role_resource_id
601: AND gm3.delete_flag = 'N'
602: AND rrl3.role_resource_type = 'RS_GROUP_MEMBER'
603: AND rrl3.delete_flag = 'N'

Line 642: ,jtf_rs_group_usages usg

638: FROM jtf_rs_group_members gm
639: ,jtf_rs_role_relations rrl
640: ,jtf_rs_roles_b rol
641: ,jtf_rs_resource_extns_vl res
642: ,jtf_rs_group_usages usg
643: WHERE gm.delete_flag = 'N'
644: AND gm.group_member_id = rrl.role_resource_id
645: AND rrl.role_resource_type = 'RS_GROUP_MEMBER'
646: AND rrl.delete_flag = 'N'