DBA Data[Home] [Help]

APPS.CSD_ISUP_DEPOT_WF_PVT dependencies on CS_INCIDENTS_ALL_B

Line 29: FROM cs_incidents_all_b ci,

25: -- Cursor to get the Business Process id..
26:
27: cursor get_business_process(p_incident_number in varchar2) is
28: SELECT cit.business_process_id
29: FROM cs_incidents_all_b ci,
30: cs_incident_types_b cit
31: where ci.incident_number = g_incident_number
32: and ci.incident_type_id = cit.incident_type_id;
33:

Line 176: FROM cs_incidents_all_b cs,

172: cs.account_id,
173: cs.incident_date,
174: cs.incident_severity_id,
175: mtl.primary_uom_code
176: FROM cs_incidents_all_b cs,
177: mtl_system_items_b mtl
178: WHERE
179: cs.inventory_item_id = mtl.inventory_item_id AND
180: cs.inv_organization_id = mtl.organization_id AND