VIEW: APPS.MSC_OTHER_TABLE_V

Source

View Text - Preformatted

SELECT LOOKUP_TYPE, LOOKUP_CODE, MEANING TABLE_NAME, description, ATTRIBUTE1 Application_ID FROM FND_LOOKUP_VALUES WHERE lookup_type = 'MSC_OTHER_TABLE' AND enabled_flag = 'Y' AND view_application_id = 700 AND language = userenv('lang')

View Text - HTML Formatted

SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING TABLE_NAME
, DESCRIPTION
, ATTRIBUTE1 APPLICATION_ID
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MSC_OTHER_TABLE'
AND ENABLED_FLAG = 'Y'
AND VIEW_APPLICATION_ID = 700
AND LANGUAGE = USERENV('LANG')