36: ro.repair_number,
37: ro.serial_number,
38: sr.item,
39: decode(sr.contact_type,'EMPLOYEE',sr.first_name||' '||sr.last_name,sr.full_name) contact_name
40: from csd_incidents_v sr,
41: csd_repairs ro
42: where ro.incident_id = sr.incident_id
43: and ro.repair_line_id = p_repair_line_id;
44:
186: ro.serial_number,
187: ro.item,
188: ro.flow_status,
189: decode(sr.contact_type,'EMPLOYEE',sr.first_name||' '||sr.last_name,sr.full_name) contact_name
190: from csd_incidents_v sr,
191: csd_repairs_v ro
192: where ro.incident_id = sr.incident_id
193: and ro.repair_line_id = p_repair_line_id;
194:
336: ro.repair_number, ro.serial_number,
337: ro.flow_status, ro.item,
338: cjr.source_first_name, cjr.source_last_name
339: From wf_roles wr,
340: csd_incidents_v sr,
341: csd_repairs_v ro,
342: CS_JTF_RS_RESOURCE_EXTNS_SEC cjr
343: Where ro.repair_line_id = p_repair_line_id
344: and ro.incident_id = sr.incident_id