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_ALL

Line 253: FROM jtf_terr_qual_all jtq, jtf_terr_all jt

249: --DELETE territory value records
250: DELETE FROM jtf_terr_values_all jtv
251: WHERE jtv.terr_qual_id IN
252: ( SELECT jtq.terr_qual_id
253: FROM jtf_terr_qual_all jtq, jtf_terr_all jt
254: WHERE jtq.terr_id = jt.terr_id
255: AND jt.terr_group_flag = 'Y' );
256:
257: --Delete Territory Qualifer records

Line 258: DELETE FROM JTF_TERR_QUAL_ALL jtq

254: WHERE jtq.terr_id = jt.terr_id
255: AND jt.terr_group_flag = 'Y' );
256:
257: --Delete Territory Qualifer records
258: DELETE FROM JTF_TERR_QUAL_ALL jtq
259: WHERE jtq.terr_id IN
260: ( SELECT jt.terr_id
261: FROM jtf_terr_all jt
262: WHERE jt.terr_group_flag = 'Y' );

Line 336: FROM JTF_TERR_QUAL_ALL A

332:
333: --Delete Territory Values
334: DELETE FROM JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN
335: ( SELECT TERR_QUAL_ID
336: FROM JTF_TERR_QUAL_ALL A
337: ,JTF_TERR_ALL B
338: WHERE B.GEO_TERRITORY_ID = p_geo_territory_id
339: AND B.TERR_ID = A.TERR_ID );
340:

Line 342: DELETE FROM JTF_TERR_QUAL_ALL WHERE TERR_ID IN

338: WHERE B.GEO_TERRITORY_ID = p_geo_territory_id
339: AND B.TERR_ID = A.TERR_ID );
340:
341: --Delete Territory Qualifer records
342: DELETE FROM JTF_TERR_QUAL_ALL WHERE TERR_ID IN
343: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE GEO_TERRITORY_ID = p_geo_territory_id );
344:
345: --Delete Territory qual type usgs
346: DELETE FROM JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN

Line 399: FROM JTF_TERR_QUAL_ALL A

395:
396: --Delete Territory Values
397: DELETE FROM JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN
398: ( SELECT TERR_QUAL_ID
399: FROM JTF_TERR_QUAL_ALL A
400: ,JTF_TERR_ALL B
401: WHERE B.TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id
402: AND B.TERR_ID = A.TERR_ID );
403:

Line 405: DELETE FROM JTF_TERR_QUAL_ALL WHERE TERR_ID IN

401: WHERE B.TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id
402: AND B.TERR_ID = A.TERR_ID );
403:
404: --Delete Territory Qualifer records
405: DELETE FROM JTF_TERR_QUAL_ALL WHERE TERR_ID IN
406: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_terr_grp_acct_id );
407:
408: --Delete Territory qual type usgs
409: DELETE FROM JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN

Line 447: (SELECT terr_qual_id FROM jtf_terr_qual_all WHERE terr_id = p_catchall_terr_id);

443: AND B.qual_usg_id = -1012
444: AND B.COMPARISON_OPERATOR = jtv.COMPARISON_OPERATOR
445: AND B.VALUE1_CHAR = jtv.LOW_VALUE_CHAR)
446: AND terr_qual_id =
447: (SELECT terr_qual_id FROM jtf_terr_qual_all WHERE terr_id = p_catchall_terr_id);
448: END IF;
449:
450: IF G_Debug THEN
451: Write_Log(2, 'End deleting the territories corresponding to the territory group account : ' || p_terr_grp_acct_id);

Line 498: FROM JTF_TERR_QUAL_ALL A

494: --Delete Territory Values
495: forall idx in p_grpAcctId_tbl.FIRST .. p_grpAcctId_tbl.LAST
496: DELETE from JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN
497: ( SELECT TERR_QUAL_ID
498: FROM JTF_TERR_QUAL_ALL A
499: ,JTF_TERR_ALL B
500: WHERE B.TERR_GROUP_ACCOUNT_ID = p_grpAcctId_tbl(idx)
501: AND B.TERR_ID = A.TERR_ID );
502:

Line 505: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID IN

501: AND B.TERR_ID = A.TERR_ID );
502:
503: --Delete Territory Qualifer records
504: forall idx in p_grpAcctId_tbl.FIRST .. p_grpAcctId_tbl.LAST
505: DELETE from JTF_TERR_QUAL_ALL WHERE TERR_ID IN
506: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ACCOUNT_ID = p_grpAcctId_tbl(idx) );
507:
508: --Delete Territory qual type usgs
509: forall idx in p_grpAcctId_tbl.FIRST .. p_grpAcctId_tbl.LAST

Line 556: FROM jtf_terr_qual_all tqa,

