VIEW: APPS.BIV_MAINT_WK_ORDER_TYPE_LVL_V

Source

View Text - Preformatted

SELECT lookup_code ID, meaning VALUE from fnd_lookup_values WHERE lookup_type = 'WIP_EAM_WORK_ORDER_TYPE' 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 ID
, MEANING VALUE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'WIP_EAM_WORK_ORDER_TYPE'
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