View: FND_DOCUMENTS_VL

Product:	FND - Application Object Library
Description:	Resolves viewed language of a document
Implementation/DBA Data:	APPS.FND_DOCUMENTS_VL

View Text

SELECT D.ROWID
, D.DOCUMENT_ID
, D.CREATION_DATE
, D.CREATED_BY
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
, D.DATATYPE_ID
, DD.USER_NAME
, DL.DESCRIPTION
, D.FILE_NAME
, D.MEDIA_ID
, D.STORAGE_TYPE
, C.APPLICATION_ID
, D.CATEGORY_ID
, CL.USER_NAME
, D.SECURITY_TYPE
, D.SECURITY_ID
, D.PUBLISH_FLAG
, D.IMAGE_TYPE
, D.USAGE_TYPE
, L.MEANING
, D.START_DATE_ACTIVE
, D.END_DATE_ACTIVE
, D.REQUEST_ID
, D.PROGRAM_APPLICATION_ID
, D.PROGRAM_ID
, D.PROGRAM_UPDATE_DATE
, DL.DOC_ATTRIBUTE_CATEGORY
, DL.DOC_ATTRIBUTE1
, DL.DOC_ATTRIBUTE2
, DL.DOC_ATTRIBUTE3
, DL.DOC_ATTRIBUTE4
, DL.DOC_ATTRIBUTE5
, DL.DOC_ATTRIBUTE6
, DL.DOC_ATTRIBUTE7
, DL.DOC_ATTRIBUTE8
, DL.DOC_ATTRIBUTE9
, DL.DOC_ATTRIBUTE10
, DL.DOC_ATTRIBUTE11
, DL.DOC_ATTRIBUTE12
, DL.DOC_ATTRIBUTE13
, DL.DOC_ATTRIBUTE14
, DL.DOC_ATTRIBUTE15
, D.DM_NODE
, D.DM_FOLDER_PATH
, D.DM_TYPE
, D.DM_DOCUMENT_ID
, D.DM_VERSION_NUMBER
, D.URL
, DL.TITLE
, D.ORIG_DOC_ID
FROM FND_DOCUMENT_CATEGORIES_TL CL
, FND_DOCUMENT_CATEGORIES C
, FND_DOCUMENT_DATATYPES DD
, FND_LOOKUP_VALUES L
, FND_DOCUMENTS_TL DL
, FND_DOCUMENTS D
WHERE D.DOCUMENT_ID = DL.DOCUMENT_ID
AND DL.LANGUAGE= USERENV('LANG')
AND D.DATATYPE_ID = DD.DATATYPE_ID
AND DD.LANGUAGE = USERENV('LANG')
AND D.CATEGORY_ID = C.CATEGORY_ID
AND C.CATEGORY_ID = CL.CATEGORY_ID
AND CL.LANGUAGE = USERENV('LANG')
AND D.USAGE_TYPE = L.LOOKUP_CODE
AND L.LANGUAGE = USERENV('LANG')
AND L.LOOKUP_TYPE = 'ATCHMT_DOCUMENT_TYPE'

Columns