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_NAMED_ACCT_RSC

Line 4370: jtf_tty_named_acct_rsc nar

4366: */
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

Line 4383: jtf_tty_named_acct_rsc nar

4379: AND ra.access_type IN ('ACCOUNT')
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

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 4491: , jtf_tty_named_acct_rsc b

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;
4495:

Line 4518: FROM jtf_tty_named_acct_rsc nar

4514: -- AND (a.DUNS_NUMBER_C IS NOT NULL OR l_matching_rule_code = '4' OR l_matching_rule_code = '5')
4515: AND EXISTS (
4516: /* Salesperson exists for this Named Account */
4517: SELECT NULL
4518: FROM jtf_tty_named_acct_rsc nar
4519: WHERE nar.terr_group_account_id = C.TERR_GROUP_ACCOUNT_ID );
4520:
4521: /* get the PARTY_NAME + POSTAL_CODE for the Named Account:
4522: ** used for NAMED ACCOUNT territory creation */

Line 4545: FROM jtf_tty_named_acct_rsc nar

4541: WHERE d.named_account_id = c.named_account_id )
4542: AND EXISTS (
4543: /* Salesperson exists for this Named Account */
4544: SELECT NULL
4545: FROM jtf_tty_named_acct_rsc nar
4546: WHERE nar.terr_group_account_id = C.TERR_GROUP_ACCOUNT_ID );
4547:
4548: /* Should Unassigned NAs go to Sales Manager or NA Catch-All? */
4549: -- WHERE c.dn_jnr_assigned_flag = 'Y';

Line 4568: FROM jtf_tty_named_acct_rsc nar

4564: AND EXISTS (
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

Line 4599: FROM jtf_tty_named_acct_rsc nar

4595: AND EXISTS (
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

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 7076: jtf_tty_named_acct_rsc nar

7072: */
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

Line 7089: jtf_tty_named_acct_rsc nar

7085: AND ra.access_type IN ('ACCOUNT')
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

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 7197: , jtf_tty_named_acct_rsc b

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;
7201:

Line 7236: FROM jtf_tty_named_acct_rsc nar

7232: -- AND (a.DUNS_NUMBER_C IS NOT NULL OR l_matching_rule_code = '4')
7233: AND EXISTS (
7234: /* Salesperson exists for this Named Account */
7235: SELECT NULL
7236: FROM jtf_tty_named_acct_rsc nar
7237: WHERE nar.terr_group_account_id = C.TERR_GROUP_ACCOUNT_ID );
7238:
7239: /* get the PARTY_NAME + POSTAL_CODE for the Named Account:
7240: ** used for NAMED ACCOUNT territory creation */

Line 7279: FROM jtf_tty_named_acct_rsc nar

7275: WHERE d.named_account_id = c.named_account_id )
7276: AND EXISTS (
7277: /* Salesperson exists for this Named Account */
7278: SELECT NULL
7279: FROM jtf_tty_named_acct_rsc nar
7280: WHERE nar.terr_group_account_id = C.TERR_GROUP_ACCOUNT_ID );
7281:
7282: /* used for OVERLAY territory creation for DUNS# and Party Number qualifier */
7283: CURSOR get_OVLY_party_info(LP_terr_group_id NUMBER, l_matching_rule_code VARCHAR2) IS

Line 7315: FROM jtf_tty_named_acct_rsc nar

7311: AND EXISTS (
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

Line 7362: FROM jtf_tty_named_acct_rsc nar

7358: AND EXISTS (
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

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 12908: , jtf_tty_named_acct_rsc b

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;
12912: