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_MAINTAIN_NA_PVT dependencies on JTF_TTY_TERR_GRP_ACCTS

Line 135: FROM jtf_tty_named_accts na, jtf_tty_terr_grp_accts tga

131:
132: --Cursor to get NA id and TGA id for specified party and terr group: Single Row
133: CURSOR c_get_all_ids(l_party_id NUMBER, l_party_site_id NUMBER, l_tg_id NUMBER) IS
134: SELECT na.named_account_id, tga.terr_group_account_id
135: FROM jtf_tty_named_accts na, jtf_tty_terr_grp_accts tga
136: WHERE na.party_id = l_party_id
137: AND na.party_site_id = l_party_site_id
138: AND tga.named_account_id = na.named_account_id
139: AND tga.terr_group_id = l_tg_id;

Line 229: update jtf_tty_terr_grp_accts

225: CLOSE c_get_all_ids;
226:
227: -- added 06/05/2006 bug 5246668, update attributes and date
228:
229: update jtf_tty_terr_grp_accts
230: set ATTRIBUTE1 = P_ATTRIBUTE1,
231: ATTRIBUTE2 = P_ATTRIBUTE2,
232: ATTRIBUTE3 = P_ATTRIBUTE3,
233: ATTRIBUTE4 = P_ATTRIBUTE4,

Line 289: DELETE from JTF_TTY_TERR_GRP_ACCTS

285: DELETE from jtf_tty_named_acct_rsc
286: WHERE terr_group_account_id = p_terr_grp_acct_id;
287:
288: --Delete TG account
289: DELETE from JTF_TTY_TERR_GRP_ACCTS
290: WHERE terr_group_account_id = p_terr_grp_acct_id;
291:
292: --Delete this named account if it has no other TG references
293:

Line 297: from JTF_TTY_TERR_GRP_ACCTS a

293:
294: DELETE from JTF_TTY_NAMED_ACCTS
295: WHERE named_account_id = P_NAMED_ACCT_ID
296: AND NOT EXISTS (SELECT named_account_id
297: from JTF_TTY_TERR_GRP_ACCTS a
298: where a.named_account_id = P_NAMED_ACCT_ID);
299:
300: --Delete the NA mappings if an NA is deleted or no reference to it exists
301:

Line 644: FROM jtf_tty_named_accts na, jtf_tty_terr_grp_accts tga

640:
641: --Cursor to check if TGA already exists for specified party and terr group: Single Row
642: CURSOR c_check_tga_exists(l_party_id NUMBER, l_party_site_id NUMBER, l_tg_id NUMBER) IS
643: SELECT na.named_account_id, tga.terr_group_account_id
644: FROM jtf_tty_named_accts na, jtf_tty_terr_grp_accts tga
645: WHERE na.party_id = l_party_id
646: AND na.party_site_id = l_party_site_id
647: AND tga.named_account_id = na.named_account_id
648: AND tga.terr_group_id = l_tg_id;

Line 819: SELECT jtf_tty_terr_grp_accts_s.nextval INTO l_tga_id FROM dual;

815: --At this point either named account exists or it has been created
816: --Add this named account to the TG
817: -- dbms_output.put_line('Sandeep - In AADD_ORGTO_TG :34' );
818: CLOSE c_check_na_exists;
819: SELECT jtf_tty_terr_grp_accts_s.nextval INTO l_tga_id FROM dual;
820:
821: INSERT INTO jtf_tty_terr_grp_accts
822: (TERR_GROUP_ACCOUNT_ID,
823: OBJECT_VERSION_NUMBER,

Line 821: INSERT INTO jtf_tty_terr_grp_accts

817: -- dbms_output.put_line('Sandeep - In AADD_ORGTO_TG :34' );
818: CLOSE c_check_na_exists;
819: SELECT jtf_tty_terr_grp_accts_s.nextval INTO l_tga_id FROM dual;
820:
821: INSERT INTO jtf_tty_terr_grp_accts
822: (TERR_GROUP_ACCOUNT_ID,
823: OBJECT_VERSION_NUMBER,
824: TERR_GROUP_ID,
825: NAMED_ACCOUNT_ID,

Line 1132: FROM jtf_tty_terr_grp_accts tga,

1128: /* commenting out due to 3576571 bug */
1129: /*
1130: BEGIN
1131: SELECT 'VALID' INTO l_select
1132: FROM jtf_tty_terr_grp_accts tga,
1133: jtf_tty_named_acct_rsc nar,
1134: jtf_tty_terr_groups tg
1135: WHERE nar.terr_group_account_id = tga.terr_group_account_id
1136: AND nar.rsc_role_code = X_ROLE_CODE

Line 1576: FROM jtf_tty_terr_grp_accts ga,

1572: p_owner_role_code :=owners_c.rsc_role_code;
1573: BEGIN
1574: SELECT 'X'
1575: INTO p_exists_flag
1576: FROM jtf_tty_terr_grp_accts ga,
1577: jtf_tty_my_resources_v repdn,
1578: jtf_tty_named_acct_rsc narsc
1579: WHERE ga.terr_group_account_id = narsc.terr_group_account_id
1580: AND narsc.resource_id = repdn.resource_id

Line 1739: jtf_tty_terr_grp_accts gai,

1735: cursor c_subsidiaries(cl_terr_group_account_id number) is
1736: select distinct gao.terr_group_account_id
1737: from hz_relationships hzr,
1738: jtf_tty_named_accts nai,
1739: jtf_tty_terr_grp_accts gai,
1740: jtf_tty_named_accts nao,
1741: jtf_tty_terr_grp_accts gao
1742: where gao.named_account_id = nao.named_account_id
1743: and nao.party_id = hzr.object_id -- these are the subsidiary parties

Line 1741: jtf_tty_terr_grp_accts gao

1737: from hz_relationships hzr,
1738: jtf_tty_named_accts nai,
1739: jtf_tty_terr_grp_accts gai,
1740: jtf_tty_named_accts nao,
1741: jtf_tty_terr_grp_accts gao
1742: where gao.named_account_id = nao.named_account_id
1743: and nao.party_id = hzr.object_id -- these are the subsidiary parties
1744: and hzr.subject_table_name = 'HZ_PARTIES'
1745: and hzr.object_table_name = 'HZ_PARTIES'

Line 1757: -- jtf_tty_terr_grp_accts ga

1753: and exists( select 'Y'
1754: from jtf_tty_named_acct_rsc narsc ,
1755: jtf_tty_my_resources_v repdn
1756: -- jtf_tty_named_accts na,
1757: -- jtf_tty_terr_grp_accts ga
1758: where narsc.terr_group_account_id = gao.terr_group_account_id
1759: -- and ga.named_account_id = na.named_account_id
1760: and narsc.resource_id = repdn.resource_id
1761: and narsc.rsc_group_id = repdn.group_id