FND Design Data [Home] [Help]

View: FV_LOOKUP_TYPES

Product: FV - Federal Financials
Description: Contains Federal seeded lookup types
Implementation/DBA Data: ViewAPPS.FV_LOOKUP_TYPES
View Text

SELECT LV.LOOKUP_TYPE
, LV.DESCRIPTION
, DECODE(LV.CUSTOMIZATION_LEVEL
, 'E'
, 'Y'
, 'N') USER_UPDATEABLE_FLAG
, LV.CREATED_BY
, LV.CREATION_DATE
, LV.LAST_UPDATED_BY
, LV.LAST_UPDATE_DATE
FROM FND_LOOKUP_TYPES_VL LV
WHERE LV.VIEW_APPLICATION_ID = 8901
AND LV.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LV.LOOKUP_TYPE
, LV.VIEW_APPLICATION_ID)

Columns

Name
LOOKUP_TYPE
DESCRIPTION
USER_UPDATEABLE_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE