VIEW: APPS.CS_SR_OCV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'