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_REP_MANAGERS

Line 469: , jtf_rs_rep_managers sgh

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
473: WHERE usg.usage = 'SALES'

Line 525: FROM jtf_rs_rep_managers mgr

521: AND grpmemo.group_id = SALES_GRPS.group_id
522: AND NOT EXISTS (
523: /* Rep is not a manager */
524: SELECT NULL
525: FROM jtf_rs_rep_managers mgr
526: WHERE mgr.parent_resource_id = dir.resource_id
527: AND mgr.parent_resource_id = mgr.resource_id
528: AND mgr.group_id = grpmemo.group_id
529: AND mgr.hierarchy_type = 'MGR_TO_MGR'

Line 716: FROM jtf_rs_rep_managers repmgr,

712: ( SELECT /*+ NO_MERGE */
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

Line 859: jtf_rs_rep_managers sgh ,

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
863: WHERE usg.usage = 'SALES'