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_GROUPS_VL

Line 14: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

10:
11: *****************************************************************************/
12:
13: TYPE REL_RECORD_TYPE IS RECORD
14: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
15: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
16: p_start_date_active DATE,
17: p_end_date_active DATE,
18: p_relation_start_date DATE,

Line 15: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

11: *****************************************************************************/
12:
13: TYPE REL_RECORD_TYPE IS RECORD
14: ( p_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
15: p_related_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
16: p_start_date_active DATE,
17: p_end_date_active DATE,
18: p_relation_start_date DATE,
19: p_relation_end_date DATE,

Line 305: jtf_rs_groups_vl g2,

301: decode(gm.old_group_id, g1.group_id, g2.group_name, null) to_group_name,
302: ext.resource_id,
303: g1.group_id
304: from
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,

Line 306: jtf_rs_groups_vl g3,

302: ext.resource_id,
303: g1.group_id
304: from
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,

Line 312: jtf_rs_groups_vl g1

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
316: and ( gm.new_group_id = g1.group_id

Line 352: jtf_rs_groups_vl g2,

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,
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,

Line 353: jtf_rs_groups_vl g3,

349: decode(gm.old_group_id, g1.group_id, g2.group_number, null) to_group_number,
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,

Line 356: jtf_rs_groups_vl g1,

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,
359: jtf_rs_resource_extns_vl ext
360: where ext.resource_id = l_res_id

Line 386: jtf_rs_groups_vl g1

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;
390:

Line 392: l_to_grp_number jtf_rs_groups_vl.group_number%type;

388: and gm.new_resource_id = l_resource_id
389: and g1.group_id = gm.new_group_id;
390:
391: to_grp_rec to_grp_cur%rowtype;
392: l_to_grp_number jtf_rs_groups_vl.group_number%type;
393: l_to_grp_name jtf_rs_groups_vl.group_name%type;
394:
395:
396:

Line 393: l_to_grp_name jtf_rs_groups_vl.group_name%type;

389: and g1.group_id = gm.new_group_id;
390:
391: to_grp_rec to_grp_cur%rowtype;
392: l_to_grp_number jtf_rs_groups_vl.group_number%type;
393: l_to_grp_name jtf_rs_groups_vl.group_name%type;
394:
395:
396:
397:

Line 979: from jtf_rs_groups_vl

975: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
976: attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7, attribute8,
977: attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15
978: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
979: from jtf_rs_groups_vl
980: where group_name = p_group_name;
981: group_id_rec group_id_cur%rowtype;
982:
983: cursor child_dtls_cur(l_group_id number)

Line 992: from jtf_rs_groups_vl

988: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
989: attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
990: attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15
991: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
992: from jtf_rs_groups_vl
993: where group_id = l_group_id;
994:
995: -- Introduced for incorporating reporting of DFF fields Ref: ER# 2549463
996: child_dtls_rec child_dtls_cur%rowtype;

Line 1200: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)

1196: p_end_date in date,
1197: p_usage in varchar2)
1198: is
1199:
1200: CURSOR c_date(x_group_id JTF_RS_GROUPS_VL.GROUP_ID%TYPE)
1201: IS
1202: SELECT grp.start_date_active,
1203: grp.end_date_active
1204: FROM jtf_rs_groups_b grp

Line 1242: jtf_rs_groups_vl g2,

1238: decode(gm.old_group_id, g1.group_id, g2.group_name, null) to_group_name,
1239: ext.resource_id,
1240: g1.group_id
1241: from
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,

Line 1243: jtf_rs_groups_vl g3,

1239: ext.resource_id,
1240: g1.group_id
1241: from
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,

Line 1249: jtf_rs_groups_vl g1

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
1253: and ( gm.new_group_id = g1.group_id

Line 1280: jtf_rs_groups_vl g1

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;
1284:

Line 1286: l_to_grp_number jtf_rs_groups_vl.group_number%type;

1282: and gm.new_resource_id = l_resource_id
1283: and g1.group_id = gm.new_group_id;
1284:
1285: to_grp_rec to_grp_cur%rowtype;
1286: l_to_grp_number jtf_rs_groups_vl.group_number%type;
1287: l_to_grp_name jtf_rs_groups_vl.group_name%type;
1288:
1289: --Declare the variables
1290: --

Line 1287: l_to_grp_name jtf_rs_groups_vl.group_name%type;

1283: and g1.group_id = gm.new_group_id;
1284:
1285: to_grp_rec to_grp_cur%rowtype;
1286: l_to_grp_number jtf_rs_groups_vl.group_number%type;
1287: l_to_grp_name jtf_rs_groups_vl.group_name%type;
1288:
1289: --Declare the variables
1290: --
1291: l_api_version CONSTANT NUMBER :=1.0;