DBA Data[Home] [Help]

APPS.CSC_ROUTING_UTL dependencies on CS_INCIDENTS_V

Line 203: cs_incidents_v inc

199: --
200: CURSOR c_party_id (repnum NUMBER) IS
201: SELECT inc.customer_id
202: FROM csd_repairs rep,
203: cs_incidents_v inc
204: WHERE rep.repair_number = repnum
205: AND rep.incident_id = inc.incident_id;
206:
207: BEGIN

Line 247: cs_incidents_v inc

243: CURSOR c_party_id (defnum VARCHAR2) IS
244: SELECT inc.incident_Id
245: FROM css_def_defects_all_v def,
246: cs_incident_links inl,
247: cs_incidents_v inc
248: WHERE def.defect_number = defnum
249: AND def.defect_id = inl.link_id
250: AND inl.from_incident_id = inc.incident_id;
251: */