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_TERR_RSC_ALL

Line 285: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt

281: --Delete Territory Resource Access
282: DELETE FROM JTF_TERR_RSC_ACCESS_ALL jtra
283: WHERE jtra.terr_rsc_id IN
284: ( SELECT jtr.terr_rsc_id
285: FROM jtf_terr_rsc_all jtr, jtf_terr_all jt
286: WHERE jtr.terr_id = jt.terr_id
287: AND jt.terr_group_flag = 'Y' );
288:
289:

Line 291: DELETE FROM JTF_TERR_RSC_ALL jtr

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

Line 356: FROM JTF_TERR_RSC_ALL A

352:
353: --Delete Territory Resource Access
354: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
355: ( SELECT TERR_RSC_ID
356: FROM JTF_TERR_RSC_ALL A
357: ,JTF_TERR_ALL B
358: WHERE B.GEO_TERRITORY_ID = p_geo_territory_id
359: AND B.TERR_ID = A.TERR_ID );
360:

Line 362: DELETE FROM JTF_TERR_RSC_ALL WHERE TERR_ID IN

358: WHERE B.GEO_TERRITORY_ID = p_geo_territory_id
359: AND B.TERR_ID = A.TERR_ID );
360:
361: -- Delete the Territory Resource records
362: DELETE FROM JTF_TERR_RSC_ALL WHERE TERR_ID IN
363: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE GEO_TERRITORY_ID = p_geo_territory_id );
364:
365: --Delete Territory records corresponding to the territory group
366: DELETE FROM JTF_TERR_ALL WHERE GEO_TERRITORY_ID = p_geo_territory_id;

Line 419: FROM JTF_TERR_RSC_ALL A

415:
416: --Delete Territory Resource Access
417: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
418: ( SELECT TERR_RSC_ID
419: FROM JTF_TERR_RSC_ALL A
420: ,JTF_TERR_ALL B
421: WHERE B.TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id
422: AND B.TERR_ID = A.TERR_ID );
423:

Line 425: DELETE FROM JTF_TERR_RSC_ALL WHERE TERR_ID IN

421: WHERE B.TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id
422: AND B.TERR_ID = A.TERR_ID );
423:
424: -- Delete the Territory Resource records
425: DELETE FROM JTF_TERR_RSC_ALL WHERE TERR_ID IN
426: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id );
427:
428: --Delete Territory records corresponding to the territory group
429: DELETE FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id;

Line 522: FROM JTF_TERR_RSC_ALL A

518: --Delete Territory Resource Access
519: forall idx in p_grpAcctId_tbl.FIRST .. p_grpAcctId_tbl.LAST
520: DELETE from JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
521: ( SELECT TERR_RSC_ID
522: FROM JTF_TERR_RSC_ALL A
523: ,JTF_TERR_ALL B
524: WHERE B.TERR_GROUP_ACCOUNT_ID = p_grpAcctId_tbl(idx)
525: AND B.TERR_ID = A.TERR_ID );
526:

Line 529: DELETE from JTF_TERR_RSC_ALL Where TERR_ID IN

525: AND B.TERR_ID = A.TERR_ID );
526:
527: -- Delete the Territory Resource records
528: forall idx in p_grpAcctId_tbl.FIRST .. p_grpAcctId_tbl.LAST
529: DELETE from JTF_TERR_RSC_ALL Where TERR_ID IN
530: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_grpAcctId_tbl(idx) );
531:
532: --Delete Territory records corresponding to the territory group
533: forall idx in p_grpAcctId_tbl.FIRST .. p_grpAcctId_tbl.LAST

Line 724: FROM JTF_TERR_RSC_ALL A

720:
721: --Delete Territory Resource Access
722: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
723: ( SELECT TERR_RSC_ID
724: FROM JTF_TERR_RSC_ALL A
725: ,JTF_TERR_ALL B
726: WHERE B.TERR_GROUP_ID = p_terr_grp_id
727: AND B.TERR_ID = A.TERR_ID );
728:

Line 730: DELETE FROM JTF_TERR_RSC_ALL WHERE TERR_ID IN

726: WHERE B.TERR_GROUP_ID = p_terr_grp_id
727: AND B.TERR_ID = A.TERR_ID );
728:
729: -- Delete the Territory Resource records
730: DELETE FROM JTF_TERR_RSC_ALL WHERE TERR_ID IN
731: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ID = p_terr_grp_id );
732:
733: --Delete Territory records corresponding to the territory group
734:

