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_TERR_ALL

Line 231: from jtf_terr_all

227:
228: /* get all the Territories to DELETE */
229: CURSOR delterr IS
230: SELECT terr_id
231: from jtf_terr_all
232: where terr_group_flag = 'Y';
233:
234: BEGIN
235:

Line 243: FROM jtf_terr_qual_all jtq, jtf_terr_all jt

239: --DELETE territory value records
240: DELETE FROM jtf_terr_values_all jtv
241: WHERE jtv.terr_qual_id IN
242: ( SELECT jtq.terr_qual_id
243: FROM jtf_terr_qual_all jtq, jtf_terr_all jt
244: WHERE jtq.terr_id = jt.terr_id
245: AND jt.terr_group_flag = 'Y' );
246:
247: COMMIT;

Line 253: FROM jtf_terr_all jt

249: --Delete Territory Qualifer records
250: DELETE from JTF_TERR_QUAL_ALL jtq
251: WHERE jtq.terr_id IN
252: ( SELECT jt.terr_id
253: FROM jtf_terr_all jt
254: WHERE jt.terr_group_flag = 'Y' );
255:
256: COMMIT;
257:

Line 262: FROM jtf_terr_all jt

258: --Delete Territory qual type usgs
259: DELETE from JTF_TERR_QTYPE_USGS_ALL jtqu
260: WHERE jtqu.terr_id IN
261: ( SELECT jt.terr_id
262: FROM jtf_terr_all jt
263: WHERE jt.terr_group_flag = 'Y' );
264:
265: COMMIT;
266:

Line 271: FROM jtf_terr_all jt

267: --Delete Territory usgs
268: DELETE from JTF_TERR_USGS_ALL jtu
269: WHERE jtu.terr_id IN
270: ( SELECT jt.terr_id
271: FROM jtf_terr_all jt
272: WHERE jt.terr_group_flag = 'Y' );
273:
274: COMMIT;
275:

Line 280: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt

276: --Delete Territory Resource Access
277: DELETE from JTF_TERR_RSC_ACCESS_ALL jtra
278: WHERE jtra.terr_rsc_id IN
279: ( SELECT jtr.terr_rsc_id
280: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt
281: WHERE jtr.terr_id = jt.terr_id
282: AND jt.terr_group_flag = 'Y' );
283:
284: COMMIT;

Line 290: FROM jtf_terr_all jt

286: -- Delete the Territory Resource records
287: DELETE from JTF_TERR_RSC_ALL jtr
288: WHERE jtr.terr_id IN
289: ( SELECT jt.terr_id
290: FROM jtf_terr_all jt
291: WHERE jt.terr_group_flag = 'Y' );
292:
293: COMMIT;
294:

Line 296: DELETE from JTF_TERR_ALL jt

292:
293: COMMIT;
294:
295: --Delete Territory record
296: DELETE from JTF_TERR_ALL jt
297: WHERE jt.terr_id IN
298: ( SELECT jt.terr_id
299: FROM jtf_terr_all jt
300: WHERE jt.terr_group_flag = 'Y' );

Line 299: FROM jtf_terr_all jt

295: --Delete Territory record
296: DELETE from JTF_TERR_ALL jt
297: WHERE jt.terr_id IN
298: ( SELECT jt.terr_id
299: FROM jtf_terr_all jt
300: WHERE jt.terr_group_flag = 'Y' );
301:
302: COMMIT;
303:

Line 453: , JTF_TERR_ALL B

449: , A.NUM_WINNERS /* JDOCHERT: 07/29/03: BUG#3072230 */
450: , A.SELF_SERVICE_TYPE
451: , B.ORG_ID
452: FROM JTF_TTY_TERR_GROUPS A
453: , JTF_TERR_ALL B
454: WHERE A.parent_terr_id = b.terr_id
455: AND ( a.active_to_date >= SYSDATE OR a.active_to_date IS NULL )
456: AND a.active_from_date <= SYSDATE;
457:

Line 744: from jtf_terr_all

740: , description
741: , rank
742: , parent_territory_id
743: , terr_id
744: from jtf_terr_all
745: where terr_id = l_terr;
746:
747: /* get Qualifiers used in a territory */
748: CURSOR csr_get_qual( lp_terr_id NUMBER) IS

Line 1071: UPDATE JTF_TERR_ALL

1067: /* BEGIN: SUCCESSFUL TERRITORY CREATION? */
1068: IF X_RETURN_STATUS = 'S' THEN
1069:
1070: /* JDOCHERT: 01/08/03: ADDED TERR_GROUP_ID */
1071: UPDATE JTF_TERR_ALL
1072: SET TERR_GROUP_FLAG = 'Y'
1073: , CATCH_ALL_FLAG = 'N'
1074: , TERR_GROUP_ID = TERR_GROUP.TERR_GROUP_ID
1075: , NUM_WINNERS = TERR_GROUP.NUM_WINNERS

Line 1315: UPDATE JTF_TERR_ALL

1311: /* BEGIN: Successful Territory creation? */
1312: IF x_return_status = 'S' THEN
1313:
1314: /* JDOCHERT: 01/08/03: Added TERR_GROUP_ID and CATCH_ALL_FLAG */
1315: UPDATE JTF_TERR_ALL
1316: set TERR_GROUP_FLAG = 'Y'
1317: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
1318: , CATCH_ALL_FLAG = 'Y'
1319: where terr_id = x_terr_id;

Line 1478: FROM jtf_terr_all jt

1474: l_terr_exists := 0;
1475:
1476: SELECT COUNT(*)
1477: INTO l_terr_exists
1478: FROM jtf_terr_all jt
1479: WHERE jt.terr_id = naterr.terr_group_account_id * -100;
1480:
1481: IF (l_terr_exists = 0) THEN
1482: l_terr_all_rec.TERR_ID := naterr.terr_group_account_id * -100;

