VIEW: APPS.FND_DOCUMENTS_VL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'