Line 770: FROM JTF_TERR_RSC_ALL A

766:
767: --Delete Territory Resource Access
768: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
769: ( SELECT TERR_RSC_ID
770: FROM JTF_TERR_RSC_ALL A
771: ,JTF_TERR_ALL B
772: WHERE B.TERR_GROUP_ID = p_terr_grp_id
773: AND B.TERR_ID = A.TERR_ID
774: );

Line 777: DELETE FROM JTF_TERR_RSC_ALL WHERE TERR_ID IN

773: AND B.TERR_ID = A.TERR_ID
774: );
775:
776: -- Delete the Territory Resource records
777: DELETE FROM JTF_TERR_RSC_ALL WHERE TERR_ID IN
778: ( SELECT TERR_ID FROM JTF_TERR_ALL
779: WHERE TERR_GROUP_ID = p_terr_grp_id
780: );
781:

Line 12601: FROM JTF_TERR_RSC_ALL B

12597: IF ( l_catchall_terr_id <> -999 ) THEN
12598: BEGIN
12599: DELETE FROM JTF_TERR_RSC_ACCESS_ALL A
12600: WHERE A.TERR_RSC_ID IN ( SELECT B.TERR_RSC_ID
12601: FROM JTF_TERR_RSC_ALL B
12602: WHERE B.terr_id = l_catchall_terr_id );
12603:
12604: DELETE FROM JTF_TERR_RSC_ALL
12605: WHERE TERR_ID = l_catchall_terr_id;

Line 12604: DELETE FROM JTF_TERR_RSC_ALL

12600: WHERE A.TERR_RSC_ID IN ( SELECT B.TERR_RSC_ID
12601: FROM JTF_TERR_RSC_ALL B
12602: WHERE B.terr_id = l_catchall_terr_id );
12603:
12604: DELETE FROM JTF_TERR_RSC_ALL
12605: WHERE TERR_ID = l_catchall_terr_id;
12606:
12607: DELETE FROM JTF_TERR_ALL
12608: WHERE TERR_ID = l_catchall_terr_id;

Line 12644: FROM JTF_TERR_RSC_ALL B

12640: BEGIN
12641:
12642: DELETE FROM JTF_TERR_RSC_ACCESS_ALL A
12643: WHERE A.TERR_RSC_ID IN ( SELECT B.TERR_RSC_ID
12644: FROM JTF_TERR_RSC_ALL B
12645: WHERE B.terr_id = l_catchall_terr_id );
12646:
12647: DELETE FROM JTF_TERR_RSC_ALL
12648: WHERE TERR_ID IN

Line 12647: DELETE FROM JTF_TERR_RSC_ALL

12643: WHERE A.TERR_RSC_ID IN ( SELECT B.TERR_RSC_ID
12644: FROM JTF_TERR_RSC_ALL B
12645: WHERE B.terr_id = l_catchall_terr_id );
12646:
12647: DELETE FROM JTF_TERR_RSC_ALL
12648: WHERE TERR_ID IN
12649: ( SELECT terr_id
12650: FROM JTF_TERR_ALL
12651: WHERE CATCH_ALL_FLAG='Y'

Line 12703: INSERT INTO jtf_terr_rsc_all

12699: FROM JTF_TERR_ALL
12700: WHERE CATCH_ALL_FLAG='Y'
12701: AND TERR_GROUP_ID = p_terr_group_id;
12702:
12703: INSERT INTO jtf_terr_rsc_all
12704: (
12705: TERR_RSC_ID,
12706: LAST_UPDATE_DATE,
12707: LAST_UPDATED_BY,

Line 12934: FROM JTF_TERR_RSC_ALL A

12930:
12931: --Delete Territory Resource Access
12932: DELETE FROM JTF_TERR_RSC_ACCESS_ALL WHERE TERR_RSC_ID IN
12933: ( SELECT TERR_RSC_ID
12934: FROM JTF_TERR_RSC_ALL A
12935: ,JTF_TERR_ALL B
12936: WHERE B.TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id
12937: AND B.TERR_ID = A.TERR_ID );
12938:

Line 12940: DELETE FROM JTF_TERR_RSC_ALL WHERE TERR_ID IN

12936: WHERE B.TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id
12937: AND B.TERR_ID = A.TERR_ID );
12938:
12939: -- Delete the Territory Resource records
12940: DELETE FROM JTF_TERR_RSC_ALL WHERE TERR_ID IN
12941: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id );
12942:
12943: l_init_msg_list :=FND_API.G_TRUE;
12944: i := 0;