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_QUAL_S

Line 1226: SELECT JTF_TERR_QUAL_S.nextval

1222:
1223:
1224: /*
1225: ** Customer Name Range Qualifier -1012 */
1226: SELECT JTF_TERR_QUAL_S.nextval
1227: into l_terr_qual_id
1228: FROM DUAL;
1229:
1230: l_terr_qual_tbl(1).TERR_QUAL_ID :=l_terr_qual_id;

Line 1610: SELECT JTF_TERR_QUAL_S.nextval

1606: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
1607:
1608: j:=j+1;
1609:
1610: SELECT JTF_TERR_QUAL_S.nextval
1611: into l_terr_qual_id
1612: FROM DUAL;
1613:
1614: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;

Line 2000: SELECT JTF_TERR_QUAL_S.nextval

1996: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
1997:
1998: j:=j+1;
1999:
2000: SELECT JTF_TERR_QUAL_S.nextval
2001: into l_terr_qual_id
2002: FROM DUAL;
2003:
2004: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;

Line 2390: SELECT JTF_TERR_QUAL_S.nextval

2386: FOR csr_qual IN csr_get_qual ( topt.terr_id ) LOOP
2387:
2388: j:=j+1;
2389:
2390: SELECT JTF_TERR_QUAL_S.nextval
2391: INTO l_terr_qual_id
2392: FROM DUAL;
2393:
2394: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 2577: SELECT JTF_TERR_QUAL_S.nextval

2573: l_terr_qualtypeusgs_tbl(2).TERR_ID:= null;
2574: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID:=-1003;
2575: l_terr_qualtypeusgs_tbl(2).ORG_ID:=terr_group.ORG_ID;
2576:
2577: SELECT JTF_TERR_QUAL_S.nextval
2578: into l_terr_qual_id
2579: FROM DUAL;
2580:
2581: j:=0;

Line 2591: SELECT JTF_TERR_QUAL_S.nextval

2587:
2588: if l_prev_qual_usg_id <> qval.qual_usg_id then
2589:
2590: j:=j+1;
2591: SELECT JTF_TERR_QUAL_S.nextval
2592: into l_terr_qual_id
2593: FROM DUAL;
2594:
2595: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;

Line 2759: SELECT JTF_TERR_QUAL_S.nextval

2755: l_terr_qualtypeusgs_tbl(i).TERR_ID:= null;
2756: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID:=-1003;
2757: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
2758:
2759: SELECT JTF_TERR_QUAL_S.nextval
2760: into l_terr_qual_id
2761: FROM DUAL;
2762: /* opp expected purchase */
2763:

Line 2825: SELECT JTF_TERR_QUAL_S.nextval

2821: l_terr_qualtypeusgs_tbl(i).TERR_ID:= null;
2822: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID:=-1002;
2823: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
2824:
2825: SELECT JTF_TERR_QUAL_S.nextval
2826: into l_terr_qual_id
2827: FROM DUAL;
2828:
2829: /* lead expected purchase */

Line 3158: SELECT JTF_TERR_QUAL_S.nextval

3154: l_terr_qualtypeusgs_tbl(2).TERR_ID:= null;
3155: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID:=-1003;
3156: l_terr_qualtypeusgs_tbl(2).ORG_ID:=terr_group.ORG_ID;
3157:
3158: SELECT JTF_TERR_QUAL_S.nextval
3159: into l_terr_qual_id
3160: FROM DUAL;
3161:
3162: j:=0;

Line 3172: SELECT JTF_TERR_QUAL_S.nextval

3168:
3169: if l_prev_qual_usg_id <> qval.qual_usg_id then
3170:
3171: j:=j+1;
3172: SELECT JTF_TERR_QUAL_S.nextval
3173: into l_terr_qual_id
3174: FROM DUAL;
3175:
3176: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;

Line 3338: SELECT JTF_TERR_QUAL_S.nextval

3334: l_terr_qualtypeusgs_tbl(i).TERR_ID:= null;
3335: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID:=-1003;
3336: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
3337:
3338: SELECT JTF_TERR_QUAL_S.nextval
3339: into l_terr_qual_id
3340: FROM DUAL;
3341: /* opp expected purchase */
3342:

Line 3404: SELECT JTF_TERR_QUAL_S.nextval

3400: l_terr_qualtypeusgs_tbl(i).TERR_ID:= null;
3401: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID:=-1002;
3402: l_terr_qualtypeusgs_tbl(i).ORG_ID:=terr_group.ORG_ID;
3403:
3404: SELECT JTF_TERR_QUAL_S.nextval
3405: into l_terr_qual_id
3406: FROM DUAL;
3407:
3408: /* lead expected purchase */

Line 4214: SELECT JTF_TERR_QUAL_S.nextval

4210: IF l_prev_qual_usg_id <> gval.qual_usg_id THEN
4211:
4212: j:=j+1;
4213:
4214: SELECT JTF_TERR_QUAL_S.nextval
4215: into l_terr_qual_id
4216: FROM DUAL;
4217:
4218: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;

Line 4570: SELECT JTF_TERR_QUAL_S.nextval

4566: FOR csr_qual IN csr_get_qual ( topt.terr_id ) LOOP
4567:
4568: j:=j+1;
4569:
4570: SELECT JTF_TERR_QUAL_S.nextval
4571: INTO l_terr_qual_id
4572: FROM DUAL;
4573:
4574: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 4760: SELECT JTF_TERR_QUAL_S.nextval

4756: l_terr_qualtypeusgs_tbl(2).TERR_ID:= null;
4757: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID:=-1003;
4758: l_terr_qualtypeusgs_tbl(2).ORG_ID:=p_ORG_ID;
4759:
4760: SELECT JTF_TERR_QUAL_S.nextval
4761: into l_terr_qual_id
4762: FROM DUAL;
4763:
4764: j:=0;

Line 4773: SELECT JTF_TERR_QUAL_S.nextval

4769:
4770: if l_prev_qual_usg_id <> gval.qual_usg_id then
4771:
4772: j:=j+1;
4773: SELECT JTF_TERR_QUAL_S.nextval
4774: into l_terr_qual_id
4775: FROM DUAL;
4776:
4777: l_terr_qual_tbl(j).TERR_QUAL_ID :=l_terr_qual_id;

Line 4935: SELECT JTF_TERR_QUAL_S.nextval

4931: l_terr_qualtypeusgs_tbl(i).TERR_ID:= null;
4932: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID:=-1003;
4933: l_terr_qualtypeusgs_tbl(i).ORG_ID:=p_ORG_ID;
4934:
4935: SELECT JTF_TERR_QUAL_S.nextval
4936: into l_terr_qual_id
4937: FROM DUAL;
4938: /* opp expected purchase */
4939:

Line 5001: SELECT JTF_TERR_QUAL_S.nextval

4997: l_terr_qualtypeusgs_tbl(i).TERR_ID:= null;
4998: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID:=-1002;
4999: l_terr_qualtypeusgs_tbl(i).ORG_ID:=p_ORG_ID;
5000:
5001: SELECT JTF_TERR_QUAL_S.nextval
5002: into l_terr_qual_id
5003: FROM DUAL;
5004:
5005: /* lead expected purchase */