Line 1693: UPDATE JTF_TERR_ALL

1689: if x_return_status = 'S' then
1690:
1691: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID and CATCH_ALL_FLAG
1692: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
1693: UPDATE JTF_TERR_ALL
1694: set TERR_GROUP_FLAG = 'Y'
1695: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
1696: , CATCH_ALL_FLAG = 'N'
1697: , NAMED_ACCOUNT_FLAG = 'Y'

Line 1871: FROM jtf_terr_all jt

1867: l_terr_exists := 0;
1868:
1869: SELECT COUNT(*)
1870: INTO l_terr_exists
1871: FROM jtf_terr_all jt
1872: WHERE jt.terr_id = naterr.terr_group_account_id * -10000;
1873:
1874: IF (l_terr_exists = 0) THEN
1875: l_terr_all_rec.TERR_ID := naterr.terr_group_account_id * -10000;

Line 2083: UPDATE JTF_TERR_ALL

2079: if x_return_status = 'S' then
2080:
2081: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID and CATCH_ALL_FLAG
2082: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
2083: UPDATE JTF_TERR_ALL
2084: set TERR_GROUP_FLAG = 'Y'
2085: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
2086: , CATCH_ALL_FLAG = 'N'
2087: , NAMED_ACCOUNT_FLAG = 'Y'

Line 2478: UPDATE JTF_TERR_ALL

2474:
2475: if x_return_status = 'S' then
2476:
2477: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID
2478: UPDATE JTF_TERR_ALL
2479: set TERR_GROUP_FLAG = 'Y'
2480: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
2481: where terr_id = x_terr_id;
2482:

Line 2672: UPDATE JTF_TERR_ALL

2668: if x_return_status = 'S' then
2669:
2670: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID
2671: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
2672: UPDATE JTF_TERR_ALL
2673: set TERR_GROUP_FLAG = 'Y'
2674: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
2675: , NAMED_ACCOUNT_FLAG = 'Y'
2676: , TERR_GROUP_ACCOUNT_ID = overlayterr.terr_group_account_id

Line 2913: UPDATE JTF_TERR_ALL

2909: if (x_return_status = 'S') then
2910:
2911: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID
2912: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
2913: UPDATE JTF_TERR_ALL
2914: set TERR_GROUP_FLAG = 'Y'
2915: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
2916: , NAMED_ACCOUNT_FLAG = 'Y'
2917: , TERR_GROUP_ACCOUNT_ID = overlayterr.terr_group_account_id

Line 3255: UPDATE JTF_TERR_ALL

3251: if x_return_status = 'S' then
3252:
3253: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID
3254: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
3255: UPDATE JTF_TERR_ALL
3256: set TERR_GROUP_FLAG = 'Y'
3257: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
3258: , NAMED_ACCOUNT_FLAG = 'Y'
3259: , TERR_GROUP_ACCOUNT_ID = overlayterr.terr_group_account_id

Line 3495: UPDATE JTF_TERR_ALL

3491: IF (x_return_status = 'S') THEN
3492:
3493: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID
3494: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
3495: UPDATE JTF_TERR_ALL
3496: set TERR_GROUP_FLAG = 'Y'
3497: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
3498: , NAMED_ACCOUNT_FLAG = 'Y'
3499: , TERR_GROUP_ACCOUNT_ID = overlayterr.terr_group_account_id

Line 3984: from jtf_terr_all

3980: , description
3981: , rank
3982: , parent_territory_id
3983: , terr_id
3984: from jtf_terr_all
3985: where terr_id = l_terr;
3986:
3987: /* get Qualifiers used in a territory */
3988: CURSOR csr_get_qual( lp_terr_id NUMBER) IS

Line 4293: UPDATE JTF_TERR_ALL

4289:
4290: -- JDOCHERT: 01/08/03: Added p_terr_group_rec_ID and CATCH_ALL_FLAG
4291: -- and NAMED_ACCOUNT_FLAG and p_terr_group_rec_ACCOUNT_ID
4292:
4293: UPDATE JTF_TERR_ALL
4294: set TERR_GROUP_FLAG = 'Y'
4295: , TERR_GROUP_ID = p_terr_group_rec.TERR_GROUP_ID
4296: where terr_id = x_terr_id;
4297:

Line 4661: UPDATE JTF_TERR_ALL

4657:
4658: if x_return_status = 'S' then
4659:
4660: -- JDOCHERT: 01/08/03: Added p_terr_group_rec.ID
4661: UPDATE JTF_TERR_ALL
4662: set terr_group_FLAG = 'Y'
4663: , terr_group_ID = p_terr_group_rec.TERR_GROUP_ID
4664: where terr_id = x_terr_id;
4665:

Line 4849: UPDATE JTF_TERR_ALL

4845:
4846: if x_return_status = 'S' then
4847:
4848:
4849: UPDATE JTF_TERR_ALL
4850: set TERR_GROUP_FLAG = 'Y'
4851: , TERR_GROUP_ID = p_terr_group_rec.TERR_GROUP_ID
4852: where terr_id = x_terr_id;
4853:

Line 5083: UPDATE JTF_TERR_ALL

5079: );
5080:
5081: if (x_return_status = 'S') then
5082:
5083: UPDATE JTF_TERR_ALL
5084: set TERR_GROUP_FLAG = 'Y'
5085: , TERR_GROUP_ID = p_terr_group_rec.TERR_GROUP_ID
5086: where terr_id = x_terr_id;
5087: