DBA Data[Home] [Help]

VIEW: APPS.CN_LOOKUP_TYPES

Source

View Text - Preformatted

SELECT LOOKUP_TYPE , MEANING , DESCRIPTION , CUSTOMIZATION_LEVEL , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , CREATION_DATE , CREATED_BY FROM FND_LOOKUP_TYPES_VL LV WHERE VIEW_APPLICATION_ID = 283 AND SECURITY_GROUP_ID = fnd_global.lookup_security_group(LV.LOOKUP_TYPE, LV.VIEW_APPLICATION_ID)
View Text - HTML Formatted

SELECT LOOKUP_TYPE
, MEANING
, DESCRIPTION
, CUSTOMIZATION_LEVEL
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
FROM FND_LOOKUP_TYPES_VL LV
WHERE VIEW_APPLICATION_ID = 283
AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LV.LOOKUP_TYPE
, LV.VIEW_APPLICATION_ID)