DBA Data[Home] [Help]

APPS.CSD_ISUP_DEPOT_WF_PVT dependencies on CS_INCIDENT_TYPES

Line 31: cs_incident_types_b cit,

27:
28: cursor get_business_process(p_incident_number in varchar2) is
29: SELECT cit.business_process_id
30: FROM cs_incidents_all_b ci,
31: cs_incident_types_b cit,
32: cs_business_processes cbp
33: where ci.incident_number = g_incident_number
34: and ci.incident_type_id = cit.incident_type_id
35: and cbp.business_process_id = cit.business_process_id

Line 172: cs_incident_types cit

168: cs.ship_to_site_use_id,
169: cs.problem_code
170: FROM cs_incidents_all_b cs,
171: mtl_system_items_b mtl,
172: cs_incident_types cit
173: WHERE
174: cs.inventory_item_id = mtl.inventory_item_id AND
175: cs.inv_organization_id = mtl.organization_id AND
176: cs.INCIDENT_NUMBER = p_incident_number AND