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_VWP_RULES_PVT dependencies on CS_INCIDENTS_ALL_B

Line 602: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT

598: -- yazhou 19Oct2005 Starts
599: -- Bug fix #4415024
600: IF p_service_id IS NOT NULL THEN
601: SELECT a.Incident_Id INTO x_service_id
602: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT
603: WHERE a.incident_type_id = cit.incident_type_id
604: AND cit.INCIDENT_SUBTYPE = 'INC'
605: AND cit.CMRO_FLAG = 'Y'
606: AND Incident_Id = p_service_id;

Line 609: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT

605: AND cit.CMRO_FLAG = 'Y'
606: AND Incident_Id = p_service_id;
607: ELSIF p_service_number IS NOT NULL THEN
608: SELECT a.Incident_Id INTO x_service_id
609: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT
610: WHERE a.incident_type_id = cit.incident_type_id
611: AND cit.INCIDENT_SUBTYPE = 'INC'
612: AND cit.CMRO_FLAG = 'Y'
613: AND Incident_Number = p_service_number;

Line 2870: SELECT customer_id FROM CS_INCIDENTS_ALL_B

2866:
2867: l_service_request_id NUMBER;
2868:
2869: CURSOR customer_id_csr(p_service_request_id IN NUMBER)IS
2870: SELECT customer_id FROM CS_INCIDENTS_ALL_B
2871: WHERE incident_id = p_service_request_id;
2872:
2873: l_customer_id NUMBER;
2874: