DBA Data[Home] [Help]

APPS.CSD_ISUP_DEPOT_WF_PVT dependencies on CS_INCIDENTS_ALL_B

Line 30: FROM cs_incidents_all_b ci,

26: -- fix for bug#9275129, subhat.
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

Line 170: FROM cs_incidents_all_b cs,

166: cs.contract_id,
167: cs.contract_service_id,
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