DBA Data[Home] [Help]

APPS.CSD_WF_PROCESS_PVT dependencies on CSD_REPAIRS_V

Line 191: csd_repairs_v ro

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:
195: -- cursor to see if a role exists for the SR contact.

Line 341: csd_repairs_v ro,

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
345: and wr.orig_system_id = cjr.source_id