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_USAGES

Line 2026: jtf_rs_group_usages usg

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
2030: and r.role_resource_type = G_GROUP_ROLE_CODE

Line 2044: jtf_rs_groups_vl g, jtf_rs_group_usages usg

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
2048: and r.role_id = p_role_id

Line 3309: From jtf_rs_groups_vl g, jtf_rs_group_usages usg

3305: l_email_address VARCHAR2(2000);
3306: --
3307: CURSOR Check_Group_csr IS
3308: Select g.group_id
3309: From jtf_rs_groups_vl g, jtf_rs_group_usages usg
3310: Where g.group_name = p_group_name
3311: And g.start_date_active < sysdate
3312: And nvl(g.end_date_active, sysdate+1) > sysdate
3313: And usg.group_id = g.group_id

Line 3430: jtf_rs_group_usages_pub.create_group_usage

3426: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR ) THEN
3427: RAISE FND_API.G_EXC_ERROR;
3428: END IF;
3429: -- Add group usage.
3430: jtf_rs_group_usages_pub.create_group_usage
3431: (
3432: p_api_version => 1.0,
3433: p_group_id => x_group_id,
3434: p_group_number => l_group_number,

Line 3636: From jtf_rs_groups_vl g, jtf_rs_group_usages usg

3632: Where group_id = p_group_id
3633: ;
3634: CURSOR Check_Group_csr(p_name IN VARCHAR2) IS
3635: Select g.group_id
3636: From jtf_rs_groups_vl g, jtf_rs_group_usages usg
3637: Where g.group_name = p_name
3638: And usg.group_id = g.group_id
3639: And usg.usage = p_group_usage
3640: ;

Line 4229: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';

4225: 'g.email_address, ' ||
4226: 'g.group_desc, ' ||
4227: 'g.start_date_active, ' ||
4228: 'g.end_date_active ' ||
4229: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';
4230: l_sql_statement2 :=
4231: 'Select count(*) ' ||
4232: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';
4233: l_where_clause := 'Where g.start_date_active < sysdate ' ||

Line 4232: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';

4228: 'g.end_date_active ' ||
4229: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';
4230: l_sql_statement2 :=
4231: 'Select count(*) ' ||
4232: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';
4233: l_where_clause := 'Where g.start_date_active < sysdate ' ||
4234: 'And nvl(g.end_date_active, sysdate+1) > sysdate ' ||
4235: 'And usg.group_id = g.group_id ' ||
4236: 'And usg.usage = ''' || p_group_usage || ''' ';

Line 4248: ' jtf_rs_group_usages usg ';

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, ' ||
4252: ' jtf_rs_group_usages usg ';

Line 4252: ' jtf_rs_group_usages usg ';

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 || ' ' ||
4256: 'And g.start_date_active < sysdate ' ||

Line 4474: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';

4470: 'g.email_address, ' ||
4471: 'g.group_desc, ' ||
4472: 'g.start_date_active, ' ||
4473: 'g.end_date_active ' ||
4474: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';
4475: l_sql_statement2 :=
4476: 'Select count(*) ' ||
4477: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';
4478: l_where_clause := 'Where g.start_date_active < sysdate ' ||

Line 4477: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';

4473: 'g.end_date_active ' ||
4474: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';
4475: l_sql_statement2 :=
4476: 'Select count(*) ' ||
4477: 'From jtf_rs_groups_vl g, jtf_rs_group_usages usg ';
4478: l_where_clause := 'Where g.start_date_active < sysdate ' ||
4479: 'And nvl(g.end_date_active, sysdate+1) > sysdate ' ||
4480: 'And usg.group_id = g.group_id ' ||
4481: 'And usg.usage = ''' || p_group_usage || ''' ';