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_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_ALL

Line 248: from jtf_terr_all

244:
245: /* get all the Territories to DELETE */
246: CURSOR delterr IS
247: SELECT terr_id
248: from jtf_terr_all
249: where terr_group_flag = 'Y';
250:
251: BEGIN
252:

Line 260: FROM jtf_terr_qual_all jtq, jtf_terr_all jt

256: --DELETE territory value records
257: DELETE FROM jtf_terr_values_all jtv
258: WHERE jtv.terr_qual_id IN
259: ( SELECT jtq.terr_qual_id
260: FROM jtf_terr_qual_all jtq, jtf_terr_all jt
261: WHERE jtq.terr_id = jt.terr_id
262: AND jt.terr_group_flag = 'Y' );
263:
264: --Delete Territory Qualifer records

Line 268: FROM jtf_terr_all jt

264: --Delete Territory Qualifer records
265: DELETE from JTF_TERR_QUAL_ALL jtq
266: WHERE jtq.terr_id IN
267: ( SELECT jt.terr_id
268: FROM jtf_terr_all jt
269: WHERE jt.terr_group_flag = 'Y' );
270:
271:
272: --Delete Territory qual type usgs

Line 276: FROM jtf_terr_all jt

272: --Delete Territory qual type usgs
273: DELETE from JTF_TERR_QTYPE_USGS_ALL jtqu
274: WHERE jtqu.terr_id IN
275: ( SELECT jt.terr_id
276: FROM jtf_terr_all jt
277: WHERE jt.terr_group_flag = 'Y' );
278:
279:
280: --Delete Territory usgs

Line 284: FROM jtf_terr_all jt

280: --Delete Territory usgs
281: DELETE from JTF_TERR_USGS_ALL jtu
282: WHERE jtu.terr_id IN
283: ( SELECT jt.terr_id
284: FROM jtf_terr_all jt
285: WHERE jt.terr_group_flag = 'Y' );
286:
287:
288: --Delete Territory Resource Access

Line 292: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt

288: --Delete Territory Resource Access
289: DELETE from JTF_TERR_RSC_ACCESS_ALL jtra
290: WHERE jtra.terr_rsc_id IN
291: ( SELECT jtr.terr_rsc_id
292: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt
293: WHERE jtr.terr_id = jt.terr_id
294: AND jt.terr_group_flag = 'Y' );
295:
296:

Line 301: FROM jtf_terr_all jt

297: -- Delete the Territory Resource records
298: DELETE from JTF_TERR_RSC_ALL jtr
299: WHERE jtr.terr_id IN
300: ( SELECT jt.terr_id
301: FROM jtf_terr_all jt
302: WHERE jt.terr_group_flag = 'Y' );
303:
304:
305: --Delete Territory record

Line 306: DELETE from JTF_TERR_ALL jt

302: WHERE jt.terr_group_flag = 'Y' );
303:
304:
305: --Delete Territory record
306: DELETE from JTF_TERR_ALL jt
307: WHERE jt.terr_id IN
308: ( SELECT jt.terr_id
309: FROM jtf_terr_all jt
310: WHERE jt.terr_group_flag = 'Y' );

Line 309: FROM jtf_terr_all jt

305: --Delete Territory record
306: DELETE from JTF_TERR_ALL jt
307: WHERE jt.terr_id IN
308: ( SELECT jt.terr_id
309: FROM jtf_terr_all jt
310: WHERE jt.terr_group_flag = 'Y' );
311:
312:
313: END IF;

Line 455: , JTF_TERR_ALL B

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

Line 746: from jtf_terr_all

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

Line 1058: UPDATE JTF_TERR_ALL

1054: /* BEGIN: SUCCESSFUL TERRITORY CREATION? */
1055: IF X_RETURN_STATUS = 'S' THEN
1056:
1057: /* JDOCHERT: 01/08/03: ADDED TERR_GROUP_ID */
1058: UPDATE JTF_TERR_ALL
1059: SET TERR_GROUP_FLAG = 'Y'
1060: , CATCH_ALL_FLAG = 'N'
1061: , TERR_GROUP_ID = TERR_GROUP.TERR_GROUP_ID
1062: , NUM_WINNERS = TERR_GROUP.NUM_WINNERS

