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_TTY_GEO_TERR_RSC

Line 997: JTF_TTY_GEO_TERR_RSC grsc

993: */
994: CURSOR get_NON_OVLY_geo_trans(l_geo_territory_id NUMBER) IS
995: SELECT ra.access_type
996: FROM
997: JTF_TTY_GEO_TERR_RSC grsc
998: , jtf_tty_geo_terr gtr
999: , jtf_tty_terr_grp_roles tgr
1000: , jtf_tty_role_access ra
1001: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id

Line 1010: JTF_TTY_GEO_TERR_RSC grsc

1006: AND ra.access_type IN ('ACCOUNT')
1007: UNION
1008: SELECT ra.access_type
1009: FROM
1010: JTF_TTY_GEO_TERR_RSC grsc
1011: , jtf_tty_geo_terr gtr
1012: , jtf_tty_terr_grp_roles tgr
1013: , jtf_tty_role_access ra
1014: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id

Line 1180: FROM jtf_tty_geo_terr_rsc a

1176: CURSOR terr_resource (l_geo_territory_id NUMBER,l_role VARCHAR2) IS
1177: SELECT DISTINCT a.resource_id
1178: , a.rsc_group_id
1179: , NVL(a.rsc_resource_type,'RS_EMPLOYEE') rsc_resource_type
1180: FROM jtf_tty_geo_terr_rsc a
1181: , jtf_tty_geo_terr b
1182: WHERE a.geo_territory_id = b.geo_territory_id
1183: AND b.geo_territory_id = l_geo_territory_id
1184: AND a.rsc_role_code = l_role;

Line 1233: FROM jtf_tty_geo_terr_rsc grsc

1229: WHERE gterr.terr_group_id = lp_terr_group_id
1230: AND EXISTS (
1231: /* Salesperson, with Role that has a Product Interest defined, exists for this Named Account */
1232: SELECT NULL
1233: FROM jtf_tty_geo_terr_rsc grsc
1234: , jtf_tty_role_prod_int rpi
1235: , jtf_tty_terr_grp_roles tgr
1236: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
1237: AND tgr.terr_group_id = gterr.TERR_GROUP_ID

Line 1257: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

1253: AND b.terr_group_id = lp_terr_group_id
1254: AND EXISTS (
1255: /* Named Account exists with Salesperson with this role */
1256: SELECT NULL
1257: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
1258: WHERE gterr.geo_territory_id = grsc.geo_territory_id
1259: AND grsc.geo_territory_id = lp_geo_territory_id
1260: AND gterr.terr_group_id = b.terr_group_id
1261: AND grsc.rsc_role_code = b.role_code );

Line 1782: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

1778: AND b.terr_group_id = p_TERR_GROUP_ID(x)
1779: AND EXISTS (
1780: /* Geography Territory exists with Salesperson with this role */
1781: SELECT NULL
1782: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
1783: WHERE grsc.geo_territory_id = gterr.geo_territory_id
1784: AND gterr.terr_group_id = b.terr_group_id
1785: AND grsc.rsc_role_code = b.role_code )
1786: AND ROWNUM < 2;

Line 2498: JTF_TTY_GEO_TERR_RSC grsc

2494: */
2495: CURSOR get_NON_OVLY_geo_trans(l_geo_territory_id NUMBER) IS
2496: SELECT ra.access_type
2497: FROM
2498: JTF_TTY_GEO_TERR_RSC grsc
2499: , jtf_tty_geo_terr gtr
2500: , jtf_tty_terr_grp_roles tgr
2501: , jtf_tty_role_access ra
2502: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id

Line 2511: JTF_TTY_GEO_TERR_RSC grsc

2507: AND ra.access_type IN ('ACCOUNT')
2508: UNION
2509: SELECT ra.access_type
2510: FROM
2511: JTF_TTY_GEO_TERR_RSC grsc
2512: , jtf_tty_geo_terr gtr
2513: , jtf_tty_terr_grp_roles tgr
2514: , jtf_tty_role_access ra
2515: WHERE grsc.GEO_TERRITORY_ID = l_geo_territory_id

Line 2681: FROM jtf_tty_geo_terr_rsc a

2677: CURSOR terr_resource (l_geo_territory_id NUMBER,l_role VARCHAR2) IS
2678: SELECT DISTINCT a.resource_id
2679: , a.rsc_group_id
2680: , NVL(a.rsc_resource_type,'RS_EMPLOYEE') rsc_resource_type
2681: FROM jtf_tty_geo_terr_rsc a
2682: , jtf_tty_geo_terr b
2683: WHERE a.geo_territory_id = b.geo_territory_id
2684: AND b.geo_territory_id = l_geo_territory_id
2685: AND a.rsc_role_code = l_role;

Line 2734: FROM jtf_tty_geo_terr_rsc grsc

2730: WHERE gterr.terr_group_id = lp_terr_group_id
2731: AND EXISTS (
2732: /* Salesperson, with Role that has a Product Interest defined, exists for this Named Account */
2733: SELECT NULL
2734: FROM jtf_tty_geo_terr_rsc grsc
2735: , jtf_tty_role_prod_int rpi
2736: , jtf_tty_terr_grp_roles tgr
2737: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
2738: AND tgr.terr_group_id = gterr.TERR_GROUP_ID

Line 2758: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

2754: AND b.terr_group_id = lp_terr_group_id
2755: AND EXISTS (
2756: /* Named Account exists with Salesperson with this role */
2757: SELECT NULL
2758: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
2759: WHERE gterr.geo_territory_id = grsc.geo_territory_id
2760: AND grsc.geo_territory_id = lp_geo_territory_id
2761: AND gterr.terr_group_id = b.terr_group_id
2762: AND grsc.rsc_role_code = b.role_code );

Line 3448: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr

3444: AND b.terr_group_id = p_TERR_GROUP_ID(x)
3445: AND EXISTS (
3446: /* Geography territory exists with Salesperson with this role */
3447: SELECT NULL
3448: FROM jtf_tty_geo_terr_rsc grsc, jtf_tty_geo_terr gterr
3449: WHERE grsc.geo_territory_id = gterr.geo_territory_id
3450: AND gterr.terr_group_id = b.terr_group_id
3451: AND grsc.rsc_role_code = b.role_code )
3452: AND ROWNUM < 2;