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_ALIGN_ACTIVATE_PKG dependencies on JTF_RS_ROLES_B

Line 176: FROM jtf_rs_roles_b rol

172: /* Salesperson directly/indirectly reports to user */
173: SELECT dir.resource_id
174: , grpmemo.group_id
175: , rol.role_code
176: FROM jtf_rs_roles_b rol
177: , jtf_rs_role_relations rlt
178: , jtf_rs_group_members grpmemo
179: , jtf_rs_resource_extns dir
180: WHERE ( rol.manager_flag = 'Y' or rol.member_flag = 'Y' )

Line 252: FROM jtf_rs_roles_b rol

248: and (ALPT.resource_id, ALPT.rsc_group_id, ALPT.rsc_role_code) IN
249: ( SELECT dir.resource_id
250: , grpmemo.group_id
251: , rol.role_code
252: FROM jtf_rs_roles_b rol
253: , jtf_rs_role_relations rlt
254: , jtf_rs_group_members grpmemo
255: , jtf_rs_resource_extns dir
256: , ( SELECT distinct dv.group_id, dv.immediate_parent_flag child_group_flag