Line 1300: UPDATE JTF_TERR_ALL

1296: /* BEGIN: Successful Territory creation? */
1297: IF x_return_status = 'S' THEN
1298:
1299: /* JDOCHERT: 01/08/03: Added TERR_GROUP_ID and CATCH_ALL_FLAG */
1300: UPDATE JTF_TERR_ALL
1301: set TERR_GROUP_FLAG = 'Y'
1302: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
1303: , CATCH_ALL_FLAG = 'Y'
1304: where terr_id = x_terr_id;

Line 1465: FROM jtf_terr_all jt

1461: l_terr_exists := 0;
1462:
1463: SELECT COUNT(*)
1464: INTO l_terr_exists
1465: FROM jtf_terr_all jt
1466: WHERE jt.terr_id = naterr.terr_group_account_id * -100;
1467:
1468: IF (l_terr_exists = 0) THEN
1469: l_terr_all_rec.TERR_ID := naterr.terr_group_account_id * -100;

Line 1678: UPDATE JTF_TERR_ALL

1674: if x_return_status = 'S' then
1675:
1676: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID and CATCH_ALL_FLAG
1677: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
1678: UPDATE JTF_TERR_ALL
1679: set TERR_GROUP_FLAG = 'Y'
1680: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
1681: , CATCH_ALL_FLAG = 'N'
1682: , NAMED_ACCOUNT_FLAG = 'Y'

Line 1859: FROM jtf_terr_all jt

1855: l_terr_exists := 0;
1856:
1857: SELECT COUNT(*)
1858: INTO l_terr_exists
1859: FROM jtf_terr_all jt
1860: WHERE jt.terr_id = naterr.terr_group_account_id * -10000;
1861:
1862: IF (l_terr_exists = 0) THEN
1863: l_terr_all_rec.TERR_ID := naterr.terr_group_account_id * -10000;

Line 2072: UPDATE JTF_TERR_ALL

2068: if x_return_status = 'S' then
2069:
2070: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID and CATCH_ALL_FLAG
2071: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
2072: UPDATE JTF_TERR_ALL
2073: set TERR_GROUP_FLAG = 'Y'
2074: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
2075: , CATCH_ALL_FLAG = 'N'
2076: , NAMED_ACCOUNT_FLAG = 'Y'

Line 2468: UPDATE JTF_TERR_ALL

2464:
2465: if x_return_status = 'S' then
2466:
2467: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID
2468: UPDATE JTF_TERR_ALL
2469: set TERR_GROUP_FLAG = 'Y'
2470: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
2471: where terr_id = x_terr_id;
2472:

Line 2664: UPDATE JTF_TERR_ALL

2660: if x_return_status = 'S' then
2661:
2662: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID
2663: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
2664: UPDATE JTF_TERR_ALL
2665: set TERR_GROUP_FLAG = 'Y'
2666: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
2667: , NAMED_ACCOUNT_FLAG = 'Y'
2668: , TERR_GROUP_ACCOUNT_ID = overlayterr.terr_group_account_id

Line 2905: UPDATE JTF_TERR_ALL

2901: if (x_return_status = 'S') then
2902:
2903: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID
2904: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
2905: UPDATE JTF_TERR_ALL
2906: set TERR_GROUP_FLAG = 'Y'
2907: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
2908: , NAMED_ACCOUNT_FLAG = 'Y'
2909: , TERR_GROUP_ACCOUNT_ID = overlayterr.terr_group_account_id

Line 3247: UPDATE JTF_TERR_ALL

3243: if x_return_status = 'S' then
3244:
3245: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID
3246: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
3247: UPDATE JTF_TERR_ALL
3248: set TERR_GROUP_FLAG = 'Y'
3249: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
3250: , NAMED_ACCOUNT_FLAG = 'Y'
3251: , TERR_GROUP_ACCOUNT_ID = overlayterr.terr_group_account_id

Line 3487: UPDATE JTF_TERR_ALL

