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_EXCEL_NAORG_PVT dependencies on JTF_RS_ROLES_VL

Line 579: jtf_rs_roles_vl rol,

575: SELECT role_code, MAX(num) num
576: FROM (
577: SELECT rol.role_code role_code, COUNT(rol.role_code) num
578: FROM
579: jtf_rs_roles_vl rol,
580: jtf_tty_named_acct_rsc narsc,
581: jtf_tty_terr_grp_accts ga
582: WHERE rol.role_code = narsc.rsc_role_code
583: AND narsc.terr_group_account_id = ga.terr_group_account_id

Line 616: , jtf_rs_roles_vl rol

612: , narsc.START_DATE
613: , narsc.END_DATE
614: FROM jtf_rs_resource_extns_vl rsc
615: , jtf_rs_groups_vl grp
616: , jtf_rs_roles_vl rol
617: , jtf_tty_named_acct_rsc narsc
618: , jtf_tty_terr_grp_accts ga
619: -- , jtf_tty_terr_groups tga
620: WHERE rsc.resource_id = narsc.resource_id