[Home] [Help]
View: AS_LOOKUP_TYPES
Product: | AS - Sales Foundation |
Description: | Lookup type view |
Implementation/DBA Data: |
APPS.AS_LOOKUP_TYPES
|
View Text
SELECT LV.LOOKUP_TYPE
, LV.LAST_UPDATE_DATE
, LV.LAST_UPDATED_BY
, LV.LAST_UPDATE_LOGIN
, LV.CREATION_DATE
, LV.CREATED_BY
, LV.CUSTOMIZATION_LEVEL
, LV.DESCRIPTION
FROM FND_LOOKUP_TYPES_VL LV
WHERE LV.VIEW_APPLICATION_ID = 279
AND LV.SECURITY_GROUP_ID = (SELECT MAX(LT.SECURITY_GROUP_ID)
FROM FND_LOOKUP_TYPES LT
WHERE LT.VIEW_APPLICATION_ID = LV.VIEW_APPLICATION_ID
AND LT.LOOKUP_TYPE = LV.LOOKUP_TYPE
AND LT.SECURITY_GROUP_ID= FND_GLOBAL.LOOKUP_SECURITY_GROUP(LT.LOOKUP_TYPE
, LT.VIEW_APPLICATION_ID))
Columns
Name |
LOOKUP_TYPE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATION_DATE |
CREATED_BY |
USER_MAINTAINABLE_FLAG |
DESCRIPTION |