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_NA_TERRGP dependencies on JTF_RS_GROUP_MEMBERS

Line 701: jtf_rs_group_members grpmem ,

697: SELECT 'Y' INTO result
698: FROM jtf_tty_named_acct_rsc narsc,
699: jtf_tty_terr_grp_accts tga,
700: jtf_rs_role_relations rlt ,
701: jtf_rs_group_members grpmem ,
702: jtf_rs_groups_denorm grpdn
703: WHERE narsc.terr_group_account_id = tga.terr_group_account_id
704: AND tga.terr_group_id = DelCandidateGrp(idx)
705: AND narsc.resource_id = grpmem.resource_id

Line 865: jtf_rs_group_members grpmem ,

861: WHERE narsc.terr_group_account_id
862: IN ( SELECT terr_group_account_id
863: FROM jtf_tty_terr_grp_accts,
864: jtf_rs_role_relations rlt ,
865: jtf_rs_group_members grpmem ,
866: jtf_rs_groups_denorm grpdn
867: WHERE terr_group_id = p_terr_gp_id
868: AND grpmem.resource_id = narsc.resource_id
869: AND grpmem.group_id = narsc.rsc_group_id

Line 1197: from jtf_rs_group_members

1193: FROM JTF_TTY_TERR_GRP_ACCTS
1194: WHERE TERR_GROUP_ID = p_terr_gp_id)
1195: AND j.RESOURCE_ID IN (
1196: select resource_id
1197: from jtf_rs_group_members
1198: where group_id = managed_group_id);
1199: */
1200: /*
1201: DELETE from jtf_tty_acct_rsc_dn j

Line 1208: from jtf_rs_group_members

1204: FROM JTF_TTY_TERR_GRP_ACCTS
1205: WHERE TERR_GROUP_ID = p_terr_gp_id)
1206: AND j.RESOURCE_ID IN (
1207: select resource_id
1208: from jtf_rs_group_members
1209: where group_id = managed_group_id);
1210: */
1211: /* delete from the named acct sum */
1212: /*

Line 1216: from jtf_rs_group_members

1212: /*
1213: DELETE from jtf_tty_rsc_acct_summ j
1214: WHERE j.RESOURCE_ID IN (
1215: select resource_id
1216: from jtf_rs_group_members
1217: where group_id = managed_group_id);
1218: */
1219: /* re-summarize */
1220: /*

Line 1256: from jtf_rs_group_members

1252: where na.named_account_id = tga.named_account_id
1253: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
1254: and narsc.RESOURCE_ID IN (
1255: select resource_id
1256: from jtf_rs_group_members
1257: where group_id = managed_group_id)
1258: group by narsc.RESOURCE_ID, narsc.RSC_GROUP_ID, na.site_type_code)ilv);
1259: */
1260: /* commented out by shli

Line 1270: from jtf_rs_group_members

1266: FROM JTF_TTY_TERR_GRP_ACCTS
1267: WHERE TERR_GROUP_ID = p_terr_gp_id)
1268: AND j.RESOURCE_ID IN (
1269: select resource_id
1270: from jtf_rs_group_members
1271: where group_id = child_group_id);
1272: */
1273: /*
1274: DELETE from jtf_tty_acct_rsc_dn j

Line 1281: from jtf_rs_group_members

1277: FROM JTF_TTY_TERR_GRP_ACCTS
1278: WHERE TERR_GROUP_ID = p_terr_gp_id)
1279: AND j.RESOURCE_ID IN (
1280: select resource_id
1281: from jtf_rs_group_members
1282: where group_id = child_group_id);
1283: */
1284: /* delete from the named acct sum */
1285: /*

Line 1289: from jtf_rs_group_members

1285: /*
1286: DELETE from jtf_tty_rsc_acct_summ j
1287: WHERE j.RESOURCE_ID IN (
1288: select resource_id
1289: from jtf_rs_group_members
1290: where group_id = child_group_id);
1291: */
1292: /* re-summarize */
1293: /*

Line 1329: from jtf_rs_group_members

1325: where na.named_account_id = tga.named_account_id
1326: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
1327: and narsc.RESOURCE_ID IN (
1328: select resource_id
1329: from jtf_rs_group_members
1330: where group_id = child_group_id)
1331: group by narsc.RESOURCE_ID, narsc.RSC_GROUP_ID, na.site_type_code)ilv);
1332: */
1333:

Line 1676: jtf_rs_group_members mem,

1672: IS SELECT mdv.resource_id,
1673: mdv.group_id,
1674: mdv.dir_user_id
1675: FROM jtf_tty_my_resources_v mdv,
1676: jtf_rs_group_members mem,
1677: jtf_rs_roles_b rol,
1678: jtf_rs_role_relations rlt
1679: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
1680: AND NVL(rlt.delete_flag, 'N') <> 'Y'

Line 1697: jtf_rs_group_members mem,

1693: IS SELECT DISTINCT sdv.resource_id,
1694: sdv.group_id,
1695: sdv.dir_user_id
1696: FROM jtf_tty_my_resources_v sdv,
1697: jtf_rs_group_members mem,
1698: jtf_rs_roles_b rol,
1699: jtf_rs_role_relations rlt
1700: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
1701: AND NVL(rlt.delete_flag, 'N') <> 'Y'

Line 1714: jtf_rs_group_members mem1,

