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_TTY_ROLE_PROD_INT

Line 492: FROM jtf_tty_role_prod_int rpi

488: AND nar.rsc_role_code = tgr.role_code
489: AND ra.terr_group_role_id = tgr.terr_group_role_id
490: AND NOT EXISTS (
491: SELECT NULL
492: FROM jtf_tty_role_prod_int rpi
493: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id );
494:
495:
496: /* Access Types for a Territory Group */

Line 516: FROM jtf_tty_role_prod_int rpi

512: and b.role_code = lp_role
513: AND NOT EXISTS (
514: /* Product Interest does not exist for this role */
515: SELECT NULL
516: FROM jtf_tty_role_prod_int rpi
517: WHERE rpi.terr_group_role_id = B.TERR_GROUP_ROLE_ID )
518: order by a.access_type ;
519:
520:

Line 536: from jtf_tty_role_prod_int a

532: CURSOR role_interest_nonpi(l_terr_group_id number) IS
533: SELECT b.role_code role_code
534: --,a.interest_type_id
535: ,b.terr_group_id
536: from jtf_tty_role_prod_int a
537: , jtf_tty_terr_grp_roles b
538: where a.terr_group_role_id(+) = b.terr_group_role_id
539: and b.terr_group_id = l_terr_group_id
540: and a.terr_group_role_id is null

Line 550: , jtf_tty_role_prod_int a

546: SELECT distinct
547: b.role_code role_code
548: , r.role_name role_name
549: from jtf_rs_roles_vl r
550: , jtf_tty_role_prod_int a
551: , jtf_tty_terr_grp_roles b
552: where r.role_code = b.role_code
553: and a.terr_group_role_id = b.terr_group_role_id
554: and b.terr_group_id = lp_terr_group_id

Line 567: from jtf_tty_role_prod_int a

563:
564: /* Product Interest for a Role */
565: CURSOR role_pi_interest(l_terr_group_id number,l_role varchar2) IS
566: SELECT a.interest_type_id
567: from jtf_tty_role_prod_int a
568: , jtf_tty_terr_grp_roles b
569: where a.terr_group_role_id = b.terr_group_role_id
570: and b.terr_group_id = l_terr_group_id
571: and b.role_code = l_role;

Line 668: , jtf_tty_role_prod_int rpi

664: /* Salesperson, with Role that has a Product
665: ** Interest defined, exists for this Named Account */
666: SELECT NULL
667: FROM jtf_tty_named_acct_rsc nar
668: , jtf_tty_role_prod_int rpi
669: , jtf_tty_terr_grp_roles tgr
670: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
671: AND tgr.terr_group_id = C.TERR_GROUP_ID
672: AND tgr.role_code = nar.rsc_role_code

Line 700: , jtf_tty_role_prod_int rpi

696: /* Salesperson, with Role that has a Product
697: ** Interest defined, exists for this Named Account */
698: SELECT NULL
699: FROM jtf_tty_named_acct_rsc nar
700: , jtf_tty_role_prod_int rpi
701: , jtf_tty_terr_grp_roles tgr
702: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
703: AND tgr.terr_group_id = C.TERR_GROUP_ID
704: AND tgr.role_code = nar.rsc_role_code

Line 781: , jtf_tty_role_prod_int c

777: CURSOR role_no_pi(l_terr_group_id number) IS
778: SELECT distinct b.role_code
779: from jtf_tty_role_access a
780: , jtf_tty_terr_grp_roles b
781: , jtf_tty_role_prod_int c
782: where a.terr_group_role_id = b.terr_group_role_id
783: and b.terr_group_id = l_terr_group_id
784: and a.access_type = 'ACCOUNT'
785: and c.terr_group_role_id = b.terr_group_role_id

Line 787: from jtf_tty_role_prod_int e

783: and b.terr_group_id = l_terr_group_id
784: and a.access_type = 'ACCOUNT'
785: and c.terr_group_role_id = b.terr_group_role_id
786: and not exists ( SELECT 1
787: from jtf_tty_role_prod_int e
788: , jtf_tty_terr_grp_roles d
789: where e.terr_group_role_id (+) = d.terr_group_role_id
790: and d.terr_group_id = b.terr_group_id
791: and d.role_code = b.role_code

Line 2270: , jtf_tty_role_prod_int a

2266:
2267: SELECT COUNT( DISTINCT b.role_code )
2268: into l_pi_count
2269: from jtf_rs_roles_vl r
2270: , jtf_tty_role_prod_int a
2271: , jtf_tty_terr_grp_roles b
2272: where r.role_code = b.role_code
2273: and a.terr_group_role_id = b.terr_group_role_id
2274: and b.terr_group_id = TERR_GROUP.TERR_GROUP_ID

Line 3821: FROM jtf_tty_role_prod_int rpi

3817: AND grsc.rsc_role_code = tgr.role_code
3818: AND ra.terr_group_role_id = tgr.terr_group_role_id
3819: AND NOT EXISTS (
3820: SELECT NULL
3821: FROM jtf_tty_role_prod_int rpi
3822: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id );
3823:
3824: /* same sql used in geography download to Excel
3825: This query will find out all the postal codes

Line 3951: FROM jtf_tty_role_prod_int rpi

3947: and b.role_code = lp_role
3948: AND NOT EXISTS (
3949: /* Product Interest does not exist for this role */
3950: SELECT NULL
3951: FROM jtf_tty_role_prod_int rpi
3952: WHERE rpi.terr_group_role_id = B.TERR_GROUP_ROLE_ID )
3953: order by a.access_type ;
3954:
3955: /* Roles WITHOUT a Product Iterest defined */

Line 3960: from jtf_tty_role_prod_int a

3956: CURSOR role_interest_nonpi(l_terr_group_id number) IS
3957: SELECT b.role_code role_code
3958: --,a.interest_type_id
3959: ,b.terr_group_id
3960: from jtf_tty_role_prod_int a
3961: , jtf_tty_terr_grp_roles b
3962: where a.terr_group_role_id(+) = b.terr_group_role_id
3963: and b.terr_group_id = l_terr_group_id
3964: and a.terr_group_role_id is null

Line 4027: , jtf_tty_role_prod_int rpi

4023: /* Salesperson, with Role that has a Product
4024: ** Interest defined, exists for this Named Account */
4025: SELECT NULL
4026: FROM jtf_tty_geo_terr_rsc grsc
4027: , jtf_tty_role_prod_int rpi
4028: , jtf_tty_terr_grp_roles tgr
4029: WHERE rpi.terr_group_role_id = tgr.terr_group_role_id
4030: AND tgr.terr_group_id = gterr.TERR_GROUP_ID
4031: AND tgr.role_code = grsc.rsc_role_code

Line 4042: , jtf_tty_role_prod_int a

4038: SELECT distinct
4039: b.role_code role_code
4040: , r.role_name role_name
4041: from jtf_rs_roles_vl r
4042: , jtf_tty_role_prod_int a
4043: , jtf_tty_terr_grp_roles b
4044: where r.role_code = b.role_code
4045: and a.terr_group_role_id = b.terr_group_role_id
4046: and b.terr_group_id = lp_terr_group_id

Line 4070: from jtf_tty_role_prod_int a

4066:
4067: /* Product Interest for a Role */
4068: CURSOR role_pi_interest(l_terr_group_id number,l_role varchar2) IS
4069: SELECT a.interest_type_id
4070: from jtf_tty_role_prod_int a
4071: , jtf_tty_terr_grp_roles b
4072: where a.terr_group_role_id = b.terr_group_role_id
4073: and b.terr_group_id = l_terr_group_id
4074: and b.role_code = l_role;

Line 4445: , jtf_tty_role_prod_int a

4441:
4442: SELECT COUNT( DISTINCT b.role_code )
4443: into l_pi_count
4444: from jtf_rs_roles_vl r
4445: , jtf_tty_role_prod_int a
4446: , jtf_tty_terr_grp_roles b
4447: where r.role_code = b.role_code
4448: and a.terr_group_role_id = b.terr_group_role_id
4449: and b.terr_group_id = p_terr_group_rec.TERR_GROUP_ID