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

Line 1248: FROM jtf_rs_roles_vl r

1244: , lp_geo_territory_id NUMBER) IS
1245: SELECT DISTINCT
1246: b.role_code role_code
1247: , r.role_name role_name
1248: FROM jtf_rs_roles_vl r
1249: , jtf_tty_role_prod_int a
1250: , jtf_tty_terr_grp_roles b
1251: WHERE r.role_code = b.role_code
1252: AND a.terr_group_role_id = b.terr_group_role_id

Line 1773: FROM jtf_rs_roles_vl r

1769: BEGIN
1770:
1771: SELECT COUNT( DISTINCT b.role_code )
1772: INTO l_pi_count
1773: FROM jtf_rs_roles_vl r
1774: , jtf_tty_role_prod_int a
1775: , jtf_tty_terr_grp_roles b
1776: WHERE r.role_code = b.role_code
1777: AND a.terr_group_role_id = b.terr_group_role_id

Line 2749: FROM jtf_rs_roles_vl r

2745: , lp_geo_territory_id NUMBER) IS
2746: SELECT DISTINCT
2747: b.role_code role_code
2748: , r.role_name role_name
2749: FROM jtf_rs_roles_vl r
2750: , jtf_tty_role_prod_int a
2751: , jtf_tty_terr_grp_roles b
2752: WHERE r.role_code = b.role_code
2753: AND a.terr_group_role_id = b.terr_group_role_id

Line 3439: FROM jtf_rs_roles_vl r

3435: BEGIN
3436:
3437: SELECT COUNT( DISTINCT b.role_code )
3438: INTO l_pi_count
3439: FROM jtf_rs_roles_vl r
3440: , jtf_tty_role_prod_int a
3441: , jtf_tty_terr_grp_roles b
3442: WHERE r.role_code = b.role_code
3443: AND a.terr_group_role_id = b.terr_group_role_id

Line 4442: FROM jtf_rs_roles_vl r

4438: , lp_terr_group_account_id NUMBER) IS
4439: SELECT DISTINCT
4440: b.role_code role_code
4441: , r.role_name role_name
4442: FROM jtf_rs_roles_vl r
4443: , jtf_tty_role_prod_int a
4444: , jtf_tty_terr_grp_roles b
4445: WHERE r.role_code = b.role_code
4446: AND a.terr_group_role_id = b.terr_group_role_id

Line 5677: FROM jtf_rs_roles_vl r

5673: BEGIN
5674:
5675: SELECT COUNT( DISTINCT b.role_code )
5676: INTO l_pi_count
5677: FROM jtf_rs_roles_vl r
5678: , jtf_tty_role_prod_int a
5679: , jtf_tty_terr_grp_roles b
5680: WHERE r.role_code = b.role_code
5681: AND a.terr_group_role_id = b.terr_group_role_id

Line 7148: FROM jtf_rs_roles_vl r

7144: , lp_terr_group_account_id NUMBER) IS
7145: SELECT DISTINCT
7146: b.role_code role_code
7147: , r.role_name role_name
7148: FROM jtf_rs_roles_vl r
7149: , jtf_tty_role_prod_int a
7150: , jtf_tty_terr_grp_roles b
7151: WHERE r.role_code = b.role_code
7152: AND a.terr_group_role_id = b.terr_group_role_id

Line 8893: FROM jtf_rs_roles_vl r

8889: BEGIN
8890:
8891: SELECT COUNT( DISTINCT b.role_code )
8892: INTO l_pi_count
8893: FROM jtf_rs_roles_vl r
8894: , jtf_tty_role_prod_int a
8895: , jtf_tty_terr_grp_roles b
8896: WHERE r.role_code = b.role_code
8897: AND a.terr_group_role_id = b.terr_group_role_id