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.IEU_TASKS_USERHOOKS dependencies on JTF_RS_GROUP_MEMBERS

Line 830: from jtf_rs_group_members

826: where c.task_id = jtf_tasks_pub.p_task_user_hooks.task_id
827: and c.assignee_role = 'ASSIGNEE'
828: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
829: and c.resource_id in ( select resource_id
830: from jtf_rs_group_members
831: where group_id = jtf_tasks_pub.p_task_user_hooks.owner_id
832: and nvl(delete_flag,'N') <> 'Y')
833: and c.last_update_date = (select max(a.last_update_date)
834: from jtf_task_assignments a,jtf_task_statuses_vl b

Line 840: from jtf_rs_group_members

836: and a.assignee_role = 'ASSIGNEE'
837: and a.assignment_status_id = b.task_status_id
838: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
839: and a.resource_id in ( select resource_id
840: from jtf_rs_group_members
841: where group_id = jtf_tasks_pub.p_task_user_hooks.owner_id
842: and nvl(delete_flag,'N') <> 'Y')
843: and (nvl(b.closed_flag, 'N') = 'N'
844: and nvl(b.completed_flag, 'N') = 'N'

Line 1815: from jtf_rs_group_members

1811:
1812: if l_assignee_type not in ('RS_TEAM', 'RS_GROUP') then
1813: begin
1814: select 'Y' into l_group_id
1815: from jtf_rs_group_members
1816: where resource_id = l_assignee_id
1817: and group_id = l_owner_id
1818: and nvl(delete_flag,'N') <> 'Y'
1819: and rownum < 2;

Line 1869: from jtf_rs_group_members

1865: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
1866: and c.assignee_role = 'ASSIGNEE'
1867: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
1868: and c.resource_id in ( select resource_id
1869: from jtf_rs_group_members
1870: where group_id = l_owner_id
1871: and nvl(delete_flag,'N') <> 'Y')
1872: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
1873: and c.last_update_date = (select max(a.last_update_date)

Line 1881: from jtf_rs_group_members

1877: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
1878: and a.assignment_status_id = b.task_status_id
1879: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
1880: and a.resource_id in ( select resource_id
1881: from jtf_rs_group_members
1882: where group_id = l_owner_id
1883: and nvl(delete_flag,'N') <> 'Y')
1884: and (nvl(b.closed_flag, 'N') = 'N'
1885: and nvl(b.completed_flag, 'N') = 'N'

Line 2585: from jtf_rs_group_members

2581:
2582: if l_assignee_type not in ('RS_TEAM', 'RS_GROUP') then
2583: begin
2584: select 'Y' into l_group_id
2585: from jtf_rs_group_members
2586: where resource_id = l_assignee_id
2587: and group_id = l_owner_id
2588: and nvl(delete_flag,'N') <> 'Y'
2589: and rownum < 2;

Line 2605: from jtf_rs_group_members

2601: where c.task_id = jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id
2602: and c.assignee_role = 'ASSIGNEE'
2603: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
2604: and c.resource_id in ( select resource_id
2605: from jtf_rs_group_members
2606: where group_id = l_owner_id
2607: and nvl(delete_flag,'N') <> 'Y')
2608: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
2609: and c.last_update_date = (select max(a.last_update_date)

Line 2617: from jtf_rs_group_members

2613: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
2614: and a.assignment_status_id = b.task_status_id
2615: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
2616: and a.resource_id in ( select resource_id
2617: from jtf_rs_group_members
2618: where group_id = l_owner_id
2619: and nvl(delete_flag,'N') <> 'Y')
2620: and (nvl(b.closed_flag, 'N') = 'N'
2621: and nvl(b.completed_flag, 'N') = 'N'

Line 3266: from jtf_rs_group_members

3262: where c.task_id = l_task_id
3263: and c.assignee_role = 'ASSIGNEE'
3264: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
3265: and c.resource_id in ( select resource_id
3266: from jtf_rs_group_members
3267: where group_id = l_owner_id
3268: and nvl(delete_flag,'N') <> 'Y')
3269: --and c.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
3270: and c.last_update_date = (select max(a.last_update_date)

Line 3278: from jtf_rs_group_members

3274: and a.task_assignment_id <> jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id
3275: and a.assignment_status_id = b.task_status_id
3276: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
3277: and a.resource_id in ( select resource_id
3278: from jtf_rs_group_members
3279: where group_id = l_owner_id
3280: and nvl(delete_flag,'N') <> 'Y')
3281: and (nvl(b.closed_flag, 'N') = 'N'
3282: and nvl(b.completed_flag, 'N') = 'N'

Line 3413: from jtf_rs_group_members

3409: where c.task_id = l_task_id
3410: and c.assignee_role = 'ASSIGNEE'
3411: and c.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
3412: and c.resource_id in ( select resource_id
3413: from jtf_rs_group_members
3414: where group_id = l_owner_id
3415: and nvl(delete_flag,'N') <> 'Y')
3416: and c.last_update_date = (select max(a.last_update_date)
3417: from jtf_task_assignments a,jtf_task_statuses_vl b

Line 3423: from jtf_rs_group_members

3419: and a.assignee_role = 'ASSIGNEE'
3420: and a.assignment_status_id = b.task_status_id
3421: and a.resource_type_code not in ('RS_TEAM', 'RS_GROUP')
3422: and a.resource_id in ( select resource_id
3423: from jtf_rs_group_members
3424: where group_id = l_owner_id
3425: and nvl(delete_flag,'N') <> 'Y')
3426: and (nvl(b.closed_flag, 'N') = 'N'
3427: and nvl(b.completed_flag, 'N') = 'N'