DBA Data[Home] [Help]

VIEW: APPS.IEC_LOOKUPS

Source

View Text - Preformatted

SELECT LT.LOOKUP_TYPE, LV.LOOKUP_CODE, LV.MEANING, LV.DESCRIPTION, LV.ENABLED_FLAG, LV.START_DATE_ACTIVE, LV.END_DATE_ACTIVE, LV.TAG FROM FND_LOOKUP_TYPES LT, FND_LOOKUP_VALUES LV WHERE LV.LANGUAGE = userenv('LANG') AND LV.LOOKUP_TYPE = LT.LOOKUP_TYPE AND LT.APPLICATION_ID = 545
View Text - HTML Formatted

SELECT LT.LOOKUP_TYPE
, LV.LOOKUP_CODE
, LV.MEANING
, LV.DESCRIPTION
, LV.ENABLED_FLAG
, LV.START_DATE_ACTIVE
, LV.END_DATE_ACTIVE
, LV.TAG
FROM FND_LOOKUP_TYPES LT
, FND_LOOKUP_VALUES LV
WHERE LV.LANGUAGE = USERENV('LANG')
AND LV.LOOKUP_TYPE = LT.LOOKUP_TYPE
AND LT.APPLICATION_ID = 545