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

Line 104: jtf_tty_terr_grp_accts ga

100: select -- NO_MERGE
101: repmgr.parent_resource_id
102: from jtf_rs_rep_managers repmgr,
103: jtf_tty_named_acct_rsc narsc,
104: jtf_tty_terr_grp_accts ga
105: where narsc.resource_id = repmgr.resource_id
106: and narsc.rsc_group_id = repmgr.group_id
107: AND narsc.terr_group_account_id = ga.terr_group_account_id
108: AND ga.terr_group_account_id = tgaid_list.terr_grp_acct_id

Line 259: jtf_tty_terr_grp_accts ga,

255: mydir.group_name,
256: mydir.role_name, mydir.role_code
257: FROM
258: jtf_tty_named_acct_rsc narsc,
259: jtf_tty_terr_grp_accts ga,
260: jtf_rs_rep_managers repmgr,
261: jtf_tty_my_directs_v mydir
262: WHERE narsc.resource_id = repmgr.resource_id
263: and narsc.rsc_group_id = repmgr.group_id

Line 376: ' jtf_tty_terr_grp_accts ga, '||

372: P_USERID || ' LAST_UPDATED_BY,'
373: || '''' || sysdate || '''' || ' LAST_UPDATE_DATE '||
374: ' from hz_parties hzp, '||
375: ' jtf_tty_named_accts na, '||
376: ' jtf_tty_terr_grp_accts ga, '||
377: ' fnd_lookups lkp, '||
378: ' jtf_tty_terr_groups ttygrp '||
379: ' , ( /* Global Ultimate */ ' ||
380: ' SELECT min(gup.party_name) GU_NAME ' ||

Line 423: ' jtf_tty_terr_grp_accts ga, '||

419: ' dir.group_name, dir.group_id, '||
420: ' dir.role_name, dir.role_code '||
421: ' FROM '||
422: ' jtf_tty_named_acct_rsc narsc, '||
423: ' jtf_tty_terr_grp_accts ga, '||
424: ' jtf_rs_rep_managers repmgr, '||
425: ' jtf_tty_my_directs_v mydir '||
426: ' WHERE narsc.resource_id = repmgr.resource_id '||
427: ' and narsc.rsc_group_id = repmgr.group_id '||

Line 450: ' jtf_tty_terr_grp_accts ga '||

446: ' dir.role_name, dir.role_code '||
447: ' from '||
448: ' jtf_tty_my_directs_v dir, '||
449: ' jtf_tty_named_acct_rsc narsc, '||
450: ' jtf_tty_terr_grp_accts ga '||
451: ' where dir.current_user_id = :0 '||
452: ' and dir.resource_id = narsc.resource_id '||
453: ' and dir.role_code = narsc.rsc_role_code '||
454: ' and dir.group_id = narsc.rsc_group_id '||

Line 472: ' jtf_tty_terr_grp_accts ga '||

468: ' and dir.dir_user_id <> :1 '||
469: ' and dir.resource_id IN ( select res.parent_resource_id '||
470: ' from jtf_rs_rep_managers res, '||
471: ' jtf_tty_named_acct_rsc narsc, '||
472: ' jtf_tty_terr_grp_accts ga '||
473: ' where res.resource_id = narsc.resource_id '||
474: ' and res.group_id = narsc.rsc_group_id '||
475: ' and res.role_code = narsc.rsc_role_code '||
476: ' and narsc.terr_group_account_id = ga.terr_group_account_id '||

Line 764: jtf_tty_terr_grp_accts ga,

