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_QUAL_S

Line 1532: SELECT JTF_TERR_QUAL_S.NEXTVAL

1528: IF l_prev_qual_usg_id <> gval.qual_usg_id THEN
1529:
1530: j:=j+1;
1531:
1532: SELECT JTF_TERR_QUAL_S.NEXTVAL
1533: INTO l_terr_qual_id
1534: FROM DUAL;
1535:
1536: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 1875: SELECT JTF_TERR_QUAL_S.NEXTVAL

1871: l_terr_qualtypeusgs_tbl(2).TERR_ID := NULL;
1872: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID := -1003;
1873: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
1874:
1875: SELECT JTF_TERR_QUAL_S.NEXTVAL
1876: INTO l_terr_qual_id
1877: FROM DUAL;
1878:
1879: j:=0;

Line 1888: SELECT JTF_TERR_QUAL_S.NEXTVAL

1884:
1885: IF l_prev_qual_usg_id <> gval.qual_usg_id THEN
1886:
1887: j:=j+1;
1888: SELECT JTF_TERR_QUAL_S.NEXTVAL
1889: INTO l_terr_qual_id
1890: FROM DUAL;
1891:
1892: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 2040: SELECT JTF_TERR_QUAL_S.NEXTVAL

2036: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
2037: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1003;
2038: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
2039:
2040: SELECT JTF_TERR_QUAL_S.NEXTVAL
2041: INTO l_terr_qual_id
2042: FROM DUAL;
2043:
2044: /* opp expected purchase */

Line 2111: SELECT JTF_TERR_QUAL_S.NEXTVAL

2107: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
2108: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1002;
2109: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
2110:
2111: SELECT JTF_TERR_QUAL_S.NEXTVAL
2112: INTO l_terr_qual_id
2113: FROM DUAL;
2114:
2115: /* lead expected purchase */

Line 3191: SELECT JTF_TERR_QUAL_S.NEXTVAL

3187: IF l_prev_qual_usg_id <> gval.qual_usg_id THEN
3188:
3189: j:=j+1;
3190:
3191: SELECT JTF_TERR_QUAL_S.NEXTVAL
3192: INTO l_terr_qual_id
3193: FROM DUAL;
3194:
3195: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 3560: SELECT JTF_TERR_QUAL_S.NEXTVAL

3556: FOR csr_qual IN csr_get_qual ( topt.terr_id ) LOOP
3557:
3558: j:=j+1;
3559:
3560: SELECT JTF_TERR_QUAL_S.NEXTVAL
3561: INTO l_terr_qual_id
3562: FROM DUAL;
3563:
3564: /* Top_level Parent's Qualifier */

Line 3731: SELECT JTF_TERR_QUAL_S.NEXTVAL

3727: l_terr_qualtypeusgs_tbl(2).TERR_ID := NULL;
3728: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID := -1003;
3729: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
3730:
3731: SELECT JTF_TERR_QUAL_S.NEXTVAL
3732: INTO l_terr_qual_id
3733: FROM DUAL;
3734:
3735: j:=0;

Line 3744: SELECT JTF_TERR_QUAL_S.NEXTVAL

3740:
3741: IF l_prev_qual_usg_id <> gval.qual_usg_id THEN
3742:
3743: j:=j+1;
3744: SELECT JTF_TERR_QUAL_S.NEXTVAL
3745: INTO l_terr_qual_id
3746: FROM DUAL;
3747:
3748: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 3896: SELECT JTF_TERR_QUAL_S.NEXTVAL

3892: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
3893: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1003;
3894: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
3895:
3896: SELECT JTF_TERR_QUAL_S.NEXTVAL
3897: INTO l_terr_qual_id
3898: FROM DUAL;
3899:
3900: /* opp expected purchase */

Line 3967: SELECT JTF_TERR_QUAL_S.NEXTVAL

3963: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
3964: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1002;
3965: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
3966:
3967: SELECT JTF_TERR_QUAL_S.NEXTVAL
3968: INTO l_terr_qual_id
3969: FROM DUAL;
3970:
3971: /* lead expected purchase */

