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_GROUP_REPORT_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 286: select /+ INDEX(gm jtf_rs_group_members_aud_nu3) / g1.group_name,

282: r_grp_usagename c_grp_usagename%rowtype;
283:
284: cursor c_grp_sec(l_group number)
285: is
286: select /*+ INDEX(gm jtf_rs_group_members_aud_nu3) */ g1.group_name,
287: --: Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
288: g1.attribute_category, g1.attribute1, g1.attribute2, g1.attribute3, g1.attribute4, g1.attribute5, g1.attribute6, g1.attribute7, g1.attribute8,
289: g1.attribute9, g1.attribute10, g1.attribute11, g1.attribute12, g1.attribute13, g1.attribute14, g1.attribute15,
290: --: Introduced for incorporating reporting of DFF fields Ref: ER# 2549463

Line 310: jtf_rs_group_members_aud gm,

306: jtf_rs_groups_vl g3,
307: jtf_rs_resource_extns_vl ext,
308: jtf_objects_vl lkp ,
309: fnd_user fnd,
310: jtf_rs_group_members_aud gm,
311: jtf_rs_group_members mem,
312: jtf_rs_groups_vl g1
313: where g1.group_id = l_group
314: and mem.group_id = g1.group_id

Line 311: jtf_rs_group_members mem,

307: jtf_rs_resource_extns_vl ext,
308: jtf_objects_vl lkp ,
309: fnd_user fnd,
310: jtf_rs_group_members_aud gm,
311: jtf_rs_group_members mem,
312: jtf_rs_groups_vl g1
313: where g1.group_id = l_group
314: and mem.group_id = g1.group_id
315: and gm.group_member_id = mem.group_member_id

Line 335: select /+ INDEX(gm jtf_rs_group_members_aud_nu3) / g1.group_name,

331:
332:
333: cursor c_res
334: is
335: select /*+ INDEX(gm jtf_rs_group_members_aud_nu3) */ g1.group_name,
336: --: Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
337: g1.attribute_category, g1.attribute1, g1.attribute2, g1.attribute3, g1.attribute4, g1.attribute5, g1.attribute6, g1.attribute7, g1.attribute8,
338: g1.attribute9, g1.attribute10, g1.attribute11, g1.attribute12, g1.attribute13, g1.attribute14, g1.attribute15,
339: --: Introduced for incorporating reporting of DFF fields Ref: ER# 2549463

Line 357: jtf_rs_group_members_aud gm,

353: jtf_rs_groups_vl g3,
354: fnd_user fnd,
355: jtf_objects_vl lkp,
356: jtf_rs_groups_vl g1,
357: jtf_rs_group_members_aud gm,
358: jtf_rs_group_members mem,
359: jtf_rs_resource_extns_vl ext
360: where ext.resource_id = l_res_id
361: and mem.resource_id = ext.resource_id

Line 358: jtf_rs_group_members mem,

354: fnd_user fnd,
355: jtf_objects_vl lkp,
356: jtf_rs_groups_vl g1,
357: jtf_rs_group_members_aud gm,
358: jtf_rs_group_members mem,
359: jtf_rs_resource_extns_vl ext
360: where ext.resource_id = l_res_id
361: and mem.resource_id = ext.resource_id
362: and gm.group_member_id = mem.group_member_id

Line 385: from jtf_rs_group_members_aud gm,

381: select gm.group_member_id,
382: g1.group_id,
383: g1.group_name,
384: g1.group_number
385: from jtf_rs_group_members_aud gm,
386: jtf_rs_groups_vl g1
387: where gm.old_group_id = l_group_id
388: and gm.new_resource_id = l_resource_id
389: and g1.group_id = gm.new_group_id;

Line 1006: from jtf_rs_group_members mem,

1002: is
1003: select mem.resource_id,
1004: res.resource_name,
1005: obj.name category_name
1006: from jtf_rs_group_members mem,
1007: jtf_rs_resource_extns_vl res,
1008: jtf_objects_vl obj
1009: where mem.group_id = l_group_id
1010: and nvl(mem.delete_flag, 'N') <> 'Y'

Line 1023: from jtf_rs_group_members mem,

1019: rol.role_name,
1020: obj.name category_name,
1021: rol.res_rl_start_date,
1022: rol.res_rl_end_date
1023: from jtf_rs_group_members mem,
1024: jtf_rs_resource_extns_vl res,
1025: jtf_rs_defresroles_vl rol,
1026: jtf_objects_vl obj
1027: where mem.group_id = l_group_id

Line 1223: select /+ INDEX(gm jtf_rs_group_members_aud_nu3) / g1.group_name,

1219: l_usr_name varchar2,
1220: l_start_date date,
1221: l_end_date date)
1222: is
1223: select /*+ INDEX(gm jtf_rs_group_members_aud_nu3) */ g1.group_name,
1224: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
1225: g1.attribute_category, g1.attribute1, g1.attribute2, g1.attribute3, g1.attribute4, g1.attribute5, g1.attribute6, g1.attribute7, g1.attribute8,
1226: g1.attribute9, g1.attribute10, g1.attribute11, g1.attribute12, g1.attribute13, g1.attribute14, g1.attribute15,
1227: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463

Line 1247: jtf_rs_group_members_aud gm,

1243: jtf_rs_groups_vl g3,
1244: jtf_rs_resource_extns_vl ext,
1245: jtf_objects_vl lkp ,
1246: fnd_user fnd,
1247: jtf_rs_group_members_aud gm,
1248: jtf_rs_group_members mem,
1249: jtf_rs_groups_vl g1
1250: where g1.group_id = l_group_id
1251: and mem.group_id = g1.group_id

Line 1248: jtf_rs_group_members mem,

1244: jtf_rs_resource_extns_vl ext,
1245: jtf_objects_vl lkp ,
1246: fnd_user fnd,
1247: jtf_rs_group_members_aud gm,
1248: jtf_rs_group_members mem,
1249: jtf_rs_groups_vl g1
1250: where g1.group_id = l_group_id
1251: and mem.group_id = g1.group_id
1252: and gm.group_member_id = mem.group_member_id

Line 1279: from jtf_rs_group_members_aud gm,

1275: select gm.group_member_id,
1276: g1.group_id,
1277: g1.group_name,
1278: g1.group_number
1279: from jtf_rs_group_members_aud gm,
1280: jtf_rs_groups_vl g1
1281: where gm.old_group_id = l_group_id
1282: and gm.new_resource_id = l_resource_id
1283: and g1.group_id = gm.new_group_id;