[Home] [Help]
View: FND_COMMON_LOOKUP_TYPES
Product: | FND - Application Object Library |
Description: | View of QuickCode types provided for backward compatibility |
Implementation/DBA Data: |
APPS.FND_COMMON_LOOKUP_TYPES
|
View Text
SELECT B.APPLICATION_ID
, B.LOOKUP_TYPE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.CUSTOMIZATION_LEVEL
, T.MEANING
FROM FND_LOOKUP_TYPES_TL T
, FND_LOOKUP_TYPES B
WHERE B.LOOKUP_TYPE = T.LOOKUP_TYPE
AND B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
AND B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.VIEW_APPLICATION_ID = 3
AND B.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(B.LOOKUP_TYPE
, B.VIEW_APPLICATION_ID)
Columns
Name |
APPLICATION_ID |
LOOKUP_TYPE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
CUSTOMIZATION_LEVEL |
LOOKUP_TYPE_MEANING |