DBA Data[Home] [Help]

VIEW: APPS.ZX_CEC_LOOKUPS

Source

View Text - Preformatted

SELECT LV.LOOKUP_TYPE,
          LV.LOOKUP_CODE,
          LV.LAST_UPDATE_DATE,
          LV.LAST_UPDATED_BY,
          LV.LAST_UPDATE_LOGIN,
          LV.CREATION_DATE,
          LV.CREATED_BY,
          LV.MEANING,
          LV.ENABLED_FLAG,
          LV.START_DATE_ACTIVE,
          LV.END_DATE_ACTIVE,
          LV.DESCRIPTION
     from FND_LOOKUP_VALUES LV
    WHERE LV.LANGUAGE = userenv('LANG')
      and LV.VIEW_APPLICATION_ID = 222
      and LV.SECURITY_GROUP_ID = 0

   
View Text - HTML Formatted

SELECT LV.LOOKUP_TYPE
, LV.LOOKUP_CODE
, LV.LAST_UPDATE_DATE
, LV.LAST_UPDATED_BY
, LV.LAST_UPDATE_LOGIN
, LV.CREATION_DATE
, LV.CREATED_BY
, LV.MEANING
, LV.ENABLED_FLAG
, LV.START_DATE_ACTIVE
, LV.END_DATE_ACTIVE
, LV.DESCRIPTION
FROM FND_LOOKUP_VALUES LV
WHERE LV.LANGUAGE = USERENV('LANG')
AND LV.VIEW_APPLICATION_ID = 222
AND LV.SECURITY_GROUP_ID = 0