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.BIS_PMV_APPROVALS_PVT dependencies on FND_GLOBAL

Line 46: AND (n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME)))

42: SELECT n.message_type, count(distinct n.notification_id)
43: FROM wf_notifications n, wf_notification_attributes a
44: where n.notification_id = a.notification_id
45: AND ( (n.more_info_role is null)
46: AND (n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME)))
47: and n.status='OPEN' and n.message_type in (SELECT lookup_code FROM fnd_lookup_values WHERE lookup_type = 'BIS_PMV_APPROVAL_TYPES')
48: group by n.message_type;
49:
50: CURSOR get_more_notifications IS

Line 54: (n.more_info_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME))

50: CURSOR get_more_notifications IS
51: SELECT n.message_type, count(distinct n.notification_id)
52: FROM wf_notifications n, wf_notification_attributes a
53: where n.notification_id = a.notification_id AND
54: (n.more_info_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME))
55: and n.status='OPEN' and n.message_type in (SELECT lookup_code FROM fnd_lookup_values WHERE lookup_type = 'BIS_PMV_APPROVAL_TYPES')
56: group by n.message_type;
57:
58: BEGIN

Line 148: ' and n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME) '||

144: ' n.message_type BIS_NOTIFY_PROMPT, count(distinct n.notification_id) BIS_OBJECT_ROW_COUNT, '|| l_exp_url ||' BISREPORTURL '||
145: ' FROM wf_notifications n, wf_notification_attributes a
146: where n.notification_id = a.notification_id
147: and n.status ='||'''OPEN'''||l_type_where||
148: ' and n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME) '||
149: ' group by n.message_type ';*/
150:
151: x_custom_sql := l_sql;
152:

Line 265: l_recipient_where_clause := ' AND ( (n.more_info_role is null) AND (n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME))) ';

261: l_drill_url ||' BIS_COLUMN_6 ';
262: l_from_clause := ' FROM wf_notifications n, wf_notification_attributes a ';
263: l_notif_where_clause := ' where n.notification_id = a.notification_id ';
264: IF (l_isOpen) THEN
265: l_recipient_where_clause := ' AND ( (n.more_info_role is null) AND (n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME))) ';
266: ELSE
267: l_recipient_where_clause := ' AND ( n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME)) ';
268: END IF;
269: l_more_where_clause := ' AND (n.more_info_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME)) ';

Line 267: l_recipient_where_clause := ' AND ( n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME)) ';

263: l_notif_where_clause := ' where n.notification_id = a.notification_id ';
264: IF (l_isOpen) THEN
265: l_recipient_where_clause := ' AND ( (n.more_info_role is null) AND (n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME))) ';
266: ELSE
267: l_recipient_where_clause := ' AND ( n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME)) ';
268: END IF;
269: l_more_where_clause := ' AND (n.more_info_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME)) ';
270:
271:

Line 269: l_more_where_clause := ' AND (n.more_info_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME)) ';

265: l_recipient_where_clause := ' AND ( (n.more_info_role is null) AND (n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME))) ';
266: ELSE
267: l_recipient_where_clause := ' AND ( n.recipient_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME)) ';
268: END IF;
269: l_more_where_clause := ' AND (n.more_info_role in (SELECT role_name from wf_user_roles where user_name=FND_GLOBAL.USER_NAME)) ';
270:
271:
272: l_sql := '('||l_select_clause || l_from_clause ||l_notif_where_clause||
273: l_recipient_where_clause ||