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_TERR_GRP_ACCTS

Line 66: TYPE g_terr_group_account_id_tab IS TABLE OF jtf_tty_terr_grp_accts.terr_group_account_id%TYPE;

62: TYPE g_num_winners_tab IS TABLE OF jtf_tty_terr_groups.num_winners%TYPE;
63: TYPE g_org_id_tab IS TABLE OF jtf_terr_all.org_id%TYPE;
64: TYPE g_change_type_tab IS TABLE OF jtf_tty_named_acct_changes.change_type%TYPE;
65: TYPE g_from_where_tab IS TABLE OF jtf_tty_named_acct_changes.from_where%TYPE;
66: TYPE g_terr_group_account_id_tab IS TABLE OF jtf_tty_terr_grp_accts.terr_group_account_id%TYPE;
67: TYPE g_terr_id_tab IS TABLE OF jtf_terr_all.terr_id%TYPE;
68: TYPE g_geo_territory_id_tab IS TABLE OF jtf_tty_geo_terr.geo_territory_id%TYPE;
69: TYPE g_geo_terr_name_tab IS TABLE OF jtf_tty_geo_terr.geo_terr_name%TYPE;
70: TYPE g_terr_attribute_tab IS TABLE OF jtf_tty_terr_grp_accts.attribute1%TYPE;

Line 70: TYPE g_terr_attribute_tab IS TABLE OF jtf_tty_terr_grp_accts.attribute1%TYPE;

66: TYPE g_terr_group_account_id_tab IS TABLE OF jtf_tty_terr_grp_accts.terr_group_account_id%TYPE;
67: TYPE g_terr_id_tab IS TABLE OF jtf_terr_all.terr_id%TYPE;
68: TYPE g_geo_territory_id_tab IS TABLE OF jtf_tty_geo_terr.geo_territory_id%TYPE;
69: TYPE g_geo_terr_name_tab IS TABLE OF jtf_tty_geo_terr.geo_terr_name%TYPE;
70: TYPE g_terr_attribute_tab IS TABLE OF jtf_tty_terr_grp_accts.attribute1%TYPE;
71: TYPE g_terr_attr_cat_tab IS TABLE OF jtf_terr_all.attribute_category%TYPE;
72: -- TYPE g_terr_created_id_tab IS TABLE OF jtf_terr_all.terr_id%TYPE;
73: -- TYPE g_terr_creation_flag_tab IS TABLE OF VARCHAR2(1);
74:

Line 439: FROM jtf_tty_terr_grp_accts A

