APPS.AHL_UMP_SR_PVT dependencies on CS_INCIDENTS_ALL

Line 224: FROM cs_incidents_all_b

220: -- Validate Incident ID
221: CURSOR validate_incident_id ( c_request_id in NUMBER )
222: IS
223: SELECT incident_id
224: FROM cs_incidents_all_b
225: WHERE incident_id = c_request_id;
226:
227: -- Validate Item Instance
228: CURSOR validate_instance ( c_instance_id in NUMBER)

Line 963: FROM CS_INCIDENT_STATUSES_B STATUS,CS_INCIDENTS_ALL_B INC

959: AND INCIDENT_NUMBER like NVL(p_request_number, '%')
960: AND OBJECT_VERSION_NUMBER = p_object_version_number;*/
961:
962: SELECT INC.incident_id, INC.incident_status_id, NVL(STATUS.CLOSE_FLAG, 'N') closed_flag, INC.customer_product_id, INC.expected_resolution_date
963: FROM CS_INCIDENT_STATUSES_B STATUS,CS_INCIDENTS_ALL_B INC
964: WHERE INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
965: AND INC.INCIDENT_ID like DECODE(p_request_id, null, '%', p_request_id)
966: AND INC.INCIDENT_NUMBER like NVL(p_request_number, '%')
967: AND INC.OBJECT_VERSION_NUMBER = p_object_version_number;

Line 3170: CS_INCIDENTS_ALL CSIA,

3166: SELECT
3167: CSIA.summary,
3168: CSIT.name -- incident type name.
3169: FROM
3170: CS_INCIDENTS_ALL CSIA,
3171: CS_INCIDENT_TYPES_VL CSIT,
3172: AHL_UNIT_EFFECTIVITIES_B UE
3173: WHERE
3174: UE.unit_effectivity_id = p_sr_ue_id AND