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

Line 549: from jtf_rs_roles_vl r

545: , lp_terr_group_account_id NUMBER) IS
546: SELECT distinct
547: b.role_code role_code
548: , r.role_name role_name
549: from jtf_rs_roles_vl r
550: , jtf_tty_role_prod_int a
551: , jtf_tty_terr_grp_roles b
552: where r.role_code = b.role_code
553: and a.terr_group_role_id = b.terr_group_role_id

Line 2269: from jtf_rs_roles_vl r

2265: BEGIN
2266:
2267: SELECT COUNT( DISTINCT b.role_code )
2268: into l_pi_count
2269: from jtf_rs_roles_vl r
2270: , jtf_tty_role_prod_int a
2271: , jtf_tty_terr_grp_roles b
2272: where r.role_code = b.role_code
2273: and a.terr_group_role_id = b.terr_group_role_id

Line 4041: from jtf_rs_roles_vl r

4037: , lp_geo_territory_id NUMBER) IS
4038: SELECT distinct
4039: b.role_code role_code
4040: , r.role_name role_name
4041: from jtf_rs_roles_vl r
4042: , jtf_tty_role_prod_int a
4043: , jtf_tty_terr_grp_roles b
4044: where r.role_code = b.role_code
4045: and a.terr_group_role_id = b.terr_group_role_id

Line 4444: from jtf_rs_roles_vl r

4440: BEGIN
4441:
4442: SELECT COUNT( DISTINCT b.role_code )
4443: into l_pi_count
4444: from jtf_rs_roles_vl r
4445: , jtf_tty_role_prod_int a
4446: , jtf_tty_terr_grp_roles b
4447: where r.role_code = b.role_code
4448: and a.terr_group_role_id = b.terr_group_role_id