APPS.JTF_TTY_POP_TERR_ADMIN_BIN_PVT dependencies on JTF_TTY_TERR_GRP_ACCTS

Line 155: from jtf_tty_terr_grp_accts jga

151: , nvl(to_char(map.mapped/tot.named_accounts * 100,'9999.9'),'0.0') || '%' mapPer
152: , nvl(to_char(ass.assigned/tot.named_accounts * 100 ,'9999.9'),'0.0') || '%' assPer
153: from ( select jga.terr_group_id
154: , count(*) assigned
155: from jtf_tty_terr_grp_accts jga
156: where jga.DN_JNR_ASSIGNED_FLAG = 'Y'
157: group by jga.terr_group_id) ASS,
158: ( select jga.terr_group_id, jtg.terr_group_name
159: , count(*) named_accounts

Line 160: from jtf_tty_terr_grp_accts jga

156: where jga.DN_JNR_ASSIGNED_FLAG = 'Y'
157: group by jga.terr_group_id) ASS,
158: ( select jga.terr_group_id, jtg.terr_group_name
159: , count(*) named_accounts
160: from jtf_tty_terr_grp_accts jga
161: , jtf_tty_terr_groups jtg
162: where jga.terr_group_id = jtg.terr_group_id
163: group by jga.terr_group_id, jtg.terr_group_name ) tot,
164: ( select

Line 167: from jtf_tty_terr_grp_accts jga

163: group by jga.terr_group_id, jtg.terr_group_name ) tot,
164: ( select
165: jga.terr_group_id
166: , count(*) mapped
167: from jtf_tty_terr_grp_accts jga
168: where jga.dn_jna_mapping_complete_flag = 'Y'
169: group by jga.terr_group_id ) map
170: where ass.terr_group_id (+) = tot.terr_group_id
171: and map.terr_group_id (+) = tot.terr_group_id

Line 204: UPDATE JTF_TTY_TERR_GRP_ACCTS

200:
201: JTF_TTY_WORKFLOW_POP_BIN_PVT.print_log('Synchronizing the SUMM table with TERR_GROUPS table');
202: /* take care of the logic moved from web adi admin excel */
203:
204: UPDATE JTF_TTY_TERR_GRP_ACCTS
205: SET DN_JNR_ASSIGNED_FLAG = 'Y'
206: WHERE TERR_GROUP_ACCOUNT_ID IN
207: (select /*+ INDEX_FFS(NARSC JTF_TTY_NAMED_ACCT_RSC_N8 )*/ narsc.terr_group_account_id
208: from jtf_tty_named_acct_rsc narsc

Line 211: UPDATE JTF_TTY_TERR_GRP_ACCTS

207: (select /*+ INDEX_FFS(NARSC JTF_TTY_NAMED_ACCT_RSC_N8 )*/ narsc.terr_group_account_id
208: from jtf_tty_named_acct_rsc narsc
209: where assigned_flag = 'Y');
210:
211: UPDATE JTF_TTY_TERR_GRP_ACCTS
212: SET DN_JNR_ASSIGNED_FLAG = 'N'
213: WHERE TERR_GROUP_ACCOUNT_ID NOT IN
214: (select /*+ INDEX_FFS(NARSC JTF_TTY_NAMED_ACCT_RSC_N8 )*/ narsc.terr_group_account_id
215: from jtf_tty_named_acct_rsc narsc