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