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.JTF_TTY_WEBADI_SALSTEAM_UPDATE dependencies on JTF_RS_ROLE_RELATIONS

Line 185: jtf_rs_role_relations rlt

181: SELECT 'VALID'
182: INTO l_select
183: FROM jtf_rs_group_members mem,
184: jtf_rs_roles_b rol,
185: jtf_rs_role_relations rlt
186: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
187: AND rlt.delete_flag = 'N'
188: AND sysdate >= rlt.start_date_active
189: AND ( rlt.end_date_active is null

Line 453: , jtf_rs_role_relations rlt

449: , rol.role_code, rol.role_name
450: , MY_GRPS.current_user_role_code
451: , MY_GRPS.current_user_rsc_id
452: FROM jtf_rs_roles_vl rol
453: , jtf_rs_role_relations rlt
454: , jtf_rs_group_members grpmemo
455: , jtf_rs_resource_extns_vl dir
456:
457: , ( /* MY_GRPS INLINE VIEW */

Line 472: , jtf_rs_role_relations rlt

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
473: WHERE usg.usage = 'SALES'
474: AND usg.group_id = dv.group_id
475: AND rlt.role_id = rol.role_id
476: AND rlt.role_relate_id = sgh.par_role_relate_id

Line 504: , jtf_rs_role_relations rlt

500: , rol.role_code, rol.role_name
501: , rol.role_code current_user_role_code
502: , dir.resource_id current_user_rsc_id
503: FROM jtf_rs_roles_vl rol
504: , jtf_rs_role_relations rlt
505: , jtf_rs_group_members grpmemo
506: , jtf_rs_resource_extns_vl dir
507: , ( /* SALES GROUPS INLINE VIEW */
508: SELECT dv.group_id

Line 717: jtf_rs_role_relations rlt,

713: repmgr.parent_resource_id,
714: grpmem.group_id,
715: rol.role_code
716: FROM jtf_rs_rep_managers repmgr,
717: jtf_rs_role_relations rlt,
718: jtf_rs_roles_b rol,
719: jtf_rs_group_members grpmem
720: WHERE repmgr.resource_id = c_resource_id
721: AND repmgr.group_id = c_group_id

Line 862: jtf_rs_role_relations rlt

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
863: WHERE usg.usage = 'SALES'
864: AND usg.group_id = dv.group_id
865: AND rlt.role_id = rol.role_id
866: AND rlt.role_relate_id = sgh.par_role_relate_id