552: AND B.COMPARISON_OPERATOR = jtv.COMPARISON_OPERATOR
553: AND B.VALUE1_CHAR = jtv.LOW_VALUE_CHAR)
554: AND terr_qual_id =
555: ( SELECT terr_qual_id
556: FROM jtf_terr_qual_all tqa,
557: jtf_terr_all ta
558: WHERE tqa.terr_id = ta.terr_id
559: AND ta.catch_all_flag='Y'
560: AND enabled_flag='Y'

Line 704: FROM JTF_TERR_QUAL_ALL A

700: IF p_terr_creation_flag IS NULL THEN
701: --Delete Territory Values
702: DELETE FROM JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN
703: ( SELECT TERR_QUAL_ID
704: FROM JTF_TERR_QUAL_ALL A
705: ,JTF_TERR_ALL B
706: WHERE B.TERR_GROUP_ID = p_terr_grp_id
707: AND B.TERR_ID = A.TERR_ID );
708:

Line 710: DELETE FROM JTF_TERR_QUAL_ALL WHERE TERR_ID IN

706: WHERE B.TERR_GROUP_ID = p_terr_grp_id
707: AND B.TERR_ID = A.TERR_ID );
708:
709: --Delete Territory Qualifer records
710: DELETE FROM JTF_TERR_QUAL_ALL WHERE TERR_ID IN
711: ( SELECT TERR_ID FROM JTF_TERR_ALL WHERE TERR_GROUP_ID = p_terr_grp_id );
712:
713: --Delete Territory qual type usgs
714: DELETE FROM JTF_TERR_QTYPE_USGS_ALL WHERE TERR_ID IN

Line 741: FROM JTF_TERR_QUAL_ALL A

737: ELSE
738: --Delete Territory Values
739: DELETE FROM JTF_TERR_VALUES_ALL WHERE TERR_QUAL_ID IN
740: ( SELECT TERR_QUAL_ID
741: FROM JTF_TERR_QUAL_ALL A
742: ,JTF_TERR_ALL B
743: WHERE B.TERR_GROUP_ID = p_terr_grp_id
744: AND B.TERR_ID = A.TERR_ID
745: AND B.TERR_ID <> p_terr_id );

Line 748: DELETE FROM JTF_TERR_QUAL_ALL WHERE TERR_ID IN

744: AND B.TERR_ID = A.TERR_ID
745: AND B.TERR_ID <> p_terr_id );
746:
747: --Delete Territory Qualifer records
748: DELETE FROM JTF_TERR_QUAL_ALL WHERE TERR_ID IN
749: ( SELECT TERR_ID FROM JTF_TERR_ALL
750: WHERE TERR_GROUP_ID = p_terr_grp_id
751: AND TERR_ID <> p_terr_id
752: );

Line 1200: FROM jtf_terr_qual_all jtq

1196: /* get Qualifiers used in a territory */
1197: CURSOR csr_get_qual( lp_terr_id NUMBER) IS
1198: SELECT jtq.terr_qual_id
1199: , jtq.qual_usg_id
1200: FROM jtf_terr_qual_all jtq
1201: WHERE jtq.terr_id = lp_terr_id;
1202:
1203: /* get Values used in a territory qualifier */
1204: CURSOR csr_get_qual_val ( lp_terr_qual_id NUMBER ) IS

Line 2701: FROM jtf_terr_qual_all jtq

2697: /* get Qualifiers used in a territory */
2698: CURSOR csr_get_qual( lp_terr_id NUMBER) IS
2699: SELECT jtq.terr_qual_id
2700: , jtq.qual_usg_id
2701: FROM jtf_terr_qual_all jtq
2702: WHERE jtq.terr_id = lp_terr_id;
2703:
2704: /* get Values used in a territory qualifier */
2705: CURSOR csr_get_qual_val ( lp_terr_qual_id NUMBER ) IS

Line 4784: FROM jtf_terr_qual_all

4780:
4781: BEGIN
4782: SELECT terr_qual_id
4783: INTO l_terr_qual_id
4784: FROM jtf_terr_qual_all
4785: WHERE terr_id = p_catchall_terr_id(x)
4786: AND qual_usg_id = -1012;
4787:
4788: FOR catchall IN catchall_cust(p_terr_grp_acct_id(x)) LOOP

Line 7432: FROM jtf_terr_qual_all jtq

7428: /* get Qualifiers used in a territory */
7429: CURSOR csr_get_qual( lp_terr_id NUMBER) IS
7430: SELECT jtq.terr_qual_id
7431: , jtq.qual_usg_id
7432: FROM jtf_terr_qual_all jtq
7433: WHERE jtq.terr_id = lp_terr_id;
7434:
7435: /* get Values used in a territory qualifier */
7436: CURSOR csr_get_qual_val ( lp_terr_qual_id NUMBER ) IS