435: IF (p_change_type <> 'SALES_TEAM_UPDATE') THEN
436: DELETE FROM jtf_terr_values_all jtv
437: WHERE NOT EXISTS
438: (SELECT 1
439: FROM jtf_tty_terr_grp_accts A
440: ,jtf_tty_acct_qual_maps B
441: WHERE A.named_account_id = B.named_account_id
442: AND A.terr_group_id = p_terr_group_id
443: AND B.qual_usg_id = -1012

Line 547: FROM jtf_tty_terr_grp_accts A

543: forall idx in p_terrGrpId_tbl.FIRST .. p_terrGrpId_tbl.LAST
544: DELETE from jtf_terr_values_all jtv
545: WHERE NOT EXISTS
546: (SELECT 1
547: FROM jtf_tty_terr_grp_accts A
548: ,jtf_tty_acct_qual_maps B
549: WHERE A.named_account_id = B.named_account_id
550: AND A.terr_group_id = p_terrGrpId_tbl(idx)
551: AND B.qual_usg_id = -1012

Line 4371: , jtf_tty_terr_grp_accts tga

4367: CURSOR get_NON_OVLY_na_trans(LP_terr_group_account_id NUMBER) IS
4368: SELECT ra.access_type
4369: FROM
4370: jtf_tty_named_acct_rsc nar
4371: , jtf_tty_terr_grp_accts tga
4372: , jtf_tty_terr_grp_roles tgr
4373: , jtf_tty_role_access ra
4374: WHERE tga.terr_group_account_id = nar.terr_group_account_id
4375: AND nar.terr_group_account_id = LP_terr_group_account_id

Line 4384: , jtf_tty_terr_grp_accts tga

4380: UNION
4381: SELECT ra.access_type
4382: FROM
4383: jtf_tty_named_acct_rsc nar
4384: , jtf_tty_terr_grp_accts tga
4385: , jtf_tty_terr_grp_roles tgr
4386: , jtf_tty_role_access ra
4387: WHERE tga.terr_group_account_id = nar.terr_group_account_id
4388: AND nar.terr_group_account_id = LP_terr_group_account_id

Line 4451: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga

4447: AND b.terr_group_id = lp_terr_group_id
4448: AND EXISTS (
4449: /* Named Account exists with Salesperson with this role */
4450: SELECT NULL
4451: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga
4452: WHERE tga.terr_group_account_id = nar.terr_group_account_id
4453: AND nar.terr_group_account_id = lp_terr_group_account_id
4454: AND tga.terr_group_id = b.terr_group_id
4455: AND nar.rsc_role_code = b.role_code );

Line 4490: FROM jtf_tty_terr_grp_accts a

4486: , to_char(null) attribute12
4487: , to_char(null) attribute13
4488: , to_char(null) attribute14
4489: , to_char(null) attribute15
4490: FROM jtf_tty_terr_grp_accts a
4491: , jtf_tty_named_acct_rsc b
4492: WHERE a.terr_group_account_id = l_terr_group_acct_id
4493: AND a.terr_group_account_id = b.terr_group_account_id
4494: AND b.rsc_role_code = l_role;

Line 4509: , jtf_tty_terr_grp_accts c

4505: , c.start_date
4506: , c.end_date
4507: FROM hz_parties a
4508: , jtf_tty_named_accts b
4509: , jtf_tty_terr_grp_accts c
4510: WHERE c.terr_group_account_id = LP_terr_group_acct_id
4511: AND b.named_account_id = c.named_account_id
4512: AND a.party_id = b.party_id
4513: AND a.status = 'A'

Line 4532: , jtf_tty_terr_grp_accts c

4528: , c.start_date
4529: , c.end_date
4530: FROM hz_parties a
4531: , jtf_tty_named_accts b
4532: , jtf_tty_terr_grp_accts c
4533: WHERE c.terr_group_account_id = LP_terr_group_acct_id
4534: AND b.named_account_id = c.named_account_id
4535: AND a.party_id = b.party_id
4536: AND a.status = 'A'

Line 4558: , jtf_tty_terr_grp_accts c

4554: , b.named_account_id
4555: , c.terr_group_account_id
4556: FROM hz_parties a
4557: , jtf_tty_named_accts b
4558: , jtf_tty_terr_grp_accts c
4559: WHERE c.terr_group_account_id = LP_terr_group_acct_id
4560: AND b.named_account_id = c.named_account_id
4561: AND a.party_id = b.party_id
4562: AND a.status = 'A'

Line 4585: , jtf_tty_terr_grp_accts c

4581: , c.terr_group_account_id
4582: , a.duns_number_c
4583: FROM hz_parties a
4584: , jtf_tty_named_accts b
4585: , jtf_tty_terr_grp_accts c
4586: WHERE c.terr_group_account_id = LP_terr_group_acct_id
4587: AND b.named_account_id = c.named_account_id
4588: AND a.party_id = b.party_id
4589: AND a.status = 'A'

Line 4665: FROM jtf_tty_terr_grp_accts a

4661: /* Named Account Catch-All Customer Keyname values */
4662: CURSOR catchall_cust(l_terr_group_acct_id NUMBER) IS
4663: SELECT DISTINCT b.comparison_operator
4664: ,b.value1_char
4665: FROM jtf_tty_terr_grp_accts a
4666: , jtf_tty_acct_qual_maps b
4667: WHERE a.named_account_id = b.named_account_id
4668: AND a.terr_group_account_id = l_terr_group_acct_id
4669: AND b.qual_usg_id = -1012

Line 4761: FROM jtf_tty_terr_grp_accts ga

4757:
4758: /* does Territory Group Account have at least 1 Named Account? */
4759: SELECT COUNT(*)
4760: INTO l_na_count
4761: FROM jtf_tty_terr_grp_accts ga
4762: , jtf_tty_named_accts a
4763: WHERE ga.named_account_id = a.named_account_id
4764: AND ga.terr_group_account_id = p_terr_grp_acct_id(x)
4765: AND ROWNUM < 2;

Line 5686: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga

5682: AND b.terr_group_id = p_terr_group_id(x)
5683: AND EXISTS (
5684: /* Named Account exists with Salesperson with this role */
5685: SELECT NULL
5686: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga
5687: WHERE tga.terr_group_account_id = nar.terr_group_account_id
5688: AND tga.terr_group_id = b.terr_group_id
5689: AND nar.rsc_role_code = b.role_code )
5690: AND ROWNUM < 2;

Line 7077: , jtf_tty_terr_grp_accts tga

7073: CURSOR get_NON_OVLY_na_trans(LP_terr_group_account_id NUMBER) IS
7074: SELECT ra.access_type
7075: FROM
7076: jtf_tty_named_acct_rsc nar
7077: , jtf_tty_terr_grp_accts tga
7078: , jtf_tty_terr_grp_roles tgr
7079: , jtf_tty_role_access ra
7080: WHERE tga.terr_group_account_id = nar.terr_group_account_id
7081: AND nar.terr_group_account_id = LP_terr_group_account_id

Line 7090: , jtf_tty_terr_grp_accts tga

7086: UNION
7087: SELECT ra.access_type
7088: FROM
7089: jtf_tty_named_acct_rsc nar
7090: , jtf_tty_terr_grp_accts tga
7091: , jtf_tty_terr_grp_roles tgr
7092: , jtf_tty_role_access ra
7093: WHERE tga.terr_group_account_id = nar.terr_group_account_id
7094: AND nar.terr_group_account_id = LP_terr_group_account_id

Line 7157: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga

7153: AND b.terr_group_id = lp_terr_group_id
7154: AND EXISTS (
7155: /* Named Account exists with Salesperson with this role */
7156: SELECT NULL
7157: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga
7158: WHERE tga.terr_group_account_id = nar.terr_group_account_id
7159: AND nar.terr_group_account_id = lp_terr_group_account_id
7160: AND tga.terr_group_id = b.terr_group_id
7161: AND nar.rsc_role_code = b.role_code );

Line 7196: FROM jtf_tty_terr_grp_accts a

7192: , to_char(null) attribute12
7193: , to_char(null) attribute13
7194: , to_char(null) attribute14
7195: , to_char(null) attribute15
7196: FROM jtf_tty_terr_grp_accts a
7197: , jtf_tty_named_acct_rsc b
7198: WHERE a.terr_group_account_id = l_terr_group_acct_id
7199: AND a.terr_group_account_id = b.terr_group_account_id
7200: AND b.rsc_role_code = l_role;

Line 7227: , jtf_tty_terr_grp_accts c

7223: , c.attribute14
7224: , c.attribute15
7225: FROM hz_parties a
7226: , jtf_tty_named_accts b
7227: , jtf_tty_terr_grp_accts c
7228: WHERE c.terr_group_id = LP_terr_group_id
7229: AND b.named_account_id = c.named_account_id
7230: AND a.party_id = b.party_id
7231: AND a.status = 'A'

Line 7266: , jtf_tty_terr_grp_accts c

7262: , c.attribute14
7263: , c.attribute15
7264: FROM hz_parties a
7265: , jtf_tty_named_accts b
7266: , jtf_tty_terr_grp_accts c
7267: WHERE c.terr_group_id = LP_terr_group_id
7268: AND b.named_account_id = c.named_account_id
7269: AND a.party_id = b.party_id
7270: AND a.status = 'A'

Line 7305: , jtf_tty_terr_grp_accts c

7301: , c.attribute14
7302: , c.attribute15
7303: FROM hz_parties a
7304: , jtf_tty_named_accts b
7305: , jtf_tty_terr_grp_accts c
7306: WHERE c.terr_group_id = LP_terr_group_id
7307: AND b.named_account_id = c.named_account_id
7308: AND a.party_id = b.party_id
7309: AND a.status = 'A'

Line 7348: , jtf_tty_terr_grp_accts c

7344: , c.attribute14
7345: , c.attribute15
7346: FROM hz_parties a
7347: , jtf_tty_named_accts b
7348: , jtf_tty_terr_grp_accts c
7349: WHERE c.terr_group_id = LP_terr_group_id
7350: AND b.named_account_id = c.named_account_id
7351: AND a.party_id = b.party_id
7352: AND a.status = 'A'

Line 7411: FROM jtf_tty_terr_grp_accts a

7407: /* Named Account Catch-All Customer Keyname values */
7408: CURSOR catchall_cust(l_terr_group_id NUMBER) IS
7409: SELECT DISTINCT b.comparison_operator
7410: ,b.value1_char
7411: FROM jtf_tty_terr_grp_accts a
7412: , jtf_tty_acct_qual_maps b
7413: WHERE a.named_account_id = b.named_account_id
7414: AND a.terr_group_id = l_terr_group_id
7415: AND b.qual_usg_id = -1012

Line 7571: , jtf_tty_terr_grp_accts ga

7567: /* does Territory Group have at least 1 Named Account? */
7568: /*SELECT COUNT(*)
7569: INTO l_na_count
7570: FROM jtf_tty_terr_groups g
7571: , jtf_tty_terr_grp_accts ga
7572: , jtf_tty_named_accts a
7573: WHERE g.terr_group_id = ga.terr_group_id
7574: AND ga.named_account_id = a.named_account_id
7575: AND g.terr_group_id = p_terr_group_id(x)

Line 8902: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga

8898: AND b.terr_group_id = p_terr_group_id(x)
8899: AND EXISTS (
8900: /* Named Account exists with Salesperson with this role */
8901: SELECT NULL
8902: FROM jtf_tty_named_acct_rsc nar, jtf_tty_terr_grp_accts tga
8903: WHERE tga.terr_group_account_id = nar.terr_group_account_id
8904: AND tga.terr_group_id = b.terr_group_id
8905: AND nar.rsc_role_code = b.role_code )
8906: AND ROWNUM < 2;

Line 10858: ,jtf_tty_terr_grp_accts B

10854: ** of the corresponding named account has been updated */
10855: SELECT B.terr_group_account_id terr_group_account_id
10856: ,'MAPPING_UPDATE' change_type
10857: FROM jtf_tty_named_acct_changes A
10858: ,jtf_tty_terr_grp_accts B
10859: WHERE A.creation_date <= l_date
10860: AND A.change_type = 'UPDATE'
10861: AND A.object_type = 'NA'
10862: AND A.object_id = B.named_account_id) A

