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 FND_USER

Line 296: fnd.user_name created_by,

292: ext.resource_name,
293: ext.category,
294: lkp.name category_name,
295: to_char(gm.creation_date, 'DD-MON-YYYY:HH24:MI:SS') creation_date,
296: fnd.user_name created_by,
297: decode(gm.old_group_id, g1.group_id, 'OUT', 'IN') moved,
298: decode(gm.old_group_id, null, null, g1.group_id,null, g3.group_number ) from_group_number,
299: decode(gm.old_group_id, null, null, g1.group_id,null, g3.group_name ) from_group_name,
300: decode(gm.old_group_id, g1.group_id, g2.group_number, null) to_group_number,

Line 309: fnd_user fnd,

305: jtf_rs_groups_vl g2,
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

Line 322: and fnd.user_name like nvl(l_usr_name, '%')

318: and gm.creation_date between nvl(l_start_date,sysdate)
319: and nvl(l_end_date,sysdate)
320: and gm.new_group_id = g2.group_id(+)
321: and gm.old_group_id = g3.group_id(+)
322: and fnd.user_name like nvl(l_usr_name, '%')
323: and fnd.user_id = gm.created_by
324: and mem.resource_id = ext.resource_id
325: and ext.category = lkp.object_code
326: order by g1.group_name , resource_name, gm.creation_date , fnd.user_name;

Line 323: and fnd.user_id = gm.created_by

319: and nvl(l_end_date,sysdate)
320: and gm.new_group_id = g2.group_id(+)
321: and gm.old_group_id = g3.group_id(+)
322: and fnd.user_name like nvl(l_usr_name, '%')
323: and fnd.user_id = gm.created_by
324: and mem.resource_id = ext.resource_id
325: and ext.category = lkp.object_code
326: order by g1.group_name , resource_name, gm.creation_date , fnd.user_name;
327:

Line 326: order by g1.group_name , resource_name, gm.creation_date , fnd.user_name;

322: and fnd.user_name like nvl(l_usr_name, '%')
323: and fnd.user_id = gm.created_by
324: and mem.resource_id = ext.resource_id
325: and ext.category = lkp.object_code
326: order by g1.group_name , resource_name, gm.creation_date , fnd.user_name;
327:
328:
329: r_grp c_grp_sec%rowtype;
330: l_prev_group JTF_RS_GROUPS_TL.GROUP_NAME%TYPE;

Line 345: fnd.user_name created_by,

341: ext.resource_name,
342: ext.category,
343: lkp.name category_name,
344: to_char(gm.creation_date, 'DD-MON-YYYY:HH24:MI:SS') creation_date,
345: fnd.user_name created_by,
346: decode(gm.old_group_id, g1.group_id, 'OUT', 'IN') moved,
347: decode(gm.old_group_id, null, null, g1.group_id,null, g3.group_number ) from_group_number,
348: decode(gm.old_group_id, null, null, g1.group_id,null, g3.group_name ) from_group_name,
349: decode(gm.old_group_id, g1.group_id, g2.group_number, null) to_group_number,

Line 354: fnd_user fnd,

350: decode(gm.old_group_id, g1.group_id, g2.group_name, null) to_group_name
351: from
352: jtf_rs_groups_vl g2,
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,

Line 365: and gm.created_by = fnd.user_id

361: and mem.resource_id = ext.resource_id
362: and gm.group_member_id = mem.group_member_id
363: and gm.creation_date between nvl(l_start_date,sysdate)
364: and nvl(l_end_date,sysdate)
365: and gm.created_by = fnd.user_id
366: and fnd.user_name like nvl(l_usr_name, '%')
367: and g1.group_id = mem.group_id
368: and g2.group_id(+)= gm.new_group_id
369: and g3.group_id(+) = gm.old_group_id

Line 366: and fnd.user_name like nvl(l_usr_name, '%')

362: and gm.group_member_id = mem.group_member_id
363: and gm.creation_date between nvl(l_start_date,sysdate)
364: and nvl(l_end_date,sysdate)
365: and gm.created_by = fnd.user_id
366: and fnd.user_name like nvl(l_usr_name, '%')
367: and g1.group_id = mem.group_id
368: and g2.group_id(+)= gm.new_group_id
369: and g3.group_id(+) = gm.old_group_id
370: and ext.category = lkp.object_code

Line 371: order by resource_name, g1.group_name , gm.creation_date , fnd.user_name;

367: and g1.group_id = mem.group_id
368: and g2.group_id(+)= gm.new_group_id
369: and g3.group_id(+) = gm.old_group_id
370: and ext.category = lkp.object_code
371: order by resource_name, g1.group_name , gm.creation_date , fnd.user_name;
372:
373: r_res c_res%rowtype;
374:
375: /* Moved the initial assignment of below variable to inside begin */

Line 1233: fnd.user_name created_by,

1229: ext.resource_name,
1230: ext.category,
1231: lkp.name category_name,
1232: to_char(gm.creation_date, 'DD-MON-YYYY:HH24:MI:SS') creation_date,
1233: fnd.user_name created_by,
1234: decode(gm.old_group_id, g1.group_id, 'OUT', 'IN') moved,
1235: decode(gm.old_group_id, null, null, g1.group_id,null, g3.group_number ) from_group_number,
1236: decode(gm.old_group_id, null, null, g1.group_id,null, g3.group_name ) from_group_name,
1237: decode(gm.old_group_id, g1.group_id, g2.group_number, null) to_group_number,

Line 1246: fnd_user fnd,

1242: jtf_rs_groups_vl g2,
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

Line 1259: and fnd.user_name like nvl(l_usr_name, '%')

1255: and gm.creation_date between nvl(l_start_date,sysdate)
1256: and nvl(l_end_date,sysdate)
1257: and gm.new_group_id = g2.group_id(+)
1258: and gm.old_group_id = g3.group_id(+)
1259: and fnd.user_name like nvl(l_usr_name, '%')
1260: and fnd.user_id = gm.created_by
1261: and mem.resource_id = ext.resource_id
1262: and ext.category = lkp.object_code
1263: order by g1.group_name , resource_name, gm.creation_date , fnd.user_name;

Line 1260: and fnd.user_id = gm.created_by

1256: and nvl(l_end_date,sysdate)
1257: and gm.new_group_id = g2.group_id(+)
1258: and gm.old_group_id = g3.group_id(+)
1259: and fnd.user_name like nvl(l_usr_name, '%')
1260: and fnd.user_id = gm.created_by
1261: and mem.resource_id = ext.resource_id
1262: and ext.category = lkp.object_code
1263: order by g1.group_name , resource_name, gm.creation_date , fnd.user_name;
1264:

Line 1263: order by g1.group_name , resource_name, gm.creation_date , fnd.user_name;

1259: and fnd.user_name like nvl(l_usr_name, '%')
1260: and fnd.user_id = gm.created_by
1261: and mem.resource_id = ext.resource_id
1262: and ext.category = lkp.object_code
1263: order by g1.group_name , resource_name, gm.creation_date , fnd.user_name;
1264:
1265: r_grp_child c_grp_child%rowtype;
1266:
1267: l_child_tab rel_table;