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_ALIGN_ACCTS

Line 180: from JTF_TTY_ALIGN_ACCTS aa,

176: cursor getStatisticByAlign (userid in number, p_align_id in number) IS
177: select role_code, MAX(num) num
178: from (
179: select ap.rsc_role_code role_code, count(ap.rsc_role_code) num
180: from JTF_TTY_ALIGN_ACCTS aa,
181: JTF_TTY_PTERR_ACCTS pa,
182: JTF_TTY_ALIGN_PTERR ap
183: -- jtf_rs_roles_vl rol
184: where

Line 274: from JTF_TTY_ALIGN_ACCTS aa,

270: cursor al_sales(align_id in number, tgaid in number) IS
271: select rsc.resource_name, --ap.resource_id,
272: grp.group_name, --ap.rsc_group_id group_id,
273: rol.role_name, ap.rsc_role_code role_code
274: from JTF_TTY_ALIGN_ACCTS aa,
275: JTF_TTY_PTERR_ACCTS pa,
276: JTF_TTY_ALIGN_PTERR ap,
277: jtf_rs_resource_extns_vl rsc,
278: jtf_rs_groups_vl grp,

Line 595: from jtf_tty_align_accts

591: In this case, the salesrep is from named account resource table */
592: /* for removed NA, are those taken care of in upload? */
593: begin
594: select alignment_id into l_align_id
595: from jtf_tty_align_accts
596: where terr_group_account_id = m.terr_grp_acct_id
597: and alignment_id = p_align_id;
598:
599: exception

Line 762: jtf_tty_align_accts ac,

758: from ( select pa.align_proposed_terr_id pterr_id
759: ,sum(am.metric_value) metric_value
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

Line 769: ,jtf_tty_align_accts ala

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
773: and ams.metric_lookup_type = 'JTF_TTY_ALIGN_METRICS'

Line 821: jtf_tty_align_accts ac,

817: from ( select pa.align_proposed_terr_id pterr_id
818: ,sum(am.metric_value) metric_value
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

Line 828: ,jtf_tty_align_accts ala

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
832: and ams.metric_lookup_type = 'JTF_TTY_ALIGN_METRICS'

Line 883: from jtf_tty_align_accts ala

879: from
880: JTF_TTY_PTERR_ACCTS pa,
881: jtf_tty_align_pterr ap,
882: ( select count(ala.terr_group_account_id) tot_align_metric_val
883: from jtf_tty_align_accts ala
884: where ala.alignment_id = l_alignment_id
885: ) alm
886: where
887: pa.align_proposed_terr_id = ap.align_proposed_terr_id

Line 926: jtf_tty_align_accts ac,

922: from ( select pa.align_proposed_terr_id pterr_id
923: ,sum(am.metric_value) metric_value
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

Line 933: ,jtf_tty_align_accts ala

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
937: and ams.metric_lookup_type = 'JTF_TTY_ALIGN_METRICS'

Line 999: from JTF_TTY_ALIGN_ACCTS

995: and PA.ALIGN_ACCT_ID = c_align_acct_id ;
996:
997: cursor c_align_acct(c_terr_group_account_id NUMBER, c_alignment_id NUMBER ) IS
998: select align_acct_id
999: from JTF_TTY_ALIGN_ACCTS
1000: where terr_group_account_id = c_terr_group_account_id
1001: and alignment_id = c_alignment_id;
1002:
1003: cursor c_all_align_accts ( c_alignment_id NUMBER ) IS

Line 1005: from JTF_TTY_ALIGN_ACCTS

1001: and alignment_id = c_alignment_id;
1002:
1003: cursor c_all_align_accts ( c_alignment_id NUMBER ) IS
1004: select align_acct_id, terr_group_account_id
1005: from JTF_TTY_ALIGN_ACCTS
1006: where alignment_id = c_alignment_id;
1007:
1008: cursor c_align_pterr(c_resource_id NUMBER, c_group_id NUMBER, c_role_code VARCHAR2,
1009: c_alignment_id NUMBER ) IS

Line 1098: --populate JTF_TTY_ALIGN_ACCTS

1094:
1095: --Initial population of alignment datamodel if this is the first upload
1096: if l_imported_on is null then
1097:
1098: --populate JTF_TTY_ALIGN_ACCTS
1099: OPEN c_all_tg_accounts( c_user_id => l_user_id );
1100: FETCH c_all_tg_accounts BULK COLLECT INTO all_tg_accts_tbl;
1101: CLOSE c_all_tg_accounts;
1102:

Line 1104: insert into JTF_TTY_ALIGN_ACCTS

1100: FETCH c_all_tg_accounts BULK COLLECT INTO all_tg_accts_tbl;
1101: CLOSE c_all_tg_accounts;
1102:
1103: FORALL k IN all_tg_accts_tbl.FIRST .. all_tg_accts_tbl.LAST
1104: insert into JTF_TTY_ALIGN_ACCTS
1105: ( align_acct_id
1106: ,object_version_number
1107: ,alignment_id
1108: ,terr_group_account_id

Line 1115: ( JTF_TTY_ALIGN_ACCTS_S.nextval

1111: ,last_updated_by
1112: ,last_update_date
1113: ,last_update_login
1114: ) values
1115: ( JTF_TTY_ALIGN_ACCTS_S.nextval
1116: ,1
1117: ,l_alignment_id
1118: ,all_tg_accts_tbl(k)
1119: ,G_USER

Line 1255: select JTF_TTY_ALIGN_ACCTS_S.nextval

1251: --check to see if alignment account exists
1252: if c_align_acct%notfound then
1253: --
1254: --create a new alignment account record
1255: select JTF_TTY_ALIGN_ACCTS_S.nextval
1256: into l_align_acct_id
1257: from dual;
1258:
1259: --insert into tmp values('2. Create Align Account', l_align_acct_id); commit;

Line 1260: insert into JTF_TTY_ALIGN_ACCTS

1256: into l_align_acct_id
1257: from dual;
1258:
1259: --insert into tmp values('2. Create Align Account', l_align_acct_id); commit;
1260: insert into JTF_TTY_ALIGN_ACCTS
1261: ( align_acct_id
1262: ,object_version_number
1263: ,alignment_id
1264: ,terr_group_account_id

Line 1475: delete from jtf_tty_align_accts

1471: -- The previous remove will remove salespersons only for changed rows in excel.
1472: -- Since the accounts no longer owned by user do not show up in excel, we have
1473: -- to process them seperately
1474: -----------------------------------------------*/
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,

Line 1504: from jtf_tty_align_accts

1500: from jtf_tty_align_pterr
1501: where alignment_id = l_alignment_id )
1502: and align_acct_id NOT IN
1503: ( select align_acct_id
1504: from jtf_tty_align_accts
1505: where alignment_id = l_alignment_id )
1506: returning align_proposed_terr_id BULK COLLECT INTO pterrs_changed_tbl;
1507:
1508: IF ( pterrs_changed_tbl IS NOT NULL ) AND ( pterrs_changed_tbl.COUNT > 0 )