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_GROUPS_VL

Line 625: l_sql_statement := l_sql_statement || ', jtf_rs_groups_vl g ';

621: 'And s.resource_id = r.resource_id ' ||
622: 'And m.delete_flag <> ''Y'' ' ||
623: 'And m.group_id = ' || p_group_id || ' ';
624: IF (p_check_effective_date = FND_API.G_TRUE) THEN
625: l_sql_statement := l_sql_statement || ', jtf_rs_groups_vl g ';
626: l_sql_statement2 := l_sql_statement2 || ', jtf_rs_groups_vl g ';
627: l_where_clause := l_where_clause ||
628: 'And g.group_id = ' || p_group_id || ' ' ||
629: --'And r.start_date_active < sysdate ' ||

Line 626: l_sql_statement2 := l_sql_statement2 || ', jtf_rs_groups_vl g ';

622: 'And m.delete_flag <> ''Y'' ' ||
623: 'And m.group_id = ' || p_group_id || ' ';
624: IF (p_check_effective_date = FND_API.G_TRUE) THEN
625: l_sql_statement := l_sql_statement || ', jtf_rs_groups_vl g ';
626: l_sql_statement2 := l_sql_statement2 || ', jtf_rs_groups_vl g ';
627: l_where_clause := l_where_clause ||
628: 'And g.group_id = ' || p_group_id || ' ' ||
629: --'And r.start_date_active < sysdate ' ||
630: --'And nvl(r.end_date_active, sysdate+1) > sysdate ' ||

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 3161: From jtf_rs_role_relations_vl r, jtf_rs_groups_vl g

3157: --
3158: CURSOR Get_GroupRole2_csr IS
3159: Select
3160: r.role_relate_id
3161: From jtf_rs_role_relations_vl r, jtf_rs_groups_vl g
3162: Where r.role_id = p_role_id
3163: And r.role_resource_id = p_group_id
3164: And r.role_resource_type = G_GROUP_ROLE_CODE
3165: And r.start_date_active < sysdate

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 3631: From jtf_rs_groups_vl

3627: l_channel_id NUMBER;
3628: --
3629: CURSOR Get_Version_csr IS
3630: Select object_version_number
3631: From jtf_rs_groups_vl
3632: Where group_id = p_group_id
3633: ;
3634: CURSOR Check_Group_csr(p_name IN VARCHAR2) IS
3635: Select g.group_id

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 3861: From jtf_rs_groups_vl

3857: l_channel_id NUMBER;
3858: --
3859: CURSOR Get_GroupID_csr(p_name IN VARCHAR2) IS
3860: Select group_id
3861: From jtf_rs_groups_vl
3862: Where group_name = p_name
3863: ;
3864: CURSOR Get_ChannelID_csr(p_grp_id IN NUMBER) IS
3865: SELECT CHANNEL_ID

Line 4028: From jtf_rs_groups_vl

4024: email_address,
4025: group_desc,
4026: start_date_active,
4027: end_date_active
4028: From jtf_rs_groups_vl
4029: Where group_id = p_group_id
4030: ;
4031: --
4032: l_group_info Get_GroupObj_csr%ROWTYPE;

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 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 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 || ''' ';

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 6542: From amv_u_access u, jtf_rs_groups_vl g

6538: U.CAN_CREATE_DIST_RULE_FLAG,
6539: U.CHL_APPROVER_FLAG,
6540: U.CHL_REQUIRED_FLAG,
6541: U.CHL_REQUIRED_NEED_NOTIF_FLAG
6542: From amv_u_access u, jtf_rs_groups_vl g
6543: Where u.user_or_group_id = g.group_id
6544: And u.user_or_group_type = G_GROUP_ARC_TYPE
6545: And access_to_table_code = G_CHAN_ARC_TYPE
6546: And u.access_to_table_record_id = p_channel_id;

Line 6989: From amv_u_access a, jtf_rs_groups_vl g

6985: A.CAN_CREATE_DIST_RULE_FLAG,
6986: A.CHL_APPROVER_FLAG,
6987: A.CHL_REQUIRED_FLAG,
6988: A.CHL_REQUIRED_NEED_NOTIF_FLAG
6989: From amv_u_access a, jtf_rs_groups_vl g
6990: Where a.user_or_group_id = p_user_or_group_id
6991: And a.user_or_group_type = G_GROUP_ARC_TYPE
6992: And a.access_to_table_record_id = p_business_object_id
6993: And a.access_to_table_code = p_business_object_type

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