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_TTY_ROLE_PROD_INT

Line 1021: FROM jtf_tty_role_prod_int rpi

1017: AND tgr.terr_group_id = gtr.terr_group_id
1018: AND ra.terr_group_role_id = tgr.terr_group_role_id
1019: AND NOT EXISTS (
1020: SELECT NULL
1021: FROM jtf_tty_role_prod_int rpi
1022: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id );
1023:
1024: /* same sql used in geography download to Excel
1025: This query will find out all the postal codes

Line 1160: FROM jtf_tty_role_prod_int rpi

1156: AND b.role_code = lp_role
1157: AND NOT EXISTS (
1158: /* Product Interest does not exist for this role */
1159: SELECT NULL
1160: FROM jtf_tty_role_prod_int rpi
1161: WHERE rpi.terr_group_role_id = B.TERR_GROUP_ROLE_ID )
1162: ORDER BY a.access_type ;
1163:
1164: /* Roles WITHOUT a Product Iterest defined */

Line 1169: FROM jtf_tty_role_prod_int a

1165: CURSOR role_interest_nonpi(l_terr_group_id NUMBER) IS
1166: SELECT b.role_code role_code
1167: --,a.interest_type_id
1168: ,b.terr_group_id
1169: FROM jtf_tty_role_prod_int a
1170: , jtf_tty_terr_grp_roles b
1171: WHERE a.terr_group_role_id(+) = b.terr_group_role_id
1172: AND b.terr_group_id = l_terr_group_id
1173: AND a.terr_group_role_id IS NULL

Line 1234: , jtf_tty_role_prod_int rpi

