[Home] [Help]
View: AP_LOOKUP_TYPES
View Text
SELECT LV.LOOKUP_TYPE
, LV.DESCRIPTION
, DECODE(LV.CUSTOMIZATION_LEVEL
, 'E'
, 'Y'
, 'N')
, LV.CREATED_BY
, LV.CREATION_DATE
, LV.LAST_UPDATED_BY
, LV.LAST_UPDATE_DATE
, LV.LAST_UPDATE_LOGIN
FROM FND_LOOKUP_TYPES_VL LV
WHERE LV.VIEW_APPLICATION_ID = 200
AND LV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LV.LOOKUP_TYPE
, LV.VIEW_APPLICATION_ID)
Columns
Name |
LOOKUP_TYPE |
DESCRIPTION |
USER_UPDATABLE_FLAG |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |