VIEW: APPS.ISC_CARRIER_SERVICE_LEVEL_V

Source

View Text - Preformatted

SELECT lookup_code ID,meaning Value FROM fnd_lookup_values WHERE lookup_type = 'WSH_SERVICE_LEVELS' AND view_application_id = 665 AND security_group_id = fnd_global.lookup_security_group(lookup_type, view_application_id) AND language = userenv('LANG') union select '-1' id, message_text value from fnd_new_messages m, fnd_application a where 'EDW_UNASSIGNED' = m.message_name and m.language_code = userenv('LANG') and 'BIS' = a.application_short_name and m.application_id = a.application_id

View Text - HTML Formatted

SELECT LOOKUP_CODE ID
, MEANING VALUE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'WSH_SERVICE_LEVELS'
AND VIEW_APPLICATION_ID = 665
AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LOOKUP_TYPE
, VIEW_APPLICATION_ID)
AND LANGUAGE = USERENV('LANG') UNION SELECT '-1' ID
, MESSAGE_TEXT VALUE
FROM FND_NEW_MESSAGES M
, FND_APPLICATION A
WHERE 'EDW_UNASSIGNED' = M.MESSAGE_NAME
AND M.LANGUAGE_CODE = USERENV('LANG')
AND 'BIS' = A.APPLICATION_SHORT_NAME
AND M.APPLICATION_ID = A.APPLICATION_ID