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.IBU_DYN_USER_GROUPS_PKG dependencies on JTF_RS_DYNAMIC_GROUPS_VL

Line 143: l_q_str jtf_rs_dynamic_groups_vl.sql_text%TYPE;

139: End;
140: -- =================================================================================================================
141: Procedure Get_Category (p_sql_text IN varchar2, x_category OUT NOCOPY varchar2)
142: IS
143: l_q_str jtf_rs_dynamic_groups_vl.sql_text%TYPE;
144: l_num NUMBER;
145: l_party_num NUMBER;
146: l_emp_num NUMBER;
147: l_substring VARCHAR2(2000);

Line 275: -- from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B

271: -- select B.group_id, B.group_name, B.group_number,
272: -- A.start_date_active, A.end_date_active,
273: -- B.exclusive_flag, B.group_desc, B.object_version_number,
274: -- A.sql_text
275: -- from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B
276: -- Where A.group_name || '(' || A.group_number || ')' = B.GROUP_NAME
277: -- and ( ( A.end_date_active is null ) or ( A.end_date_active > sysdate ) )
278: -- and A.Usage = 'ISUPPORT';
279:

Line 290: -- from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B

286: -- select B.group_id, A.group_name || '(' || A.group_number || ')' group_name, B.group_number,
287: -- A.start_date_active, A.end_date_active,
288: -- B.exclusive_flag, B.group_desc, B.object_version_number,
289: -- A.sql_text
290: -- from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B
291: -- Where B.GROUP_NAME like '%(' || A.group_number || ')'
292: -- and ( ( A.end_date_active is null ) or ( A.end_date_active > sysdate ) )
293: -- and A.Usage = 'ISUPPORT';
294: --and A.last_update_date > Sysdate - 1;

Line 334: l_start_date_active jtf_rs_dynamic_groups_vl.start_date_active%TYPE;

330:
331: l_group_id jtf_rs_groups_vl.group_id%TYPE;
332: l_group_name jtf_rs_groups_vl.group_name%TYPE;
333: l_group_number jtf_rs_groups_vl.group_number%TYPE;
334: l_start_date_active jtf_rs_dynamic_groups_vl.start_date_active%TYPE;
335: l_end_date_active jtf_rs_dynamic_groups_vl.end_date_active%TYPE;
336: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE;
337: l_group_desc jtf_rs_groups_vl.group_desc%TYPE;
338: l_obj_grp_version_num jtf_rs_groups_vl.object_version_number%TYPE;

Line 335: l_end_date_active jtf_rs_dynamic_groups_vl.end_date_active%TYPE;

331: l_group_id jtf_rs_groups_vl.group_id%TYPE;
332: l_group_name jtf_rs_groups_vl.group_name%TYPE;
333: l_group_number jtf_rs_groups_vl.group_number%TYPE;
334: l_start_date_active jtf_rs_dynamic_groups_vl.start_date_active%TYPE;
335: l_end_date_active jtf_rs_dynamic_groups_vl.end_date_active%TYPE;
336: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE;
337: l_group_desc jtf_rs_groups_vl.group_desc%TYPE;
338: l_obj_grp_version_num jtf_rs_groups_vl.object_version_number%TYPE;
339: l_sql_text jtf_rs_dynamic_groups_vl.sql_text%TYPE;

Line 339: l_sql_text jtf_rs_dynamic_groups_vl.sql_text%TYPE;

335: l_end_date_active jtf_rs_dynamic_groups_vl.end_date_active%TYPE;
336: l_exclusive_flag jtf_rs_groups_vl.exclusive_flag%TYPE;
337: l_group_desc jtf_rs_groups_vl.group_desc%TYPE;
338: l_obj_grp_version_num jtf_rs_groups_vl.object_version_number%TYPE;
339: l_sql_text jtf_rs_dynamic_groups_vl.sql_text%TYPE;
340: l_category varchar2(50);
341: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
342: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;
343: l_user_id fnd_user.user_id%TYPE;

Line 665: from jtf_rs_dynamic_groups_vl A

661: A.start_date_active, A.end_date_active,
662: A.group_desc,
663: A.sql_text,
664: A.created_by
665: from jtf_rs_dynamic_groups_vl A
666: Where not exists ( Select B.group_name
667: from jtf_rs_groups_vl B
668: Where B.group_name = A.group_name || '(' || A.group_number || ')' )
669: and ( ( A.end_date_active is null ) or ( A.end_date_active > sysdate ) )

Line 1073: from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B

1069: B.group_name static_group_name,
1070: B.group_number static_group_number,
1071: A.start_date_active, A.end_date_active, A.sql_text,
1072: B.exclusive_flag, B.group_desc, B.object_version_number
1073: from jtf_rs_dynamic_groups_vl A, jtf_rs_groups_vl B
1074: Where A.group_name || '(' || A.group_number || ')' = B.GROUP_NAME
1075: and ( ( B.end_date_active is null ) OR ( B.end_date_active > sysdate ) )
1076: and ( ( A.end_date_active is not null ) AND ( A.end_date_active <= sysdate ) )
1077: and A.usage = 'ISUPPORT';