APPS.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_RS_GROUPS_DENORM

Line 390: FROM JTF_RS_GROUPS_DENORM /*jtf_rs_grp_denorm_vl*/ grpd

386: FROM jtf_tty_srch_my_resources_v /*jtf_tty_my_resources_v*/ grv,
387: jtf_tty_terr_grp_owners jto
388: WHERE EXISTS
389: ( SELECT NULL
390: FROM JTF_RS_GROUPS_DENORM /*jtf_rs_grp_denorm_vl*/ grpd
391: WHERE /* part of Salesgroup hierarchy of Territory Group owner */
392: grpd.parent_group_id = JTO.rsc_group_id
393: /* groups I (logged-in user) am 'member' of */
394: AND grpd.group_id = GRV.group_id

Line 468: , jtf_rs_groups_denorm dv

464: , mrsc.resource_id current_user_rsc_id
465: , usg.USAGE
466: , rol.role_code current_user_role_code
467: FROM jtf_rs_group_usages usg
468: , jtf_rs_groups_denorm dv
469: , jtf_rs_rep_managers sgh
470: , jtf_rs_resource_extns mrsc
471: , jtf_rs_roles_b rol
472: , jtf_rs_role_relations rlt

Line 536: FROM JTF_RS_GROUPS_DENORM /*jtf_rs_grp_denorm_vl*/ grpd

532: , jtf_tty_terr_grp_owners tgo
533: , jtf_tty_terr_grp_roles tgr
534: WHERE EXISTS (
535: SELECT NULL
536: FROM JTF_RS_GROUPS_DENORM /*jtf_rs_grp_denorm_vl*/ grpd
537: WHERE grpd.parent_group_id = TGO.rsc_group_id
538: AND grpd.group_id = MY_REPS.group_id )
539: AND tgr.role_code = MY_REPS.role_code
540: AND tgr.terr_group_id = tgo.terr_group_id

Line 858: jtf_rs_groups_denorm dv ,

854: jtf_rs_resource_extns dir ,
855: ( SELECT /*+ NO_MERGE */ dv.group_id ,
856: mrsc.user_id CURRENT_USER_ID
857: FROM jtf_rs_group_usages usg ,
858: jtf_rs_groups_denorm dv ,
859: jtf_rs_rep_managers sgh ,
860: jtf_rs_resource_extns mrsc ,
861: jtf_rs_roles_b rol ,
862: jtf_rs_role_relations rlt