View: FND_DOCUMENT_CATEGORIES_VL

Product:	FND - Application Object Library
Description:	View of FND_DOCUMENT_CATEGORIES for translation purposes
Implementation/DBA Data:	APPS.FND_DOCUMENT_CATEGORIES_VL

View Text

SELECT C.ROWID
, C.CATEGORY_ID
, C.CREATION_DATE
, C.CREATED_BY
, C.LAST_UPDATE_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_LOGIN
, C.NAME
, T.USER_NAME
, DD.USER_NAME
, C.DEFAULT_DATATYPE_ID
, C.APPLICATION_ID
, APPTL.APPLICATION_NAME
, C.START_DATE_ACTIVE
, C.END_DATE_ACTIVE
, C.ATTRIBUTE_CATEGORY
, C.ATTRIBUTE1
, C.ATTRIBUTE2
, C.ATTRIBUTE3
, C.ATTRIBUTE4
, C.ATTRIBUTE5
, C.ATTRIBUTE6
, C.ATTRIBUTE7
, C.ATTRIBUTE8
, C.ATTRIBUTE9
, C.ATTRIBUTE10
, C.ATTRIBUTE11
, C.ATTRIBUTE12
, C.ATTRIBUTE13
, C.ATTRIBUTE14
, C.ATTRIBUTE15
FROM FND_APPLICATION_TL APPTL
, FND_DOCUMENT_DATATYPES DD
, FND_DOCUMENT_CATEGORIES_TL T
, FND_DOCUMENT_CATEGORIES C
WHERE C.CATEGORY_ID = T.CATEGORY_ID
AND T.LANGUAGE = USERENV('LANG')
AND C.DEFAULT_DATATYPE_ID = DD.DATATYPE_ID(+)
AND DD.LANGUAGE(+) = USERENV('LANG')
AND C.APPLICATION_ID = APPTL.APPLICATION_ID(+)
AND (APPTL.LANGUAGE IS NULL OR APPTL.LANGUAGE = USERENV('LANG'))

Columns