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_GROUP_MEMBERS

Line 1131: FROM wf_local_user_roles wlur, jtf_rs_group_members mem

1127: --Bug10044172 - Added Resource_id in cursor
1128:
1129: CURSOR c_wlur_grp_mem_del IS
1130: SELECT wlur.user_orig_system, wlur.user_orig_system_id, mem.group_id,mem.resource_id
1131: FROM wf_local_user_roles wlur, jtf_rs_group_members mem
1132: WHERE NVL (mem.delete_flag,'N') = 'Y'
1133: AND wlur.role_orig_system = l_grp_orig_system
1134: AND wlur.role_orig_system_id = mem.group_id
1135: AND wlur.role_name = l_grp_orig_system ||':'|| mem.group_id

Line 1140: -- (jtf_rs_group_members) that are still not defined in workflow

1136: AND wlur.user_orig_system <> l_grp_orig_system
1137: AND NVL(wlur.expiration_date, l_sysdate) >= l_sysdate;
1138:
1139: -- Cursor to select all active records from resource group members table
1140: -- (jtf_rs_group_members) that are still not defined in workflow
1141: -- user role table (wf_local_user_roles). This is for category OTHER and TBH.
1142: -- These records have to be created in workflow user roles table.
1143:
1144: CURSOR c_grp_mem_wf_crt IS

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 1167: -- (jtf_rs_group_members) that are still not defined in workflow

1163: AND wlur.user_orig_system = l_ind_orig_system
1164: AND wlur.role_orig_system = l_grp_orig_system);
1165:
1166: -- Select all active records from resource group members table
1167: -- (jtf_rs_group_members) that are still not defined in workflow
1168: -- user role table (wf_local_user_roles). This is for category
1169: -- EMPLOYEE, PARTY, PARTNER and SUPPLIER_CONTACT
1170: -- These records have to be created in workflow user roles table.
1171:

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'