APPS.JTF_TTY_WEBADI_NADOC_PKG dependencies on JTF_TTY_TERR_GRP_ACCTS

Line 164: , jtf_tty_terr_grp_accts ga

160: FROM jtf_rs_resource_extns_vl rsc
161: , jtf_rs_groups_vl grp
162: , jtf_rs_roles_vl rol
163: , jtf_tty_named_acct_rsc narsc
164: , jtf_tty_terr_grp_accts ga
165: -- , jtf_tty_named_accts na
166: WHERE rsc.resource_id = narsc.resource_id
167: AND grp.group_id = narsc.rsc_group_id
168: AND rol.role_code = narsc.rsc_role_code

Line 294: ' from jtf_tty_terr_grp_accts ga ' ||

290: ' ttygrp.terr_group_name grpname, ' ||
291: ' ga.terr_group_account_id gaid, '||
292: ' ga.terr_group_id tgid, ' ||
293: ' na.named_account_id naid ' ||
294: ' from jtf_tty_terr_grp_accts ga ' ||
295: ' ,jtf_tty_terr_groups ttygrp ' ||
296: ' ,jtf_tty_named_accts na ' ||
297: ' ,fnd_lookups lkp ' ||
298: ' ,hz_parties hzp ' ||

Line 365: ' jtf_tty_terr_grp_accts ga, ' ||

361: ' from hz_parties hzp, ' ||
362: ' hz_party_sites hzps, ' ||
363: ' hz_locations hzl, ' ||
364: ' jtf_tty_named_accts na, ' ||
365: ' jtf_tty_terr_grp_accts ga, ' ||
366: ' fnd_lookups lkp, ' ||
367: ' jtf_tty_terr_groups ttygrp ' ||
368: ' , ( /* Global Ultimate */ ' ||
369: ' SELECT min(gup.party_name) GU_NAME ' ||

Line 511: ' jtf_tty_terr_grp_accts ga, ' ||

507: ' from hz_parties hzp, ' ||
508: ' hz_locations hzl, ' ||
509: ' hz_party_sites hzps, ' ||
510: ' jtf_tty_named_accts na, ' ||
511: ' jtf_tty_terr_grp_accts ga, ' ||
512: ' fnd_lookups lkp, ' ||
513: ' jtf_tty_terr_groups ttygrp ' ||
514: ' , ( /* Global Ultimate */ ' ||
515: ' SELECT min(gup.party_name) GU_NAME ' ||

Line 989: || ' jtf_tty_terr_grp_accts ga '

985: || ' WHERE jtw.user_id = ' ||p_userid
986: || ' ) sub, '
987: || ' jtf_rs_roles_vl rol, '
988: || ' jtf_tty_named_acct_rsc narsc, '
989: || ' jtf_tty_terr_grp_accts ga '
990: || ' WHERE rol.role_code = narsc.rsc_role_code '
991: || ' AND narsc.terr_group_account_id = ga.terr_group_account_id '
992: || ' AND ga.named_account_id = sub.jtf_tty_webadi_int_id '
993: || ' GROUP BY ga.named_account_id, rol.role_code '