3483: IF (x_return_status = 'S') THEN
3484:
3485: -- JDOCHERT: 01/08/03: Added TERR_GROUP_ID
3486: -- and NAMED_ACCOUNT_FLAG and TERR_GROUP_ACCOUNT_ID
3487: UPDATE JTF_TERR_ALL
3488: set TERR_GROUP_FLAG = 'Y'
3489: , TERR_GROUP_ID = terr_group.TERR_GROUP_ID
3490: , NAMED_ACCOUNT_FLAG = 'Y'
3491: , TERR_GROUP_ACCOUNT_ID = overlayterr.terr_group_account_id

Line 3700: , jtf_terr_all jt1

3696: , lp_sysdate DATE ) IS
3697: SELECT 'TRUE'
3698: FROM jtf_terr_qtype_usgs_all jtqu
3699: , jtf_terr_usgs_all jtu
3700: , jtf_terr_all jt1
3701: , jtf_qual_type_usgs jqtu
3702: WHERE jtqu.terr_id = jt1.terr_id
3703: AND jqtu.qual_type_usg_id = jtqu.qual_type_usg_id
3704: AND jqtu.qual_type_id = lp_qual_type_id

Line 3717: FROM jtf_terr_all jt

3713: AND NVL(jtrs.start_date_active, lp_sysdate) <= lp_sysdate
3714: AND jtrs.terr_id = jt1.terr_id )
3715: AND NOT EXISTS (
3716: SELECT jt.terr_id
3717: FROM jtf_terr_all jt
3718: WHERE NVL(jt.end_date_active, lp_sysdate + 1) < lp_sysdate
3719: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
3720: START WITH jt.terr_id = jt1.terr_id)
3721: AND jqtu.qual_type_id <> -1001

Line 3911: FROM jtf_terr_all jt

3907: --
3908:
3909: AND jt1.terr_id IN
3910: ( SELECT jt.terr_id
3911: FROM jtf_terr_all jt
3912: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
3913: START WITH jt.terr_id = csr_dnm.terr_id )
3914: )
3915: WHERE jtdr.source_id = p_source_id

Line 4017: FROM jtf_terr_all jt

4013: AND jt1.qual_type_id = lp_qual_type_id
4014:
4015: AND jt1.terr_id IN
4016: ( SELECT jt.terr_id
4017: FROM jtf_terr_all jt
4018: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
4019: START WITH jt.terr_id = csr_dnm.terr_id )
4020: )
4021: WHERE jtdr.source_id = p_source_id

Line 4090: FROM jtf_terr_all jt

4086: AND jqtu.qual_type_id = v.related_id
4087: AND v.qual_type_id = lp_qual_type_id
4088: AND jtq.terr_id IN
4089: ( SELECT jt.terr_id
4090: FROM jtf_terr_all jt
4091: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
4092: START WITH jt.terr_id = csr_dnm.terr_id )
4093: )
4094: WHERE qua.terr_qtype_usg_id = csr_dnm.terr_qtype_usg_id;

Line 4225: FROM jtf_terr_all jt

4221: --
4222:
4223: AND jt1.terr_id IN
4224: ( SELECT jt.terr_id
4225: FROM jtf_terr_all jt
4226: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
4227: START WITH jt.terr_id = csr_dnm.terr_id )
4228: )
4229: WHERE jtdr.source_id = p_source_id

Line 4277: FROM jtf_terr_all jt

4273: /* ARPATEL: 11/12/03 Bug#3254575 */
4274: AND jt1.qual_type_id = p_qualifier_type_id
4275: AND jt1.terr_id IN
4276: ( SELECT jt.terr_id
4277: FROM jtf_terr_all jt
4278: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
4279: START WITH jt.terr_id = csr_dnm.terr_id )
4280: )
4281: WHERE jtdr.source_id = p_source_id

Line 4344: FROM jtf_terr_all jt

4340: AND jqtu.qual_type_id = v.related_id
4341: AND v.qual_type_id = p_qualifier_type_id
4342: AND jtq.terr_id IN
4343: ( SELECT jt.terr_id
4344: FROM jtf_terr_all jt
4345: CONNECT BY PRIOR jt.parent_territory_id = jt.terr_id AND jt.terr_id <> 1
4346: START WITH jt.terr_id = csr_dnm.terr_id )
4347: )
4348: WHERE qua.terr_qtype_usg_id = csr_dnm.terr_qtype_usg_id;