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_RESOURCE_EXTNS

Line 179: , jtf_rs_resource_extns dir

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' )
181: AND rlt.role_id = rol.role_id
182: AND rlt.role_resource_type = 'RS_GROUP_MEMBER'
183: AND rlt.delete_flag = 'N'

Line 193: , jtf_rs_resource_extns mrsc

189: AND grpmemo.group_id IN ( SELECT dv.group_id
190: FROM jtf_rs_group_usages usg
191: , jtf_rs_groups_denorm dv
192: , jtf_rs_rep_managers sgh
193: , jtf_rs_resource_extns mrsc
194: WHERE usg.usage = 'SALES'
195: AND usg.group_id = dv.group_id
196: -- AND dv.immediate_parent_flag = 'Y'
197: AND dv.parent_group_id = sgh.group_id

Line 255: , jtf_rs_resource_extns dir

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
257: FROM jtf_rs_group_usages usg
258: , jtf_rs_groups_denorm dv
259: , jtf_rs_rep_managers sgh

Line 260: , jtf_rs_resource_extns mrsc

256: , ( SELECT distinct dv.group_id, dv.immediate_parent_flag child_group_flag
257: FROM jtf_rs_group_usages usg
258: , jtf_rs_groups_denorm dv
259: , jtf_rs_rep_managers sgh
260: , jtf_rs_resource_extns mrsc
261: WHERE usg.usage = 'SALES'
262: AND usg.group_id = dv.group_id
263: AND ( dv.immediate_parent_flag = 'Y' OR dv.group_id = dv.parent_group_id )
264: AND dv.parent_group_id = sgh.group_id