APPS.JTF_TTY_EXCEL_NAORG_PVT dependencies on JTF_TTY_NAMED_ACCT_RSC

Line 580: jtf_tty_named_acct_rsc narsc,

576: FROM (
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

Line 617: , jtf_tty_named_acct_rsc narsc

613: , narsc.END_DATE
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

Line 1128: ' from jtf_tty_named_acct_rsc narsc1, ' ||

1124: (trim(P_SALES_ROLE) IS NULL)) THEN
1125: l_na_query := l_na_query || ' and ga.terr_group_account_id in ( ';
1126: l_na_query := l_na_query ||
1127: ' select /*+ NO_MERGE */ narsc1.terr_group_account_id ' ||
1128: ' from jtf_tty_named_acct_rsc narsc1, ' ||
1129: ' ( SELECT dir.resource_id, ' ||
1130: ' MY_GRPS.group_id , ' ||
1131: ' MY_GRPS.CURRENT_USER_ID ' ||
1132: ' FROM jtf_rs_group_members grpmemo , ' ||

Line 1177: ' from jtf_tty_named_acct_rsc narsc1, '||

1173: (trim(P_SALES_ROLE) IS NULL)) THEN
1174: l_na_query := l_na_query || ' and ga.terr_group_account_id in ( ';
1175: l_na_query := l_na_query ||
1176: ' select narsc1.terr_group_account_id '||
1177: ' from jtf_tty_named_acct_rsc narsc1, '||
1178: ' jtf_rs_group_members mem1, '||
1179: ' jtf_rs_groups_denorm grpdn1 '||
1180: ' where narsc1.resource_id = mem1.resource_id '||
1181: ' and narsc1.rsc_group_id = mem1.group_id '||

Line 1195: ' from jtf_tty_named_acct_rsc narsc1, '||

1191: (trim(P_SALES_GROUP) IS NULL)) THEN
1192: l_na_query := l_na_query || ' and EXISTS ( ';
1193: l_na_query := l_na_query ||
1194: ' select narsc1.terr_group_account_id '||
1195: ' from jtf_tty_named_acct_rsc narsc1, '||
1196: --' jtf_rs_rep_managers mgr, '||
1197: ' jtf_rs_rep_managers mgr1, '||
1198: ' jtf_rs_role_relations rlt, '||
1199: ' jtf_rs_roles_b rol '||

Line 1218: ' from jtf_tty_named_acct_rsc narsc1, '||

1214: (trim(P_SALES_ROLE) IS NULL)) THEN
1215: l_na_query := l_na_query || ' and ga.terr_group_account_id in ( ';
1216: l_na_query := l_na_query ||
1217: ' select narsc1.terr_group_account_id '||
1218: ' from jtf_tty_named_acct_rsc narsc1, '||
1219: ' jtf_tty_my_resources_v repdn1 '||
1220: ' where narsc1.resource_id = repdn1.resource_id '||
1221: ' and narsc1.rsc_group_id = repdn1.group_id '||
1222: ' and repdn1.current_user_id = :P_SALESPERSON '||

Line 1232: ' from jtf_tty_named_acct_rsc narsc1, '||

1228: (trim(P_SALES_ROLE) IS NOT NULL)) THEN
1229: l_na_query := l_na_query || ' and ga.terr_group_account_id in ( ';
1230: l_na_query := l_na_query ||
1231: ' select narsc1.terr_group_account_id '||
1232: ' from jtf_tty_named_acct_rsc narsc1, '||
1233: ' jtf_tty_my_resources_v repdn1 '||
1234: ' where narsc1.resource_id = repdn1.resource_id '||
1235: ' and narsc1.rsc_group_id = repdn1.group_id '||
1236: ' and repdn1.current_user_id = :P_SALESPERSON '||

Line 1246: ' from jtf_tty_named_acct_rsc narsc1, '||

1242: (trim(P_SALES_ROLE) IS NOT NULL)) THEN
1243: l_na_query := l_na_query || ' and EXISTS ( ';
1244: l_na_query := l_na_query ||
1245: ' select narsc1.terr_group_account_id '||
1246: ' from jtf_tty_named_acct_rsc narsc1, '||
1247: -- ' jtf_rs_rep_managers mgr, '||
1248: ' jtf_rs_rep_managers mgr1, '||
1249: ' jtf_rs_role_relations rlt, '||
1250: ' jtf_rs_roles_b rol, '||

Line 1272: ' from jtf_tty_named_acct_rsc narsc1, '||

1268: (trim(P_SALES_ROLE) IS NOT NULL)) THEN
1269: l_na_query := l_na_query || ' and ga.terr_group_account_id in ( ';
1270: l_na_query := l_na_query ||
1271: ' select narsc1.terr_group_account_id '||
1272: ' from jtf_tty_named_acct_rsc narsc1, '||
1273: ' jtf_tty_my_resources_v repdn1 '||
1274: ' where narsc1.resource_id = repdn1.resource_id '||
1275: ' and narsc1.rsc_group_id = repdn1.group_id '||
1276: ' and repdn1.current_user_id = :P_SALESPERSON ' ||