DBA Data[Home] [Help]

VIEW: APPS.ASO_LOOKUPS

Source

View Text - Preformatted

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

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