VIEW: APPS.BIV_MAINT_ASSET_CRITICAL_LVL_V

Source

View Text - Preformatted

SELECT lookup_code as ID , meaning as VALUE from fnd_lookup_values WHERE lookup_type = 'MTL_EAM_ASSET_CRITICALITY' and language = userenv('LANG') and VIEW_APPLICATION_ID = 700 and SECURITY_GROUP_ID = fnd_global.lookup_security_group( LOOKUP_TYPE, VIEW_APPLICATION_ID) union all select '-1' id, fnd_message.get_string('BIS','BIS_UNASSIGNED') value from dual

View Text - HTML Formatted

SELECT LOOKUP_CODE AS ID
, MEANING AS VALUE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MTL_EAM_ASSET_CRITICALITY'
AND LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 700
AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP( LOOKUP_TYPE
, VIEW_APPLICATION_ID) UNION ALL SELECT '-1' ID
, FND_MESSAGE.GET_STRING('BIS'
, 'BIS_UNASSIGNED') VALUE
FROM DUAL