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.CS_SR_LOG_DATA_TEMP_PVT dependencies on FND_USER

Line 105: from fnd_user FU,

101: decode(audi.resource_type,'RS_EMPLOYEE',ext2.source_last_name||' '||ext2.source_first_name,'RS_TEAM',team2.team_name,'RS_GROUP',grp2.group_name) new_owner,
102: obj1.name old_resource_type ,
103: obj2.name resource_type ,
104: audi.change_resource_type_flag
105: from fnd_user FU,
106: cs_incidents_AUDIT_vl AUDI ,
107: cs_incident_severities_tl severity1 ,
108: cs_incident_severities_tl severity2 ,
109: cs_incident_types_tl type1 ,

Line 156: cursor task_cursor is select 'TASK' source_type,jtf.task_id,fnd.user_name,

152: and (obj1.language = userenv('LANG') or obj1.language is null)
153: and obj2.object_code(+) = audi.resource_type
154: and (obj2.language = userenv('LANG') or obj2.language is null);
155:
156: cursor task_cursor is select 'TASK' source_type,jtf.task_id,fnd.user_name,
157: jtf.last_update_date,jtf.description
158: from jtf_tasks_vl jtf, fnd_user fnd
159: where source_object_type_code='SR'
160: and source_object_id=p_incident_id

Line 158: from jtf_tasks_vl jtf, fnd_user fnd

154: and (obj2.language = userenv('LANG') or obj2.language is null);
155:
156: cursor task_cursor is select 'TASK' source_type,jtf.task_id,fnd.user_name,
157: jtf.last_update_date,jtf.description
158: from jtf_tasks_vl jtf, fnd_user fnd
159: where source_object_type_code='SR'
160: and source_object_id=p_incident_id
161: and jtf.last_updated_by = fnd.user_id;
162:

Line 161: and jtf.last_updated_by = fnd.user_id;

157: jtf.last_update_date,jtf.description
158: from jtf_tasks_vl jtf, fnd_user fnd
159: where source_object_type_code='SR'
160: and source_object_id=p_incident_id
161: and jtf.last_updated_by = fnd.user_id;
162:
163: cursor note_cursor is select 'NOTE' source_type,jtf.jtf_note_id,fnd.user_name,
164: jtf.last_update_date,jtf.notes
165: from jtf_notes_vl jtf, fnd_user fnd

Line 163: cursor note_cursor is select 'NOTE' source_type,jtf.jtf_note_id,fnd.user_name,

159: where source_object_type_code='SR'
160: and source_object_id=p_incident_id
161: and jtf.last_updated_by = fnd.user_id;
162:
163: cursor note_cursor is select 'NOTE' source_type,jtf.jtf_note_id,fnd.user_name,
164: jtf.last_update_date,jtf.notes
165: from jtf_notes_vl jtf, fnd_user fnd
166: where source_object_code='SR'
167: and source_object_id=p_incident_id

Line 165: from jtf_notes_vl jtf, fnd_user fnd

161: and jtf.last_updated_by = fnd.user_id;
162:
163: cursor note_cursor is select 'NOTE' source_type,jtf.jtf_note_id,fnd.user_name,
164: jtf.last_update_date,jtf.notes
165: from jtf_notes_vl jtf, fnd_user fnd
166: where source_object_code='SR'
167: and source_object_id=p_incident_id
168: and jtf.last_updated_by = fnd.user_id;
169:

Line 168: and jtf.last_updated_by = fnd.user_id;

164: jtf.last_update_date,jtf.notes
165: from jtf_notes_vl jtf, fnd_user fnd
166: where source_object_code='SR'
167: and source_object_id=p_incident_id
168: and jtf.last_updated_by = fnd.user_id;
169:
170: cursor activity_cursor is select 'ACTIVITY' source_type,jtf.interaction_id,
171: act.short_description,fnd.user_name,jtf.last_update_date
172: from jtf_ih_activities jtf, jtf_ih_actions_tl act,

Line 171: act.short_description,fnd.user_name,jtf.last_update_date

167: and source_object_id=p_incident_id
168: and jtf.last_updated_by = fnd.user_id;
169:
170: cursor activity_cursor is select 'ACTIVITY' source_type,jtf.interaction_id,
171: act.short_description,fnd.user_name,jtf.last_update_date
172: from jtf_ih_activities jtf, jtf_ih_actions_tl act,
173: fnd_user fnd
174: where doc_ref = 'SR'
175: and doc_id = p_incident_id

Line 173: fnd_user fnd

169:
170: cursor activity_cursor is select 'ACTIVITY' source_type,jtf.interaction_id,
171: act.short_description,fnd.user_name,jtf.last_update_date
172: from jtf_ih_activities jtf, jtf_ih_actions_tl act,
173: fnd_user fnd
174: where doc_ref = 'SR'
175: and doc_id = p_incident_id
176: and jtf.action_id = act.action_id
177: and act.language = userenv('LANG')

Line 178: and jtf.last_updated_by = fnd.user_id;

174: where doc_ref = 'SR'
175: and doc_id = p_incident_id
176: and jtf.action_id = act.action_id
177: and act.language = userenv('LANG')
178: and jtf.last_updated_by = fnd.user_id;
179:
180: cursor soln_cursor is
181: select 'SOLN' source_type, setv.set_id,
182: setv.name set_summary, sett.name set_type_name,

Line 184: setl.last_update_date, fnd.user_name

180: cursor soln_cursor is
181: select 'SOLN' source_type, setv.set_id,
182: setv.name set_summary, sett.name set_type_name,
183: elev.name element_summary, elet.name element_type_name,
184: setl.last_update_date, fnd.user_name
185: from cs_kb_set_links setl, cs_kb_sets_vl setv,
186: cs_kb_set_types_tl sett, cs_kb_element_links elel,
187: cs_kb_elements_vl elev, cs_kb_element_types_tl elet,
188: fnd_user fnd

Line 188: fnd_user fnd

184: setl.last_update_date, fnd.user_name
185: from cs_kb_set_links setl, cs_kb_sets_vl setv,
186: cs_kb_set_types_tl sett, cs_kb_element_links elel,
187: cs_kb_elements_vl elev, cs_kb_element_types_tl elet,
188: fnd_user fnd
189: where setl.object_code ='SR'
190: and setl.other_id = p_incident_id
191: and setl.set_id=setv.set_id
192: and sett.set_type_id=setv.set_type_id(+)

Line 199: and setl.last_updated_by = fnd.user_id;

195: and elel.other_id(+)=setv.set_id
196: and elel.element_id=elev.element_id(+)
197: and elev.element_type_id = elet.element_type_id(+)
198: and (elet.language = userenv('LANG') or elet.language is null)
199: and setl.last_updated_by = fnd.user_id;
200:
201: i_main_pointer integer;
202: i_other_pointer integer;
203: i_size_of_kb integer;