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_ROLES_B

Line 184: jtf_rs_roles_b rol,

180: BEGIN
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

Line 471: , jtf_rs_roles_b rol

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'
474: AND usg.group_id = dv.group_id
475: AND rlt.role_id = rol.role_id

Line 718: jtf_rs_roles_b rol,

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
722: AND repmgr.par_role_relate_id = rlt.role_relate_id

Line 861: jtf_rs_roles_b rol ,

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'
864: AND usg.group_id = dv.group_id
865: AND rlt.role_id = rol.role_id