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_RS_CONC_WF_PUB dependencies on JTF_RS_GROUPS_B

Line 452: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur

448: -- These workflow local user role records have to be inactivated.
449:
450: CURSOR c_grp_wf_ur_del IS
451: SELECT grp.group_id, grp.start_date_active, grp.end_date_active
452: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur
453: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) < l_sysdate
454: AND ((wlur.role_orig_system_id = grp.group_id
455: AND wlur.role_orig_system = l_grp_orig_system
456: AND wlur.role_name = l_grp_orig_system||':'||to_char(grp.group_id))

Line 512: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur

508: -- These workflow user role records have to be updated with new values.
509:
510: CURSOR c_grp_wf_ur_upd IS
511: SELECT grp.group_id, grp.start_date_active, grp.end_date_active
512: FROM jtf_rs_groups_b grp, wf_local_user_roles wlur
513: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) >= l_sysdate
514: AND ((wlur.role_orig_system_id = grp.group_id
515: AND wlur.role_orig_system = l_grp_orig_system
516: AND wlur.role_name = l_grp_orig_system||':'||to_char(grp.group_id))

Line 1152: FROM jtf_rs_resource_extns_vl ext, jtf_rs_group_members mem, jtf_rs_groups_b grp

1148: mem.resource_id, mem.group_id
1149: ,greatest (ext.start_date_active, grp.start_date_active) m_start_date_active
1150: ,least (NVL (grp.end_date_active, l_fnd_date) ,
1151: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1152: FROM jtf_rs_resource_extns_vl ext, jtf_rs_group_members mem, jtf_rs_groups_b grp
1153: WHERE mem.resource_id = ext.resource_id
1154: AND mem.group_id = grp.group_id
1155: AND ext.category IN ('OTHER','TBH')
1156: AND ext.resource_name IS NOT NULL

Line 1180: FROM jtf_rs_resource_extns_vl ext, jtf_rs_group_members mem, jtf_rs_groups_b grp

1176: mem.resource_id, mem.group_id, ext.category, ext.resource_name
1177: ,greatest (ext.start_date_active, grp.start_date_active) m_start_date_active
1178: ,least (NVL (grp.end_date_active, l_fnd_date) ,
1179: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1180: FROM jtf_rs_resource_extns_vl ext, jtf_rs_group_members mem, jtf_rs_groups_b grp
1181: WHERE mem.resource_id = ext.resource_id
1182: AND mem.group_id = grp.group_id
1183: AND ext.category IN ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
1184: AND NVL (mem.delete_flag,'N') <> 'Y'

Line 1481: FROM jtf_rs_groups_b grp, jtf_rs_team_members mem, jtf_rs_teams_b team

1477: SELECT mem.team_resource_id group_id, mem.team_id
1478: ,greatest (team.start_date_active, grp.start_date_active) m_start_date_active
1479: ,least (NVL (team.end_date_active, l_fnd_date) ,
1480: NVL (grp.end_date_active, l_fnd_date)) m_end_date_active
1481: FROM jtf_rs_groups_b grp, jtf_rs_team_members mem, jtf_rs_teams_b team
1482: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1483: AND mem.team_resource_id = grp.group_id
1484: AND mem.resource_type = 'GROUP'
1485: AND mem.team_id = team.team_id