1230: AND EXISTS (
1231: /* Salesperson, with Role that has a Product Interest defined, exists for this Named Account */
1232: SELECT NULL
1233: FROM jtf_tty_geo_terr_rsc grsc
1234: , jtf_tty_role_prod_int rpi
1235: , jtf_tty_terr_grp_roles tgr
1236: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
1237: AND tgr.terr_group_id = gterr.TERR_GROUP_ID
1238: AND tgr.role_code = grsc.rsc_role_code

Line 1249: , jtf_tty_role_prod_int a

1245: SELECT DISTINCT
1246: b.role_code role_code
1247: , r.role_name role_name
1248: FROM jtf_rs_roles_vl r
1249: , jtf_tty_role_prod_int a
1250: , jtf_tty_terr_grp_roles b
1251: WHERE r.role_code = b.role_code
1252: AND a.terr_group_role_id = b.terr_group_role_id
1253: AND b.terr_group_id = lp_terr_group_id

Line 1279: FROM jtf_tty_role_prod_int a

1275: CURSOR role_pi_interest(l_terr_group_id NUMBER,l_role VARCHAR2) IS
1276: SELECT a.interest_type_id
1277: ,a.product_category_id
1278: ,a.product_category_set_id
1279: FROM jtf_tty_role_prod_int a
1280: , jtf_tty_terr_grp_roles b
1281: WHERE a.terr_group_role_id = b.terr_group_role_id
1282: AND b.terr_group_id = l_terr_group_id
1283: AND b.role_code = l_role;

Line 1291: , jtf_tty_role_prod_int c

1287: CURSOR role_no_pi(l_terr_group_id NUMBER) IS
1288: SELECT DISTINCT b.role_code
1289: FROM jtf_tty_role_access a
1290: , jtf_tty_terr_grp_roles b
1291: , jtf_tty_role_prod_int c
1292: WHERE a.terr_group_role_id = b.terr_group_role_id
1293: AND b.terr_group_id = l_terr_group_id
1294: AND a.access_type = 'ACCOUNT'
1295: AND c.terr_group_role_id = b.terr_group_role_id

Line 1297: FROM jtf_tty_role_prod_int e

1293: AND b.terr_group_id = l_terr_group_id
1294: AND a.access_type = 'ACCOUNT'
1295: AND c.terr_group_role_id = b.terr_group_role_id
1296: AND NOT EXISTS ( SELECT 1
1297: FROM jtf_tty_role_prod_int e
1298: , jtf_tty_terr_grp_roles d
1299: WHERE e.terr_group_role_id (+) = d.terr_group_role_id
1300: AND d.terr_group_id = b.terr_group_id
1301: AND d.role_code = b.role_code

Line 1774: , jtf_tty_role_prod_int a

1770:
1771: SELECT COUNT( DISTINCT b.role_code )
1772: INTO l_pi_count
1773: FROM jtf_rs_roles_vl r
1774: , jtf_tty_role_prod_int a
1775: , jtf_tty_terr_grp_roles b
1776: WHERE r.role_code = b.role_code
1777: AND a.terr_group_role_id = b.terr_group_role_id
1778: AND b.terr_group_id = p_TERR_GROUP_ID(x)

Line 2522: FROM jtf_tty_role_prod_int rpi

2518: AND tgr.terr_group_id = gtr.terr_group_id
2519: AND ra.terr_group_role_id = tgr.terr_group_role_id
2520: AND NOT EXISTS (
2521: SELECT NULL
2522: FROM jtf_tty_role_prod_int rpi
2523: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id );
2524:
2525: /* same sql used in geography download to Excel
2526: This query will find out all the postal codes

Line 2661: FROM jtf_tty_role_prod_int rpi

2657: AND b.role_code = lp_role
2658: AND NOT EXISTS (
2659: /* Product Interest does not exist for this role */
2660: SELECT NULL
2661: FROM jtf_tty_role_prod_int rpi
2662: WHERE rpi.terr_group_role_id = B.TERR_GROUP_ROLE_ID )
2663: ORDER BY a.access_type ;
2664:
2665: /* Roles WITHOUT a Product Iterest defined */

Line 2670: FROM jtf_tty_role_prod_int a

2666: CURSOR role_interest_nonpi(l_terr_group_id NUMBER) IS
2667: SELECT b.role_code role_code
2668: --,a.interest_type_id
2669: ,b.terr_group_id
2670: FROM jtf_tty_role_prod_int a
2671: , jtf_tty_terr_grp_roles b
2672: WHERE a.terr_group_role_id(+) = b.terr_group_role_id
2673: AND b.terr_group_id = l_terr_group_id
2674: AND a.terr_group_role_id IS NULL

Line 2735: , jtf_tty_role_prod_int rpi

2731: AND EXISTS (
2732: /* Salesperson, with Role that has a Product Interest defined, exists for this Named Account */
2733: SELECT NULL
2734: FROM jtf_tty_geo_terr_rsc grsc
2735: , jtf_tty_role_prod_int rpi
2736: , jtf_tty_terr_grp_roles tgr
2737: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
2738: AND tgr.terr_group_id = gterr.TERR_GROUP_ID
2739: AND tgr.role_code = grsc.rsc_role_code

Line 2750: , jtf_tty_role_prod_int a

2746: SELECT DISTINCT
2747: b.role_code role_code
2748: , r.role_name role_name
2749: FROM jtf_rs_roles_vl r
2750: , jtf_tty_role_prod_int a
2751: , jtf_tty_terr_grp_roles b
2752: WHERE r.role_code = b.role_code
2753: AND a.terr_group_role_id = b.terr_group_role_id
2754: AND b.terr_group_id = lp_terr_group_id

Line 2780: FROM jtf_tty_role_prod_int a

2776: CURSOR role_pi_interest(l_terr_group_id NUMBER,l_role VARCHAR2) IS
2777: SELECT a.interest_type_id
2778: ,a.product_category_id
2779: ,a.product_category_set_id
2780: FROM jtf_tty_role_prod_int a
2781: , jtf_tty_terr_grp_roles b
2782: WHERE a.terr_group_role_id = b.terr_group_role_id
2783: AND b.terr_group_id = l_terr_group_id
2784: AND b.role_code = l_role;

Line 2792: , jtf_tty_role_prod_int c

2788: CURSOR role_no_pi(l_terr_group_id NUMBER) IS
2789: SELECT DISTINCT b.role_code
2790: FROM jtf_tty_role_access a
2791: , jtf_tty_terr_grp_roles b
2792: , jtf_tty_role_prod_int c
2793: WHERE a.terr_group_role_id = b.terr_group_role_id
2794: AND b.terr_group_id = l_terr_group_id
2795: AND a.access_type = 'ACCOUNT'
2796: AND c.terr_group_role_id = b.terr_group_role_id

Line 2798: FROM jtf_tty_role_prod_int e

2794: AND b.terr_group_id = l_terr_group_id
2795: AND a.access_type = 'ACCOUNT'
2796: AND c.terr_group_role_id = b.terr_group_role_id
2797: AND NOT EXISTS ( SELECT 1
2798: FROM jtf_tty_role_prod_int e
2799: , jtf_tty_terr_grp_roles d
2800: WHERE e.terr_group_role_id (+) = d.terr_group_role_id
2801: AND d.terr_group_id = b.terr_group_id
2802: AND d.role_code = b.role_code

Line 3440: , jtf_tty_role_prod_int a

3436:
3437: SELECT COUNT( DISTINCT b.role_code )
3438: INTO l_pi_count
3439: FROM jtf_rs_roles_vl r
3440: , jtf_tty_role_prod_int a
3441: , jtf_tty_terr_grp_roles b
3442: WHERE r.role_code = b.role_code
3443: AND a.terr_group_role_id = b.terr_group_role_id
3444: AND b.terr_group_id = p_TERR_GROUP_ID(x)

Line 4394: FROM jtf_tty_role_prod_int rpi

4390: AND nar.rsc_role_code = tgr.role_code
4391: AND ra.terr_group_role_id = tgr.terr_group_role_id
4392: AND NOT EXISTS (
4393: SELECT NULL
4394: FROM jtf_tty_role_prod_int rpi
4395: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id );
4396:
4397:
4398: /* Access Types for a particular Role within a Territory Group */

Line 4420: FROM jtf_tty_role_prod_int rpi

4416: AND b.role_code = lp_role
4417: AND NOT EXISTS (
4418: /* Product Interest does not exist for this role */
4419: SELECT NULL
4420: FROM jtf_tty_role_prod_int rpi
4421: WHERE rpi.terr_group_role_id = B.TERR_GROUP_ROLE_ID )
4422: ORDER BY a.access_type ;
4423:
4424: /* Roles WITHOUT a Product Iterest defined */

Line 4429: FROM jtf_tty_role_prod_int a

4425: CURSOR role_interest_nonpi(l_terr_group_id NUMBER) IS
4426: SELECT b.role_code role_code
4427: --,a.interest_type_id
4428: ,b.terr_group_id
4429: FROM jtf_tty_role_prod_int a
4430: , jtf_tty_terr_grp_roles b
4431: WHERE a.terr_group_role_id(+) = b.terr_group_role_id
4432: AND b.terr_group_id = l_terr_group_id
4433: AND a.terr_group_role_id IS NULL

Line 4443: , jtf_tty_role_prod_int a

4439: SELECT DISTINCT
4440: b.role_code role_code
4441: , r.role_name role_name
4442: FROM jtf_rs_roles_vl r
4443: , jtf_tty_role_prod_int a
4444: , jtf_tty_terr_grp_roles b
4445: WHERE r.role_code = b.role_code
4446: AND a.terr_group_role_id = b.terr_group_role_id
4447: AND b.terr_group_id = lp_terr_group_id

Line 4462: FROM jtf_tty_role_prod_int a

4458: CURSOR role_pi_interest(l_terr_group_id NUMBER,l_role VARCHAR2) IS
4459: SELECT a.interest_type_id
4460: ,a.product_category_id
4461: ,a.product_category_set_id
4462: FROM jtf_tty_role_prod_int a
4463: , jtf_tty_terr_grp_roles b
4464: WHERE a.terr_group_role_id = b.terr_group_role_id
4465: AND b.terr_group_id = l_terr_group_id
4466: AND b.role_code = l_role;

Line 4569: , jtf_tty_role_prod_int rpi

4565: /* Salesperson, with Role that has a Product
4566: ** Interest defined, exists for this Named Account */
4567: SELECT NULL
4568: FROM jtf_tty_named_acct_rsc nar
4569: , jtf_tty_role_prod_int rpi
4570: , jtf_tty_terr_grp_roles tgr
4571: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
4572: AND tgr.terr_group_id = C.TERR_GROUP_ID
4573: AND tgr.role_code = nar.rsc_role_code

Line 4600: , jtf_tty_role_prod_int rpi

4596: /* Salesperson, with Role that has a Product
4597: ** Interest defined, exists for this Named Account */
4598: SELECT NULL
4599: FROM jtf_tty_named_acct_rsc nar
4600: , jtf_tty_role_prod_int rpi
4601: , jtf_tty_terr_grp_roles tgr
4602: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
4603: AND tgr.terr_group_id = C.TERR_GROUP_ID
4604: AND tgr.role_code = nar.rsc_role_code

Line 4648: , jtf_tty_role_prod_int c

4644: CURSOR role_no_pi(l_terr_group_id NUMBER) IS
4645: SELECT DISTINCT b.role_code
4646: FROM jtf_tty_role_access a
4647: , jtf_tty_terr_grp_roles b
4648: , jtf_tty_role_prod_int c
4649: WHERE a.terr_group_role_id = b.terr_group_role_id
4650: AND b.terr_group_id = l_terr_group_id
4651: AND a.access_type = 'ACCOUNT'
4652: AND c.terr_group_role_id = b.terr_group_role_id

Line 4654: FROM jtf_tty_role_prod_int e

4650: AND b.terr_group_id = l_terr_group_id
4651: AND a.access_type = 'ACCOUNT'
4652: AND c.terr_group_role_id = b.terr_group_role_id
4653: AND NOT EXISTS ( SELECT 1
4654: FROM jtf_tty_role_prod_int e
4655: , jtf_tty_terr_grp_roles d
4656: WHERE e.terr_group_role_id (+) = d.terr_group_role_id
4657: AND d.terr_group_id = b.terr_group_id
4658: AND d.role_code = b.role_code

Line 5678: , jtf_tty_role_prod_int a

5674:
5675: SELECT COUNT( DISTINCT b.role_code )
5676: INTO l_pi_count
5677: FROM jtf_rs_roles_vl r
5678: , jtf_tty_role_prod_int a
5679: , jtf_tty_terr_grp_roles b
5680: WHERE r.role_code = b.role_code
5681: AND a.terr_group_role_id = b.terr_group_role_id
5682: AND b.terr_group_id = p_terr_group_id(x)

Line 7100: FROM jtf_tty_role_prod_int rpi

7096: AND nar.rsc_role_code = tgr.role_code
7097: AND ra.terr_group_role_id = tgr.terr_group_role_id
7098: AND NOT EXISTS (
7099: SELECT NULL
7100: FROM jtf_tty_role_prod_int rpi
7101: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id );
7102:
7103:
7104: /* Access Types for a particular Role within a Territory Group */

Line 7126: FROM jtf_tty_role_prod_int rpi

7122: AND b.role_code = lp_role
7123: AND NOT EXISTS (
7124: /* Product Interest does not exist for this role */
7125: SELECT NULL
7126: FROM jtf_tty_role_prod_int rpi
7127: WHERE rpi.terr_group_role_id = B.TERR_GROUP_ROLE_ID )
7128: ORDER BY a.access_type ;
7129:
7130: /* Roles WITHOUT a Product Iterest defined */

Line 7135: FROM jtf_tty_role_prod_int a

7131: CURSOR role_interest_nonpi(l_terr_group_id NUMBER) IS
7132: SELECT b.role_code role_code
7133: --,a.interest_type_id
7134: ,b.terr_group_id
7135: FROM jtf_tty_role_prod_int a
7136: , jtf_tty_terr_grp_roles b
7137: WHERE a.terr_group_role_id(+) = b.terr_group_role_id
7138: AND b.terr_group_id = l_terr_group_id
7139: AND a.terr_group_role_id IS NULL

Line 7149: , jtf_tty_role_prod_int a

7145: SELECT DISTINCT
7146: b.role_code role_code
7147: , r.role_name role_name
7148: FROM jtf_rs_roles_vl r
7149: , jtf_tty_role_prod_int a
7150: , jtf_tty_terr_grp_roles b
7151: WHERE r.role_code = b.role_code
7152: AND a.terr_group_role_id = b.terr_group_role_id
7153: AND b.terr_group_id = lp_terr_group_id

Line 7168: FROM jtf_tty_role_prod_int a

7164: CURSOR role_pi_interest(l_terr_group_id NUMBER,l_role VARCHAR2) IS
7165: SELECT a.interest_type_id
7166: ,a.product_category_id
7167: ,a.product_category_set_id
7168: FROM jtf_tty_role_prod_int a
7169: , jtf_tty_terr_grp_roles b
7170: WHERE a.terr_group_role_id = b.terr_group_role_id
7171: AND b.terr_group_id = l_terr_group_id
7172: AND b.role_code = l_role;

Line 7316: , jtf_tty_role_prod_int rpi

7312: /* Salesperson, with Role that has a Product
7313: ** Interest defined, exists for this Named Account */
7314: SELECT NULL
7315: FROM jtf_tty_named_acct_rsc nar
7316: , jtf_tty_role_prod_int rpi
7317: , jtf_tty_terr_grp_roles tgr
7318: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
7319: AND tgr.terr_group_id = C.TERR_GROUP_ID
7320: AND tgr.role_code = nar.rsc_role_code

Line 7363: , jtf_tty_role_prod_int rpi

7359: /* Salesperson, with Role that has a Product
7360: ** Interest defined, exists for this Named Account */
7361: SELECT NULL
7362: FROM jtf_tty_named_acct_rsc nar
7363: , jtf_tty_role_prod_int rpi
7364: , jtf_tty_terr_grp_roles tgr
7365: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
7366: AND tgr.terr_group_id = C.TERR_GROUP_ID
7367: AND tgr.role_code = nar.rsc_role_code

Line 7461: , jtf_tty_role_prod_int c

7457: CURSOR role_no_pi(l_terr_group_id NUMBER) IS
7458: SELECT DISTINCT b.role_code
7459: FROM jtf_tty_role_access a
7460: , jtf_tty_terr_grp_roles b
7461: , jtf_tty_role_prod_int c
7462: WHERE a.terr_group_role_id = b.terr_group_role_id
7463: AND b.terr_group_id = l_terr_group_id
7464: AND a.access_type = 'ACCOUNT'
7465: AND c.terr_group_role_id = b.terr_group_role_id

Line 7467: FROM jtf_tty_role_prod_int e

7463: AND b.terr_group_id = l_terr_group_id
7464: AND a.access_type = 'ACCOUNT'
7465: AND c.terr_group_role_id = b.terr_group_role_id
7466: AND NOT EXISTS ( SELECT 1
7467: FROM jtf_tty_role_prod_int e
7468: , jtf_tty_terr_grp_roles d
7469: WHERE e.terr_group_role_id (+) = d.terr_group_role_id
7470: AND d.terr_group_id = b.terr_group_id
7471: AND d.role_code = b.role_code

Line 8894: , jtf_tty_role_prod_int a

8890:
8891: SELECT COUNT( DISTINCT b.role_code )
8892: INTO l_pi_count
8893: FROM jtf_rs_roles_vl r
8894: , jtf_tty_role_prod_int a
8895: , jtf_tty_terr_grp_roles b
8896: WHERE r.role_code = b.role_code
8897: AND a.terr_group_role_id = b.terr_group_role_id
8898: AND b.terr_group_id = p_terr_group_id(x)