Line 10863: ,jtf_tty_terr_grp_accts B

10859: WHERE A.creation_date <= l_date
10860: AND A.change_type = 'UPDATE'
10861: AND A.object_type = 'NA'
10862: AND A.object_id = B.named_account_id) A
10863: ,jtf_tty_terr_grp_accts B
10864: ,jtf_tty_terr_groups C
10865: ,jtf_terr_all D -- to get the org_id of the parent territory
10866: ,jtf_terr_all E -- to get the terr_id of the top level territory of overlay branch
10867: ,jtf_terr_all F -- to get the terr_id for the placeholder territory of non-overlay branch

Line 12174: jtf_tty_terr_grp_accts B

12170: ,B.attribute13
12171: ,B.attribute14
12172: ,B.attribute15
12173: FROM
12174: jtf_tty_terr_grp_accts B
12175: ,jtf_tty_terr_groups C
12176: ,jtf_terr_all D -- to get the org_id of the parent territory
12177: ,jtf_terr_all E -- to get the terr_id of the top level territory of overlay branch
12178: ,jtf_terr_all F -- to get the terr_id for the placeholder territory of non-overlay branch

Line 12907: FROM jtf_tty_terr_grp_accts a

12903: , to_char(null) attribute12
12904: , to_char(null) attribute13
12905: , to_char(null) attribute14
12906: , to_char(null) attribute15
12907: FROM jtf_tty_terr_grp_accts a
12908: , jtf_tty_named_acct_rsc b
12909: WHERE a.terr_group_account_id = l_terr_group_acct_id
12910: AND a.terr_group_account_id = b.terr_group_account_id
12911: AND b.rsc_role_code = l_role;

Line 13115: FROM jtf_tty_terr_grp_accts tty

13111: tty.ATTRIBUTE10, tty.ATTRIBUTE11, tty.ATTRIBUTE12,
13112: tty.ATTRIBUTE13, tty.ATTRIBUTE14, tty.ATTRIBUTE15,
13113: NVL( tty.START_DATE, TRUNC(jta.start_date_active) ),
13114: NVL( tty.END_DATE, TRUNC(jta.end_date_active) )
13115: FROM jtf_tty_terr_grp_accts tty
13116: WHERE tty.terr_group_account_id = jta.terr_group_account_id
13117: AND tty.terr_group_id = jta.terr_group_id)
13118: WHERE jta.terr_group_account_id = p_terr_grp_acct_id
13119: AND jta.terr_group_id = p_terr_group_id;