760: ,round( (sum(am.metric_value)/ alm.align_metric_val )* 100, 2 ) metric_pct
761: from JTF_TTY_ACCT_METRICS AM,
762: jtf_tty_align_accts ac,
763: JTF_TTY_PTERR_ACCTS pa,
764: jtf_tty_terr_grp_accts ga,
765: jtf_tty_align_pterr ap,
766: ( select sum(ams.metric_value) align_metric_val
767: from jtf_tty_acct_metrics ams
768: ,jtf_tty_terr_grp_accts tga

Line 768: ,jtf_tty_terr_grp_accts tga

764: jtf_tty_terr_grp_accts ga,
765: jtf_tty_align_pterr ap,
766: ( select sum(ams.metric_value) align_metric_val
767: from jtf_tty_acct_metrics ams
768: ,jtf_tty_terr_grp_accts tga
769: ,jtf_tty_align_accts ala
770: where ala.alignment_id = l_alignment_id
771: and ala.terr_group_account_id = tga.terr_group_account_id
772: and tga.named_account_id = ams.named_account_id

Line 823: jtf_tty_terr_grp_accts ga,

819: ,round( (sum(am.metric_value)/ alm.align_metric_val )* 100, 2 ) metric_pct
820: from JTF_TTY_ACCT_METRICS AM,
821: jtf_tty_align_accts ac,
822: JTF_TTY_PTERR_ACCTS pa,
823: jtf_tty_terr_grp_accts ga,
824: jtf_tty_align_pterr ap,
825: ( select sum(ams.metric_value) align_metric_val
826: from jtf_tty_acct_metrics ams
827: ,jtf_tty_terr_grp_accts tga

Line 827: ,jtf_tty_terr_grp_accts tga

823: jtf_tty_terr_grp_accts ga,
824: jtf_tty_align_pterr ap,
825: ( select sum(ams.metric_value) align_metric_val
826: from jtf_tty_acct_metrics ams
827: ,jtf_tty_terr_grp_accts tga
828: ,jtf_tty_align_accts ala
829: where ala.alignment_id = l_alignment_id
830: and ala.terr_group_account_id = tga.terr_group_account_id
831: and tga.named_account_id = ams.named_account_id

Line 928: jtf_tty_terr_grp_accts ga,

924: ,round( (sum(am.metric_value)/ alm.align_metric_val )* 100, 2 ) metric_pct
925: from JTF_TTY_ACCT_METRICS AM,
926: jtf_tty_align_accts ac,
927: JTF_TTY_PTERR_ACCTS pa,
928: jtf_tty_terr_grp_accts ga,
929: jtf_tty_align_pterr ap,
930: ( select sum(ams.metric_value) align_metric_val
931: from jtf_tty_acct_metrics ams
932: ,jtf_tty_terr_grp_accts tga

Line 932: ,jtf_tty_terr_grp_accts tga

928: jtf_tty_terr_grp_accts ga,
929: jtf_tty_align_pterr ap,
930: ( select sum(ams.metric_value) align_metric_val
931: from jtf_tty_acct_metrics ams
932: ,jtf_tty_terr_grp_accts tga
933: ,jtf_tty_align_accts ala
934: where ala.alignment_id = l_alignment_id
935: and ala.terr_group_account_id = tga.terr_group_account_id
936: and tga.named_account_id = ams.named_account_id

Line 1019: from jtf_tty_terr_grp_accts ga,

1015: and rsc_role_code = c_role_code;
1016:
1017: CURSOR c_all_tg_accounts( c_user_id NUMBER ) IS
1018: select ga.terr_group_account_id gaid
1019: from jtf_tty_terr_grp_accts ga,
1020: jtf_tty_terr_groups ttygrp
1021: where ttygrp.terr_group_id = ga.terr_group_id
1022: and ttygrp.active_from_date <= sysdate
1023: and ( ttygrp.active_to_date is null

Line 1479: from jtf_tty_terr_grp_accts ga,

1475: delete from jtf_tty_align_accts
1476: where alignment_id = l_alignment_id
1477: and terr_group_account_id NOT IN
1478: ( select ga.terr_group_account_id
1479: from jtf_tty_terr_grp_accts ga,
1480: jtf_tty_terr_groups ttygrp
1481: where ttygrp.terr_group_id = ga.terr_group_id
1482: and ttygrp.active_from_date <= sysdate
1483: and ( ttygrp.active_to_date is null