1710: AND sdv.parent_group_id = p_owner_group_id
1711: AND sdv.current_user_id = p_owner_user_id;
1712: /*
1713: and not exists (select mem1.resource_id from
1714: jtf_rs_group_members mem1,
1715: jtf_rs_roles_b rol1,
1716: jtf_rs_role_relations rlt1
1717: where rlt1.role_resource_type = 'RS_GROUP_MEMBER'
1718: and nvl(rlt1.delete_flag, 'N') <> 'Y'

Line 1736: jtf_rs_group_members mem,

1732: jtf_tty_terr_grp_accts ga,
1733: jtf_tty_my_resources_v repdn,
1734: jtf_tty_named_acct_rsc narsc,
1735: jtf_rs_resource_extns rs,
1736: jtf_rs_group_members mem,
1737: jtf_tty_terr_groups ttygrp
1738: WHERE na.named_account_id = ga.named_account_id
1739: AND ga.terr_group_account_id = narsc.terr_group_account_id
1740: AND narsc.resource_id = repdn.resource_id

Line 1760: jtf_rs_group_members mem,

1756: jtf_tty_terr_grp_accts ga,
1757: jtf_tty_my_resources_v repdn,
1758: jtf_tty_named_acct_rsc narsc,
1759: jtf_rs_resource_extns rs,
1760: jtf_rs_group_members mem,
1761: jtf_tty_terr_groups ttygrp
1762: WHERE na.named_account_id = ga.named_account_id
1763: AND ga.terr_group_account_id = narsc.terr_group_account_id
1764: AND narsc.resource_id = repdn.resource_id

Line 2405: FROM jtf_rs_group_members mem,

2401: child_group_id NUMBER;
2402: CURSOR groups_managed_c
2403: IS
2404: SELECT mem.group_id
2405: FROM jtf_rs_group_members mem,
2406: jtf_rs_roles_b rol,
2407: jtf_rs_role_relations rlt
2408: WHERE rlt.role_resource_type = 'RS_GROUP_MEMBER'
2409: AND NVL(rlt.delete_flag, 'N') <> 'Y'

Line 2426: FROM jtf_rs_group_members

2422:
2423: CURSOR directs_c
2424: IS
2425: SELECT resource_id
2426: FROM jtf_rs_group_members
2427: WHERE group_id = x_group_id;
2428:
2429: BEGIN
2430: p_user_id := Fnd_Global.user_id;

Line 2471: FROM jtf_rs_group_members

2467: FROM JTF_TTY_TERR_GRP_ACCTS
2468: WHERE TERR_GROUP_ID = p_terr_gp_id)
2469: AND j.RESOURCE_ID IN (
2470: SELECT resource_id
2471: FROM jtf_rs_group_members
2472: WHERE group_id = managed_group_id);
2473: /*
2474: DELETE from jtf_tty_acct_rsc_dn j
2475: WHERE j.TERR_GROUP_ACCOUNT_ID in

Line 2481: from jtf_rs_group_members

2477: FROM JTF_TTY_TERR_GRP_ACCTS
2478: WHERE TERR_GROUP_ID = p_terr_gp_id)
2479: AND j.RESOURCE_ID IN (
2480: select resource_id
2481: from jtf_rs_group_members
2482: where group_id = managed_group_id);
2483: */
2484: /* delete from the named acct sum */
2485: /*

Line 2489: from jtf_rs_group_members

2485: /*
2486: DELETE from jtf_tty_rsc_acct_summ j
2487: WHERE j.RESOURCE_ID IN (
2488: select resource_id
2489: from jtf_rs_group_members
2490: where group_id = managed_group_id);
2491: */
2492: /* re-summarize */
2493: /*

Line 2529: from jtf_rs_group_members

2525: where na.named_account_id = tga.named_account_id
2526: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
2527: and narsc.RESOURCE_ID IN (
2528: select resource_id
2529: from jtf_rs_group_members
2530: where group_id = managed_group_id)
2531: group by narsc.RESOURCE_ID, narsc.RSC_GROUP_ID, na.site_type_code)ilv);
2532: */
2533: FOR child_gp_data IN child_groups_c LOOP

Line 2542: FROM jtf_rs_group_members

2538: FROM JTF_TTY_TERR_GRP_ACCTS
2539: WHERE TERR_GROUP_ID = p_terr_gp_id)
2540: AND j.RESOURCE_ID IN (
2541: SELECT resource_id
2542: FROM jtf_rs_group_members
2543: WHERE group_id = child_group_id);
2544: /*
2545: DELETE from jtf_tty_acct_rsc_dn j
2546: WHERE j.TERR_GROUP_ACCOUNT_ID in

Line 2552: from jtf_rs_group_members

2548: FROM JTF_TTY_TERR_GRP_ACCTS
2549: WHERE TERR_GROUP_ID = p_terr_gp_id)
2550: AND j.RESOURCE_ID IN (
2551: select resource_id
2552: from jtf_rs_group_members
2553: where group_id = child_group_id);
2554: */
2555: /* delete from the named acct sum */
2556: /*

Line 2560: from jtf_rs_group_members

2556: /*
2557: DELETE from jtf_tty_rsc_acct_summ j
2558: WHERE j.RESOURCE_ID IN (
2559: select resource_id
2560: from jtf_rs_group_members
2561: where group_id = child_group_id);
2562: */
2563: /* re-summarize */
2564: /*

Line 2600: from jtf_rs_group_members

2596: where na.named_account_id = tga.named_account_id
2597: and narsc.TERR_GROUP_ACCOUNT_ID = tga.TERR_GROUP_ACCOUNT_ID
2598: and narsc.RESOURCE_ID IN (
2599: select resource_id
2600: from jtf_rs_group_members
2601: where group_id = child_group_id)
2602: group by narsc.RESOURCE_ID, narsc.RSC_GROUP_ID, na.site_type_code)ilv);
2603: */
2604: END LOOP;