DBA Data[Home] [Help]

VIEW: APPS.GMS_LOOKUPS

Source

View Text - Preformatted

SELECT lv.LOOKUP_TYPE, lv.LOOKUP_CODE, lv.MEANING, lv.DESCRIPTION, lv.ENABLED_FLAG, lv.START_DATE_ACTIVE, lv.END_DATE_ACTIVE FROM FND_LOOKUP_VALUES LV WHERE lv.LANGUAGE = userenv('LANG') and lv.VIEW_APPLICATION_ID = 8402 and lv.SECURITY_GROUP_ID = 0
View Text - HTML Formatted

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