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_RESOURCE_EXTNS_VL

Line 743: FROM jtf_rs_resource_extns_vl;

739:
740: CURSOR c_res_details IS
741: SELECT resource_id, category, start_date_active, end_date_active
742: ,source_id, source_email, resource_name
743: FROM jtf_rs_resource_extns_vl;
744:
745: CURSOR c_wf_ur_details (l_user_orig_system_id NUMBER, l_user_orig_system VARCHAR2, l_user_name VARCHAR2) IS
746: SELECT role_orig_system_id, role_orig_system, role_name
747: ,start_date, expiration_date

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

1091: mem.resource_id, mem.group_id
1092: ,greatest (ext.start_date_active, grp.start_date_active) m_start_date_active
1093: ,least (NVL (grp.end_date_active, l_fnd_date) ,
1094: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1095: FROM jtf_rs_resource_extns_vl ext, jtf_rs_group_members mem, jtf_rs_groups_b grp
1096: WHERE mem.resource_id = ext.resource_id
1097: AND mem.group_id = grp.group_id
1098: AND ext.category IN ('OTHER','TBH')
1099: AND ext.resource_name IS NOT NULL

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

1119: mem.resource_id, mem.group_id, ext.category, ext.resource_name
1120: ,greatest (ext.start_date_active, grp.start_date_active) m_start_date_active
1121: ,least (NVL (grp.end_date_active, l_fnd_date) ,
1122: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1123: FROM jtf_rs_resource_extns_vl ext, jtf_rs_group_members mem, jtf_rs_groups_b grp
1124: WHERE mem.resource_id = ext.resource_id
1125: AND mem.group_id = grp.group_id
1126: AND ext.category IN ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
1127: AND NVL (mem.delete_flag,'N') <> 'Y'

Line 1329: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team

1325: SELECT mem.team_resource_id resource_id, mem.team_id
1326: ,greatest (team.start_date_active, ext.start_date_active) m_start_date_active
1327: ,least (NVL (team.end_date_active, l_fnd_date) ,
1328: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1329: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team
1330: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1331: AND mem.team_resource_id = ext.resource_id
1332: AND mem.resource_type = 'INDIVIDUAL'
1333: AND mem.team_id = team.team_id

Line 1357: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team

1353: SELECT mem.team_resource_id resource_id, mem.team_id, ext.category, ext.resource_name
1354: ,greatest (team.start_date_active, ext.start_date_active) m_start_date_active
1355: ,least (NVL (team.end_date_active, l_fnd_date) ,
1356: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1357: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team
1358: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1359: AND mem.team_resource_id = ext.resource_id
1360: AND mem.resource_type = 'INDIVIDUAL'
1361: AND mem.team_id = team.team_id