DBA Data[Home] [Help]

VIEW: APPS.RG_LOOKUPS

Source

View Text - Preformatted

SELECT lookup_type LOOKUP_TYPE, lookup_code LOOKUP_CODE, meaning MEANING, description DESCRIPTION, enabled_flag ENABLED_FLAG, start_date_active START_DATE_ACTIVE, end_date_active END_DATE_ACTIVE FROM fnd_lookup_values LV WHERE language = userenv('LANG') and view_application_id = 168 and SECURITY_GROUP_ID = 0
View Text - HTML Formatted

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