SELECT INCIDENT_TYPE_ID CODE , USERENV ('LANG') LANGUAGE , NAME MEANING FROM CS_INCIDENT_TYPES_VL WHERE INCIDENT_SUBTYPE = 'INC' UNION SELECT TO_NUMBER(LOOKUP_CODE) CODE , LANGUAGE , MEANING FROM FND_LOOKUP_VALUES WHERE LANGUAGE = USERENV('LANG') AND VIEW_APPLICATION_ID = 170 AND SECURITY_GROUP_ID = GREATEST (0 , TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO') , 55 , 1) , ' ' , '0' , NULL , '0' , SUBSTRB(USERENV('CLIENT_INFO') , 55 , 10)))) AND LOOKUP_TYPE = 'CS_SR_EXT_ALL_REQ_TYPES'