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_INCIDENT_TYPES_VL

Line 596: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT

592: -- yazhou 19Oct2005 Starts
593: -- Bug fix #4415024
594: IF p_service_id IS NOT NULL THEN
595: SELECT a.Incident_Id INTO x_service_id
596: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT
597: WHERE a.incident_type_id = cit.incident_type_id
598: AND cit.INCIDENT_SUBTYPE = 'INC'
599: AND cit.CMRO_FLAG = 'Y'
600: AND Incident_Id = p_service_id;

Line 603: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT

599: AND cit.CMRO_FLAG = 'Y'
600: AND Incident_Id = p_service_id;
601: ELSIF p_service_number IS NOT NULL THEN
602: SELECT a.Incident_Id INTO x_service_id
603: FROM CS_INCIDENTS_ALL_B a, CS_INCIDENT_TYPES_VL CIT
604: WHERE a.incident_type_id = cit.incident_type_id
605: AND cit.INCIDENT_SUBTYPE = 'INC'
606: AND cit.CMRO_FLAG = 'Y'
607: AND Incident_Number = p_service_number;