View: CS_SR_OCV

Product:	CS - Service
Description:	This view has been created for SR extensible attributes only.
Implementation/DBA Data:	APPS.CS_SR_OCV

View Text

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'

Columns