Line 5027: SELECT JTF_TERR_QUAL_S.NEXTVAL

5023: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
5024:
5025: j:=j+1;
5026:
5027: SELECT JTF_TERR_QUAL_S.NEXTVAL
5028: INTO l_terr_qual_id
5029: FROM DUAL;
5030:
5031: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 5420: SELECT JTF_TERR_QUAL_S.NEXTVAL

5416: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
5417:
5418: j:=j+1;
5419:
5420: SELECT JTF_TERR_QUAL_S.NEXTVAL
5421: INTO l_terr_qual_id
5422: FROM DUAL;
5423:
5424: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 5791: SELECT JTF_TERR_QUAL_S.NEXTVAL

5787: l_terr_qualtypeusgs_tbl(2).TERR_ID := NULL;
5788: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID := -1003;
5789: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
5790:
5791: SELECT JTF_TERR_QUAL_S.NEXTVAL
5792: INTO l_terr_qual_id
5793: FROM DUAL;
5794:
5795: j:=0;

Line 5805: SELECT JTF_TERR_QUAL_S.NEXTVAL

5801: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
5802:
5803: j:=j+1;
5804:
5805: SELECT JTF_TERR_QUAL_S.NEXTVAL
5806: INTO l_terr_qual_id
5807: FROM DUAL;
5808:
5809: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 5994: SELECT JTF_TERR_QUAL_S.NEXTVAL

5990: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
5991: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1003;
5992: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
5993:
5994: SELECT JTF_TERR_QUAL_S.NEXTVAL
5995: INTO l_terr_qual_id
5996: FROM DUAL;
5997:
5998: /* opp expected purchase */

Line 6064: SELECT JTF_TERR_QUAL_S.NEXTVAL

6060: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
6061: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1002;
6062: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
6063:
6064: SELECT JTF_TERR_QUAL_S.NEXTVAL
6065: INTO l_terr_qual_id
6066: FROM DUAL;
6067:
6068: /* lead expected purchase */

Line 6389: SELECT JTF_TERR_QUAL_S.NEXTVAL

6385: l_terr_qualtypeusgs_tbl(2).TERR_ID := NULL;
6386: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID := -1003;
6387: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
6388:
6389: SELECT JTF_TERR_QUAL_S.NEXTVAL
6390: INTO l_terr_qual_id
6391: FROM DUAL;
6392:
6393: j:=0;

Line 6402: SELECT JTF_TERR_QUAL_S.NEXTVAL

6398:
6399: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
6400:
6401: j:=j+1;
6402: SELECT JTF_TERR_QUAL_S.NEXTVAL
6403: INTO l_terr_qual_id
6404: FROM DUAL;
6405:
6406: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 6575: SELECT JTF_TERR_QUAL_S.NEXTVAL

6571: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
6572: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1003;
6573: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
6574:
6575: SELECT JTF_TERR_QUAL_S.NEXTVAL
6576: INTO l_terr_qual_id
6577: FROM DUAL;
6578:
6579: /* opp expected purchase */

Line 6645: SELECT JTF_TERR_QUAL_S.NEXTVAL

6641: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
6642: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1002;
6643: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
6644:
6645: SELECT JTF_TERR_QUAL_S.NEXTVAL
6646: INTO l_terr_qual_id
6647: FROM DUAL;
6648:
6649: /* lead expected purchase */

Line 7847: SELECT JTF_TERR_QUAL_S.NEXTVAL

7843: END LOOP;
7844:
7845: /*
7846: ** Customer Name Range Qualifier -1012 */
7847: SELECT JTF_TERR_QUAL_S.NEXTVAL
7848: INTO l_terr_qual_id
7849: FROM DUAL;
7850:
7851: l_terr_qual_tbl(1).TERR_QUAL_ID := l_terr_qual_id;

Line 8245: SELECT JTF_TERR_QUAL_S.NEXTVAL

8241: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
8242:
8243: j:=j+1;
8244:
8245: SELECT JTF_TERR_QUAL_S.NEXTVAL
8246: INTO l_terr_qual_id
8247: FROM DUAL;
8248:
8249: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 8637: SELECT JTF_TERR_QUAL_S.NEXTVAL

