APPS.JTF_TTY_EXCEL_NAORG_PVT dependencies on JTF_TTY_TERR_GRP_ACCTS

Line 581: jtf_tty_terr_grp_accts ga

577: SELECT rol.role_code role_code, COUNT(rol.role_code) num
578: FROM
579: jtf_rs_roles_vl rol,
580: jtf_tty_named_acct_rsc narsc,
581: jtf_tty_terr_grp_accts ga
582: WHERE rol.role_code = narsc.rsc_role_code
583: AND narsc.terr_group_account_id = ga.terr_group_account_id
584: AND ga.terr_group_account_id IN
585: ( SELECT terr_grp_acct_id

Line 618: , jtf_tty_terr_grp_accts ga

614: FROM jtf_rs_resource_extns_vl rsc
615: , jtf_rs_groups_vl grp
616: , jtf_rs_roles_vl rol
617: , jtf_tty_named_acct_rsc narsc
618: , jtf_tty_terr_grp_accts ga
619: -- , jtf_tty_terr_groups tga
620: WHERE rsc.resource_id = narsc.resource_id
621: AND grp.group_id = narsc.rsc_group_id
622: AND rol.role_code = narsc.rsc_role_code

Line 818: ' ,jtf_tty_terr_grp_accts ga ' ||

814: ' hz_parties hzp ' ||
815: ' ,hz_locations hzl '||
816: ' ,hz_party_sites hzps '||
817: ' ,jtf_tty_named_accts na ' ||
818: ' ,jtf_tty_terr_grp_accts ga ' ||
819: ' ,fnd_lookups lkp ' ||
820: ' ,jtf_tty_terr_groups ttygrp ' ;
821:
822: /*vbghosh Added start */