DBA Data[Home] [Help]

VIEW: APPS.AMS_LOOKUPS

Source

View Text - Preformatted

SELECT lookup_type, lookup_code, meaning, description, enabled_flag, start_date_active, end_date_active, tag FROM fnd_lookup_values lv WHERE language = USERENV('LANG') AND view_application_id = 530 AND security_group_id = 0
View Text - HTML Formatted

SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING
, DESCRIPTION
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, TAG
FROM FND_LOOKUP_VALUES LV
WHERE LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 530
AND SECURITY_GROUP_ID = 0