DBA Data[Home] [Help]

APPS.CSD_WF_PROCESS_PVT dependencies on CSD_INCIDENTS_V

Line 40: from csd_incidents_v sr,

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:

Line 190: from csd_incidents_v sr,

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:

Line 340: csd_incidents_v sr,

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