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 WF_NOTIFICATION_ATTRIBUTES

Line 43: FROM wf_notifications n, wf_notification_attributes a

39: SELECT lookup_code, meaning FROM fnd_lookup_values_vl WHERE lookup_type = 'BIS_PMV_APPROVAL_TYPES';
40:
41: CURSOR get_Notifications IS
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')

Line 52: FROM wf_notifications n, wf_notification_attributes a

48: group by n.message_type;
49:
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;

Line 145: ' FROM wf_notifications n, wf_notification_attributes a

141: END IF;
142: /*
143: l_sql := ' SELECT '||l_mean_types||
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 ';*/

Line 262: l_from_clause := ' FROM wf_notifications n, wf_notification_attributes a ';

258: l_select_clause := ' SELECT distinct FROM_USER BIS_COLUMN_1, n.subject BIS_COLUMN_2,'||
259: ' n.begin_date BIS_COLUMN_3, n.end_date BIS_COLUMN_4,'||
260: ' n.notification_id BIS_COLUMN_5 ,'||
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