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 799: FROM jtf_rs_resource_extns_vl;

795:
796: CURSOR c_res_details IS
797: SELECT resource_id, category, start_date_active, end_date_active
798: ,source_id, source_email, resource_name
799: FROM jtf_rs_resource_extns_vl;
800:
801: CURSOR c_wf_ur_details (l_user_orig_system_id NUMBER, l_user_orig_system VARCHAR2, l_user_name VARCHAR2) IS
802: SELECT role_orig_system_id, role_orig_system, role_name
803: ,start_date, expiration_date

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 1427: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team

1423: SELECT mem.team_resource_id resource_id, mem.team_id
1424: ,greatest (team.start_date_active, ext.start_date_active) m_start_date_active
1425: ,least (NVL (team.end_date_active, l_fnd_date) ,
1426: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1427: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team
1428: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1429: AND mem.team_resource_id = ext.resource_id
1430: AND mem.resource_type = 'INDIVIDUAL'
1431: AND mem.team_id = team.team_id

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

1451: SELECT mem.team_resource_id resource_id, mem.team_id, ext.category, ext.resource_name
1452: ,greatest (team.start_date_active, ext.start_date_active) m_start_date_active
1453: ,least (NVL (team.end_date_active, l_fnd_date) ,
1454: NVL (ext.end_date_active, l_fnd_date)) m_end_date_active
1455: FROM jtf_rs_resource_extns_vl ext, jtf_rs_team_members mem, jtf_rs_teams_b team
1456: WHERE NVL (mem.delete_flag,'N') <> 'Y'
1457: AND mem.team_resource_id = ext.resource_id
1458: AND mem.resource_type = 'INDIVIDUAL'
1459: AND mem.team_id = team.team_id