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.AMV_USER_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 615: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';

611: 's.user_name, ' ||
612: 'r.resource_name, ' ||
613: 'r.first_name, ' ||
614: 'r.last_name ' ||
615: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';
616: l_sql_statement2 :=
617: 'Select count(*) ' ||
618: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';
619: l_where_clause :=

Line 618: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';

614: 'r.last_name ' ||
615: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';
616: l_sql_statement2 :=
617: 'Select count(*) ' ||
618: 'From amv_rs_all_res_extns_vl r, jtf_rs_group_members m, jtf_rs_resource_extns s ';
619: l_where_clause :=
620: 'Where m.resource_id = r.resource_id ' ||
621: 'And s.resource_id = r.resource_id ' ||
622: 'And m.delete_flag <> ''Y'' ' ||

Line 2025: from jtf_rs_group_members m, jtf_rs_role_relations_vl r,

2021: From dual
2022: Where exists
2023: (
2024: select r.role_id
2025: from jtf_rs_group_members m, jtf_rs_role_relations_vl r,
2026: jtf_rs_group_usages usg
2027: where m.resource_id = p_res_id
2028: and m.delete_flag <> 'Y'
2029: and m.group_id = r.role_resource_id

Line 2043: from jtf_rs_group_members m, jtf_rs_role_relations_vl r,

2039: From dual
2040: Where exists
2041: (
2042: select r.role_id
2043: from jtf_rs_group_members m, jtf_rs_role_relations_vl r,
2044: jtf_rs_groups_vl g, jtf_rs_group_usages usg
2045: where m.resource_id = p_res_id
2046: and m.delete_flag <> 'Y'
2047: and m.group_id = r.role_resource_id

Line 4247: 'From jtf_rs_groups_vl g, jtf_rs_group_members m, ' ||

4243: 'g.email_address, ' ||
4244: 'g.group_desc, ' ||
4245: 'g.start_date_active, ' ||
4246: 'g.end_date_active ' ||
4247: 'From jtf_rs_groups_vl g, jtf_rs_group_members m, ' ||
4248: ' jtf_rs_group_usages usg ';
4249: l_sql_statement2 :=
4250: 'Select count(*) ' ||
4251: 'From jtf_rs_groups_vl g, jtf_rs_group_members m, ' ||

Line 4251: 'From jtf_rs_groups_vl g, jtf_rs_group_members m, ' ||

4247: 'From jtf_rs_groups_vl g, jtf_rs_group_members m, ' ||
4248: ' jtf_rs_group_usages usg ';
4249: l_sql_statement2 :=
4250: 'Select count(*) ' ||
4251: 'From jtf_rs_groups_vl g, jtf_rs_group_members m, ' ||
4252: ' jtf_rs_group_usages usg ';
4253: l_where_clause := 'Where g.group_id = m.group_id ' ||
4254: 'And m.delete_flag <> ''Y'' ' ||
4255: 'And m.resource_id = ' || p_resource_id || ' ' ||

Line 4629: From jtf_rs_group_members

4625: l_temp NUMBER;
4626: --
4627: CURSOR Check_GroupMember_csr IS
4628: Select group_member_id
4629: From jtf_rs_group_members
4630: Where resource_id = p_resource_id
4631: And group_id = p_group_id
4632: And delete_flag <> 'Y';
4633: --

Line 4715: jtf_rs_group_members_pub.create_resource_group_members

4711: OPEN Check_GroupMember_csr;
4712: FETCH Check_GroupMember_csr INTO l_temp;
4713: IF (Check_GroupMember_csr%NOTFOUND) THEN
4714: CLOSE Check_GroupMember_csr;
4715: jtf_rs_group_members_pub.create_resource_group_members
4716: (
4717: p_api_version => 1.0,
4718: p_commit => p_commit,
4719: p_group_id => p_group_id,

Line 4946: From jtf_rs_group_members

4942: l_version NUMBER;
4943: --
4944: CURSOR Check_GroupMember_csr IS
4945: Select object_version_number
4946: From jtf_rs_group_members
4947: Where resource_id = p_resource_id
4948: And group_id = p_group_id
4949: And delete_flag <> 'Y';
4950: --

Line 5012: jtf_rs_group_members_pub.delete_resource_group_members

5008: OPEN Check_GroupMember_csr;
5009: FETCH Check_GroupMember_csr INTO l_version;
5010: IF (Check_GroupMember_csr%FOUND) THEN
5011: CLOSE Check_GroupMember_csr;
5012: jtf_rs_group_members_pub.delete_resource_group_members
5013: (
5014: p_api_version => 1.0,
5015: p_commit => p_commit,
5016: p_group_id => p_group_id,

Line 5248: From jtf_rs_group_members m, jtf_rs_groups_vl g

5244: l_temp NUMBER;
5245: --
5246: CURSOR Check_GroupMember_csr IS
5247: Select m.group_member_id
5248: From jtf_rs_group_members m, jtf_rs_groups_vl g
5249: Where m.resource_id = p_resource_id
5250: And m.group_id = p_group_id
5251: And m.delete_flag <> 'Y'
5252: And g.group_id = p_group_id

Line 7010: From amv_u_access a, jtf_rs_group_members m

7006: A.CAN_CREATE_DIST_RULE_FLAG,
7007: A.CHL_APPROVER_FLAG,
7008: A.CHL_REQUIRED_FLAG,
7009: A.CHL_REQUIRED_NEED_NOTIF_FLAG
7010: From amv_u_access a, jtf_rs_group_members m
7011: Where a.access_to_table_record_id = p_business_object_id
7012: And a.access_to_table_code = p_business_object_type
7013: And a.user_or_group_type = G_GROUP_ARC_TYPE
7014: And a.user_or_group_id = m.group_id

Line 7027: From amv_u_access a, jtf_rs_group_members m, jtf_rs_groups_vl g

7023: A.CAN_CREATE_DIST_RULE_FLAG,
7024: A.CHL_APPROVER_FLAG,
7025: A.CHL_REQUIRED_FLAG,
7026: A.CHL_REQUIRED_NEED_NOTIF_FLAG
7027: From amv_u_access a, jtf_rs_group_members m, jtf_rs_groups_vl g
7028: Where a.access_to_table_record_id = p_business_object_id
7029: And a.access_to_table_code =p_business_object_type
7030: And nvl(a.effective_start_date, sysdate-1) < sysdate
7031: And nvl(a.expiration_date, sysdate+1) > sysdate