VIEW: APPS.FND_DOCUMENT_CATEGORIES_VL

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))