eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UMP_UNITMAINT_PVT dependencies on CS_INCIDENTS_ALL_B

Line 1370: FROM cs_incident_links CLK, CS_INCIDENTS_ALL_B CS

1366:
1367: CURSOR l_servq_num_csr (p_ue_id IN NUMBER, p_object_type IN VARCHAR2,
1368: p_subject_type IN VARCHAR2, p_link_type_id IN NUMBER) IS
1369: SELECT CS.incident_number
1370: FROM cs_incident_links CLK, CS_INCIDENTS_ALL_B CS
1371: WHERE CS.incident_id = CLK.subject_id
1372: AND CLK.object_id = p_ue_id
1373: AND CLK.object_type = p_object_type
1374: AND CLK.subject_type = p_subject_type

Line 1403: l_err_serreq_num cs_incidents_all_b.incident_number%TYPE;

1399:
1400: l_err_instance_number CSI_ITEM_INSTANCES.instance_number%TYPE;
1401: l_err_due_date DATE;
1402: l_err_title ahl_mr_headers_b.title%TYPE;
1403: l_err_serreq_num cs_incidents_all_b.incident_number%TYPE;
1404: l_service_line_id ahl_unit_effectivities_b.service_line_id%TYPE;
1405: -- added to validate visit status.
1406: l_visit_status VARCHAR2(100);
1407: