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_TERRGP dependencies on JTF_TTY_NAMED_ACCTS

Line 252: DELETE from JTF_TTY_NAMED_ACCTS A

248: DELETE from JTF_TTY_TERR_GRP_ACCTS j WHERE j.TERR_GROUP_ACCOUNT_ID = l_grpAcctId_tbl(idx);
249:
250: -- Delete Named Accounts
251: FORALL idx in l_acctId_tbl.FIRST .. l_acctId_tbl.LAST
252: DELETE from JTF_TTY_NAMED_ACCTS A
253: WHERE A.named_account_id = l_acctId_tbl(idx)
254: AND NOT EXISTS
255: (SELECT 'Y'
256: FROM JTF_TTY_TERR_GRP_ACCTS tga

Line 264: FROM JTF_TTY_NAMED_ACCTS a

260: FORALL idx in l_acctId_tbl.FIRST .. l_acctId_tbl.LAST
261: DELETE from JTF_TTY_ACCT_QUAL_MAPS AQM
262: WHERE AQM.NAMED_ACCOUNT_ID = l_acctId_tbl(idx)
263: AND NOT EXISTS ( SELECT 'x'
264: FROM JTF_TTY_NAMED_ACCTS a
265: WHERE a.named_account_id = AQM.named_account_id);
266:
267:
268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 373: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,

369: narsc.RSC_GROUP_ID,
370: 'RS_EMPLOYEE',
371: na.site_type_code,
372: count(na.NAMED_ACCOUNT_ID) num_accts
373: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
374: jtf_tty_terr_grp_accts tga
375: where na.named_account_id = tga.named_account_id
376: and narsc.resource_id in
377: (SELECT RESOURCE_ID

Line 408: DELETE FROM JTF_TTY_NAMED_ACCTS na

404:
405: DELETE FROM JTF_TTY_TERR_GRP_ACCTS
406: WHERE TERR_GROUP_ID = p_terr_gp_id;
407:
408: DELETE FROM JTF_TTY_NAMED_ACCTS na
409: WHERE na.NAMED_ACCOUNT_ID NOT IN
410: (SELECT named_account_id FROM JTF_TTY_TERR_GRP_ACCTS);
411: /* delete the na mappings if a na is deleted or no reference to it exists */
412:

Line 415: (SELECT named_account_id FROM JTF_TTY_NAMED_ACCTS);

411: /* delete the na mappings if a na is deleted or no reference to it exists */
412:
413: DELETE FROM JTF_TTY_ACCT_QUAL_MAPS nam
414: WHERE nam.NAMED_ACCOUNT_ID NOT IN
415: (SELECT named_account_id FROM JTF_TTY_NAMED_ACCTS);
416:
417: /* delete all the terr gp owners, access and product */
418: DELETE FROM jtf_tty_terr_grp_owners
419: WHERE terr_group_id = p_terr_gp_id;

Line 1250: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,

1246: narsc.RSC_GROUP_ID,
1247: 'RS_EMPLOYEE',
1248: na.site_type_code,
1249: count(na.NAMED_ACCOUNT_ID) num_accts
1250: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
1251: jtf_tty_terr_grp_accts tga
1252: where na.named_account_id = tga.named_account_id
1253: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
1254: and narsc.RESOURCE_ID IN (

Line 1323: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,

1319: narsc.RSC_GROUP_ID,
1320: 'RS_EMPLOYEE',
1321: na.site_type_code,
1322: count(na.NAMED_ACCOUNT_ID) num_accts
1323: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
1324: jtf_tty_terr_grp_accts tga
1325: where na.named_account_id = tga.named_account_id
1326: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
1327: and narsc.RESOURCE_ID IN (

Line 1584: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,

1580: narsc.RSC_GROUP_ID,
1581: 'RS_EMPLOYEE',
1582: na.site_type_code,
1583: count(na.NAMED_ACCOUNT_ID) num_accts
1584: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
1585: jtf_tty_terr_grp_accts tga, jtf_tty_terr_grp_owners tgo
1586: where na.named_account_id = tga.named_account_id
1587: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
1588: and narsc.RESOURCE_ID = tgo.RESOURCE_ID

Line 1634: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,

1630: narsc.RSC_GROUP_ID,
1631: 'RS_EMPLOYEE',
1632: na.site_type_code,
1633: count(na.NAMED_ACCOUNT_ID) num_accts
1634: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
1635: jtf_tty_terr_grp_accts tga
1636: where na.named_account_id = tga.named_account_id
1637: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
1638: and narsc.RESOURCE_ID = p_resource_id

Line 1731: jtf_tty_named_accts na,

1727:
1728: CURSOR named_accounts_c IS
1729: SELECT COUNT(DISTINCT na.named_account_id) num_accounts
1730: FROM
1731: jtf_tty_named_accts na,
1732: jtf_tty_terr_grp_accts ga,
1733: jtf_tty_my_resources_v repdn,
1734: jtf_tty_named_acct_rsc narsc,
1735: jtf_rs_resource_extns rs,

Line 1755: jtf_tty_named_accts na,

1751:
1752: CURSOR named_accounts_all_c IS
1753: SELECT COUNT(DISTINCT na.named_account_id) num_accounts
1754: FROM
1755: jtf_tty_named_accts na,
1756: jtf_tty_terr_grp_accts ga,
1757: jtf_tty_my_resources_v repdn,
1758: jtf_tty_named_acct_rsc narsc,
1759: jtf_rs_resource_extns rs,

Line 1801: FROM jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,

1797: WHERE lookup_type = 'JTF_TTY_SITE_TYPE_CODE';
1798:
1799: CURSOR salesrep_named_accounts_c
1800: IS SELECT COUNT(na.NAMED_ACCOUNT_ID) num_accounts
1801: FROM jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,
1802: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg
1803: WHERE na.named_account_id = tga.named_account_id
1804: AND tga.terr_group_id = tg.terr_group_id
1805: AND (tg.active_from_date <= SYSDATE OR tg.active_from_date IS NULL)

Line 1815: FROM jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,

1811: AND na.site_type_code = p_site_type_code;
1812:
1813: CURSOR salesrep_named_accounts_all_c
1814: IS SELECT COUNT(na.NAMED_ACCOUNT_ID) num_accounts
1815: FROM jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,
1816: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg
1817: WHERE na.named_account_id = tga.named_account_id
1818: AND tga.terr_group_id = tg.terr_group_id
1819: AND (tg.active_from_date <= SYSDATE OR tg.active_from_date IS NULL)

Line 2126: from jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,

2122: narsc.RSC_GROUP_ID,
2123: 'RS_EMPLOYEE',
2124: na.site_type_code,
2125: count(na.NAMED_ACCOUNT_ID) num_accts
2126: from jtf_tty_named_accts na, jtf_tty_named_acct_rsc narsc,
2127: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg
2128: where na.named_account_id = tga.named_account_id
2129: and tga.terr_group_id = tg.terr_group_id
2130: and (tg.active_from_date <= sysdate or tg.active_from_date is null)

Line 2190: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,

2186: narsc.RSC_GROUP_ID,
2187: 'RS_EMPLOYEE',
2188: na.site_type_code,
2189: count(na.NAMED_ACCOUNT_ID) num_accts
2190: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
2191: jtf_tty_terr_grp_accts tga, jtf_tty_terr_groups tg
2192: where na.named_account_id = tga.named_account_id
2193: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
2194: and tga.terr_group_id = tg.terr_group_id

Line 2523: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,

2519: narsc.RSC_GROUP_ID,
2520: 'RS_EMPLOYEE',
2521: na.site_type_code,
2522: count(na.NAMED_ACCOUNT_ID) num_accts
2523: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
2524: jtf_tty_terr_grp_accts tga
2525: where na.named_account_id = tga.named_account_id
2526: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
2527: and narsc.RESOURCE_ID IN (

Line 2594: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,

2590: narsc.RSC_GROUP_ID,
2591: 'RS_EMPLOYEE',
2592: na.site_type_code,
2593: count(na.NAMED_ACCOUNT_ID) num_accts
2594: from jtf_tty_named_accts na, jtf_tty_acct_rsc_dn narsc,
2595: jtf_tty_terr_grp_accts tga
2596: where na.named_account_id = tga.named_account_id
2597: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
2598: and narsc.RESOURCE_ID IN (

Line 2804: DELETE FROM JTF_TTY_NAMED_ACCTS

2800: DELETE FROM JTF_TTY_TERR_GRP_ACCTS
2801: WHERE terr_group_account_id = p_tga_id;
2802:
2803: -- delete named account if no references to it exist
2804: DELETE FROM JTF_TTY_NAMED_ACCTS
2805: WHERE party_id = p_party_id
2806: AND party_id NOT IN
2807: (SELECT party_id FROM JTF_TTY_NAMED_ACCTS na, JTF_TTY_TERR_GRP_ACCTS tga
2808: WHERE tga.named_account_id = na.named_account_id);

Line 2807: (SELECT party_id FROM JTF_TTY_NAMED_ACCTS na, JTF_TTY_TERR_GRP_ACCTS tga

2803: -- delete named account if no references to it exist
2804: DELETE FROM JTF_TTY_NAMED_ACCTS
2805: WHERE party_id = p_party_id
2806: AND party_id NOT IN
2807: (SELECT party_id FROM JTF_TTY_NAMED_ACCTS na, JTF_TTY_TERR_GRP_ACCTS tga
2808: WHERE tga.named_account_id = na.named_account_id);
2809:
2810: COMMIT;
2811:

Line 2944: FROM jtf_tty_named_accts

2940: BEGIN
2941: BEGIN
2942: SELECT 1
2943: INTO p_account_count
2944: FROM jtf_tty_named_accts
2945: WHERE party_id = p_party_id
2946: AND ROWNUM < 2;
2947: EXCEPTION
2948: WHEN NO_DATA_FOUND THEN

Line 2959: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL

2955: -- create a new named account for the party, if one does not exist
2956: -- create postal code and customer key names for a new account 2780737
2957: IF (p_account_count < 1) THEN
2958:
2959: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL
2960: INTO p_account_id
2961: FROM dual;
2962: INSERT INTO jtf_tty_named_accts
2963: (NAMED_ACCOUNT_ID,

Line 2962: INSERT INTO jtf_tty_named_accts

2958:
2959: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL
2960: INTO p_account_id
2961: FROM dual;
2962: INSERT INTO jtf_tty_named_accts
2963: (NAMED_ACCOUNT_ID,
2964: OBJECT_VERSION_NUMBER ,
2965: PARTY_ID ,
2966: MAPPING_COMPLETE_FLAG,

Line 2991: FROM jtf_tty_named_accts

2987: ELSE
2988:
2989: SELECT named_account_id, mapping_complete_flag
2990: INTO p_account_id, p_mapping_flag
2991: FROM jtf_tty_named_accts
2992: WHERE party_id = p_party_id;
2993:
2994: END IF;
2995:

Line 3000: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna

2996: -- check if any terr gp account exists
2997: BEGIN
2998: SELECT 1
2999: INTO p_grp_acct_count
3000: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna
3001: WHERE tga.named_account_id = tna.named_account_id
3002: AND tga.terr_group_id = p_terr_gp_id
3003: AND tna.party_id = p_party_id
3004: AND ROWNUM < 2;

Line 3014: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna

3010:
3011: IF (p_grp_acct_count = 1) THEN
3012: SELECT tga.terr_group_account_id
3013: INTO p_terr_gp_acct_id
3014: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna
3015: WHERE tga.named_account_id = tna.named_account_id
3016: AND tga.terr_group_id = p_terr_gp_id
3017: AND tna.party_id = p_party_id;
3018: x_gp_acct_id := p_terr_gp_acct_id;

Line 3081: FROM jtf_tty_named_accts

3077: BEGIN
3078:
3079: SELECT COUNT(*)
3080: INTO p_account_count
3081: FROM jtf_tty_named_accts
3082:
3083: WHERE party_id = p_party_id;
3084: -- create a new named account for the party, if one does not exist
3085: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL

Line 3085: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL

3081: FROM jtf_tty_named_accts
3082:
3083: WHERE party_id = p_party_id;
3084: -- create a new named account for the party, if one does not exist
3085: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL
3086: INTO p_account_id
3087: FROM dual;
3088:
3089: p_site_type_code := get_site_type_code(p_party_id);

Line 3093: INSERT INTO jtf_tty_named_accts

3089: p_site_type_code := get_site_type_code(p_party_id);
3090:
3091: IF (p_account_count < 1) THEN
3092:
3093: INSERT INTO jtf_tty_named_accts
3094: (NAMED_ACCOUNT_ID,
3095: OBJECT_VERSION_NUMBER ,
3096: PARTY_ID ,
3097: MAPPING_COMPLETE_FLAG,

Line 3122: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna

3118: -- check if any terr gp account exists
3119:
3120: SELECT COUNT(tga.terr_group_account_id)
3121: INTO p_account_count
3122: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna
3123: WHERE tga.named_account_id = tna.named_account_id
3124: AND tna.party_id = p_party_id;
3125:
3126: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL