DBA Data[Home] [Help]

VIEW: APPS.MSC_COLL_ENTITIES_V

Source

View Text - Preformatted

SELECT lookup_type, lookup_code serial_no, meaning Entity_name, description entity_description, attribute1 Netchange_support, attribute2 Snapshot_usage, attribute3 snapshot_group_string, attribute4 snapshot_group_display FROM fnd_lookup_values WHERE lookup_type = 'MSC_COLL_ENTITIES' AND enabled_flag = 'Y' AND view_application_id = 700 AND LANGUAGE = userenv('lang')
View Text - HTML Formatted

SELECT LOOKUP_TYPE
, LOOKUP_CODE SERIAL_NO
, MEANING ENTITY_NAME
, DESCRIPTION ENTITY_DESCRIPTION
, ATTRIBUTE1 NETCHANGE_SUPPORT
, ATTRIBUTE2 SNAPSHOT_USAGE
, ATTRIBUTE3 SNAPSHOT_GROUP_STRING
, ATTRIBUTE4 SNAPSHOT_GROUP_DISPLAY
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MSC_COLL_ENTITIES'
AND ENABLED_FLAG = 'Y'
AND VIEW_APPLICATION_ID = 700
AND LANGUAGE = USERENV('LANG')