8633: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
8634:
8635: j:=j+1;
8636:
8637: SELECT JTF_TERR_QUAL_S.NEXTVAL
8638: INTO l_terr_qual_id
8639: FROM DUAL;
8640:
8641: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 9008: SELECT JTF_TERR_QUAL_S.NEXTVAL

9004: FOR csr_qual IN csr_get_qual ( topt.terr_id ) LOOP
9005:
9006: j:=j+1;
9007:
9008: SELECT JTF_TERR_QUAL_S.NEXTVAL
9009: INTO l_terr_qual_id
9010: FROM DUAL;
9011:
9012: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 9193: SELECT JTF_TERR_QUAL_S.NEXTVAL

9189: l_terr_qualtypeusgs_tbl(2).TERR_ID := NULL;
9190: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID := -1003;
9191: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
9192:
9193: SELECT JTF_TERR_QUAL_S.NEXTVAL
9194: INTO l_terr_qual_id
9195: FROM DUAL;
9196:
9197: j:=0;

Line 9207: SELECT JTF_TERR_QUAL_S.NEXTVAL

9203: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
9204:
9205: j:=j+1;
9206:
9207: SELECT JTF_TERR_QUAL_S.NEXTVAL
9208: INTO l_terr_qual_id
9209: FROM DUAL;
9210:
9211: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 9392: SELECT JTF_TERR_QUAL_S.NEXTVAL

9388: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
9389: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1003;
9390: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
9391:
9392: SELECT JTF_TERR_QUAL_S.NEXTVAL
9393: INTO l_terr_qual_id
9394: FROM DUAL;
9395:
9396: /* opp expected purchase */

Line 9462: SELECT JTF_TERR_QUAL_S.NEXTVAL

9458: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
9459: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1002;
9460: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
9461:
9462: SELECT JTF_TERR_QUAL_S.NEXTVAL
9463: INTO l_terr_qual_id
9464: FROM DUAL;
9465:
9466: /* lead expected purchase */

Line 9790: SELECT JTF_TERR_QUAL_S.NEXTVAL

9786: l_terr_qualtypeusgs_tbl(2).TERR_ID := NULL;
9787: l_terr_qualtypeusgs_tbl(2).QUAL_TYPE_USG_ID := -1003;
9788: l_terr_qualtypeusgs_tbl(2).ORG_ID := p_org_id(x);
9789:
9790: SELECT JTF_TERR_QUAL_S.NEXTVAL
9791: INTO l_terr_qual_id
9792: FROM DUAL;
9793:
9794: j:=0;

Line 9803: SELECT JTF_TERR_QUAL_S.NEXTVAL

9799:
9800: IF l_prev_qual_usg_id <> qval.qual_usg_id THEN
9801:
9802: j:=j+1;
9803: SELECT JTF_TERR_QUAL_S.NEXTVAL
9804: INTO l_terr_qual_id
9805: FROM DUAL;
9806:
9807: l_terr_qual_tbl(j).TERR_QUAL_ID := l_terr_qual_id;

Line 9976: SELECT JTF_TERR_QUAL_S.NEXTVAL

9972: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
9973: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1003;
9974: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
9975:
9976: SELECT JTF_TERR_QUAL_S.NEXTVAL
9977: INTO l_terr_qual_id
9978: FROM DUAL;
9979:
9980: /* opp expected purchase */

Line 10046: SELECT JTF_TERR_QUAL_S.NEXTVAL

10042: l_terr_qualtypeusgs_tbl(i).TERR_ID := NULL;
10043: l_terr_qualtypeusgs_tbl(i).QUAL_TYPE_USG_ID := -1002;
10044: l_terr_qualtypeusgs_tbl(i).ORG_ID := p_org_id(x);
10045:
10046: SELECT JTF_TERR_QUAL_S.NEXTVAL
10047: INTO l_terr_qual_id
10048: FROM DUAL;
10049:
10050: /* lead expected purchase */