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_GROUP_USAGES

Line 467: FROM jtf_rs_group_usages usg

463: , mrsc.user_id CURRENT_USER_ID
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

Line 511: FROM jtf_rs_group_usages usg

507: , ( /* SALES GROUPS INLINE VIEW */
508: SELECT dv.group_id
509: , dv.group_id PARENT_GROUP_ID
510: , NULL PARENT_GROUP_NAME
511: FROM jtf_rs_group_usages usg
512: , jtf_rs_groups_b dv
513: WHERE usg.usage = 'SALES'
514: AND usg.group_id = dv.group_id
515: ) SALES_GRPS

Line 857: FROM jtf_rs_group_usages usg ,

853: FROM jtf_rs_group_members grpmemo ,
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 ,

Line 882: jtf_rs_group_usages usg

878: UNION ALL
879: SELECT 'Y'
880: FROM jtf_rs_group_members grpmemo ,
881: jtf_rs_resource_extns dir ,
882: jtf_rs_group_usages usg
883: WHERE usg.usage = 'SALES'
884: AND grpmemo.resource_id = dir.resource_id
885: AND grpmemo.group_id = usg.group_id
886: AND dir.user_id = l_user_id